protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
            {
                Response.Redirect("../Login.aspx");
            }
            else
            {
                if (!IsPostBack)
                {
                    ClsEdit  clEdit  = new ClsEdit();
                    string[] stredit = clEdit.EditCount("DiarySupply");
                    lblCount.Text = stredit[0].ToString();
                    if (stredit[1] == "False")
                    {
                        pnlMain.Enabled = false;
                    }
                    else
                    {
                        pnlMain.Enabled = true;
                    }
                    txtDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
                    pnlVisiblefls(); pnlToFrom.Visible = false; pnlPsubmit.Visible = false;
                    maikal dev = new maikal();
                    int    se  = dev.chksession();
                    if (se == 0)
                    {
                        ddlExamSeason.SelectedValue = "Sum";
                    }
                    else
                    {
                        ddlExamSeason.SelectedValue = "Win";
                    }
                    txtYearSeason.Text   = DateTime.Now.Year.ToString();
                    lblHiddenSeason.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString();
                    panelCourier.Visible = false; btnNewDepartment.Visible = false;

                    tblEmpNameAcademic.Visible = false;
                    bindDiary();
                    ddlExamSeason.Focus();
                }
            }
        }
        catch (NullReferenceException ex)
        {
            Response.Redirect("../Login.aspx");
        }
    }
Ejemplo n.º 2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         if (Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]) == null)
         {
             Response.Redirect("../Login.aspx");
         }
         if (!IsPostBack)
         {
             ClsEdit  clEdit  = new ClsEdit();
             string[] stredit = clEdit.EditCount("ApplicationAdd");
             lblEnrolment.Text = stredit[0].ToString();
             if (stredit[1] == "False")
             {
                 pnlEdit.Enabled = false;
             }
             else
             {
                 pnlEdit.Enabled = true;
             }
             maikal dev = new maikal();
             int    se  = dev.chksession();
             if (se == 0)
             {
                 ddlsession.SelectedValue = "Sum";
             }
             else
             {
                 ddlsession.SelectedValue = "Win";
             }
             txtSession.Text      = DateTime.Now.Year.ToString();
             panelFee1.Visible    = false; panelFee2.Visible = false;
             lblSeasonHidden.Text = ddlsession.SelectedValue.ToString() + "" + txtSession.Text.ToString();
         }
     }
     catch (NullReferenceException ex)
     {
         Response.Redirect("../Login.aspx");
     }
     finally
     {
     }
 }
Ejemplo n.º 3
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
         {
             Response.Redirect("../Login.aspx");
         }
         else
         {
             if (!IsPostBack)
             {
                 maikal dev = new maikal();
                 int    se  = dev.chksession();
                 if (se == 0)
                 {
                     ddlExamSeason.SelectedValue = "Sum";
                 }
                 else
                 {
                     ddlExamSeason.SelectedValue = "Win";
                 }
                 txtYearSeason.Text       = DateTime.Now.Year.ToString();
                 lblExamSeasonHidden.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString();
                 ClsEdit cledit = new ClsEdit();
                 lblToExamDiary.Text       = cledit.ExamToDiary(lblExamSeasonHidden.Text.ToString());
                 lblExamFormSub.Text       = cledit.ExamFormSubmitted(lblExamSeasonHidden.Text.ToString());
                 lblExamFormApproved.Text  = cledit.ExamFormApproved(lblExamSeasonHidden.Text.ToString());
                 lblExamFormFilled.Text    = cledit.ExamFormFilled(lblExamSeasonHidden.Text.ToString());
                 lblExamHold.Text          = cledit.ExamFormHold(lblExamSeasonHidden.Text.ToString());
                 lblExamFormRollNo.Text    = cledit.ExamFormRollNO(lblExamSeasonHidden.Text.ToString());
                 lblExamFormAdmitCard.Text = cledit.ExamFormAdmitCard(lblExamSeasonHidden.Text.ToString());
                 btnViewMembership.Visible = false;
                 ddlExamSeason.Focus();
             }
         }
     }
     catch (NullReferenceException ex)
     {
         Response.Redirect("../Login.aspx");
     }
 }
Ejemplo n.º 4
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
         {
             Response.Redirect("../Login.aspx");
         }
         else
         {
             if (!IsPostBack)
             {
                 ClsEdit cledit = new ClsEdit();
                 maikal  dev    = new maikal();
                 int     se     = dev.chksession();
                 if (se == 0)
                 {
                     ddlExamSeason.SelectedValue = "Sum";
                 }
                 else
                 {
                     ddlExamSeason.SelectedValue = "Win";
                 }
                 txtYearSeason.Text       = DateTime.Now.Year.ToString();
                 lblExamSeasonHidden.Text = ddlExamSeason.SelectedValue.ToString() + "" + txtYearSeason.Text.ToString();
                 lblToExamForm.Text       = cledit.ExamFormFilled(lblExamSeasonHidden.Text.ToString());
                 lblMarkNotSubmitted.Text = cledit.ExamMarksNotSubmitted(lblExamSeasonHidden.Text.ToString());
                 lblMarksSubmitted.Text   = cledit.ExamMarksSubmitted(lblExamSeasonHidden.Text.ToString());
                 ddlExamSeason.Focus();
             }
         }
     }
     catch (NullReferenceException ex)
     {
         Response.Redirect("../Login.aspx");
     }
 }
Ejemplo n.º 5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         if (Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"]) == null)
         {
             Response.Redirect("../Login.aspx");
         }
         string IMID = Request.QueryString["acid"];
         string DNo  = Request.QueryString["DNo"];
         if (!IsPostBack)
         {
             ClsEdit  clEdit  = new ClsEdit();
             string[] stredit = clEdit.EditCount("DDEntry");
             lblEditCount.Text = stredit[0].ToString();
             if (stredit[1] == "False")
             {
                 pnlEdit.Enabled = false;
             }
             else
             {
                 pnlEdit.Enabled = true;
             }
             btnSubmitAmt.Enabled = false;
             maikal dev = new maikal();
             int    se  = dev.chksession();
             if (se == 0)
             {
                 ddlsession.SelectedValue = "Sum";
             }
             else
             {
                 ddlsession.SelectedValue = "Win";
             }
             txtSession.Text       = DateTime.Now.Year.ToString();
             lblhiddenSession.Text = ddlsession.SelectedValue.ToString() + "" + txtSession.Text.ToString();
             if (IMID != null || DNo != null)
             {
                 txtIDIM.Text    = IMID;
                 txtDiaryNo.Text = DNo;
                 View();
             }
             else
             {
                 txtIDIM.Text    = "";
                 txtDiaryNo.Text = "";
             }
             lblDDNNO.Text     = "DD No:";
             lblAccountNo.Text = "Diary No:";
             pnlIMInfo.Visible = false;
             txtDDNO.Visible   = true; txtDiaryNo.Visible = true;
             totalamt.Visible  = false; panelCourier.Visible = false;
             ddlsession.Focus();
             LoadDropdownList();
         }
     }
     catch (NullReferenceException ex)
     {
         txtIDIM.Enabled = false;
         Response.Redirect("../Login.aspx");
     }
     finally
     {
     }
 }
Ejemplo n.º 6
0
    protected void btnSubmitAmt_Click(object sender, EventArgs e)
    {
        con.Close(); con.Open();
        SqlCommand     cmd = new SqlCommand();
        SqlTransaction sTR;

        sTR            = con.BeginTransaction();
        cmd.Connection = con;
        int  dif  = 0;
        bool flag = false;

        cmd.Transaction = sTR;
        try
        {
            dtinfo.DateSeparator    = "/";
            dtinfo.ShortDatePattern = "dd/MM/yyyy";
            ClsEdit clEdit = new ClsEdit();
            clEdit.CountUp("DDEntry");
            //cmd.CommandText = "select * from IMAC where IMID='"+txtIDIM.Text+"'";
            //SqlDataReader read = cmd.ExecuteReader();
            //while (read.Read())
            //{
            //    tamt = Convert.ToInt32(read["Total"].ToString().TrimEnd('0').TrimEnd('.'));
            //    gamt = Convert.ToInt32(read["GTotal"].ToString().TrimEnd('0').TrimEnd('.'));
            //    dues = Convert.ToInt32(read["Credit"].ToString().TrimEnd('0').TrimEnd('.'));
            //}
            //read.Close();
            int oamt = Convert.ToInt32(GridAppTable.SelectedRow.Cells[2].Text);
            int namt = Convert.ToInt32(txtAmt.Text);
            if (namt >= oamt)
            {
                dif = namt - oamt;
                lblDiaryAmount.Text = (Convert.ToInt32(lblDiaryAmount.Text) + dif).ToString();
                flag = true;
            }
            else
            {
                dif = oamt - namt;
                lblDiaryAmount.Text = (Convert.ToInt32(lblDiaryAmount.Text) - dif).ToString();
                flag = false;
            }
            cmd.CommandText = "select SN from Account where Session='" + ddlsession.SelectedValue + txtSession.Text + "' and IMID='" + txtIDIM.Text + "' and DiaryNo='" + GridAppTable.SelectedRow.Cells[1].Text.ToString() + "' and Details='" + GridAppTable.SelectedRow.Cells[3].Text.ToString() + ":" + GridAppTable.SelectedRow.Cells[5].Text.ToString() + "'";
            int        Sn = Convert.ToInt32(cmd.ExecuteScalar());
            ClsAccount c2 = new ClsAccount();
            c2.AmountUpdate(Sn, txtAmt.Text, cmd, ddlBank.SelectedItem.Text, txtDDNO.Text);
            //ClsAccount cl = new ClsAccount();
            //cl.AmountSubmit(txtIDIM.Text.ToString(), txtDiaryNo.Text.ToString(), Convert.ToDateTime(txtDOB.Text, dtinfo), type, amt.ToString(), lblhiddenSession.Text.ToString(), "DD Edit",sTR,cmd);
            cmd.CommandText = "Update DiaryEntry set Amount='" + lblDiaryAmount.Text + "' where DiaryNo='" + txtDiaryNo.Text.ToString() + "'";
            cmd.ExecuteNonQuery();
            cmd.CommandText = "update FeeAC set IMID=@IMID,Amt=@Amt,AmtType=@AmtType,AmtFor=@AmtFor,SubDate=@SubDate,DDDate=@DDDate,DDNO=@DDNO,Bank=@Bank,Narration=@Narration,Session=@Session,DiaryNo=@DiaryNo where DDNO='" + GridAppTable.SelectedRow.Cells[3].Text.ToString() + "' and IMID='" + txtIDIM.Text + "' and DiaryNo='" + txtDiaryNo.Text + "'";
            cmd.Parameters.AddWithValue("@IMID", lblEnrolment.Text.ToString());
            cmd.Parameters.AddWithValue("@Amt", namt.ToString());
            cmd.Parameters.AddWithValue("@AmtType", ddlAmtType.SelectedValue.ToString());
            cmd.Parameters.AddWithValue("@AmtFor", ddlAmtForMs.SelectedValue.ToString());
            cmd.Parameters.AddWithValue("@SubDate", Convert.ToDateTime(txtDate.Text, dtinfo));
            cmd.Parameters.AddWithValue("@DDDate", Convert.ToDateTime(txtDOB.Text, dtinfo));
            cmd.Parameters.AddWithValue("@DDNO", txtDDNO.Text.ToString());
            cmd.Parameters.AddWithValue("@Bank", ddlBank.SelectedItem.Text);
            cmd.Parameters.AddWithValue("@Narration", txtNarration.Text.ToString());
            cmd.Parameters.AddWithValue("@Session", lblhiddenSession.Text.ToString());
            cmd.Parameters.AddWithValue("@DiaryNo", txtDiaryNo.Text.ToString());
            cmd.ExecuteNonQuery();
            cmd.CommandText = "Update IMAccount set Amount=Amount-'" + oamt + "' where IMID='" + lblEnrolment.Text + "' and Fees='" + GridAppTable.SelectedRow.Cells[8].Text.ToString() + "'";
            cmd.ExecuteNonQuery();
            cmd.CommandText = "Update IMAccount set Amount=Amount+'" + namt + "' where IMID='" + lblEnrolment.Text + "' and Fees='" + ddlAmtForMs.SelectedValue.ToString() + "'";
            cmd.ExecuteNonQuery();
            //cmd.CommandText = "update IMAC set Total='" + tamt.ToString() + "',Gtotal='" + gamt.ToString() + "',Credit='" + dues.ToString() + "' where IMID='" + txtIDIM.Text + "'";
            //cmd.ExecuteNonQuery();
            sTR.Commit();
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Sucessfully Submitted')", true);
            lblException.Text = lblTAmt.Text.ToString() + " Rs. is saved in IM: " + lblEnrolment.Text.ToString();
            string[] stredit = clEdit.EditCount("DDEntry");
            lblEditCount.Text = stredit[0].ToString();
            if (stredit[1] == "False")
            {
                pnlEdit.Enabled = false;
            }
            else
            {
                pnlEdit.Enabled = true;
            }
        }
        catch (SqlException ex)
        {
            sTR.Rollback();
            lblException.Text = ex.ToString();
        }
        catch (Exception ex)
        {
            lblException.Text = ex.ToString();
        }
        finally
        {
            View();
            con.Close();
            con.Dispose();
            txtDDNO.Text      = "";
            txtNarration.Text = "";
            txtAmt.Text       = "";
        }
        btnSubmitAmt.Enabled = false;
        lblEdit.Visible      = true;
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        try
        {
            con.Close(); con.Open();
            putZero();
            ClsEdit clEdit = new ClsEdit();
            if (lblFormType.Text == "Forms" || lblFormType.Text == "Others")
            {
                if ((Convert.ToInt32(txtADDNo.Text) >= Convert.ToInt32(lblADDNo.Text)) && (Convert.ToInt32(txtEnroll.Text) >= Convert.ToInt32(lblEnroll.Text)) && (Convert.ToInt32(txtExam.Text) >= Convert.ToInt32(lblExam.Text)) && (Convert.ToInt32(txtITI.Text) >= Convert.ToInt32(lblITI.Text)) && (Convert.ToInt32(txtCAD.Text) >= Convert.ToInt32(lblCAD.Text)) && (Convert.ToInt32(txtOtherForm.Text) >= Convert.ToInt32(lblOtherForm.Text)) && (Convert.ToInt32(txtODDNo.Text) >= Convert.ToInt32(lblODDNo.Text)) && (Convert.ToInt32(txtProvisional.Text) >= Convert.ToInt32(lblProvisional.Text)) && (Convert.ToInt32(txtDuplicate.Text) >= Convert.ToInt32(lblDuplicate.Text)) && (Convert.ToInt32(txtReChecking.Text) >= Convert.ToInt32(lblRechecking.Text)) && (Convert.ToInt32(txtFinalPass.Text) >= Convert.ToInt32(lblFinalPass.Text)) && (Convert.ToInt32(txtMembershipDD.Text) >= Convert.ToInt32(lblMembership.Text)) && (Convert.ToInt32(txtBooksDD.Text) >= Convert.ToInt32(lblBooks.Text)) && (Convert.ToInt32(txtPrespectusDD.Text) >= Convert.ToInt32(lblProspectus.Text)) && (Convert.ToInt32(txtPDD.Text) >= Convert.ToInt32(lblProj.Text)) && (Convert.ToInt32(txtProformaA.Text) >= Convert.ToInt32(lblProC.Text)) && (Convert.ToInt32(txtProformaB.Text) >= Convert.ToInt32(lblProB.Text)) && (Convert.ToInt32(txtProformaC.Text) >= Convert.ToInt32(lblProA.Text)))
                {
                    clEdit.CountUp("DiarySupply");
                    cmd = new SqlCommand("update DairyCount set ADDRcv=@ADDRcv,ODDRcv=@ODDRcv,EnrollFormRcv=@EnrollFormRcv,CADRcv=@CADRcv,ExamFormRcv=@ExamFormRcv,ITIRcv=@ITIRcv,OtherFormRcv=@OtherFormRcv,ProvisionalRcv=@ProvisionalRcv,FinalPassRcv=@FinalPassRcv,ReCheckingRcv=@ReCheckingRcv,DuplicateDocsRcv=@DuplicateDocsRcv,MemberRcv=@MemberRcv,BooksRcv=@BooksRcv,ProspectusRcv=@ProspectusRcv,TotalDDRcv=@TotalDDRcv,TotalNoForm=@TotalNoForm,ADDSub=@ADDSub,ODDSub=@ODDSub,EnrollFormSub=@EnrollFormSub,CADSub=@CADSub,ExamFormSub=@ExamFormSub,ITISub=@ITISub,OtherFormSub=@OtherFormSub,ProvisionalSub=@ProvisionalSub,FinalPassSub=@FinalPassSub,ReCheckingSub=@ReCheckingSub,DuplicateDocsSub=@DuplicateDocsSub,MemberSub=@MemberSub,BooksSub=@BooksSub,ProspectusSub=@ProspectusSub,TotalDDSub=@TotalDDSub where Session='" + lblHiddenSeason.Text + "' and DairyNo='" + txtDiaryNo.Text + "'", con);
                    cmd.Parameters.AddWithValue("@ODDRcv", Convert.ToInt32(txtODDNo.Text));
                    cmd.Parameters.AddWithValue("@ADDRcv", Convert.ToInt32(txtADDNo.Text));
                    cmd.Parameters.AddWithValue("@EnrollFormRcv", Convert.ToInt32(txtEnroll.Text));
                    cmd.Parameters.AddWithValue("@ExamFormRCv", Convert.ToInt32(txtExam.Text));
                    cmd.Parameters.AddWithValue("@CADRcv", Convert.ToInt32(txtCAD.Text));
                    cmd.Parameters.AddWithValue("@ITIRcv", Convert.ToInt32(txtITI.Text));
                    cmd.Parameters.AddWithValue("@OtherFormRcv", Convert.ToInt32(txtOtherForm.Text));
                    cmd.Parameters.AddWithValue("@ProvisionalRcv", Convert.ToInt32(txtProvisional.Text));
                    cmd.Parameters.AddWithValue("@FinalPassRcv", Convert.ToInt32(txtFinalPass.Text));
                    cmd.Parameters.AddWithValue("@ReCheckingRcv", Convert.ToInt32(txtReChecking.Text));
                    cmd.Parameters.AddWithValue("@DuplicateDocsRcv", Convert.ToInt32(txtDuplicate.Text));
                    cmd.Parameters.AddWithValue("@MemberRcv", Convert.ToInt32(txtMembershipDD.Text));
                    cmd.Parameters.AddWithValue("@ProspectusRcv", Convert.ToInt32(txtPrespectusDD.Text));
                    cmd.Parameters.AddWithValue("@BooksRcv", Convert.ToInt32(txtBooksDD.Text));

                    cmd.Parameters.AddWithValue("@TotalDDRcv", (Convert.ToInt32(txtADDNo.Text) + Convert.ToInt32(txtODDNo.Text) + Convert.ToInt32(txtPDD.Text) + Convert.ToInt32(txtMembershipDD.Text) + Convert.ToInt32(txtBooksDD.Text) + Convert.ToInt32(txtPrespectusDD.Text)));
                    cmd.Parameters.AddWithValue("@TotalNoForm", Convert.ToInt32(txtProformaA.Text) + Convert.ToInt32(txtProformaC.Text) + Convert.ToInt32(txtProformaB.Text) + Convert.ToInt32(txtEnroll.Text) + Convert.ToInt32(txtITI.Text) + Convert.ToInt32(txtCAD.Text) + Convert.ToInt32(txtOtherForm.Text) + Convert.ToInt32(txtExam.Text) + Convert.ToInt32(txtProvisional.Text) + Convert.ToInt32(txtFinalPass.Text) + Convert.ToInt32(txtReChecking.Text) + Convert.ToInt32(txtDuplicate.Text));

                    cmd.Parameters.AddWithValue("@ODDSub", Convert.ToInt32(lblODDNo.Text));
                    cmd.Parameters.AddWithValue("@ADDSub", Convert.ToInt32(lblADDNo.Text));
                    cmd.Parameters.AddWithValue("@EnrollFormSub", Convert.ToInt32(lblEnroll.Text));
                    cmd.Parameters.AddWithValue("@ExamFormSub", Convert.ToInt32(lblExam.Text));
                    cmd.Parameters.AddWithValue("@CADSub", Convert.ToInt32(lblCAD.Text));
                    cmd.Parameters.AddWithValue("@ITISub", Convert.ToInt32(lblITI.Text));
                    cmd.Parameters.AddWithValue("@OtherFormSub", Convert.ToInt32(lblOtherForm.Text));
                    cmd.Parameters.AddWithValue("@ProvisionalSub", Convert.ToInt32(lblProvisional.Text));
                    cmd.Parameters.AddWithValue("@FinalPassSub", Convert.ToInt32(lblFinalPass.Text));
                    cmd.Parameters.AddWithValue("@ReCheckingSub", Convert.ToInt32(lblRechecking.Text));
                    cmd.Parameters.AddWithValue("@DuplicateDocsSub", Convert.ToInt32(lblDuplicate.Text));
                    cmd.Parameters.AddWithValue("@MemberSub", Convert.ToInt32(lblMembership.Text));
                    cmd.Parameters.AddWithValue("@ProspectusSub", Convert.ToInt32(lblProspectus.Text));
                    cmd.Parameters.AddWithValue("@BooksSub", Convert.ToInt32(lblBooks.Text));
                    cmd.Parameters.AddWithValue("@TotalDDSub", (Convert.ToInt32(lblADDNo.Text) + Convert.ToInt32(lblODDNo.Text) + Convert.ToInt32(lblProspectus.Text) + Convert.ToInt32(lblMembership.Text) + Convert.ToInt32(lblBooks.Text) + Convert.ToInt32(lblProspectus.Text)));
                    cmd.ExecuteNonQuery();
                    cmd = new SqlCommand("update ProjectCount set EmpName=@EmpName,EmpCode=@EmpCode,DDRcv=@DDRcv,DDSub=@DDSub,ProformaARCv=@ProformaARcv,ProformaASub=@ProformaASub,ProformaBRcv=@ProformaBRcv,ProformaBSub=@ProformaBSub where  Session='" + lblHiddenSeason.Text + "' and DairyNo='" + txtDiaryNo.Text + "'", con);
                    cmd.Parameters.AddWithValue("@DDRcv", Convert.ToInt32(txtPDD.Text));
                    cmd.Parameters.AddWithValue("@DDSub", Convert.ToInt32(lblProj.Text));
                    cmd.Parameters.AddWithValue("@EmpName", Convert.ToInt32(txtProformaC.Text));
                    cmd.Parameters.AddWithValue("@EmpCode", Convert.ToInt32(lblProA.Text));
                    cmd.Parameters.AddWithValue("@ProformaARcv", Convert.ToInt32(txtProformaA.Text));
                    cmd.Parameters.AddWithValue("@ProformaASub", Convert.ToInt32(lblProC.Text));
                    cmd.Parameters.AddWithValue("@ProformaBRcv", Convert.ToInt32(txtProformaB.Text));
                    cmd.Parameters.AddWithValue("@ProformaBSub", Convert.ToInt32(lblProB.Text));
                    cmd.ExecuteNonQuery();
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Diary Successfully Updated')", true);
                }
                else
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Please Update Lessthen Submitted Count')", true);
                }
            }
            else
            {
                cmd = new SqlCommand("update DairyCount set LatterTo='" + txtLtrTo.Text + "',LatterFrom='" + txtFrom.Text + "',Department='" + ddlDeparmentNeme.SelectedValue + "',EmpName='" + txtEmpName.Text + "' where Session='" + lblHiddenSeason.Text + "' and DairyNo='" + txtDiaryNo.Text + "'", con);
                cmd.ExecuteNonQuery();
                if (lblFormType.Text == "Others" && ddlDeparmentNeme.Text == "ADMINISTRATION")
                {
                    if ((Convert.ToInt32(txtMembershipDD.Text) >= Convert.ToInt32(lblMembership.Text) && Convert.ToInt32(txtBooksDD.Text) >= Convert.ToInt32(lblBooks.Text) && Convert.ToInt32(txtPrespectusDD.Text) >= Convert.ToInt32(lblProspectus.Text)))
                    {
                        clEdit.CountUp("DiarySupply");
                        int total = (Convert.ToInt32(txtMembershipDD.Text) + Convert.ToInt32(txtBooksDD.Text) + Convert.ToInt32(txtPrespectusDD.Text));
                        cmd = new SqlCommand("update DairyCount set MemberRcv=@MemberRcv,BooksRcv=@BooksRcv,ProspectusRcv=@ProspectusRcv,TotalDDRcv='" + total + "' where Session='" + lblHiddenSeason.Text + "' and DairyNo='" + txtDiaryNo.Text + "'", con);
                        cmd.Parameters.AddWithValue("@MemberRcv", Convert.ToInt32(txtMembershipDD.Text));
                        cmd.Parameters.AddWithValue("@ProspectusRcv", Convert.ToInt32(txtPrespectusDD.Text));
                        cmd.Parameters.AddWithValue("@BooksRcv", Convert.ToInt32(txtBooksDD.Text));
                        cmd.ExecuteNonQuery();
                        ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Diary Successfully Updated')", true);
                    }
                }
            }
            string[] stredit = clEdit.EditCount("DiarySupply");
            lblCount.Text = stredit[0].ToString();
            if (stredit[1] == "False")
            {
                pnlMain.Enabled = false;
            }
            else
            {
                pnlMain.Enabled = true;
            }
            con.Close(); con.Dispose();
        }
        catch (SqlException ex)
        {
        }
    }