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