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) { } }