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