/// <summary> /// Deletes perticular row from SIBLING GRID VIEW. /// </summary> /// <param name="sender">sender who has invoked methos.</param> /// <param name="e">Argument of Event.</param> protected void GvSibling_RowDeleting(object sender, GridViewDeleteEventArgs e) { Label Srno = (Label)GvSibling.Rows[e.RowIndex].FindControl("LblSiblingid"); if (Srno != null) { foreach (DataRow drow in Dt_SibligData.Rows) { if (drow["SiblingId"].ToString() == Srno.Text) { drow.Delete(); break; } } GvSibling.DataSource = Dt_SibligData; GvSibling.DataBind(); } }
/// <summary> /// Add (Temporary) Sibling Record to Grid view. /// </summary> /// <param name="sender">Sender object who has initiated the request.</param> /// <param name="e">Argument of the event.</param> protected void BtnAddNewSibling_Click(object sender, EventArgs e) { if (Dt_SibligData.Columns.Count == 0) { Dt_SibligData.Columns.Add("SiblingId", typeof(string)); Dt_SibligData.Columns.Add("SiblingName", typeof(string)); Dt_SibligData.Columns.Add("SiblingAge", typeof(string)); Dt_SibligData.Columns.Add("SiblingGender", typeof(string)); Dt_SibligData.Columns.Add("SiblingSchool", typeof(string)); Dt_SibligData.Columns.Add("SiblingClass", typeof(string)); } DataRow dr = Dt_SibligData.NewRow(); dr["SiblingId"] = Dt_SibligData.Rows.Count + 1; dr["SiblingName"] = TxtAddSiblingName.Text; dr["SiblingAge"] = txtAddSiblingAge.Text; if (RblstAddSiblingGender.SelectedIndex != -1) { dr["SiblingGender"] = RblstAddSiblingGender.SelectedItem.Value; } else { dr["SiblingGender"] = ""; } dr["SiblingSchool"] = TxtAddSiblingSchool.Text; dr["SiblingClass"] = TxtAddSiblingClass.Text; Dt_SibligData.Rows.Add(dr); GvSibling.DataSource = Dt_SibligData; GvSibling.DataBind(); TxtAddSiblingName.Text = string.Empty; txtAddSiblingAge.Text = string.Empty; TxtAddSiblingSchool.Text = string.Empty; TxtAddSiblingClass.Text = string.Empty; RblstAddSiblingGender.SelectedIndex = -1; TxtAddSiblingName.Focus(); }
/// <summary> /// Submit Data in Admission Table, Sibling Table, and Attached Document Table. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { oAdmission_BLogic = new Admission_BLogic(); oAdmission = new Admission(); oAdmission.FormNo = (!string.IsNullOrEmpty(TxtFormNo.Text)) ? TxtFormNo.Text.Trim() : null; oAdmission.AdmissionGrade = DdlAdmissionGrade.SelectedValue; oAdmission.FirstName = TxtFirstName.Text.Trim(); oAdmission.MiddleName = TxtMiddleName.Text.Trim(); oAdmission.LastName = TxtLastName.Text.Trim(); oAdmission.MailingAddress = (!string.IsNullOrEmpty(TxtMailingAddress.Text)) ? TxtMailingAddress.Text.Trim() : null; if (Fu_PassportImage.HasFile) { //getting length of uploaded file int length = Fu_PassportImage.PostedFile.ContentLength; //create a byte array to store the binary image data byte[] imgbyte = new byte[length]; //store the currently selected file in memeory HttpPostedFile img = Fu_PassportImage.PostedFile; //set the binary data img.InputStream.Read(imgbyte, 0, length); oAdmission.Photo = imgbyte; } oAdmission.TelephoneNo = (!string.IsNullOrEmpty(TxtTelephoneNo.Text)) ? TxtTelephoneNo.Text.Trim() : null; oAdmission.EmergencyMobileNo = (!string.IsNullOrEmpty(TxtMobileNo.Text)) ? TxtMobileNo.Text.Trim() : null; oAdmission.CommunicationEmailId = (!string.IsNullOrEmpty(TxtCommunicationMail.Text)) ? TxtCommunicationMail.Text.Trim() : null; oAdmission.Gender = RlstGender.SelectedValue; DateTime dt; if (DateTime.TryParse(TxtDateOfBirth.Text, out dt)) { oAdmission.DateOfBirth = dt.ToString(IFormat); } oAdmission.PlaceOfBirth = (!string.IsNullOrEmpty(TxtPlaceOfBirth.Text)) ? TxtPlaceOfBirth.Text.Trim() : null; oAdmission.Nationality = (!string.IsNullOrEmpty(TxtNationality.Text)) ? TxtNationality.Text.Trim() : null; oAdmission.Religion = (!string.IsNullOrEmpty(TxtReligion.Text)) ? TxtReligion.Text.Trim() : null; oAdmission.Caste = (!string.IsNullOrEmpty(TxtCaste.Text)) ? TxtCaste.Text.Trim() : null; oAdmission.SubCaste = (!string.IsNullOrEmpty(TxtSubCaste.Text)) ? TxtSubCaste.Text.Trim() : null; oAdmission.LastSchoolAttended = (!string.IsNullOrEmpty(TxtLastSchoolAttended.Text)) ? TxtLastSchoolAttended.Text.Trim() : null; oAdmission.FatherName = (!string.IsNullOrEmpty(TxtFatherName.Text)) ? TxtFatherName.Text.Trim() : null; oAdmission.FatherEducation = (!string.IsNullOrEmpty(TxtFatherEducation.Text)) ? TxtFatherEducation.Text.Trim() : null; oAdmission.FatherOccupation = (!string.IsNullOrEmpty(TxtFatherOccupation.Text)) ? TxtFatherOccupation.Text.Trim() : null; oAdmission.FatherOfficeAddress = (!string.IsNullOrEmpty(TxtFatherOfficeAddress.Text)) ? TxtFatherOfficeAddress.Text.Trim() : null; oAdmission.FatherTelephoneNo = (!string.IsNullOrEmpty(TxtFatherTelephoneNo.Text)) ? TxtFatherTelephoneNo.Text.Trim() : null; oAdmission.FatherMobileNo = (!string.IsNullOrEmpty(TxtFatherMobileNo.Text)) ? TxtFatherMobileNo.Text.Trim() : null; oAdmission.FatherEmailId = (!string.IsNullOrEmpty(TxtFatherEmailId.Text)) ? TxtFatherEmailId.Text.Trim() : null; oAdmission.MotherName = (!string.IsNullOrEmpty(TxtMotherName.Text)) ? TxtMotherName.Text.Trim() : null; oAdmission.MotherEducation = (!string.IsNullOrEmpty(TxtMotherEducation.Text)) ? TxtMotherEducation.Text.Trim() : null; oAdmission.MotherOccupation = (!string.IsNullOrEmpty(TxtMotherOccupation.Text)) ? TxtMotherOccupation.Text.Trim() : null; oAdmission.MotherOfficeAddress = (!string.IsNullOrEmpty(TxtMotherOfficeAddress.Text)) ? TxtMotherOfficeAddress.Text.Trim() : null; oAdmission.MotherTelephoneNo = (!string.IsNullOrEmpty(TxtMotherTelephoneNo.Text)) ? TxtMotherTelephoneNo.Text.Trim() : null; oAdmission.MotherMobileNo = (!string.IsNullOrEmpty(TxtMotherMobileNo.Text)) ? TxtMotherMobileNo.Text.Trim() : null; oAdmission.MotherEmailId = (!string.IsNullOrEmpty(TxtMotherEmailId.Text)) ? TxtMotherEmailId.Text.Trim() : null; oAdmission.MotherTongue = (!string.IsNullOrEmpty(TxtMotherTongue.Text)) ? TxtMotherTongue.Text.Trim() : null; oAdmission.OtherLanguages = (!string.IsNullOrEmpty(TxtOtherLanguages.Text)) ? TxtOtherLanguages.Text.Trim() : null; oAdmission.IsNuclearorJointFamily = (!string.IsNullOrEmpty(TxtIsNuclearorJointFamily.Text)) ? TxtIsNuclearorJointFamily.Text.Trim() : null; oAdmission.HowDoYouHearAboutAIS = (!string.IsNullOrEmpty(TxtHowdoyouhearAboutAIS.Text)) ? TxtHowdoyouhearAboutAIS.Text.Trim() : null; oAdmission.CreatedBy = Convert.ToString(AppSessions.EmpolyeeID); oAdmission.SchoolId = Convert.ToString(AppSessions.SchoolID); bool IsInsert = oAdmission_BLogic.Admission_Insert(oAdmission); if (IsInsert) { // For Creating a multi insert statement string of sibling details DataSet tempDsAdmissionId = oAdmission_BLogic.GetLastAdmissionId(); string LastAdmissionid = string.Empty; string InsertString; System.Text.StringBuilder sb = new System.Text.StringBuilder(); if (tempDsAdmissionId != null && tempDsAdmissionId.Tables.Count > 0 && tempDsAdmissionId.Tables[0].Rows.Count > 0) { LastAdmissionid = tempDsAdmissionId.Tables[0].Rows[0][0].ToString(); } if (GvSibling.Rows.Count > 0) { sb = new System.Text.StringBuilder(); foreach (GridViewRow gvr in GvSibling.Rows) { Label gvLblSiblingName = (Label)gvr.FindControl("LblSiblingName"); Label gvLblSiblingAge = (Label)gvr.FindControl("LblSiblingAge"); Label gvLblSiblingGender = (Label)gvr.FindControl("LblSiblingGender"); Label gvLblSiblingSchool = (Label)gvr.FindControl("LblSiblingLastSchool"); Label gvLblSiblingClass = (Label)gvr.FindControl("LblSiblingClass"); sb.Append("(" + LastAdmissionid + ",'" + gvLblSiblingName.Text + "'," + gvLblSiblingAge.Text + ",'" + gvLblSiblingGender.Text + "','" + gvLblSiblingSchool.Text + "','" + gvLblSiblingClass.Text + "'),"); } InsertString = sb.ToString().Remove(sb.ToString().Length - 1, 1); oAdmission_BLogic.Admission_Sibling_Insert(InsertString); Dt_SibligData.Clear(); GvSibling.DataSource = null; GvSibling.DataBind(); sb.Clear(); InsertString = string.Empty; } if (ChklstAttachmentList.Items.Count > 0) { foreach (ListItem cbItem in ChklstAttachmentList.Items) { if (cbItem.Selected) { sb.Append("(" + LastAdmissionid + "," + cbItem.Value + "),"); } } if (sb.ToString().Length > 0) { InsertString = sb.ToString().Remove(sb.ToString().Length - 1, 1); oAdmission_BLogic.Admission_Documents_Insert(InsertString); } } WebMsg.Show("Admission has been created successfully."); ResetControl(); } else { WebMsg.Show("Admission has been created failed."); } }