protected void btnSubmit_Click(object sender, EventArgs e) { TblTransportHolder transport; if (hdnID.Value != "") { transport = new SubSonic.Select() .From(TblTransportHolder.Schema) .Where(TblTransportHolder.Columns.MemberID).IsEqualTo(hdnID.Value) .And(TblTransportHolder.Columns.MemberType).IsEqualTo(true) .ExecuteSingle <TblTransportHolder>(); if (transport == null) { transport = new TblTransportHolder(); transport.IsNew = true; } else { transport.IsNew = false; } } else { transport = new TblTransportHolder(); transport.IsNew = true; } transport.RouteID = Convert.ToInt32(ddlRoute.SelectedValue); transport.BusID = Convert.ToInt32(ddlBus.SelectedValue); transport.MemberID = employee.EmployeeID; transport.MemberType = true; transport.Discount = Convert.ToInt32(txtDiscount.Text); transport.SeatNo = Convert.ToInt32(txtSeatNo.Text); transport.Stop = txtBusStop.Text; transport.JoiningDate = txtTJoinDate.SelectedDate; transport.IsActive = true; transport.Save(); hdnID.Value = ""; }
protected void btnSave_Click(object sender, EventArgs e) { if (helper.ExecutePlainQuery("select * from TblStudents where RegistrationNo='" + txtRegNo.Text + "' and BranchID=" + Session["BranchID"]).Rows.Count > 0 && String.IsNullOrEmpty(hdnID.Value)) { lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, txtRegNo.Text + " already exists!", "alert alert-danger alert-icon alert-dismissible", icon, "icon mdi mdi-check"); } else { string msg = "student has been added!"; if (hdnID.Value == "") { student = new TblStudent(); student.IsNew = true; student.CreateBy = Convert.ToString(Session["BranchUserID"]); } else { student = new TblStudent(hdnID.Value); student.IsNew = false; msg = "student has been updated!"; student.UpdatedBy = Convert.ToString(Session["BranchUserID"]); } student.BranchID = Convert.ToInt32(Session["BranchID"]); student.StudentName = txtStudentName.Text; student.FatherName = txtFatherName.Text; student.IsActive = true; student.RegistrationNo = txtRegNo.Text; student.LevelID = Convert.ToInt32(ddlLevel.SelectedValue); if (DDProgName.SelectedValue != "-1") { if (DDProgName.SelectedValue == "PreEng") { student.Program = "FSC"; } else if (DDProgName.SelectedValue == "PreMed") { student.Program = "FSC"; } else { student.Program = DDProgName.SelectedValue; } } if (radioSpring.Checked) { student.Session = "Spring"; } else { student.Session = "Autumn"; } student.DateofAdmission = txtDOA.SelectedDate; if (radioMale.Checked) { student.Gender = "Male"; } else { student.Gender = "Female"; } if (txtPic.HasFile) { if (String.IsNullOrEmpty(lblimgName.Text)) { postedFile = txtPic.FileName; } else { postedFile = lblimgName.Text; } txtPic.SaveAs(Server.MapPath("~/Admin/assets/CustomImages/" + txtPic.FileName)); student.Pic = postedFile; } student.Nationality = txtNationality.Text; student.Domicile = txtDomicile.Text; student.Religion = ddlReligion.SelectedValue; student.Cnic = txtCNIC.Text; student.Dob = txtDOB.SelectedDate; student.PlaceofBirth = txtPlaceOfBirth.Text; student.SEmail = txtStdEmail.Text; student.SCellNo = txtStdCell.Text; student.SHomePhone = txtPhoneNo.Text; student.SAddress = txtHomeAddress.Text; if (chkTransport.Checked) { student.IsTrannsport = true; } else { student.IsTrannsport = false; } if (chkHostel.Checked) { student.IsHostel = true; } else { student.IsHostel = false; } student.GName = txtGardianName.Text; student.GRelationship = txtRelationship.Text; student.GAddress = txtOfficeAddress.Text; student.GEmail = txtGEmail.Text; student.GOccupation = txtGOccupation.Text; student.GMonthlyIncome = Convert.ToDecimal(txtMonthlyIncome.Text); student.GCellNo = txtGCell.Text; student.ClassNo = Convert.ToInt32(ddlClass.SelectedValue); if (!String.IsNullOrEmpty(ddlGroup.SelectedValue)) { student.GroupID = Convert.ToInt32(ddlGroup.SelectedValue); } student.Save(); if (ddlLevel.SelectedValue == "2") { student.Program = DDProgName.SelectedValue; Query qry = new Query(TblStudentAcademicRecord.Schema); qry.AddWhere(TblStudentAcademicRecord.Columns.StudentID, Comparison.Equals, student.StudentID); DataTable dt = qry.ExecuteDataSet().Tables[0]; TblStudentAcademicRecord academic; if (dt.Rows.Count == 0) { academic = new TblStudentAcademicRecord(); academic.IsNew = true; } else { academic = new TblStudentAcademicRecord(dt.Rows[0]["ARecordID"]); academic.IsNew = false; } academic.StudentID = student.StudentID; academic.Degree = DropDownMatric.SelectedValue; academic.Board = txtSCCInstitue.Text; academic.Year = txtSSCYear.Text; academic.RollNo = txtSSCRNo.Text; academic.TotalMarks = Convert.ToInt32(txtSSCTMarks.Text); academic.ObtainedMarks = Convert.ToInt32(txtSSCOMarks.Text); academic.Grade = txtSSCGrade.Text; academic.MajorSubject = txtSSCDestinction.Text; academic.Save(); if (DropDownInter.SelectedValue != "-1") { TblStudentAcademicRecord interacademic; if (dt.Rows.Count == 0) { interacademic = new TblStudentAcademicRecord(); interacademic.IsNew = true; } else { interacademic = new TblStudentAcademicRecord(dt.Rows[1]["ARecordID"]); interacademic.IsNew = false; } interacademic.StudentID = student.StudentID; interacademic.Degree = DropDownInter.SelectedValue; interacademic.Board = txtInterInstitue.Text; interacademic.Year = txtInterYear.Text; interacademic.RollNo = txtInterRNo.Text; interacademic.TotalMarks = Convert.ToInt32(txtInterTMarks.Text); interacademic.ObtainedMarks = Convert.ToInt32(txtInterOMarks.Text); interacademic.Grade = txtInterGrade.Text; interacademic.MajorSubject = txtInterDestinction.Text; interacademic.Save(); } } if (chkTransport.Checked) { TblTransportHolder transport; if (hdnID.Value != "") { transport = new SubSonic.Select() .From(TblTransportHolder.Schema) .Where(TblTransportHolder.Columns.MemberID).IsEqualTo(hdnID.Value) .And(TblTransportHolder.Columns.MemberType).IsEqualTo(false) .ExecuteSingle <TblTransportHolder>(); if (transport == null) { transport = new TblTransportHolder(); transport.IsNew = true; } else { transport.IsNew = false; } } else { transport = new TblTransportHolder(); transport.IsNew = true; } transport.RouteID = Convert.ToInt32(ddlRoute.SelectedValue); transport.BusID = Convert.ToInt32(ddlBus.SelectedValue); transport.MemberID = student.StudentID; transport.MemberType = false; transport.Discount = Convert.ToInt32(txtDiscount.Text); transport.SeatNo = Convert.ToInt32(txtSeatNo.Text); transport.Stop = txtBusStop.Text; transport.JoiningDate = txtTJoinDate.SelectedDate; transport.IsActive = true; transport.Save(); } if (chkHostel.Checked) { TblHostelEnrollment hostel; if (hdnID.Value != "") { hostel = new SubSonic.Select() .From(TblHostelEnrollment.Schema) .Where(TblHostelEnrollment.Columns.MemberID).IsEqualTo(hdnID.Value) .And(TblHostelEnrollment.Columns.MemberType).IsEqualTo(false) .ExecuteSingle <TblHostelEnrollment>(); if (hostel == null) { hostel = new TblHostelEnrollment(); hostel.IsNew = true; } else { hostel.IsNew = false; } } else { hostel = new TblHostelEnrollment(); hostel.IsNew = true; } hostel.MemberID = student.StudentID; hostel.MemberType = false; hostel.HostelID = Convert.ToInt32(ddlHostel.SelectedValue); hostel.HAdmissionDate = txtEnrollDate.SelectedDate; hostel.Save(); } //TblCurrentEnrollment Currenroll; //if (hdnID.Value != "") //{ // Currenroll = new SubSonic.Select() // .From(TblCurrentEnrollment.Schema) // .Where(TblCurrentEnrollment.Columns.StudentID).IsEqualTo(hdnID.Value) // .ExecuteSingle<TblCurrentEnrollment>(); // if (Currenroll == null) // { // Currenroll = new TblCurrentEnrollment(); // Currenroll.IsNew = true; // Currenroll.CreateBy = Convert.ToString(Session["BranchUserID"]); // } // else // { // Currenroll.IsNew = false; // Currenroll.UpdatedBy = Convert.ToString(Session["BranchUserID"]); // } //} //else //{ // Currenroll = new TblCurrentEnrollment(); // Currenroll.IsNew = true; // Currenroll.CreateBy = Convert.ToString(Session["BranchUserID"]); //} //Currenroll.StudentID = student.StudentID; //Currenroll.ClassNo = Convert.ToInt32(ddlClass.SelectedValue); //Currenroll.BranchID = Convert.ToInt32(Session["BranchID"]); //Currenroll.EnrollmentDate = DateTime.Now; //Currenroll.GroupID = Convert.ToInt32(ddlGroup.SelectedValue); //Currenroll.Save(); //TblEnrollmentHistory EnrollHistory; //if (hdnID.Value != "") //{ // EnrollHistory = new SubSonic.Select() // .From(TblEnrollmentHistory.Schema) // .Where(TblEnrollmentHistory.Columns.StudentID).IsEqualTo(hdnID.Value) // .And(TblEnrollmentHistory.Columns.ClassNo).IsEqualTo(ddlClass.SelectedValue) // .ExecuteSingle<TblEnrollmentHistory>(); // if (EnrollHistory == null) // { // EnrollHistory = new TblEnrollmentHistory(); // EnrollHistory.IsNew = true; // EnrollHistory.CreateBy = Convert.ToString(Session["BranchUserID"]); // } // else // { // EnrollHistory.IsNew = false; // EnrollHistory.UpdatedBy = Convert.ToString(Session["BranchUserID"]); // } //} //else //{ // EnrollHistory = new TblEnrollmentHistory(); // EnrollHistory.IsNew = true; // EnrollHistory.CreateBy = Convert.ToString(Session["BranchUserID"]); //} //EnrollHistory.StudentID = student.StudentID; //EnrollHistory.ClassNo = Convert.ToInt32(ddlClass.SelectedValue); //EnrollHistory.BranchID = Convert.ToInt32(Session["BranchID"]); //EnrollHistory.EnrollmentDate = DateTime.Now; //EnrollHistory.GroupID = Convert.ToInt32(ddlGroup.SelectedValue); //EnrollHistory.Save(); lblmsg.Text = helper.DisplayNotificationMessage(msgDiv, msg, "alert alert-success alert-icon alert-dismissible", icon, "icon mdi mdi-check"); helper.ClearInputs(this.Controls); txtDOB.SelectedDate = null; txtDOA.SelectedDate = null; // LoadTransportRecord(); // LoadHostelRecord(); lblimgName.Text = string.Empty; hdnID.Value = ""; reqFpic.Enabled = true; chkHostel.Checked = false; chkTransport.Checked = false; lblimgName.Visible = false; } }