protected void btnSave_Click(object sender, EventArgs e)
{
var obj_ = new simsdb();
try
{
//var row_ = new StudentFeeCardRow();
//row_.StID = Convert.ToInt32(lblStID.Text);
//row_.EnrollNo = txtEnrollNo.Text;
//row_.SessionID = Convert.ToInt32(cmbSession.SelectedValue);
//row_.ProgramID = Convert.ToInt32(cmbProgram.SelectedValue);
//row_.FeeType = Convert.ToInt32(cmbFeeType.SelectedValue);
//row_.Year = Convert.ToInt32(this.cmbYear.SelectedItem.Text);
//row_.Month = this.cmbMonth.SelectedItem.Text;
//row_.Description = txtDescription.Text;
//row_.Note = txtDescription.Text;
//row_.Installment = txtInstallment.Text;
//row_.Balance = Convert.ToInt32(txtCreditAmount.Text);
//row_.ShortBalance = Convert.ToInt32(txtDueAmount.Text) - Convert.ToInt32(txtInstallment.Text);
//row_.Installment = txtInstallment.Text;
}
catch (Exception ex)
{
string msgs = ex.Message.ToString();
}
finally
{
}
}
protected void GetPopulate(string GID_)
{
var obj_ = new simsdb();
var row_ = new GuestStudentRow();
try
{
row_ = obj_.GuestStudentCollection.GetRow("GuestID='" + GID_ + "'");
string str_ = row_.GuestID.ToString();
this.txtFormNo.Text = str_;
cmbSession.SelectedValue = row_.SessionID;
txtStudentNme.Text = row_.StudentName.ToString();
txtFathername.Text = row_.FatherName.ToString();
txtMobileNo.Text = row_.MobileNo.ToString();
}
catch (Exception ex)
{
string msgs = ex.Message.ToString();
}
finally
{
obj_.Dispose();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (var obj_ = new simsdb())
{
var row_ = new TransportDuesDetailsRow();
row_.V_Information = txtVInfo.Text;
row_.Route = txtRouteDescription.Text;
row_.Routing = cmbRoutingConfig.SelectedItem.Text;
row_.V_No = txtVNo.Text;
row_.V_Type = cmbVType.SelectedItem.Text;
row_.No_of_Seats = cmbNoofSeats.SelectedItem.Text;
row_.Drive_Info = txtDriverInfo.Text;
row_.Driver_Contact_No = txtDriverContact.Text;
row_.Driver_Address = txtDriverAddress.Text;
row_.Month = cmbMonth.SelectedItem.Text;
row_.Year = Convert.ToInt32(cmbYear.SelectedItem.Text);
row_.Charges = Convert.ToInt32(txtMonthlyCharges.Text);
row_.Paid_Amount = Convert.ToInt32(txtPaidAmount.Text);
row_.Date_Payment = Convert.ToDateTime(dtPaymentDate.SelectedDate.ToString());
row_.VoucherNo = txtVoucherNo.Text;
row_.StEnrollNo = txtEnrollNo.Text;
row_.IsDeleted = false;
obj_.TransportDuesDetailsCollection.Insert(row_);
_ShowGridEnroll(this.txtEnrollNo.Text);
lblMessage.Text = "Record Inserted...";
obj_.Dispose();
}
}
protected void FillCombos()
{
using (var obj = new simsdb())
{
DataTable dt = obj.SessionCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbSession, dt, "SessionName", "SessionID", true, "--Please Select Session--", "0");
}
using (var obj = new simsdb())
{
DataTable dt = obj.ProgramCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbProgram, dt, "ProgramDesc", "ProgramID", true, "--Please Select Flag--", "0");
}
using (var obj = new simsdb())
{
DataTable dt = obj.SchoolLastAttCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbSchoolLast, dt, "PrevSchoolName", "SLAID", true, "--Please Select Prev School--", "0");
}
using (var obj = new simsdb())
{
DataTable dt = obj.FlagSetterCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbFlag, dt, "FlagLabel", "FlagID", true, "--Please Select Flag--", "0");
simsdbCommon.FillTelericCombo(ref cmbGridView, dt, "FlagLabel", "FlagID", true, "--Please Select Flag--", "0");
}
using (var obj = new simsdb())
{
DataTable dt = obj.ClassSectionCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbClass, dt, "clsSec_Description", "clsSecID", true, "--Please Select Class Sec--", "0");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (var obj_ = new simsdb())
{
var row_ = new StudentDuesRow();
row_.StID = Convert.ToInt32(this.cmbStudent.SelectedValue);
row_.EnrollNo = txtEnrollNo.Text;
row_.Session = cmbSession.SelectedItem.Text;
row_.ProgramName = cmbProgram.SelectedItem.Text;
row_.FeeStructSessionID = Convert.ToInt32(cmbFeeStructure.SelectedValue);
row_.ClassDesc = cmbClassEnrolled.SelectedItem.Text;
row_.Month = cmbMonth.SelectedItem.Text;
row_.Year = Convert.ToInt32(cmbYear.SelectedItem.Text);
row_.Total_Dues = Convert.ToInt32(txtTotalDues.Text);
row_.Paid_Amount = Convert.ToInt32(txtPaidAmount.Text);
row_.PaymentMed = cmbPaymentMed.SelectedItem.Text;
row_.PaidDated = this.DateTransaction.SelectedDate.ToString();
row_.PaidViaVoucherNo = txtVoucherNo.Text;
row_.IsDeleted = false;
row_.Date_Created = Convert.ToDateTime(System.DateTime.Now.ToShortDateString().ToString());
obj_.StudentDuesCollection.Insert(row_);
lblMessage.Text = "Row Inserted!";
_ShowGrid(txtEnrollNo.Text);
obj_.Dispose();
}
}
protected void FillCombos()
{
using (var obj = new simsdb())
{
System.Data.DataTable dt = obj.SessionCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbSession, dt, "SessionName", "SessionID", true, "--Please Select Session--", "0");
}
using (var obj = new simsdb())
{
DataTable dt = obj.ProgramCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbProgram, dt, "ProgramDesc", "ProgramID", true, "--Please Select Program--", "0");
}
using (var obj = new simsdb())
{
DataTable dt = obj.ClassSectionCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbClassEnrolled, dt, "clsSec_Description", "clsSecID", true, "--Please Select Class Sec--", "0");
}
//using (var obj = new simsdb())
//{
// DataTable dt = obj.FlagSetterCollection.GetAllAsDataTable();
// simsdbCommon.FillTelericCombo(ref cmbFlag, dt, "FlagLabel", "FlagID", true, "--Please Select Flag--", "0");
//}
using (var obj = new simsdb())
{
DataTable dt = obj.FeeStructureSessionCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbFeeStructure, dt, "FeeStructureDesc", "FeeStructID", true, "--Please Select Fee Structure--", "0");
}
}
protected void txtEnrollNo_TextChanged(object sender, EventArgs e)
{
var getRec = new GetFlyRec();
var obj_ = new simsdb();
var row_ = new Student_EnrRow();
row_ = obj_.Student_EnrCollection.GetRow("FormNo='" + txtEnrollNo.Text.Trim() + "'");
txtStudentName.Text = row_.Student_Name.ToString();
txtFatherName.Text = row_.FatherName.ToString();
obj_.Dispose();
string GridQry_ = "";
GridQry_ =
"SELECT dbo.StudentFeeCard.FeeGenID, dbo.Session.SessionName, dbo.Program.ProgramDesc, dbo.StudentFeeCard.EnrollNo, dbo.StudentFeeCard.StudentName, dbo.StudentFeeCard.FatherName," +
"cast(dbo.StudentFeeCard.Month+'-'+cast(dbo.StudentFeeCard.Year as varchar) as varchar) as Month_Year, dbo.StudentFeeCard.CurrentClassEnrolled, dbo.StudentFeeCard.AdmissionFee, dbo.StudentFeeCard.AdmProcessFee, dbo.StudentFeeCard.OnlineFee, dbo.StudentFeeCard.BuildingFee," +
"dbo.StudentFeeCard.TutionFee, dbo.StudentFeeCard.LibraryFee, dbo.StudentFeeCard.ScienceLabFee, dbo.StudentFeeCard.CSLabFee, dbo.StudentFeeCard.ExamFee, dbo.StudentFeeCard.CertificateIssueFee," +
"dbo.StudentFeeCard.AnnualCharges, dbo.StudentFeeCard.Misc, dbo.StudentFeeCard.Desciption, dbo.StudentFeeCard.OtherFee, dbo.StudentFeeCard.Comments, dbo.StudentFeeCard.Note_Comments, " +
"dbo.StudentFeeCard.Mood_Payment, dbo.StudentFeeCard.Chk_No, dbo.StudentFeeCard.Bank_Detail, dbo.StudentFeeCard.DateCreated, dbo.StudentFeeCard.SessionID, dbo.StudentFeeCard.ProgramID " +
"FROM dbo.StudentFeeCard INNER JOIN " +
"dbo.Session ON dbo.StudentFeeCard.SessionID = dbo.Session.SessionID INNER JOIN " +
"dbo.Program ON dbo.StudentFeeCard.ProgramID = dbo.Program.ProgramID INNER JOIN " +
"dbo.FlagSetter ON dbo.StudentFeeCard.FlagID = dbo.FlagSetter.FlagID " +
"WHERE (dbo.StudentFeeCard.EnrollNo ='" + txtEnrollNo.Text + "') ORDER BY dbo.StudentFeeCard.StudentName";
DataTable dt_ = getRec.Getdt(GridQry_);
_GetShowRecGrid(dt_);
_gvList.DataBind();
}
protected void cmbFeeStructure_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
var obj_ = new simsdb();
var row_ = new FeeStructureSessionRow();
row_ = obj_.FeeStructureSessionCollection.GetRow("FeeStructID=" + this.cmbFeeStructure.SelectedValue + "AND IsActive=1");
//
txtAdmissionFee.Text = row_.AdmissionFee.ToString();
txtAdmissionProcessingFee.Text = row_.AdmProcessFee.ToString();
txtOnlineFee.Text = row_.OnlineFee.ToString();
txtExaminationFee.Text = row_.ExamFee.ToString();
txtBuildingFee.Text = row_.BuildingFee.ToString();
txtTutionFee.Text = row_.TutionFee.ToString();
txtLibraryFee.Text = row_.LibraryFee.ToString();
txtScienceLabFee.Text = row_.ScienceLabFee.ToString();
txtCSLabFee.Text = row_.CSLabFee.ToString();
txtExaminationFee.Text = row_.ExamFee.ToString();
txtCertificateIssuanceFee.Text = row_.CertificateIssueFee.ToString();
txtOtherAnualCharges.Text = row_.AnnualCharges.ToString();
txtMicsFeeStructure.Text = row_.Misc.ToString();
txtCommentsDesc.Text = row_.Desciption.ToString();
txtOtherFee.Text = row_.OtherFee.ToString();
txtComments_.Text = row_.Comments.ToString();
obj_.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string EnrollNo = Request.QueryString["EnrollNo"].ToString();
if (EnrollNo != null)
{
var obj_ = new simsdb();
var row_ = new Student_EnrRow();
try
{
row_ = obj_.Student_EnrCollection.GetRow("AdmNo='" + EnrollNo + "'");
txtEnrollNo.Text = row_.AdmNo.ToString();
obj_.Dispose();
}
catch (Exception ex)
{
string msgs = ex.Message.ToString();
}
finally
{
obj_.Dispose();
}
}
_ShowGridAll();
FillYearMonths();
FillCombos();
}
}
protected void FillCombos()
{
using (var obj = new simsdb())
{
DataTable dt = obj.ClassSectionCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbGridView, dt, "clsSec_Description", "clsSecID", true, "--Please Select Class Sec--", "0");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (var obj_ = new simsdb())
{
var row_ = new StudentFeeCardRow();
row_.SessionID = Convert.ToInt32(cmbSession.SelectedValue);
row_.ProgramID = Convert.ToInt32(cmbProgram.SelectedValue);
row_.FeeStructureID = Convert.ToInt32(cmbFeeStructure.SelectedValue);
row_.EnrollNo = txtEnrollNo.Text.ToUpper();
row_.StudentName = txtStudentName.Text;
row_.FatherName = txtFatherName.Text;
row_.Year = Convert.ToInt32(cmbYear.SelectedItem.Text);
row_.Month = cmbMonth.SelectedItem.Text;
row_.AdmissionFee = Convert.ToInt32(txtAdmissionFee.Text);
row_.AdmProcessFee = Convert.ToInt32(txtAdmissionFee.Text);
row_.OnlineFee = Convert.ToInt32(txtBuildingFee.Text);
row_.BuildingFee = Convert.ToInt32(txtBuildingFee.Text);
row_.TutionFee = Convert.ToInt32(txtTutionFee.Text);
row_.LibraryFee = Convert.ToInt32(txtLibraryFee.Text);
row_.ScienceLabFee = Convert.ToInt32(txtScienceLabFee.Text);
row_.CSLabFee = Convert.ToInt32(txtCSLabFee.Text);
row_.ExamFee = Convert.ToInt32(txtExaminationFee.Text);
row_.CertificateIssueFee = Convert.ToInt32(txtCertificateIssuanceFee.Text);
row_.AnnualCharges = Convert.ToInt32(txtOtherAnualCharges.Text);
row_.Misc = Convert.ToInt32(txtMicsFeeStructure.Text);
row_.Desciption = txtCommentsDesc.Text;
row_.OtherFee = Convert.ToInt32(txtOtherFee.Text);
row_.Comments = txtComments_.Text;
row_.Note_Comments = txtNote.Text;
row_.Mood_Payment = cmbMoodofPayment.SelectedItem.Text;
row_.Chk_No = txtChequeOtherNo.Text;
row_.Bank_Detail = txtBankDetail.Text;
row_.DateCreated = Convert.ToDateTime(System.DateTime.Now.ToLongDateString().ToString());
row_.DateModified = Convert.ToDateTime(System.DateTime.Now.ToLongDateString().ToString());
row_.ModifiedBy = "zaheer";
row_.IsDeleted = false;
row_.FlagID = Convert.ToInt32(cmbFlag.SelectedValue);
obj_.StudentFeeCardCollection.Insert(row_);
//
var getRec_ = new GetFlyRec();
string GridQry_ = "";
GridQry_ =
"SELECT dbo.StudentFeeCard.FeeGenID, dbo.Session.SessionName, dbo.Program.ProgramDesc, dbo.StudentFeeCard.EnrollNo, dbo.StudentFeeCard.StudentName, dbo.StudentFeeCard.FatherName," +
"cast(dbo.StudentFeeCard.Month+'-'+cast(dbo.StudentFeeCard.Year as varchar) as varchar) as Month_Year, dbo.StudentFeeCard.CurrentClassEnrolled, dbo.StudentFeeCard.AdmissionFee, dbo.StudentFeeCard.AdmProcessFee, dbo.StudentFeeCard.OnlineFee, dbo.StudentFeeCard.BuildingFee," +
"dbo.StudentFeeCard.TutionFee, dbo.StudentFeeCard.LibraryFee, dbo.StudentFeeCard.ScienceLabFee, dbo.StudentFeeCard.CSLabFee, dbo.StudentFeeCard.ExamFee, dbo.StudentFeeCard.CertificateIssueFee," +
"dbo.StudentFeeCard.AnnualCharges, dbo.StudentFeeCard.Misc, dbo.StudentFeeCard.Desciption, dbo.StudentFeeCard.OtherFee, dbo.StudentFeeCard.Comments, dbo.StudentFeeCard.Note_Comments, " +
"dbo.StudentFeeCard.Mood_Payment, dbo.StudentFeeCard.Chk_No, dbo.StudentFeeCard.Bank_Detail, dbo.StudentFeeCard.DateCreated, dbo.StudentFeeCard.SessionID, dbo.StudentFeeCard.ProgramID " +
"FROM dbo.StudentFeeCard INNER JOIN " +
"dbo.Session ON dbo.StudentFeeCard.SessionID = dbo.Session.SessionID INNER JOIN " +
"dbo.Program ON dbo.StudentFeeCard.ProgramID = dbo.Program.ProgramID INNER JOIN " +
"dbo.FlagSetter ON dbo.StudentFeeCard.FlagID = dbo.FlagSetter.FlagID " +
"WHERE (dbo.StudentFeeCard.EnrollNo ='" + txtEnrollNo.Text + "') AND (dbo.StudentFeeCard.SessionID = " + cmbSession.SelectedValue + ")" +
" ORDER BY dbo.StudentFeeCard.StudentName";
DataTable dt_ = getRec_.Getdt(GridQry_);
_GetShowRecGrid(dt_);
}
}
protected void imgBtnDelete_Command(object sender, CommandEventArgs e)
{
using (var obj_ = new simsdb())
{
obj_.GuestStudentCollection.DeleteByPrimaryKey(e.CommandArgument.ToString());
obj_.Dispose();
showGrid();
}
}
protected void btnAdd0_Click(object sender, EventArgs e)
{
var obj_ = new simsdb();
var row_ = new Student_EnrRow();
try
{
row_.FormNo = txtFormNo.Text;
row_.AdmNo = txtFormNo.Text;
row_.SessionID = Convert.ToInt32(cmbSession.SelectedValue);
row_.Admission_year = cmbSession.SelectedItem.Text;
row_.Student_Name = txtStudentNme.Text.ToUpper();
row_.DOB = Convert.ToDateTime(dtDob.SelectedDate.ToString()).ToShortDateString();
row_.DOBinWords = Convert.ToDateTime(this.dtDoa.SelectedDate.ToString()).ToLongDateString();
row_.Gender = cmbGender.SelectedItem.Text;
row_.FatherName = txtFathername.Text.ToUpper();
row_.FatherCNIC = txtCNIC.Text;
row_.Occupation = txtFatherOccupation.Text;
row_.ClassSought = Convert.ToInt32(cmbClassSectionABC.SelectedValue);
row_.Prev_Class_Sec = Convert.ToInt32(cmbClassSectionABC.SelectedValue);
row_.PrevSchool = cmbSchoolLast.SelectedItem.Text;
row_.MediumSC = cmbMood.SelectedItem.Text;
row_.Religion = cmbReligion.SelectedItem.Text;
row_.Nationality = "Pakistan";
row_.Address = "Per Add:" + txtPerAddress.Text;
row_.Address2 = "Postal Add:" + txtPostAddress.Text;
row_.Mobile1 = txtMobileNo.Text;
row_.Mobile2 = txtMobileNo.Text;
row_.Is_Hostel = cmbIsHostel.SelectedItem.Text;
row_.Is_Transport = cmbIsTransport.SelectedItem.Text;
row_.ProgramApplied = cmbProgram.SelectedItem.Text;
row_.Is_ArmdForces = cmbIsArmForce.SelectedItem.Text;
row_.ECP = txtEmergencyContactPerson.Text.ToUpper();
row_.ECN = txtEmergencyContactNo.Text;
row_.TypoGraphic = cmbtypography.SelectedItem.Text;
row_.IsActive = true;
row_.Flag = Convert.ToInt32(cmbFlag.SelectedValue);
row_.IsDeleted = false;
row_.DateModified = System.DateTime.Now;
row_.DateCreated = System.DateTime.Now;
row_.ModifiedBy = "zaheer";
row_.CreatedBy = "zaheer";
obj_.Student_EnrCollection.Insert(row_);
lblMessage.Text = "Row Inserted";
//Guest Student Rec Updated
UpdateGuest(txtFormNo.Text, cmbFlag.SelectedValue);
showGrid();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
finally
{
obj_.Dispose();
}
}
protected void cmbStudent_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
var obj_ = new simsdb();
var row_ = new Student_EnrRow();
row_ = obj_.Student_EnrCollection.GetRow("Student_Name='" + cmbStudent.SelectedItem.Text + "'");
txtEnrollNo.Text = row_.AdmNo;
txtFatherName.Text = row_.FatherName.ToUpper();
obj_.Dispose();
}
protected string GetClass(Int32 clasID_)
{
var r_ = new ClassSectionRow();
using (var obj_ = new simsdb())
{
r_ = obj_.ClassSectionCollection.GetRow("clsSecID=" + clasID_);
}
return(r_.ClsSec_Description);
}
protected void showGrid()
{
var obj_ = new simsdb();
DataTable dt_ = new DataTable();
dt_ = obj_.GuestStudentCollection.GetAsDataTable("FLAG!=2", "STUDENTNAME");
this._gvList.DataSource = dt_;
this._gvList.DataBind();
obj_.Dispose();
}
protected void showGrid()
{
using (var obj = new simsdb())
{
DataTable dt_ = new DataTable();
dt_ = obj.vw_Stinfo_GridCollection.GetAllAsDataTable();
_gvList.DataSource = dt_;
_gvList.DataBind();
}
}
protected void cmbGridView_SelectedIndexChanged(object sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
var obj_ = new simsdb();
DataTable dt_ = new DataTable();
int setter_ = Convert.ToInt32(this.cmbGridView.SelectedValue.ToString());
dt_ = obj_.GuestStudentCollection.GetAsDataTable("Flag=" + setter_, "StudentName");
this._gvList.DataSource = dt_;
this._gvList.DataBind();
obj_.Dispose();
}
protected void GetRecStudent(string _stID)
{
using (var obj_ = new simsdb())
{
var row_ = new Student_EnrRow();
row_ = obj_.Student_EnrCollection.GetRow("StID=" + Convert.ToInt32(_stID));
this.cmbSession.SelectedValue = row_.SessionID.ToString();
this.cmbProgram.SelectedValue = row_.ProgramApplied.ToString();
this.txtEnrollNo.Text = row_.FormNo.ToString();
int clas_ = row_.ClassSought;
}
}
private Int32 GetID()
{
var row_ = new GuestStudentRow();
var obj_ = new simsdb();
row_ = obj_.GuestStudentCollection.GetRow("GuestID IN (SELECT TOP 1 GuestID FROM GuestStudent ORDER BY GuestID DESC)");
string retStr = row_.GuestID.ToString();
var result = retStr.Substring(retStr.LastIndexOf('-') + 1);
int incr = Convert.ToInt32(result) + 1;
return(incr);
}
protected void GetStudents(string SessionID, string ProgID, string ClassID)
{
var obj_ = new simsdb();
DataTable dt_ = new DataTable();
dt_ = obj_.Student_EnrCollection.GetAsDataTable("SessionID=" + SessionID + " AND ProgramApplied='" + ProgID + "' AND CLASSSOUGHT=" + cmbClassEnrolled.SelectedValue, " STUDENT_NAME");
simsdbCommon.FillTelericCombo(ref cmbStudent, dt_, "Student_Name", "STID");
//var Item_ = new Telerik.Web.UI.RadComboBoxItem();
//Item_.Text = i.ToString();
//Item_.Value = index.ToString();
//this.cmbStudent.Items.Add(Item_);
}
protected void btnAddPrevSchool_Click(object sender, EventArgs e)
{
using (var obj_ = new simsdb())
{
var row_ = new SchoolLastAttRow();
row_.PrevSchoolName = txtPrevSchool.Text;
row_.IsActive = true;
row_.Date_Modified = System.DateTime.Now;
row_.IsDeleted = false;
obj_.SchoolLastAttCollection.Insert(row_);
obj_.Dispose();
FillCombos();
}
}
protected void FillCombos()
{
using (var obj = new simsdb())
{
System.Data.DataTable dt = obj.SessionCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbSession, dt, "SessionName", "SessionID", true, "--Please Select Session--", "0");
}
using (var obj = new simsdb())
{
DataTable dt = obj.ProgramCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbProgram, dt, "ProgramDesc", "ProgramID", true, "--Please Select Program--", "0");
}
using (var obj = new simsdb())
{
DataTable dt = obj.ClassSectionCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbClassSection, dt, "clsSec_Description", "clsSecID", true, "--Please Select Class Sec--", "0");
}
}
protected void imgBtnDelete_Command(object sender, CommandEventArgs e)
{
var obj_ = new simsdb();
var row_ = new Student_EnrRow();
try
{
row_ = obj_.Student_EnrCollection.GetRow("AdmNo='" + e.CommandArgument.ToString() + "'");
txtEnrollNo.Text = row_.AdmNo.ToString();
obj_.Dispose();
}
catch (Exception ex)
{
string msgs = ex.Message.ToString();
}
finally
{
obj_.Dispose();
}
}
//public static int CalculateAge(DateTime birthDate)
//{
// DateTime now = DateTime.Today;
// int years = now.Year - birthDate.Year;
// if (now.Month < birthDate.Month || (now.Month == birthDate.Month && now.Day < birthDate.Day))
// --years;
// return years;
//}
protected void UpdateGuest(string _GuestID, string fval)
{
using (var obj = new simsdb())
{
var rowUp_ = new GuestStudentRow();
var row_ = new GuestStudentRow();
row_ = obj.GuestStudentCollection.GetRow("GuestID='" + _GuestID + "'");
string SessionID_ = row_.SessionID;
string ProgramSought = row_.ProgramSought;
Int32 Class = row_.Class;
string StudentName = row_.StudentName;
string FatherName = row_.FatherName;
string MobileNo = row_.MobileNo;
string LastSchool = row_.LastSchool;
string Gender = row_.Gender;
string Address = row_.Address;
DateTime DateCreated = row_.DateCreated;
string CreatedBy = row_.CreatedBy;
int Flag = Convert.ToInt32(fval);
//wrap in another row object
rowUp_.GuestID = _GuestID;
rowUp_.SessionID = SessionID_;
rowUp_.ProgramSought = ProgramSought;
rowUp_.Class = Class;
rowUp_.StudentName = StudentName;
rowUp_.FatherName = FatherName;
rowUp_.MobileNo = MobileNo;
rowUp_.LastSchool = LastSchool;
rowUp_.Gender = Gender;
rowUp_.Address = Address;
rowUp_.DateCreated = DateCreated;
rowUp_.CreatedBy = CreatedBy;
rowUp_.Flag = Flag;
obj.GuestStudentCollection.Update(rowUp_);
obj.Dispose();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
lblMessage.Text = "";
var obj_ = new simsdb();
var row_ = new GuestStudentRow();
try
{
string GuestID_ = this.txtFormNo.Text;
row_.GuestID = GuestID_.ToString();
row_.SessionID = this.cmbSession.SelectedItem.Text.ToString();
row_.ProgramSought = this.cmbProgram.SelectedItem.Text.ToString();
row_.Class = Convert.ToInt32(cmbClass.SelectedValue);
row_.StudentName = this.txtStudentNme.Text.ToString();
row_.FatherName = this.txtFathername.Text.ToString();
row_.MobileNo = this.txtMobileNo.Text;
row_.LastSchool = this.cmbSchoolLast.SelectedItem.Text.ToString();
row_.Gender = this.cmbGender.SelectedItem.Text.ToString();
row_.Address = this.txtaddress.Text;
row_.DateCreated = System.DateTime.Now;
row_.CreatedBy = "ZAHEER";
row_.Flag = Convert.ToInt32(this.cmbFlag.SelectedValue);
obj_.GuestStudentCollection.Insert(row_);
lblMessage.Text = "Record Inserted!";
showGrid();
}
catch (Exception ex)
{
lblMessage.Text = ex.Message.ToString();
}
finally
{
obj_.Dispose();
}
}
protected void FillCombos()
{
using (var obj = new simsdb())
{
DataTable dt = obj.SessionCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbSession, dt, "SessionName", "SessionID", true, "--Please Select Session--", "0");
}
using (var obj = new simsdb())
{
DataTable dt = obj.ProgramCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbProgram, dt, "ProgramDesc", "ProgramID", true, "--Please Select Program--", "0");
}
using (var obj = new simsdb())
{
DataTable dt = obj.FeeTypeCollection.GetAllAsDataTable();
simsdbCommon.FillTelericCombo(ref cmbFeeType, dt, "FeeTypeDesc", "FeeTypeID");//, true, "--Please Select Flag--", "0");
}
//using (var obj = new simsdb())
//{
// DataTable dt = obj.ClassSectionCollection.GetAllAsDataTable();
// simsdbCommon.FillTelericCombo(ref cmbClassSectionABC, dt, "clsSec_Description", "clsSecID", true, "--Please Select Class Sec--", "0");
//}
}
