using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
public partial class _frmRegistrationForm : System.Web.UI.Page
{
string strFees = "";
SqlConnection sqlConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RSIC"].ConnectionString);
SqlCommand cmd = null;
SqlDataAdapter sda = null;
DataSet ds = null;
string s1, s2, s3, s4, s5, s6, s7;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
sqlConn.Open();
sda = new SqlDataAdapter("Select StudentName From StudentRegistraion Where StudentName ='" + txtStudentNAme.Text.Replace("'", "''") + "' and FatherName ='" + txtFathersName.Text.Replace("'", "''") + "'", sqlConn);
ds = new DataSet();
sda.Fill(ds);
if (ds.Tables[0].Rows.Count>0)
{
Response.Write("");
}
else
{
if (chkBkFinan.Checked == true)
{
s1 = chkBkFinan.Text;
}
else
{
s1 = "";
}
if(chkBscAcc.Checked==true)
{
s2=chkBscAcc.Text;
}
else
{
s2 = "";
}
if(chkBscBuss.Checked==true)
{
s3=chkBscBuss.Text;
}
else
{
s3 = "";
}
if(chkBscEco.Checked==true)
{
s4=chkBscEco.Text;
}
else
{
s4 = "";
}
if (chkBscManaECo.Checked==true)
{
s5=chkBscManaECo.Text;
}
else
{
s5 = "";
}
if(chkDipECo.Checked==true)
{
s6=chkDipECo.Text;
}
else
{
s6 = "";
}
if(chkMana.Checked==true)
{
s7=chkMana.Text;
}
else
{
s7 = "";
}
string strName = txtStudentNAme.Text;
string strDate = System.DateTime.Now.ToString("ddMMyyyy");
string strFirstFour = (strName).Substring(0, 3);
string strStudentId = strFirstFour + strDate;
cmd = new SqlCommand();
cmd.CommandText = "Sp_Ins_StudentRegistrationDetials";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConn;
SqlParameter sqlParam = new SqlParameter();
sqlParam = cmd.Parameters.AddWithValue("@StudentID", strStudentId);
sqlParam = cmd.Parameters.AddWithValue("@StudentName", txtStudentNAme.Text.Replace("'", "''"));
sqlParam = cmd.Parameters.AddWithValue("@EduQua", txtStudentNAme0.Text.Replace("'", "''"));
sqlParam = cmd.Parameters.AddWithValue("@FatherName", txtFathersName.Text.Replace("'", "''"));
sqlParam = cmd.Parameters.AddWithValue("@Address", Address.Text.Replace("'", "''"));
sqlParam = cmd.Parameters.AddWithValue("@City", dplCity.Text.Replace("'", "''"));
sqlParam = cmd.Parameters.AddWithValue("@State", dplState.SelectedValue);
sqlParam = cmd.Parameters.AddWithValue("@Pincode", txtPincode.Text.Replace("'", "''"));
sqlParam = cmd.Parameters.AddWithValue("@ResidenceNo", txtResidence.Text.Replace("'", "''"));
sqlParam = cmd.Parameters.AddWithValue("@OfficeNo", txtOffice.Text.Replace("'", "''"));
sqlParam = cmd.Parameters.AddWithValue("@MobileNo", txtMobileNo.Text.Replace("'", "''"));
sqlParam = cmd.Parameters.AddWithValue("@EmailId", txtEmail.Text.Replace("'", "''"));
sqlParam = cmd.Parameters.AddWithValue("@BScBanFin",s1);
sqlParam = cmd.Parameters.AddWithValue("@BScAccFin", s2);
sqlParam = cmd.Parameters.AddWithValue("@BscBuss", s3);
sqlParam = cmd.Parameters.AddWithValue("@BscEco", s4);
sqlParam = cmd.Parameters.AddWithValue("@BScEcoMan", s5);
sqlParam = cmd.Parameters.AddWithValue("@DipEco", s6);
sqlParam = cmd.Parameters.AddWithValue("@BscMan", s7);
sqlParam = cmd.Parameters.AddWithValue("@EntryDate", System.DateTime.Now.ToString("MM/dd/yyyy"));
sqlParam = cmd .Parameters.Add("@ID",SqlDbType.Int);
sqlParam.Direction = ParameterDirection.Output;
int Status = cmd.ExecuteNonQuery();
int idvalue = (int)cmd.Parameters["@ID"].Value;
if (Status != 0)
{
EmptyTextField();
Response.Redirect("frmCongratulationForm.aspx?AdmissionID=" + idvalue + "," + strFees);
}
else
{
Response.Write("");
}
}
}
catch (Exception ex)
{
Response.Write("");
}
}
void EmptyTextField()
{
txtStudentNAme.Text = "";
txtFathersName.Text = "";
Address.Text = "";
dplCity.Text = " ";
dplState.SelectedValue = "Selectr State";
txtPincode.Text = "";
txtResidence.Text = "";
txtOffice.Text = "";
txtMobileNo.Text = "";
txtEmail.Text = "";
}
}