protected void Pay0_Click(object sender, EventArgs e)
{
if (agent_no.Text == "" || com_amt.Text == "" || td_ded.Text == "" || Savingaccno.Text == "")
{
WebMsgBox.Show("Sorry. PLease Enter requer fild", this.Page);
agent_no.Focus();
com_amt.Focus();
Savingaccno.Focus();
td_ded.Focus();
return;
}
else
{
string scroll_no = "";
int glcode = CLScom.GetGLcode("1007", Session["BRCD"].ToString());
int plcode = CLScom.GetPLaccno("1007", Session["BRCD"].ToString());
int setno = Convert.ToInt32(conn.sExecuteScalar("SELECT MAX(LASTNO)FROM AVS1000 WHERE ACTIVITYNO=7"));
int auther = ATH.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), glcode.ToString(), plcode.ToString(), agent_no.Text.ToString(), net_commission.Text.ToString(), net_commission.Text.ToString(), net_commission.Text.ToString(), "1", "7", "Transfer", setno.ToString(), "", "", "", "", "1001", "", Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "0", SA_no.Text.ToString(), SA_name.Text.ToString(), "0", "0");
if (auther == 1)
{
WebMsgBox.Show("Transfer is complete'", this.Page);
}
/*
* agent_no.Text = "";
* Agent_name.Text = "";
* Start_date.Text = "";
* last_date.Text = "";
* Total_coll.Text = "";
* commission.Text = "";
* com_amt.Text = "";
* td_ded.Text = "";
* TDamt.Text = "";
* net_commission.Text = "";
* Savingaccno.Text = "";
* SA_name.Text = "";
* SA_no.Text = "";
* agent_no.Focus();
*/
/* WebMsgBox.Show("validation is OK",this.Page);
* ?*/
}
}
protected void GrdAN_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string accno = (GrdAN.SelectedRow.FindControl("ACCNO") as Label).Text;
string subglcode = (GrdAN.SelectedRow.FindControl("SUBGLCODE") as Label).Text;
//string glcode = (GrdAN.SelectedRow.FindControl("GLCODE") as Label).Text;
string amount = (GrdAN.SelectedRow.FindControl("IBAL") as Label).Text;
string instno = (GrdAN.SelectedRow.FindControl("INSTNO") as Label).Text;
string instd = (GrdAN.SelectedRow.FindControl("INSTD") as Label).Text;
string cname = (GrdAN.SelectedRow.FindControl("ANAME") as Label).Text;
string custno = (GrdAN.SelectedRow.FindControl("CUSTNO") as Label).Text;
string gl = "";
int Result = 0;
string SetNo;
if (ViewState["FL"].ToString() == "A")
{
SetNo = BD.GetSetNo(Session["EntryDate"].ToString(), "DaySetNo", Session["BRCD"].ToString()).ToString();
//int resultout = BD.SetSetno(Session["EntryDate"].ToString(), "DaySetNo", SetNo);
gl = BD.GetAccTypeGL(subglcode, Session["BRCD"].ToString());
string[] glc = gl.Split('_');
string glcode = glc[1].ToString();
Result = AA.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), glcode, subglcode, accno, "", "", amount, "2", "1", "By CLG", SetNo, instno, instd, "0", "0", "1003", "0", Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "0", custno, cname, "0", "0");
if (Result > 0)
{
// int resultout = CurrentCls.UpdateSet(setno, Session["BRCD"].ToString());
// SG 06\10\16
if (Result > 0)
{
//lblMessage.Text = "Record Submitted Successfully Woth Recipt No :" + SetNo;
WebMsgBox.Show(" Record Submitted with No : " + SetNo, this.Page);
//ModalPopup.Show(this.Page);
}
}
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
try
{
string Date = Today.ToString("dd-MM-yyyy");
double BAL, AMT;
BAL = Convert.ToDouble(txtBalance.Text == "" ? "0" : txtBalance.Text);
AMT = Convert.ToDouble(TxtInstAmt.Text == "" ? "0" : TxtInstAmt.Text);
if (AMT <= BAL)
{
if (ViewState["Flag"].ToString() == "AD")
{
if (DDltransctntype.SelectedValue == "0")
{
WebMsgBox.Show("Please select Transaction Type", this.Page);
DDltransctntype.Focus();
return;
}
if (TxtInstAmt.Text == "")
{
WebMsgBox.Show("Please enter Instrument Amount", this.Page);
TxtInstAmt.Focus();
return;
}
if (DDltransctntype.SelectedItem.Text == "D" && Txtdraweloc.Text == "")
{
WebMsgBox.Show("Please enter Drawee Location ", this.Page);
Txtdraweloc.Focus();
return;
}
if (DDltransctntype.SelectedItem.Text == "N" && Txtcustrefno.Text == "")
{
WebMsgBox.Show("Please enter Cust ref No ", this.Page);
Txtcustrefno.Focus();
return;
}
if (Txtpayd5.Text == "")
{
WebMsgBox.Show("Please enter Payment Details 5", this.Page);
Txtpayd5.Focus();
return;
}
if (Txtpayd6.Text == "")
{
WebMsgBox.Show("Please enter Payment Details 6", this.Page);
Txtpayd6.Focus();
return;
}
if (Txtpayd7.Text == "")
{
WebMsgBox.Show("Please enter Payment Details 7", this.Page);
Txtpayd7.Focus();
return;
}
if (Txtchqtrndate.Text == "")
{
WebMsgBox.Show("Please enter Cheque Date", this.Page);
Txtchqtrndate.Focus();
return;
}
if (DDltransctntype.SelectedItem.Text == "R" && Txtifccode.Text == "")
{
WebMsgBox.Show("Please enter IFC Code", this.Page);
Txtifccode.Focus();
return;
}
if (DDltransctntype.SelectedItem.Text == "N" && Txtifccode.Text == "")
{
WebMsgBox.Show("Please enter IFC Code", this.Page);
Txtifccode.Focus();
return;
}
if (DDltransctntype.SelectedItem.Text == "R" && Txtbenebankname.Text == "")
{
WebMsgBox.Show("Please enter BeneBankName", this.Page);
Txtbenebankname.Focus();
return;
}
if (DDltransctntype.SelectedItem.Text == "N" && Txtbenebankname.Text == "")
{
WebMsgBox.Show("Please enter BeneBankName", this.Page);
Txtbenebankname.Focus();
return;
}
int Result = OW.Insertdata(DDltransctntype.SelectedItem.Text, Txtbeneficrycode.Text, TxtbeneAccno.Text, TxtInstAmt.Text, Txtbenename.Text, Txtdraweloc.Text, Txtprntloc.Text, Txtbeneadd1.Text,
Txtbeneadd2.Text, Txtbeneadd3.Text, Txtbeneadd4.Text, Txtbeneadd5.Text, Txtinstrefno.Text, Txtcustrefno.Text, Txtpayd1.Text, Txtpayd2.Text, Txtpayd3.Text, Txtpayd4.Text, Txtpayd5.Text,
Txtpayd6.Text, Txtpayd7.Text, Txtchequeno.Text, Txtchqtrndate.Text, Txtmicrno.Text, Txtifccode.Text, Txtbenebankname.Text, Txtbenebranchnme.Text, Txtbeneemail.Text, "1001", Session["BRCD"].ToString(),
ddlPayType.SelectedItem.Text, txtProdType1.Text, TxtAccNo1.Text, Txtinstno.Text, TxtChequeDate.Text, txtNarration.Text, txtBalance.Text, Session["MID"].ToString());
if (Result > 0)
{
WebMsgBox.Show("Data Added successfully..!!", this.Page);
BindGrid();
FL = "Insert";//Dhanya Shetty
string Res = CLM.LOGDETAILS(FL, Session["BRCD"].ToString(), Session["MID"].ToString(), "OutwardRTGS_Add _" + TxtbeneAccno.Text + "_" + Session["LOGINCODE"].ToString() + "", "00", Session["MID"].ToString());
Cleardata();
return;
}
}
else if (ViewState["Flag"].ToString() == "AT")
{
string ST = "";
int Result = OW.AuthoriseData(Session["BRCD"].ToString(), TxtbeneAccno.Text, ViewState["Id"].ToString(), Session["MID"].ToString());
if (Result > 0)
{
double CBAl = Convert.ToDouble(txtBalance.Text);
double Total = Convert.ToDouble(TxtInstAmt.Text);
string CbalT = Convert.ToString(CBAl - Total);
ST = BD.GetSetNo(Session["EntryDate"].ToString(), "IBTSetNo", Session["BRCD"].ToString()).ToString();
if (ddlPayType.SelectedValue == "2")
{
int RM = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), ViewState["GLCODE"].ToString(), txtProdType1.Text, TxtAccNo1.Text, txtNarration.Text, "RTGS/NFT",
CbalT, "1", "7", "TR", ST, Txtinstno.Text, TxtChequeDate.Text, "0", "0", "1001", "0", Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "OutwardDetail_TRF", "0", TxtAccName1.Text, "0", "0");
if (RM > 0)
{
RM = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), ViewState["GLCODE"].ToString(), txtProdType1.Text, TxtbeneAccno.Text, txtNarration.Text, "RTGS/NFT",
TxtInstAmt.Text, "2", "7", "TR", ST, Txtinstno.Text, TxtChequeDate.Text, "0", "0", "1001", "0", Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "OutwardDetail_TRF", "0", Txtbenename.Text, "0", "0");
if (RM > 0)
{
WebMsgBox.Show("Data authorised successfully and Voucher Posted successfully With Set No: " + ST + "!!", this.Page);
GenerateText();
BindGrid();
FL = "Insert";//Dhanya Shetty
string Res = CLM.LOGDETAILS(FL, Session["BRCD"].ToString(), Session["MID"].ToString(), "OutwardRTGS_Auth_T _" + TxtbeneAccno.Text + "_" + ST + "_" + Session["LOGINCODE"].ToString() + "", "00", Session["MID"].ToString());
Cleardata();
return;
}
}
}
else if (ddlPayType.SelectedValue == "4")
{
int RM = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), ViewState["GLCODE"].ToString(), txtProdType1.Text, TxtAccNo1.Text, txtNarration.Text, "RTGS/NFT",
CbalT, "1", "7", "TR", ST, Txtinstno.Text, TxtChequeDate.Text, "0", "0", "1001", "0", Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "OutwardDetail_Chq", "0", TxtAccName1.Text, "0", "0");
if (RM > 0)
{
RM = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), ViewState["GLCODE"].ToString(), txtProdType1.Text, TxtbeneAccno.Text, txtNarration.Text, "RTGS/NFT",
TxtInstAmt.Text, "2", "7", "TR", ST, Txtinstno.Text, TxtChequeDate.Text, "0", "0", "1001", "0", Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "OutwardDetail_Chq", "0", Txtbenename.Text, "0", "0");
if (RM > 0)
{
WebMsgBox.Show(" Data authorised successfully and Voucher Posted successfully With Set No: " + ST + "!!", this.Page);
GenerateText();
BindGrid();
FL = "Insert";//Dhanya Shetty
string Res = CLM.LOGDETAILS(FL, Session["BRCD"].ToString(), Session["MID"].ToString(), "OutwardRTGS_Auth_Cq _" + TxtbeneAccno.Text + "_" + ST + "_" + Session["LOGINCODE"].ToString() + "", "00", Session["MID"].ToString());
Cleardata();
return;
}
}
}
}
}
else if (ViewState["Flag"].ToString() == "DL")
{
int Result = OW.DeleteData(Session["BRCD"].ToString(), TxtbeneAccno.Text, ViewState["Id"].ToString(), Session["MID"].ToString());
if (Result > 0)
{
WebMsgBox.Show("Data Deleted successfully..!!", this.Page);
BindGrid();
FL = "Insert";//Dhanya Shetty
string Res = CLM.LOGDETAILS(FL, Session["BRCD"].ToString(), Session["MID"].ToString(), "OutwardRTGS_Del _" + TxtbeneAccno.Text + "_" + Session["LOGINCODE"].ToString() + "", "00", Session["MID"].ToString());
Cleardata();
return;
}
}
}
else
{
WebMsgBox.Show("Amount is greater than balance!", this.Page);
TxtInstAmt.Text = "";
TxtInstAmt.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
public string PostEntry(string MID, string SGLCD, string ACCNO, string EDT, string BRCD, string STT, string FL)
{
string SetNo = "", ST = "";
string CR, DR;
string REFNO = "";
CR = DR = "";
try
{
string PAYMAST = "";
if (FL == "RDCL")
{
PAYMAST = "RDCLOSE";
}
else if (FL == "LINST")
{
PAYMAST = "LOANINSTALLMENT";
}
string REFERENCEID = "";
REFERENCEID = BD.GetMaxRefid(BRCD, EDT, "REFID");
REFERENCEID = (Convert.ToInt32(REFERENCEID) + 1).ToString(); //ABHISHEK
sql = "SELECT ISNULL(MAX(LASTNO),0)+1 FROM AVS1000 WHERE SRNO='1' and BRCD='" + BRCD + "'"; //BRCD ADDED --Abhishek
REFNO = conn.sExecuteScalar(sql);
//Added by amol on 09/11/2017 as per ambika madam instruction (only when payment mode is cash)
sql = "SELECT TOP 1 ACTIVITY FROM TEMPBATCHRD WHERE MID='" + MID + "' AND BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND SETNO='" + STT + "' And ACTIVITY = '3' ORDER BY ACTIVITY DESC";
sResult = conn.sExecuteScalar(sql);
if (sResult == "3")
{
//For Cash Receipt set
DT = new DataTable();
sql = "SELECT * FROM TEMPBATCHRD WHERE MID='" + MID + "' AND BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND SETNO='" + STT + "' And ACTIVITY = '3' And AMt > 0 ORDER BY ACTIVITY DESC";
DT = conn.GetDatatable(sql);
if (DT.Rows.Count > 0)
{
ST = BD.GetSetNo(EDT, "DaySetNo", BRCD).ToString();
for (int K = 0; K < DT.Rows.Count; K++)
{
if (DT.Rows[K]["TRXTYPE"].ToString() == "1")
{
CR = DT.Rows[K]["AMT"].ToString();
DR = "0";
}
else
{
DR = DT.Rows[K]["AMT"].ToString();
CR = "0";
}
Result = AZ.Authorized(EDT, EDT, Convert.ToDateTime(DT.Rows[K]["MID_DATE"]).ToString("dd/MM/yyyy"), DT.Rows[K]["GL"].ToString(), DT.Rows[K]["SUBGL"].ToString(), DT.Rows[K]["ACCNO"].ToString(), DT.Rows[K]["NR"].ToString(), DT.Rows[K]["NR1"].ToString(), DT.Rows[K]["AMT"].ToString(), DT.Rows[K]["TRXTYPE"].ToString(), DT.Rows[K]["ACTIVITY"].ToString(), DT.Rows[K]["PMT"].ToString(), ST, "0", "01/01/1900", "0", "0", "1001", "01/01/1900", BRCD, MID, "0", "0", PAYMAST, DT.Rows[K]["CUSTNO"].ToString(), DT.Rows[K]["ACCNAME"].ToString(), REFERENCEID, "0");
}
}
SetNo = ST;
//For Cash Payment set
DT = new DataTable();
sql = "SELECT * FROM TEMPBATCHRD WHERE MID='" + MID + "' AND BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND SETNO='" + STT + "' And ACTIVITY = '4' And AMt > 0 ORDER BY ACTIVITY DESC";
DT = conn.GetDatatable(sql);
if (DT.Rows.Count > 0)
{
ST = BD.GetSetNo(EDT, "DaySetNo", BRCD).ToString();
for (int K = 0; K < DT.Rows.Count; K++)
{
if (DT.Rows[K]["TRXTYPE"].ToString() == "1")
{
CR = DT.Rows[K]["AMT"].ToString();
DR = "0";
}
else
{
DR = DT.Rows[K]["AMT"].ToString();
CR = "0";
}
Result = AZ.Authorized(EDT, EDT, Convert.ToDateTime(DT.Rows[K]["MID_DATE"]).ToString("dd/MM/yyyy"), DT.Rows[K]["GL"].ToString(), DT.Rows[K]["SUBGL"].ToString(), DT.Rows[K]["ACCNO"].ToString(), DT.Rows[K]["NR"].ToString(), DT.Rows[K]["NR1"].ToString(), DT.Rows[K]["AMT"].ToString(), DT.Rows[K]["TRXTYPE"].ToString(), DT.Rows[K]["ACTIVITY"].ToString(), DT.Rows[K]["PMT"].ToString(), ST, "0", "01/01/1900", "0", "0", "1001", "01/01/1900", BRCD, MID, "0", "0", PAYMAST, DT.Rows[K]["CUSTNO"].ToString(), DT.Rows[K]["ACCNAME"].ToString(), REFERENCEID, "0");
}
}
SetNo = SetNo + "_" + ST;
}
else
{
sql = "SELECT * FROM TEMPBATCHRD WHERE MID='" + MID + "' AND BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND SETNO='" + STT + "' ORDER BY ACTIVITY DESC";
DataTable DT = new DataTable();
DT = conn.GetDatatable(sql);
if (DT.Rows.Count > 0)
{
ST = BD.GetSetNo(EDT, "DaySetNo", BRCD).ToString();
for (int K = 0; K < DT.Rows.Count; K++)
{
if (DT.Rows[K]["TRXTYPE"].ToString() == "1")
{
CR = DT.Rows[K]["AMT"].ToString();
DR = "0";
}
else
{
DR = DT.Rows[K]["AMT"].ToString();
CR = "0";
}
Result = AZ.Authorized(EDT, EDT, Convert.ToDateTime(DT.Rows[K]["MID_DATE"]).ToString("dd/MM/yyyy"), DT.Rows[K]["GL"].ToString(), DT.Rows[K]["SUBGL"].ToString(), DT.Rows[K]["ACCNO"].ToString(), DT.Rows[K]["NR"].ToString(), DT.Rows[K]["NR1"].ToString(), DT.Rows[K]["AMT"].ToString(), DT.Rows[K]["TRXTYPE"].ToString(), DT.Rows[K]["ACTIVITY"].ToString(), DT.Rows[K]["PMT"].ToString(), ST, "0", "01/01/1900", "0", "0", "1001", "01/01/1900", BRCD, MID, "0", "0", PAYMAST, DT.Rows[K]["CUSTNO"].ToString(), DT.Rows[K]["ACCNAME"].ToString(), REFERENCEID, "0");
}
}
SetNo = ST + "_0";
}
sql = "DELETE FROM TEMPBATCHRD WHERE MID='" + MID + "' AND BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND SETNO='" + STT + "'";
Result = conn.sExecuteQuery(sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(SetNo);
}
protected void Btn_Submit_Click(object sender, EventArgs e)
{
try
{
string GLCODE = "", TGLCODE = "";
GLCODE = BD.GetAccTypeGL(TxtProcode.Text, Session["BRCD"].ToString());
string[] GL = GLCODE.Split('_');
string TGL = BD.GetAccTypeGL(TxtTProcode.Text, Session["BRCD"].ToString());
string[] TG = TGL.Split('_');
double TotalDR = Convert.ToDouble(TxtTotalBal.Text) + Convert.ToDouble(TxtCrInt.Text);
string ST = BD.GetSetNo(Session["EntryDate"].ToString(), "DaySetNo", Session["BRCD"].ToString()).ToString();
// int resultout = BD.SetSetno(Session["EntryDate"].ToString(), "DaySetNo", ST);
ViewState["ST"] = ST.ToString();
if (Ddl_type.SelectedIndex == 1)
{
Result = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), GL[1].ToString(), TxtProcode.Text,
TxtAccNo.Text, "BY CASH", "BY CASH", TxtFinal.Text, "2", "4", "CASH", ST, "0", "1900/01/01", "0", "0", "1001", Session["EntryDate"].ToString(),
Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "CP", TxtCustNo.Text, TxtAccName.Text, "1", "0");
if (Result > 0)
{
Result = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), TG[1].ToString(), TxtTProcode.Text,
"", "BY CASH", "BY CASH", TxtFinal.Text, "1", "4", "CASH", ST, "0", "1900/01/01", "0", "0", "1001", Session["EntryDate"].ToString(),
Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "CP", TxtCustNo.Text, TxtAccName.Text, "1", "0");
}
}
else if (Ddl_type.SelectedIndex == 2)
{
Result = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), GL[1].ToString(), TxtProcode.Text,
TxtAccNo.Text, "TO CHEQUE", "TO CHEQUE", TxtFinal.Text, "2", "4", "CHEQUE", ST, "0", "1900/01/01", "0", "0", "1001", Session["EntryDate"].ToString(),
Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "CP", TxtCustNo.Text, TxtAccName.Text, "1", "0");
if (Result > 0)
{
Result = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), TG[1].ToString(), TxtTProcode.Text,
"", "BY CHEQUE", "BY CHEQUE", TxtFinal.Text, "1", "4", "CHEQUE", ST, TxtInstNo.Text, TxtInstruDate.Text, "0", "0", "1001", Session["EntryDate"].ToString(),
Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "CP", TxtCustNo.Text, TxtAccName.Text, "1", "0");
}
}
else if (Ddl_type.SelectedIndex == 3)
{
// GLCODE = BD.GetAccTypeGL(TxtTProcode.Text, Session["BRCD"].ToString());
Result = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), GL[1].ToString(), TxtProcode.Text,
TxtAccNo.Text, "BY TRF", "BY TRF", TxtFinal.Text, "2", "7", "TRF", ST, "0", "1900/01/01", "0", "0", "1001", Session["EntryDate"].ToString(),
Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "TR", TxtCustNo.Text, TxtAccName.Text, "1", "0");
if (Result > 0)
{
Result = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), TG[1].ToString(), TxtTProcode.Text,
TxtTAccno.Text, "BY TRF", "BY TRF", TxtFinal.Text, "1", "7", "TRF", ST, "0", "1900/01/01", "0", "0", "1001", Session["EntryDate"].ToString(),
Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "TR", TxtCustNo.Text, TxtAccName.Text, "1", "0");
}
}
Result = CACC.Post_Charges(TxtMaxC.Text, TxtOtherChrgs.Text, TxtIntApp.Text, TxtEarlyClose.Text, TxtUnsedChqChrges.Text, TxtServChrgs.Text, TxtTotalTax.Text, TxtTotalCease.Text, TxtBCCT.Text, TxtCrInt.Text,
Session["BRCD"].ToString(), Session["EntryDate"].ToString(), Session["MID"].ToString(), TxtCustNo.Text, TxtAccName.Text, ST.ToString(), TxtAccNo.Text, GL[1].ToString(), TxtProcode.Text);
if (Result > 0)
{
Result = CACC.Operate_Closure(Session["BRCD"].ToString(), Session["EntryDate"].ToString(), TxtProcode.Text, TxtAccNo.Text);
if (Result > 0)
{
Btn_Receipt.Visible = true;
WebMsgBox.Show("Vocuher No Generated is:" + ST + " and Account Closed Successfully", this.Page);
ViewState["SETNO"] = ST;
FL = "Insert";//Dhanya Shetty
string Res = CLM.LOGDETAILS(FL, Session["BRCD"].ToString(), Session["MID"].ToString(), "Check_acc_close _" + ST + "_" + TxtProcode.Text + "_" + TxtAccNo.Text + "_" + Session["LOGINCODE"].ToString() + "", "00", Session["MID"].ToString());
ViewState["CNO"] = TxtCustNo.Text;
ViewState["NAME"] = TxtAccName.Text;
Clear();
}
}
else
{
WebMsgBox.Show("Operation Failed!.......", this.Page);
Clear();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void btnAuthorize_Click(object sender, EventArgs e)
{
string SetNo = "", RefId = "";
string GlCode = "", SubGlCode = "";
try
{
if (Convert.ToDouble(txtChequeAmt.Text.ToString() == "" ? "0" : txtChequeAmt.Text.ToString()) >= Convert.ToDouble(txtTotBalance.Text.ToString() == "" ? "0" : txtTotBalance.Text.ToString()))
{
btnAuthorize.Focus();
WebMsgBox.Show("Enter amount less than or equal to balance...!!", this.Page);
return;
}
else
{
DT = new DataTable();
GST = new DataTable();
DT = PO.GetDetails(Session["BRCD"].ToString(), ViewState["SrNumber"].ToString());
GST = PO.GstDetails(Session["BRCD"].ToString());
if (DT.Rows.Count > 0 && GST.Rows.Count > 0)
{
if (DT.Rows[0]["IssueBrCode"].ToString() != DT.Rows[0]["CrBrCode"].ToString())
{
SetNo = BD.GetSetNo(Session["EntryDate"].ToString(), "IBTSetNo", Session["BRCD"].ToString()).ToString();
RefId = BD.GetMaxRefid(Session["BRCD"].ToString(), Session["EntryDate"].ToString(), "REFID");
ViewState["RID"] = (Convert.ToInt32(RefId) + 1).ToString();
}
else
{
SetNo = BD.GetSetNo(Session["EntryDate"].ToString(), "DaySetNo", Session["BRCD"].ToString()).ToString();
RefId = BD.GetMaxRefid(Session["BRCD"].ToString(), Session["EntryDate"].ToString(), "REFID");
ViewState["RID"] = (Convert.ToInt32(RefId) + 1).ToString();
}
if (Convert.ToDouble(SetNo) > 0)
{
double TotalAmount = Convert.ToDouble(Convert.ToDouble(DT.Rows[0]["ChequeAmt"].ToString()) + Convert.ToDouble(DT.Rows[0]["ChargesAmt"].ToString()));
// For Total Debit Amount Voucher
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueGlCode"].ToString(), DT.Rows[0]["IssueSubGlCode"].ToString(),
DT.Rows[0]["IssueAccNo"].ToString(), DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), TotalAmount.ToString(), "2", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(),
"0", "0", "1003", "", DT.Rows[0]["IssueBrCode"].ToString(), DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
// For Total Credit Amount Voucher
if (Result > 0)
{
// Bank contra if debit and credit branch are not same
if (DT.Rows[0]["IssueBrCode"].ToString() != DT.Rows[0]["CrBrCode"].ToString())
{
if (DT.Rows[0]["IssueBrCode"].ToString() == "1" || DT.Rows[0]["CrBrCode"].ToString() == "1")
{
if (Result > 0)
{
DT2 = new DataTable();
DT2 = PO.GetADMSubGl(DT.Rows[0]["CrBrCode"].ToString());
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT2.Rows[0]["ADMGlCode"].ToString(), DT2.Rows[0]["ADMSubGlCode"].ToString(),
"0", DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), TotalAmount.ToString(), "1", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(), "0", "0", "1003",
"", DT.Rows[0]["IssueBrCode"].ToString(), DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
}
if (Result > 0)
{
DT2 = new DataTable();
DT2 = PO.GetADMSubGl(DT.Rows[0]["IssueBrCode"].ToString());
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT2.Rows[0]["ADMGlCode"].ToString(), DT2.Rows[0]["ADMSubGlCode"].ToString(),
"0", DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), TotalAmount.ToString(), "2", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(), "0", "0", "1003",
"", DT.Rows[0]["CrBrCode"].ToString(), DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
}
}
else
{
if (Result > 0)
{
DT2 = new DataTable();
DT2 = PO.GetADMSubGl("1");
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT2.Rows[0]["ADMGlCode"].ToString(), DT2.Rows[0]["ADMSubGlCode"].ToString(),
"0", DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), TotalAmount.ToString(), "1", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(), "0", "0", "1003",
"", DT.Rows[0]["IssueBrCode"].ToString(), DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
}
if (Result > 0)
{
DT2 = new DataTable();
DT2 = PO.GetADMSubGl(DT.Rows[0]["IssueBrCode"].ToString());
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT2.Rows[0]["ADMGlCode"].ToString(), DT2.Rows[0]["ADMSubGlCode"].ToString(),
"0", DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), TotalAmount.ToString(), "2", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(), "0", "0", "1003",
"", "1", DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
}
if (Result > 0)
{
DT2 = new DataTable();
DT2 = PO.GetADMSubGl(DT.Rows[0]["CrBrCode"].ToString());
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT2.Rows[0]["ADMGlCode"].ToString(), DT2.Rows[0]["ADMSubGlCode"].ToString(),
"0", DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), TotalAmount.ToString(), "1", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(), "0", "0", "1003",
"", "1", DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
}
if (Result > 0)
{
DT2 = new DataTable();
DT2 = PO.GetADMSubGl("1");
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT2.Rows[0]["ADMGlCode"].ToString(), DT2.Rows[0]["ADMSubGlCode"].ToString(),
"0", DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), TotalAmount.ToString(), "2", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(), "0", "0", "1003",
"", DT.Rows[0]["CrBrCode"].ToString(), DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
}
}
}
// For Cheque Amount
if (Convert.ToDouble(DT.Rows[0]["ChequeAmt"].ToString()) > 0)
{
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["CrGlCode"].ToString(), DT.Rows[0]["CrSubGlCode"].ToString(),
"0", DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), DT.Rows[0]["ChequeAmt"].ToString(), "1", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(),
"0", "0", "1003", "", DT.Rows[0]["CrBrCode"].ToString(), DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
}
// For CGST charges
if (Result > 0 && Convert.ToDouble(DT.Rows[0]["CGSTAmt"].ToString()) > 0)
{
GlCode = PO.GetGlCode(DT.Rows[0]["CrBrCode"].ToString(), GST.Rows[0]["CGSTPrdCd"].ToString());
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), GlCode.ToString(), GST.Rows[0]["CGSTPrdCd"].ToString(),
"0", DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), DT.Rows[0]["CGSTAmt"].ToString(), "1", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(),
"0", "0", "1003", "", DT.Rows[0]["CrBrCode"].ToString(), DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
}
// For SGST charges
if (Result > 0 && Convert.ToDouble(DT.Rows[0]["SGSTAmt"].ToString()) > 0)
{
GlCode = PO.GetGlCode(DT.Rows[0]["CrBrCode"].ToString(), GST.Rows[0]["SGSTPrdCd"].ToString());
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), GlCode.ToString(), GST.Rows[0]["SGSTPrdCd"].ToString(),
"0", DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), DT.Rows[0]["SGSTAmt"].ToString(), "1", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(),
"0", "0", "1003", "", DT.Rows[0]["CrBrCode"].ToString(), DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
}
// For Service charges
if (Result > 0 && Convert.ToDouble(DT.Rows[0]["TotalAmt"].ToString()) > 0)
{
SubGlCode = PO.GetSubGlCode(DT.Rows[0]["CrBrCode"].ToString());
GlCode = PO.GetGlCode(DT.Rows[0]["CrBrCode"].ToString(), SubGlCode.ToString());
Result = Trans.Authorized(DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), DT.Rows[0]["IssueDate"].ToString(), GlCode.ToString(), SubGlCode.ToString(),
"0", DT.Rows[0]["Narration"].ToString(), DT.Rows[0]["TransType"].ToString(), DT.Rows[0]["TotalAmt"].ToString(), "1", "7", "TR", SetNo, DT.Rows[0]["ChequeNo"].ToString(), DT.Rows[0]["IssueDate"].ToString(),
"0", "0", "1003", "", DT.Rows[0]["CrBrCode"].ToString(), DT.Rows[0]["Mid"].ToString(), "0", "0", "", DT.Rows[0]["IssueCustNo"].ToString(), DT.Rows[0]["IssueCustName"].ToString(), ViewState["RID"].ToString(), "0", "0");
}
Result = PO.AuthorizePayOrder(Session["BRCD"].ToString(), ViewState["SrNumber"].ToString(), SetNo.ToString(), Session["MID"].ToString());
if (Result > 0)
{
ClearAllData();
WebMsgBox.Show("Successfully authorize with setno : " + SetNo, this.Page);
return;
}
}
}
}
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void SubmitTemp_Click(object sender, EventArgs e)
{
int RC = 0;
string ST = "";
string AC, CRAC, CN, CD;
AC = CRAC = CN = CD = "";
ST = BD.GetSetNo(Session["EntryDate"].ToString(), "DaySetNo", Session["BRCD"].ToString()).ToString();
int R = Convert.ToInt32(ST);
// int R = BD.SetSetno(Session["EntryDate"].ToString(), "DaySetNo", ST);
if (ViewState["CustNo"] == null)
{
ViewState["CustNo"] = "0";
}
if (TxtAccNo.Text == "")
{
AC = "0";
ViewState["CustNo"] = "0";
}
else
{
AC = TxtAccNo.Text;
}
if (TxtCRAccNo.Text == "")
{
CRAC = "0";
ViewState["CRCustNo"] = "0";
}
else
{
CRAC = TxtCRAccNo.Text;
}
if (TxtChequeNo.Text == "")
{
CN = "0";
}
else
{
CN = TxtChequeNo.Text;
}
if (TxtChequeDate.Text == "")
{
CD = "01/01/1900";
}
else
{
CD = TxtChequeDate.Text;
}
RC = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), ViewState["GL"].ToString(), TxtPtype.Text, AC, TxtNarration.Text, "Tr From " + TxtCRPType.Text + "/" + CRAC, TxtCRAmount.Text, "2", "7", "TR", ST, CN, CD, "0", "0", "1001", "", Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "TRANSFER", ViewState["CustNo"].ToString(), TxtCustName.Text, "0", "0");
if (RC > 0)
{
RC = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), ViewState["CRGL"].ToString(), TxtCRPType.Text, CRAC, TxtNarration.Text, "Tr From " + TxtCRPType.Text + "/" + CRAC, TxtCRAmount.Text, "1", "7", "TR", ST, CN, CD, "0", "0", "1001", "", Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "TRANSFER", ViewState["CRCustNo"].ToString(), TxtCustName.Text, "0", "0");
if (RC > 0)
{
//int R = BD.SetSetno(Session["EntryDate"].ToString(), "DaySetNo", ST);
if (R > 0)
{
lblMessage.Text = " Voucher Added Successfully and voucher no is " + ST;
ModalPopup.Show(this.Page);
}
}
}
ClearText();
BindGrid();
TxtGLCD.Focus();
}
public string PostEntry(string BRCD, string EDT, string MID, string FL)
{
try
{
SetNo1 = ""; SetNo2 = "";
RefNo = BD.GetMaxRefid(BRCD, EDT, "REFID");
RefNo = (Convert.ToInt32(RefNo) + 1).ToString();
//Added by amol on 09/11/2017 as per ambika madam instruction (only when payment mode is cash)
sql = "SELECT TOP 1 ACTIVITY FROM TEMPBATCH WHERE BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND MID='" + MID + "' And SetNo = '0' And ACTIVITY = '3' And Amt > 0 ORDER BY SYSTEMDATE";
sResult = conn.sExecuteScalar(sql);
if (sResult == "3")
{
//For Cash Receipt set
DT = new DataTable();
sql = "SELECT ID,GL,SUBGL,ACCNO,ACCNAME,CUSTNO,AMT,TRXTYPE,ACTIVITY,PMT,NR,SETNO,BRCD,MID,Convert(varchar(11),MID_DATE,120)as MID_DATE,Convert(varchar(11),SYSTEMDATE,120) SYSTEMDATE,INSTRUMENTNO,Convert(varchar(11),INSTRUMENTDATE,120)INSTRUMENTDATE,NR1 FROM TEMPBATCH WHERE BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND MID='" + MID + "' And ACTIVITY <> '4' And Amt > 0 ORDER BY SYSTEMDATE";
DT = conn.GetDatatable(sql);
if (DT.Rows.Count > 0)
{
SetNo1 = BD.GetSetNo(EDT, "DaySetNo", BRCD).ToString();
for (int K = 0; K < DT.Rows.Count; K++)
{
Result = AZ.Authorized(EDT, EDT, Convert.ToDateTime(DT.Rows[K]["MID_DATE"]).ToString("dd/MM/yyyy"), DT.Rows[K]["GL"].ToString(), DT.Rows[K]["SUBGL"].ToString(), DT.Rows[K]["ACCNO"].ToString(), DT.Rows[K]["NR"].ToString(), DT.Rows[K]["NR1"].ToString(), DT.Rows[K]["AMT"].ToString(), DT.Rows[K]["TRXTYPE"].ToString(), DT.Rows[K]["ACTIVITY"].ToString(), DT.Rows[K]["PMT"].ToString(), SetNo1.ToString(), DT.Rows[K]["INSTRUMENTNO"].ToString(), DT.Rows[K]["INSTRUMENTDATE"].ToString(), "0", "0", "1003", "01/01/1900", BRCD, MID, "0", "0", "DDSCLOSE", DT.Rows[K]["CUSTNO"].ToString(), DT.Rows[K]["ACCNAME"].ToString(), RefNo, "0");
//Stage=1003 done by abhihsek for Closing blance purpose on Authorize
}
//Get All Transaction From Temporary Table (TempLnTrx)
sql = "SELECT * From TempLnTrx Where BrCd = '" + BRCD + "' And EntryDate = '" + conn.ConvertDate(EDT).ToString() + "' And Mid = '" + MID + "' And Amount > 0 Order By SystemDate";
DT = new DataTable();
DT = conn.GetDatatable(sql);
for (int i = 0; i < DT.Rows.Count; i++)
{
//Insert Data to Original Table Here
Result = ITrans.LoanTrx(BRCD, DT.Rows[i]["LoanGlCode"].ToString(), DT.Rows[i]["SubGlCode"].ToString(), DT.Rows[i]["AccountNo"].ToString(), DT.Rows[i]["HeadDesc"].ToString(), DT.Rows[i]["TrxType"].ToString(), DT.Rows[i]["Activity"].ToString(), DT.Rows[i]["Narration"].ToString(), DT.Rows[i]["Amount"].ToString(), SetNo1.ToString(), "1003", MID, "0", EDT.ToString(), RefNo.ToString());
}
}
//For Cash Payment set
DT = new DataTable();
sql = "SELECT ID,GL,SUBGL,ACCNO,ACCNAME,CUSTNO,AMT,TRXTYPE,ACTIVITY,PMT,NR,SETNO,BRCD,MID,Convert(varchar(11),MID_DATE,120)as MID_DATE,Convert(varchar(11),SYSTEMDATE,120) SYSTEMDATE,INSTRUMENTNO,Convert(varchar(11),INSTRUMENTDATE,120)INSTRUMENTDATE,NR1 FROM TEMPBATCH WHERE BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND MID='" + MID + "' And ACTIVITY = '4' And Amt > 0 ORDER BY SYSTEMDATE";
DT = conn.GetDatatable(sql);
if (DT.Rows.Count > 0)
{
SetNo2 = BD.GetSetNo(EDT, "DaySetNo", BRCD).ToString();
for (int K = 0; K < DT.Rows.Count; K++)
{
// added by abhisheck On 29/01/2018 (Stage changed 1003 to 1001)
Result = AZ.Authorized(EDT, EDT, Convert.ToDateTime(DT.Rows[K]["MID_DATE"]).ToString("dd/MM/yyyy"), DT.Rows[K]["GL"].ToString(), DT.Rows[K]["SUBGL"].ToString(), DT.Rows[K]["ACCNO"].ToString(), DT.Rows[K]["NR"].ToString(), DT.Rows[K]["NR1"].ToString(), DT.Rows[K]["AMT"].ToString(), DT.Rows[K]["TRXTYPE"].ToString(), DT.Rows[K]["ACTIVITY"].ToString(), DT.Rows[K]["PMT"].ToString(), SetNo2.ToString(), DT.Rows[K]["INSTRUMENTNO"].ToString(), DT.Rows[K]["INSTRUMENTDATE"].ToString(), "0", "0", "1001", "01/01/1900", BRCD, MID, "0", "0", "DDSCLOSE", DT.Rows[K]["CUSTNO"].ToString(), DT.Rows[K]["ACCNAME"].ToString(), RefNo, "0");
}
}
SetNo1 = SetNo1 + "_" + (SetNo2 == "" ? "0" : SetNo2);
}
else
{
sql = "SELECT ID,GL,SUBGL,ACCNO,ACCNAME,CUSTNO,AMT,TRXTYPE,ACTIVITY,PMT,NR,SETNO,BRCD,MID,Convert(varchar(11),MID_DATE,120)as MID_DATE,Convert(varchar(11),SYSTEMDATE,120) SYSTEMDATE,INSTRUMENTNO,Convert(varchar(11),INSTRUMENTDATE,120)INSTRUMENTDATE,NR1 FROM TEMPBATCH WHERE BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND MID='" + MID + "' AND SETNO = '0' And Amt > 0 ORDER BY SYSTEMDATE";
DataTable DT = new DataTable();
DT = conn.GetDatatable(sql);
if (DT.Rows.Count > 0)
{
SetNo1 = BD.GetSetNo(EDT, "DaySetNo", BRCD).ToString();
for (int K = 0; K < DT.Rows.Count; K++)
{
Result = AZ.Authorized(EDT, EDT, Convert.ToDateTime(DT.Rows[K]["MID_DATE"]).ToString("dd/MM/yyyy"), DT.Rows[K]["GL"].ToString(), DT.Rows[K]["SUBGL"].ToString(), DT.Rows[K]["ACCNO"].ToString(), DT.Rows[K]["NR"].ToString(), DT.Rows[K]["NR1"].ToString(), DT.Rows[K]["AMT"].ToString(), DT.Rows[K]["TRXTYPE"].ToString(), DT.Rows[K]["ACTIVITY"].ToString(), DT.Rows[K]["PMT"].ToString(), SetNo1.ToString(), DT.Rows[K]["INSTRUMENTNO"].ToString(), DT.Rows[K]["INSTRUMENTDATE"].ToString(), "0", "0", "1001", "01/01/1900", BRCD, MID, "0", "0", "DDSCLOSE", DT.Rows[K]["CUSTNO"].ToString(), DT.Rows[K]["ACCNAME"].ToString(), RefNo, "0");
}
//Get All Transaction From Temporary Table (TempLnTrx)
sql = "SELECT * From TempLnTrx Where BrCd = '" + BRCD + "' And EntryDate = '" + conn.ConvertDate(EDT).ToString() + "' And Mid = '" + MID + "' And SetNo = '0' And Amount > 0 Order By SystemDate";
DT = new DataTable();
DT = conn.GetDatatable(sql);
for (int i = 0; i < DT.Rows.Count; i++)
{
//Insert Data to Original Table Here
Result = ITrans.LoanTrx(BRCD, DT.Rows[i]["LoanGlCode"].ToString(), DT.Rows[i]["SubGlCode"].ToString(), DT.Rows[i]["AccountNo"].ToString(), DT.Rows[i]["HeadDesc"].ToString(), DT.Rows[i]["TrxType"].ToString(), DT.Rows[i]["Activity"].ToString(), DT.Rows[i]["Narration"].ToString(), DT.Rows[i]["Amount"].ToString(), SetNo1.ToString(), "1001", MID, "0", EDT.ToString(), RefNo.ToString());
}
}
sql = "SELECT ID,GL,SUBGL,ACCNO,ACCNAME,CUSTNO,AMT,TRXTYPE,ACTIVITY,PMT,NR,SETNO,BRCD,MID,Convert(varchar(11),MID_DATE,120)as MID_DATE,Convert(varchar(11),SYSTEMDATE,120) SYSTEMDATE,INSTRUMENTNO,Convert(varchar(11),INSTRUMENTDATE,120)INSTRUMENTDATE,NR1 FROM TEMPBATCH WHERE BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND MID='" + MID + "' AND SETNO = '1' And Amt > 0 ORDER BY SYSTEMDATE";
DT = new DataTable();
DT = conn.GetDatatable(sql);
if (DT.Rows.Count > 0)
{
SetNo2 = BD.GetSetNo(EDT, "DaySetNo", BRCD).ToString();
for (int K = 0; K < DT.Rows.Count; K++)
{
Result = AZ.Authorized(EDT, EDT, Convert.ToDateTime(DT.Rows[K]["MID_DATE"]).ToString("dd/MM/yyyy"), DT.Rows[K]["GL"].ToString(), DT.Rows[K]["SUBGL"].ToString(), DT.Rows[K]["ACCNO"].ToString(), DT.Rows[K]["NR"].ToString(), DT.Rows[K]["NR1"].ToString(), DT.Rows[K]["AMT"].ToString(), DT.Rows[K]["TRXTYPE"].ToString(), DT.Rows[K]["ACTIVITY"].ToString(), DT.Rows[K]["PMT"].ToString(), SetNo2.ToString(), DT.Rows[K]["INSTRUMENTNO"].ToString(), DT.Rows[K]["INSTRUMENTDATE"].ToString(), "0", "0", "1003", "01/01/1900", BRCD, MID, "0", "0", "DDSCLOSE", DT.Rows[K]["CUSTNO"].ToString(), DT.Rows[K]["ACCNAME"].ToString(), RefNo, "0");
}
//Get All Transaction From Temporary Table (TempLnTrx)
sql = "SELECT * From TempLnTrx Where BrCd = '" + BRCD + "' And EntryDate = '" + conn.ConvertDate(EDT).ToString() + "' And Mid = '" + MID + "' And SetNo = '1' And Amount > 0 Order By SystemDate";
DT = new DataTable();
DT = conn.GetDatatable(sql);
for (int i = 0; i < DT.Rows.Count; i++)
{
//Insert Data to Original Table Here
Result = ITrans.LoanTrx(BRCD, DT.Rows[i]["LoanGlCode"].ToString(), DT.Rows[i]["SubGlCode"].ToString(), DT.Rows[i]["AccountNo"].ToString(), DT.Rows[i]["HeadDesc"].ToString(), DT.Rows[i]["TrxType"].ToString(), DT.Rows[i]["Activity"].ToString(), DT.Rows[i]["Narration"].ToString(), DT.Rows[i]["Amount"].ToString(), SetNo2.ToString(), "1003", MID, "0", EDT.ToString(), RefNo.ToString());
}
}
SetNo1 = SetNo1 + "_" + (SetNo2 == "" ? "0" : SetNo2);
}
sql = "DELETE FROM TEMPBATCH WHERE BRCD='" + BRCD + "' AND MID_DATE='" + conn.ConvertDate(EDT) + "' AND MID='" + MID + "'";
conn.sExecuteQuery(sql);
sql = "DELETE FROM TempLnTrx Where BrCd = '" + BRCD + "' And EntryDate = '" + conn.ConvertDate(EDT).ToString() + "' And Mid = '" + MID + "'";
conn.sExecuteQuery(sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(SetNo1);
}
protected void btnPost_Click(object sender, EventArgs e)
{
try
{
bool Amol = true;
string FSet = "";
//Check product code is entered or not
if (TxtPtype.Text.Trim().ToString() == "")
{
lblMessage.Text = "Enter product code first...!!";
ModalPopup.Show(this.Page);
return;
}
//Check account number is entered or not
if (TxtAccNo.Text.Trim().ToString() == "")
{
lblMessage.Text = "Enter account number first....!!";
ModalPopup.Show(this.Page);
return;
}
if (Convert.ToDouble(txtDiffAmount.Text) == 0.00)
{
//Get All Transaction From Temporary Table
DataTable DT = new DataTable();
DT = LD.GetTransDetails(Session["BRCD"].ToString(), Session["EntryDate"].ToString(), Session["MID"].ToString());
if (DT.Rows.Count > 0)
{
//Generate Reference Number Here
string RefId = "";
RefId = BD.GetMaxRefid(Session["BRCD"].ToString(), Session["EntryDate"].ToString(), "REFID");
ViewState["RefId"] = (Convert.ToInt32(RefId) + 1).ToString();
for (int i = 0; i < DT.Rows.Count; i++)
{
//Generate Set Number Here
ST = "";
ST = BD.GetSetNo(Session["EntryDate"].ToString(), "DaySetNo", Session["BRCD"].ToString()).ToString();
if (Amol == true)
{
FSet = ST;
Amol = false;
}
//Insert Data to Original Table Here for Debit
Result = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), ViewState["GL"].ToString(), TxtPtype.Text.Trim().ToString(), TxtAccNo.Text.Trim().ToString(), "", "TRF To " + DT.Rows[i]["SubGlCode"].ToString() + "/" + DT.Rows[i]["AccNo"].ToString(), DT.Rows[i]["Amount"].ToString(), "2", DT.Rows[i]["Activity"].ToString(), DT.Rows[i]["PmtMode"].ToString(), ST, "", "", "0", "0", "1001", "", Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "LoanDisb", txtCustNo1.Text.Trim().ToString(), TxtCustName.Text.Trim().ToString(), ViewState["RefId"].ToString(), "0");
if (Result > 0)
{
//Insert Data to Original Table Here for Credit
Result = AT.Authorized(Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), Session["EntryDate"].ToString(), DT.Rows[i]["GlCode"].ToString(), DT.Rows[i]["SubGlCode"].ToString(), DT.Rows[i]["AccNo"].ToString(), DT.Rows[i]["Particulars"].ToString(), DT.Rows[i]["Particulars2"].ToString(), DT.Rows[i]["Amount"].ToString(), "1", DT.Rows[i]["Activity"].ToString(), DT.Rows[i]["PmtMode"].ToString(), ST, DT.Rows[i]["InstNo"].ToString(), DT.Rows[i]["InstDate"].ToString(), "0", "0", "1001", "", Session["BRCD"].ToString(), Session["MID"].ToString(), "0", "0", "LoanDisb", DT.Rows[i]["CustNo"].ToString(), DT.Rows[i]["CustName"].ToString(), ViewState["RefId"].ToString(), "0");
}
}
}
//Delete All Record From Table
LD.DelAllRecTable(Session["BRCD"].ToString(), Session["EntryDate"].ToString(), Session["MID"].ToString());
if (Result > 0)
{
ClearAll();
BindGrid1();
lblMessage.Text = "Transfer Seccessfully With Set No : '" + FSet + "' To '" + ST + "' ...!!";
ModalPopup.Show(this.Page);
FL = "Insert";//Dhanya Shetty
string Res = CLM.LOGDETAILS(FL, Session["BRCD"].ToString(), Session["MID"].ToString(), "Loan_Disbursement_transfer _'" + FSet + "' To '" + ST + "'" + TxtPtype.Text + "_" + TxtAccNo.Text + "_" + Session["LOGINCODE"].ToString() + "", "00", Session["MID"].ToString());
DivPayment.Visible = false;
btnPost.Enabled = false;
TxtDSAmt.Enabled = true;
grdvoucher.Visible = false;
return;
}
}
else
{
lblMessage.Text = "Amount Difference in Credit and Debit Transaction...!!";
ModalPopup.Show(this.Page);
return;
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
public int Post_Charges(string MAXCHRGS, string OTHERCHRGS, string INTAPP, string ECC, string UCC, string SC, string ST, string CA, string BCTT, string CRCC, string BRCD, string EDT, string MID, string CUSTNO, string ACCNAME, string SETNO, string ACCNO, string GLCODE, string SUBGL)
{
try
{
double TotalChrDebit = Convert.ToDouble(MAXCHRGS) + Convert.ToDouble(OTHERCHRGS) + Convert.ToDouble(ECC) + Convert.ToDouble(UCC) +
Convert.ToDouble(SC) + Convert.ToDouble(ST) + Convert.ToDouble(CA) + Convert.ToDouble(BCTT) + Convert.ToDouble(CRCC);
if (TotalChrDebit != 0)
{
Result = AT.Authorized(EDT, EDT, EDT, GLCODE, SUBGL,
ACCNO, "BY TRF", "BY TRF", TotalChrDebit.ToString(), "2", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
if (MAXCHRGS != "0")
{
Result = AT.Authorized(EDT, EDT, EDT, "100", "576",
"576", "BY TRF", "BY TRF", MAXCHRGS, "1", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
if (OTHERCHRGS != "0")
{
Result = AT.Authorized(EDT, EDT, EDT, "100", "575",
"575", "BY TRF", "BY TRF", OTHERCHRGS, "1", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
if (INTAPP != "0")
{
Result = AT.Authorized(EDT, EDT, EDT, "100", "564",
ACCNO, "BY TRF", "BY TRF", INTAPP, "2", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
if (Result > 0)
{
Result = AT.Authorized(EDT, EDT, EDT, GLCODE, SUBGL,
ACCNO, "BY TRF", "BY TRF", INTAPP, "1", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
}
if (UCC != "0")
{
Result = AT.Authorized(EDT, EDT, EDT, "100", "571",
"571", "BY TRF", "BY TRF", UCC, "1", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
if (SC != "0")
{
Result = AT.Authorized(EDT, EDT, EDT, "100", "527",
"527", "BY TRF", "BY TRF", SC, "1", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
if (ECC != "0")
{
Result = AT.Authorized(EDT, EDT, EDT, "100", "572",
"572", "BY TRF", "BY TRF", ECC, "1", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
if (ST != "0")
{
Result = AT.Authorized(EDT, EDT, EDT, "100", "546",
"546", "BY TRF", "BY TRF", ST, "1", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
if (CA != "0")
{
Result = AT.Authorized(EDT, EDT, EDT, "100", "573",
"573", "BY TRF", "BY TRF", CA, "1", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
if (BCTT != "0")
{
Result = AT.Authorized(EDT, EDT, EDT, "100", "574",
"574", "BY TRF", "BY TRF", BCTT, "1", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
if (CRCC != "0")
{
Result = AT.Authorized(EDT, EDT, EDT, "100", "577",
"577", "BY TRF", "BY TRF", CRCC, "1", "7", "CHRGS-TRF", SETNO, "0", "1900/01/01", "0", "0", "1001", EDT,
BRCD, MID, "0", "0", "TR", CUSTNO, ACCNAME, "1", "0");
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(Result);
}