protected void TxtCRAccNo_TextChanged(object sender, EventArgs e)
{
try
{
string AT = "";
// AT = BD.GetStage1(TxtAccno.Text, Session["BRCD"].ToString(), ViewState["Flag"].ToString());
AT = BD.Getstage1(TxtCRAccNo.Text, Session["BRCD"].ToString(), TxtCRPType.Text);
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer not Authorise.........!!";
ModalPopup.Show(this.Page);
ClearText();
TxtPtype.Focus();
}
else
{
int RC = LI.CheckAccount(TxtCRAccNo.Text, TxtCRPType.Text, Session["BRCD"].ToString());
if (RC < 0)
{
TxtCRAccNo.Focus();
WebMsgBox.Show("Please Enter valide Account Number Account Not Exist..........!!", this.Page);
return;
}
ViewState["CRCustNo"] = RC;
TxtCRACName.Text = AO.Getcustname(RC.ToString());
TxtChequeNo.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
public string Getaccno(string BRCD, string AT)
{
try
{
sql = " SELECT (CONVERT (VARCHAR(10),GLCODE))+'_'+GLNAME FROM GLMAST WHERE BRCD='" + BRCD + "' AND SUBGLCODE='" + AT + "' GROUP BY GLCODE,GLNAME";
AT = conn.sExecuteScalar(sql);
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
return(AT);
}
protected void TxtAccNo1_TextChanged(object sender, EventArgs e)
{
try
{
string AT = "";
AT = BD.Getstage1(TxtAccNo1.Text, Session["BRCD"].ToString(), txtProdType1.Text);
if (AT != null)
{
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer not Authorise...!!";
ModalPopup.Show(this.Page);
TxtAccNo1.Text = "";
TxtAccName1.Text = "";
TxtAccNo1.Focus();
}
else
{
DataTable DT = new DataTable();
DT = OW.GetCustName(txtProdType1.Text, TxtAccNo1.Text, Session["BRCD"].ToString());
if (DT.Rows.Count > 0)
{
string[] CustName = DT.Rows[0]["CustName"].ToString().Split('_');
TxtAccName1.Text = CustName[0].ToString();
ViewState["GLCODE"] = CustName[2].ToString();
txtBalance.Text = OW.GetOpenClose(Session["BRCD"].ToString(), txtProdType1.Text.Trim().ToString(), TxtAccNo1.Text.Trim().ToString(), Session["EntryDate"].ToString(), "ClBal").ToString();
Txtinstno.Focus();
}
}
}
else
{
lblMessage.Text = "Enter valid account number...!!";
ModalPopup.Show(this.Page);
TxtAccNo1.Text = "";
TxtAccName1.Text = "";
TxtAccNo1.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtAccNo_TextChanged(object sender, EventArgs e)
{
try
{
string AT = "";
AT = BD.Getstage1(TxtAccNo.Text, ViewState["LoanBrCode"].ToString(), TxtPtype.Text);
if (AT != null)
{
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer not Authorise...!!";
ModalPopup.Show(this.Page);
TxtAccNo.Text = "";
TxtCustName.Text = "";
txtCustNo.Text = "";
TxtBalance.Text = "";
TxtTotalBal.Text = "";
TxtAccNo.Focus();
}
else
{
DataTable DT = new DataTable();
DT = MV.GetCustName(TxtPtype.Text, TxtAccNo.Text, ViewState["LoanBrCode"].ToString());
if (DT.Rows.Count > 0)
{
string[] CustName = DT.Rows[0]["CustName"].ToString().Split('_');
TxtCustName.Text = CustName[0].ToString();
txtCustNo.Text = CustName[1].ToString();
if (Convert.ToInt32(txtCustNo.Text.Trim().ToString() == "" ? "0" : txtCustNo.Text.Trim().ToString()) < 0)
{
TxtAccNo.Text = "";
TxtCustName.Text = "";
txtCustNo.Text = "";
TxtBalance.Text = "";
TxtTotalBal.Text = "";
TxtAccNo.Focus();
WebMsgBox.Show("Please Enter valid Account Number Customer Not Exist...!!", this.Page);
return;
}
TxtBalance.Text = MV.GetOpenClose(ViewState["LoanBrCode"].ToString(), TxtPtype.Text.Trim().ToString(), TxtAccNo.Text.Trim().ToString(), Session["EntryDate"].ToString(), "ClBal").ToString();
TxtTotalBal.Text = MV.GetOpenClose(ViewState["LoanBrCode"].ToString(), TxtPtype.Text.Trim().ToString(), TxtAccNo.Text.Trim().ToString(), Session["EntryDate"].ToString(), "MainBal").ToString();
DebitAmt = MV.DebitAmount(ViewState["LoanBrCode"].ToString(), TxtPtype.Text.Trim().ToString(), TxtAccNo.Text.Trim().ToString(), Session["EntryDate"].ToString(), Session["Mid"].ToString());
if (DebitAmt.ToString() != "")
{
TxtBalance.Text = (Convert.ToDouble(TxtBalance.Text) - Convert.ToDouble(DebitAmt)).ToString();
}
TxtNarration.Focus();
}
if (TxtAccNo.Text != "" && TxtPtype.Text != "")
{
DataTable dtmodal = new DataTable();
string sql1 = "EXEC A_VOUCHINFO 'MODAL','" + TxtPtype.Text + "','" + ViewState["LoanBrCode"].ToString() + "','" + conn.ConvertDate(Session["ENTRYDATE"].ToString()) + "','" + TxtAccNo.Text + "'";
dtmodal = conn.GetDatatable(sql1);
if (dtmodal.Rows.Count > 0)
{
resultout = CR.GetInfo(GrdView, ViewState["LoanBrCode"].ToString(), Session["ENTRYDATE"].ToString(), TxtAccNo.Text, TxtPtype.Text);
if (resultout > 0)
{
string Modal_Flag = "VOUCHERVIEW";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(@"<script type='text/javascript'>");
sb.Append("$('#" + Modal_Flag + "').modal('show');");
sb.Append(@"</script>");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AddShowModalScript", sb.ToString(), false);
}
}
}
}
}
else
{
lblMessage.Text = "Enter Valid Account Number...!!";
ModalPopup.Show(this.Page);
TxtAccNo.Text = "";
TxtCustName.Text = "";
txtCustNo.Text = "";
TxtBalance.Text = "";
TxtTotalBal.Text = "";
TxtAccNo.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
public void accno()
{
try
{
string AT = "";
string ACST = "";
ACST = OC.GETACCStatus(Session["BRCD"].ToString(), TxtAccNo.Text, TxtProcode.Text);
if (ACST != "3")
{
AT = BD.Getstage1(TxtAccNo.Text, Session["BRCD"].ToString(), TxtProcode.Text);
if (AT != null)
{
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer not Authorise.........!!";
ModalPopup.Show(this.Page);
// Clear();
}
else
{
TxtACStatus.Text = "Normal/Operative";
string[] TD = Session["EntryDate"].ToString().Split('/');
if (TxtAccNo.Text == "")
{
TxtAccName.Text = "";
goto ext;
}
DataTable dt1 = new DataTable();
if (TxtAccNo.Text != "" & TxtProcode.Text != "")
{
string PRD = "";
string[] CN;
PRD = TxtProcode.Text;
CN = customcs.GetAccountName(TxtAccNo.Text.ToString(), PRD, Session["BRCD"].ToString()).Split('_');
ViewState["CUSTNO"] = CN[0].ToString();
TxtCustNo.Text = CN[0].ToString();
TxtAccName.Text = CN[1].ToString();
GetOpening();
GetBal();
GetIDetails();
GetLID();
GetChrgs("UCC");
GetChrgs("MCM");
if (TxtAccName.Text == "" & TxtAccNo.Text != "")
{
WebMsgBox.Show("Please enter valid Account number", this.Page);
TxtAccNo.Text = "";
TxtAccNo.Focus();
return;
}
TxtBookUnused.Focus();
}
if (TxtAccNo.Text == "" || TxtProcode.Text == "")
{
TxtAccName.Text = "";
goto ext;
}
dt1 = customcs.GetAccNoAccType(TxtProcode.Text, TxtAccNo.Text, Session["BRCD"].ToString());
if (dt1 != null && dt1.Rows.Count != 0)
{
}
else
{
}
ext :;
}
}
else
{
WebMsgBox.Show("Enter Valid Account number!...", this.Page);
TxtAccNo.Text = "";
TxtAccNo.Focus();
}
}
else
{
WebMsgBox.Show("Account No. " + TxtAccNo.Text + " already closed!...", this.Page);
Clear();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
//Response.Redirect("FrmLogin.aspx", true);
}
}
protected void TxtTAccno_TextChanged(object sender, EventArgs e)
{
try
{
string AT = "";
string ACST = "";
ACST = OC.GETACCStatus(Session["BRCD"].ToString(), TxtTAccno.Text, TxtTProcode.Text);
if (ACST != "3")
{
AT = BD.Getstage1(TxtTAccno.Text, Session["BRCD"].ToString(), TxtTProcode.Text);
if (AT != null)
{
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer not Authorise.........!!";
ModalPopup.Show(this.Page);
// Clear();
}
else
{
string[] TD = Session["EntryDate"].ToString().Split('/');
if (TxtTAccno.Text == "")
{
TxtTAccName.Text = "";
goto ext;
}
DataTable dt1 = new DataTable();
if (TxtTAccno.Text != "" & TxtTProcode.Text != "")
{
string PRD = "";
string[] CN;
PRD = TxtTProcode.Text;
CN = customcs.GetAccountName(TxtTAccno.Text.ToString(), PRD, Session["BRCD"].ToString()).Split('_');
ViewState["CUSTNO"] = CN[0].ToString();
TxtTAccName.Text = CN[1].ToString();
if (TxtTAccName.Text == "" & TxtTAccno.Text != "")
{
WebMsgBox.Show("Please enter valid Account number", this.Page);
TxtTAccno.Text = "";
TxtTAccno.Focus();
return;
}
Btn_Submit.Focus();
}
if (TxtTAccno.Text == "" || TxtTProcode.Text == "")
{
TxtTAccName.Text = "";
goto ext;
}
dt1 = customcs.GetAccNoAccType(TxtTProcode.Text, TxtTAccno.Text, Session["BRCD"].ToString());
if (dt1 != null && dt1.Rows.Count != 0)
{
}
else
{
}
ext :;
}
}
else
{
WebMsgBox.Show("Enter Valid Account number!...", this.Page);
TxtTAccno.Text = "";
TxtTAccno.Focus();
}
}
else
{
WebMsgBox.Show("Account already closed!...", this.Page);
Clear();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
//Response.Redirect("FrmLogin.aspx", true);
}
}
protected void TxtAccNo1_TextChanged(object sender, EventArgs e)
{
try
{
string AT = "";
AT = BD.Getstage1(TxtAccNo1.Text, Session["BRCD"].ToString(), txtProdType1.Text);
if (AT != null)
{
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer not Authorise.........!!";
ModalPopup.Show(this.Page);
TxtAccNo1.Text = "";
TxtAccName1.Text = "";
TxtAccNo1.Focus();
}
else
{
AccStatus = LD.GetAccStatus(Session["BRCD"].ToString(), txtProdType1.Text, TxtAccNo1.Text);
if (AccStatus == "1" || AccStatus == "4")
{
DT = new DataTable();
DT = LD.GetCustName(txtProdType1.Text, TxtAccNo1.Text, Session["BRCD"].ToString());
if (DT.Rows.Count > 0)
{
string[] CustName = DT.Rows[0]["CustName"].ToString().Split('_');
TxtAccName1.Text = CustName[0].ToString();
txtCustNo2.Text = CustName[1].ToString();
txtAmount.Focus();
}
}
else if (AccStatus == "3")
{
TxtAccNo1.Text = "";
lblMessage.Text = "Account is closed...!!";
ModalPopup.Show(this.Page);
TxtAccNo1.Focus();
return;
}
else
{
TxtAccNo1.Text = "";
lblMessage.Text = "Enter valid account number...!!";
ModalPopup.Show(this.Page);
TxtAccNo1.Focus();
return;
}
}
}
else
{
lblMessage.Text = "Enter valid account number...!!";
ModalPopup.Show(this.Page);
TxtAccNo1.Text = "";
TxtAccNo1.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtCustName_TextChanged(object sender, EventArgs e)
{
try
{
string AT = "";
string CUNAME = TxtCustName.Text;
string[] custnob = CUNAME.Split('_');
if (custnob.Length > 1)
{
TxtCustName.Text = custnob[0].ToString();
TxtAccNo.Text = (string.IsNullOrEmpty(custnob[1].ToString()) ? "" : custnob[1].ToString());
}
AT = BD.Getstage1(TxtAccNo.Text, Session["BRCD"].ToString(), TxtPtype.Text);
if (AT != null)
{
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer Not Authorise...!!";
ModalPopup.Show(this.Page);
}
else
{
//Added By AmolB ON 20170131 for Loan Against Gold
if (ViewState["GLGroup"].ToString() == "LAG")
{
Result = LD.CheckRecords(Session["BRCD"].ToString(), TxtPtype.Text, TxtAccNo.Text);
if (Result < 1)
{
TxtPtype.Text = "";
TxtPname.Text = "";
TxtAccNo.Text = "";
TxtCustName.Text = "";
lblMessage.Text = "First Enter Ornament Details...!!";
ModalPopup.Show(this.Page);
return;
}
}
ST = LD.CheckAccount(TxtAccNo.Text, TxtPtype.Text, Session["BRCD"].ToString());
if (ST != null)
{
TxtCustName.Text = AO.Getcustname(ST.ToString());
txtCustNo1.Text = ST.ToString();
DT = LD.GetDisburstAMT(TxtPtype.Text, TxtAccNo.Text, Session["EntryDate"].ToString(), Session["BRCD"].ToString());
if (Convert.ToDouble(DT.Rows[0]["Limit"].ToString()) == -1)
{
WebMsgBox.Show("Sorry Not having Disburstment Amount...!!", this.Page);
ClearData();
TxtPtype.Focus();
return;
}
else
{
ShowLoanDetails();
string LoanCat = LD.GetLoancat(Session["BRCD"].ToString(), TxtPtype.Text.Trim().ToString(), TxtAccNo.Text.Trim().ToString());
if (LoanCat != null && LoanCat == "CCOD")
{
string[] TD = Session["EntryDate"].ToString().Split('/');
TxtBalance.Text = OC.GetOpenClose("CLOSING", TD[2].ToString(), TD[1].ToString(), TxtPtype.Text, TxtAccNo.Text, Session["BRCD"].ToString(), Session["EntryDate"].ToString(), ViewState["GL"].ToString()).ToString();
TxtTotalBal.Text = OC.GetOpenClose("MAIN_CLOSING", TD[2].ToString(), TD[1].ToString(), TxtPtype.Text, TxtAccNo.Text, Session["BRCD"].ToString(), Session["EntryDate"].ToString(), ViewState["GL"].ToString()).ToString();
DisbAmount = Convert.ToDouble(Convert.ToDouble(txtLimitAmt.Text.Trim().ToString()) - Math.Abs(Convert.ToDouble(TxtTotalBal.Text.Trim().ToString())));
TxtDSAmt.Text = (DisbAmount > 0 ? DisbAmount : 0).ToString();
txtDrAmount.Text = Convert.ToDouble(TxtDSAmt.Text.Trim().ToString()).ToString();
hdnLimitAmt.Value = Convert.ToDouble(TxtDSAmt.Text.Trim().ToString()).ToString();
}
else
{
string[] TD = Session["EntryDate"].ToString().Split('/');
TxtBalance.Text = OC.GetOpenClose("CLOSING", TD[2].ToString(), TD[1].ToString(), TxtPtype.Text, TxtAccNo.Text, Session["BRCD"].ToString(), Session["EntryDate"].ToString(), ViewState["GL"].ToString()).ToString();
TxtTotalBal.Text = OC.GetOpenClose("MAIN_CLOSING", TD[2].ToString(), TD[1].ToString(), TxtPtype.Text, TxtAccNo.Text, Session["BRCD"].ToString(), Session["EntryDate"].ToString(), ViewState["GL"].ToString()).ToString();
DisbAmount = Convert.ToDouble(Convert.ToDouble(txtLimitAmt.Text.Trim().ToString()) - Math.Abs(Convert.ToDouble(TxtTotalBal.Text.Trim().ToString())));
TxtDSAmt.Text = (DisbAmount > 0 ? DisbAmount : 0).ToString();
txtDrAmount.Text = Convert.ToDouble(TxtDSAmt.Text.Trim().ToString()).ToString();
hdnLimitAmt.Value = Convert.ToDouble(TxtDSAmt.Text.Trim().ToString()).ToString();
}
TxtDSAmt.Focus();
DivPayment.Visible = true;
}
}
else
{
TxtAccNo.Focus();
WebMsgBox.Show("Please Enter valid Account Number.. Account Not Exist...!!", this.Page);
return;
}
BindTempGrid();
}
}
else
{
WebMsgBox.Show("Enter valid account number...!!", this.Page);
TxtAccNo.Focus();
TxtAccNo.Text = "";
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
