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 = ""; } }