private void DtStatus()
{
DataTable Dt = new DataTable();
Dt = ClsStatus.DtStatus();
RptStatus.DataSource = Dt;
RptStatus.DataBind();
}
protected void btnOK_clicck(object sendeer, EventArgs e)
{
if (txticesn.Text == "")
{
lblException.Text = "Please Insert Serial No. !";
}
else
{
pnlIMIDapp.Visible = true;
}
try
{
dtinfo.DateSeparator = "/";
dtinfo.ShortDatePattern = "dd/MM/yyyy";
int i = 0;
if (txticesn.Text == "")
{
lblExceptionApp.Text = "Please Insert Serial No.";
txticesn.Focus();
}
else
{
string sn = txticesn.Text.ToString() + "NewAdmission,";
ClsStatus clStatus = new ClsStatus();
bool bl = clStatus.changeStatus("Admission", txticesn.Text.ToString(), "", lblSeasonHidden.Text.ToString());
if (bl == false)
{
lblExceptionApp.Text = "Record Not Found !";
lblExceptionApp.ForeColor = System.Drawing.Color.Red;
lblStreamApp.Text = ""; lblCourseApp.Text = ""; lblIMIDAPP.Text = ""; lblPartApp.Text = ""; txtName.Text = "";
txtFather.Text = ""; lblExceptDob.Text = ""; txtDOB.Text = ""; txtAge.Text = ""; pnlAdmission.Visible = false;
panleSpace.Visible = true;
txticesn.Focus();
}
else
{
cmd = new SqlCommand("select AppNo from AppRecord where FormType like '%" + sn.ToString() + "%' and Session='" + lblSeasonHidden.Text.ToString() + "'", con);
con.Close(); con.Open();
string apno = Convert.ToString(cmd.ExecuteScalar());
con.Close();
if (apno != "")
{
i += 1;
lblLavelApp.Text = apno.ToString();
}
}
}
if (i == 1)
{
pnlAdmission.Visible = true;
panleSpace.Visible = false;
con.Close(); con.Open();
cmd = new SqlCommand("select * from AppRecord where AppNo='" + Convert.ToInt32(lblLavelApp.Text) + "' and Status!='NotApproved' and Status!='Hold' and Session='" + lblSeasonHidden.Text.ToString() + "'", con);
SqlDataReader sdr;
sdr = cmd.ExecuteReader();
if (sdr.Read())
{
lblEnrolment.Text = sdr["Enrolment"].ToString();
lblIMIDAPP.Text = sdr["IMID"].ToString();
lblstream.Text = sdr["Stream"].ToString();
if (lblstream.Text == "Asso")
{
lblStreamApp.Text = "Associate Examination";
}
else if (lblstream.Text == "Tech")
{
lblStreamApp.Text = "Technician Examination";
}
lblcourse.Text = sdr["Course"].ToString();
if (lblcourse.Text == "Civil")
{
lblCourseApp.Text = "Civil Engineering";
}
else if (lblcourse.Text == "Architecture")
{
lblCourseApp.Text = "Architectural Engineering";
}
lblPart.Text = sdr["Part"].ToString();
if (lblPart.Text == "PartI")
{
lblPartApp.Text = "PartI";
ddlAdmissionStatus.SelectedValue = "Regular";
}
else if (lblPart.Text == "PartII")
{
ddlAdmissionStatus.SelectedValue = "Direct";
lblPartApp.Text = "PartII";
}
else if (lblPart.Text == "SectionA")
{
ddlAdmissionStatus.SelectedValue = "Regular";
lblPartApp.Text = "SectionA";
}
else if (lblPart.Text == "SectionB")
{
ddlAdmissionStatus.SelectedValue = "Direct";
lblPartApp.Text = "SectionB";
}
appStream = lblstream.Text.ToString();
appCourse = lblcourse.Text.ToString();
appPart = lblPart.Text.ToString();
txtName.Text = sdr["Name"].ToString();
txtFather.Text = sdr["FName"].ToString();
txtDOB.Text = Convert.ToDateTime(sdr["DOB"].ToString()).ToString("dd/MM/yyyy");
//--------
hello(); //Date of Birth Age
//---------
statusApp = sdr["Status"].ToString();
}
sdr.Close();
cmd = new SqlCommand("select * from FeeMaster where FeeType='" + appStream.ToString() + "' and FeeLevel='" + lblFeeLevel.Text.ToString() + "' and Status='Active'", con);
sdr = cmd.ExecuteReader();
while (sdr.Read())
{
fee1 = Convert.ToDouble(sdr[1].ToString());
fee2 = Convert.ToDouble(sdr[3].ToString());
}
sdr.Close();
if (lblPartApp.Text == "PartI" || lblPartApp.Text == "SectionA")
{
lblEnrollFee.Text = fee1.ToString();
}
else
{
lblEnrollFee.Text = fee2.ToString();
}
sdr.Dispose();
chkEligibility();
con.Close();
}
}
catch (SqlException ex)
{
lblExceptionApp.Text = ex.ToString();
}
finally
{
con.Dispose();
txtName.Focus();
}
}
protected void btndel_Click(object sender, EventArgs e)
{
ClsStatus.DelData(Convert.ToString(txtEditSN.Text));
DtStatus();
Clear();
}
protected void btnEdit_Click(object sender, EventArgs e)
{
ClsStatus.EditData(txtEditDesc.Text, txtEditFam.Text, ddlEditBU.SelectedValue, txtEditLine.Text, ddlEditStatus.SelectedValue, txtEditOE.Text, txtEditRFID.Text, txtEditCO.Text, txtEditEAM.Text, txtEditAGD.Text, Convert.ToString(txtEditSN.Text));
DtStatus();
Clear();
}
protected void btnSave_Click(object sender, EventArgs e)
{
ClsStatus.SaveData(txtSN.Text, txtDesc.Text, txtFam.Text, ddlBU.SelectedValue, txtBULine.Text, ddlStatus.SelectedValue, txtOE.Text, txtRFID.Text, txtCO.Text, txtEAM.Text, txtAssetGD.Text);
DtStatus();
Clear();
}
