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