protected void TxtATName_TextChanged(object sender, EventArgs e)
{
try
{
if (TxtBRCD.Text != "")
{
string custno = TxtATName.Text;
string[] CT = custno.Split('_');
if (CT.Length > 0)
{
TxtATName.Text = CT[0].ToString();
TxtAccType.Text = CT[1].ToString();
string[] GLS = BD.GetAccTypeGL(TxtAccType.Text, TxtBRCD.Text).Split('_');
ViewState["GL"] = GLS[1].ToString();
AutoAccname.ContextKey = TxtBRCD.Text + "_" + TxtAccType.Text + "_" + ViewState["GL"].ToString();
}
TxtAccno.Focus();
}
else
{
WebMsgBox.Show("Enter Branch Code First....!", this.Page);
TxtATName.Text = "";
TxtBRCD.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtAccno_TextChanged(object sender, EventArgs e)
{
try
{
if (TxtBRCD.Text != "")
{
string AT = "";
// AT = BD.GetStage1(TxtAccno.Text, Session["BRCD"].ToString(), ViewState["Flag"].ToString());
AT = BD.Getstage1(TxtAccno.Text, TxtBRCD.Text, TxtAccType.Text);
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer not Authorise.........!!";
ModalPopup.Show(this.Page);
TxtAccHName.Text = "";
TxtAccno.Text = "";
TxtAccno.Focus();
}
else
{
DataTable DT = new DataTable();
DT = AST.GetCustName(TxtAccType.Text, TxtAccno.Text, TxtBRCD.Text);
if (DT.Rows.Count > 0)
{
string[] TD = TxtTDate.Text.Split('/');
TxtAccHName.Text = DT.Rows[0]["CustName"].ToString();
TxtOPDT.Text = Convert.ToDateTime(DT.Rows[0]["OPENINGDATE"]).ToString("dd/MM/yyyy");
//--Abhishek
string RES = AST.GetAccStatus(TxtBRCD.Text, TxtAccno.Text, TxtAccType.Text);
if (RES == "1")
{
TxtACStatus.Text = "Active";
}
else if (RES == "9")
{
TxtACStatus.Text = "Suit File";
}
else
{
TxtACStatus.Text = "Deactive";
}
TxtClearBal.Text = OC.GetOpenClose("CLOSING", TD[2].ToString(), TD[1].ToString(), TxtAccType.Text, TxtAccno.Text, Session["BRCD"].ToString(), Session["EntryDate"].ToString(), ViewState["GL"].ToString()).ToString();
TxtUnClearBal.Text = OC.GetOpenClose("Unclear", TD[2].ToString(), TD[1].ToString(), TxtAccType.Text, TxtAccno.Text, Session["BRCD"].ToString(), Session["EntryDate"].ToString(), ViewState["GL"].ToString()).ToString();
}
TxtFDate.Focus();
}
}
else
{
WebMsgBox.Show("Enter Branch Code First....!", this.Page);
TxtAccno.Text = "";
TxtBRCD.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
//Response.Redirect("FrmLogin.aspx", true);
}
}
protected void TxtAccType_TextChanged(object sender, EventArgs e)
{
try
{
if (TxtBRCD.Text != "")
{
TxtATName.Text = AST.GetAccType(TxtAccType.Text, TxtBRCD.Text);
string[] GL = BD.GetAccTypeGL(TxtAccType.Text, TxtBRCD.Text).Split('_');
TxtATName.Text = GL[0].ToString();
ViewState["GL"] = GL[1].ToString();
AutoAccname.ContextKey = TxtBRCD.Text + "_" + TxtAccType.Text + "_" + ViewState["GL"].ToString();
TxtAccno.Focus();
}
else
{
WebMsgBox.Show("Enter Branch Code First....!", this.Page);
TxtAccType.Text = "";
TxtBRCD.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
//Response.Redirect("FrmLogin.aspx", true);
}
}
protected void txtProdName_TextChanged(object sender, EventArgs e)
{
try
{
string custno = txtProdName.Text;
string[] CT = custno.Split('_');
if (CT.Length > 0)
{
txtProdName.Text = CT[0].ToString();
txtProdCode.Text = CT[1].ToString();
string[] GLS = BD.GetAccTypeGL(txtProdCode.Text.Trim().ToString(), Session["BRCD"].ToString()).Split('_');
ViewState["DRGL"] = GLS[1].ToString();
AutoAccname.ContextKey = Session["BRCD"].ToString() + "_" + txtProdCode.Text.Trim().ToString() + "_" + ViewState["DRGL"].ToString();
if (txtProdName.Text == "")
{
WebMsgBox.Show("Please enter valid Product code", this.Page);
txtProdCode.Text = "";
txtProdCode.Focus();
}
else
{
TxtAccno.Focus();
}
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtAccno_TextChanged(object sender, EventArgs e)
{
string AT = "";
AT = BD.Getstage1(TxtAccno.Text, Session["BRCD"].ToString(), TxtAccType.Text);
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer not Authorise.........!!";
ModalPopup.Show(this.Page);
TxtAccHName.Text = "";
TxtAccno.Text = "";
TxtAccno.Focus();
}
else
{
DataTable DT = new DataTable();
DT = CLS.GetAccName(TxtAccType.Text, TxtAccno.Text, Session["BRCD"].ToString());
if (DT.Rows.Count > 0)
{
string[] TD = TxtOPDT.Text.Split('/');
TxtAccHName.Text = DT.Rows[0]["CustName"].ToString();
TxtOPDT.Text = Convert.ToDateTime(DT.Rows[0]["OPENINGDATE"]).ToString("dd/MM/yyyy");
}
txtnewCustNo.Focus();
}
}
protected void TxtPcdName_TextChanged(object sender, EventArgs e)
{
try
{
string custno = TxtPcdName.Text;
string[] CT = custno.Split('_');
if (CT.Length > 0)
{
TxtPcdName.Text = CT[0].ToString();
TxtPcd.Text = CT[1].ToString();
ViewState["GLCODE"] = CT[2].ToString();
AutoAccname.ContextKey = TxtBrcd.Text + "_" + TxtPcd.Text.ToString();
}
else
{
WebMsgBox.Show("Enter Valid Product Name..!!", this.Page);
TxtPcd.Text = "";
TxtPcdName.Text = "";
TxtPcdName.Focus();
}
TxtAccno.Focus();
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
protected void TxtAccType_TextChanged(object sender, EventArgs e)
{
string GLNAME = CLS.GetAccType(TxtAccType.Text, Session["BRCD"].ToString());
TxtATName.Text = GLNAME;
GRDCust.Visible = false;
BINDACCNOGRID();
TxtAccno.Focus();
}
protected void txtProdCode_TextChanged(object sender, EventArgs e)
{
try
{
txtProdName.Text = FA.GetAccType(txtProdCode.Text.Trim().ToString(), Session["BRCD"].ToString());
string[] GL = BD.GetAccTypeGL(txtProdCode.Text.Trim().ToString(), Session["BRCD"].ToString()).Split('_');
txtProdName.Text = GL[0].ToString();
ViewState["GL"] = GL[1].ToString();
TxtAccno.Focus();
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtAccno_TextChanged(object sender, EventArgs e)
{
try
{
if (TxtBRCD.Text != "")
{
string AT = "";
// AT = BD.GetStage1(TxtAccno.Text, Session["BRCD"].ToString(), ViewState["Flag"].ToString());
AT = BD.Getstage1(TxtAccno.Text, TxtBRCD.Text, TxtAccType.Text);
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer not Authorise.........!!";
ModalPopup.Show(this.Page);
TxtAccHName.Text = "";
TxtAccno.Text = "";
TxtAccno.Focus();
}
else
{
DataTable DT = new DataTable();
DT = AST.GetCustName(TxtAccType.Text, TxtAccno.Text, TxtBRCD.Text);
if (DT.Rows.Count > 0)
{
TxtAccHName.Text = DT.Rows[0]["CustName"].ToString();
//--Abhishek
string RES = AST.GetAccStatus(TxtBRCD.Text, TxtAccno.Text, TxtAccType.Text);
}
}
}
else
{
WebMsgBox.Show("Enter Branch Code First....!", this.Page);
TxtAccno.Text = "";
TxtBRCD.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
//Response.Redirect("FrmLogin.aspx", true);
}
}
protected void TxtPcd_TextChanged(object sender, EventArgs e)
{
try
{
TxtPcdName.Text = customcs.GetProductName(TxtPcd.Text.ToString(), TxtBrcd.Text);
if (TxtPcdName.Text == "")
{
WebMsgBox.Show("Enter Valid Product code..!!", this.Page);
TxtPcd.Text = "";
TxtPcdName.Text = "";
TxtPcd.Focus();
}
AutoAccname.ContextKey = TxtBrcd.Text + "_" + TxtPcd.Text.ToString();
TxtAccno.Focus();
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
protected void TxtAccno_TextChanged(object sender, EventArgs e)
{
try
{
int Result = LI.CheckAccountExist(TxtAccno.Text, TxtPcd.Text, Session["BRCD"].ToString());
if (Result == 0)
{
WebMsgBox.Show("Sorry Account Number Not Exist...!!", this.Page);
TxtAccno.Text = "";
TxtAccName.Text = "";
TxtAccno.Focus();
return;
}
string AT = "";
AC_Status = CC.GetAccStatus(TxtBrcd.Text, TxtPcd.Text, TxtAccno.Text);
if (AC_Status == "1")
{
AT = BD.Getstage1(TxtAccno.Text, TxtBrcd.Text, TxtPcd.Text);
if (AT != null)
{
if (AT != "1003")
{
lblMessage.Text = "Sorry Customer not Authorise.........!!";
ModalPopup.Show(this.Page);
return;
}
else
{
TxtAccName.Text = CC.GetCustNameAc(TxtAccno.Text, TxtBrcd.Text, TxtPcd.Text);
ViewState["GLCODE"] = avs5043.getgldr(TxtAccno.Text, TxtPcd.Text, TxtBrcd.Text).Split('_')[0].ToString();
ViewState["CUSTNO"] = avs5043.getgldr(TxtAccno.Text, TxtPcd.Text, TxtBrcd.Text).Split('_')[1].ToString();
BtnSubmit.Focus();
}
}
}
}
catch (Exception ex)
{
ExceptionLogging.SendErrorToText(ex);
}
}
protected void TxtProdCde_TextChanged(object sender, EventArgs e)
{
try
{
string tds = BD.GetLoanGL(TxtProdCde.Text, Session["BRCD"].ToString());
if (tds != null)
{
string[] TD = tds.Split('_');
if (TD.Length > 0)
{
}
string GlS1;
TxtProdName.Text = TD[0].ToString();
TxtProdCde.Text = TD[1].ToString();
GlS1 = BD.GetAccTypeGL(TxtProdCde.Text, Session["BRCD"].ToString());
if (GlS1 != null)
{
string[] GLS = GlS1.Split('_');
ViewState["DRGL"] = GLS[1].ToString();
autoaccname.ContextKey = Session["BRCD"].ToString() + "_" + TxtProdCde.Text + "_" + ViewState["DRGL"].ToString();
int GL = 0;
int.TryParse(ViewState["DRGL"].ToString(), out GL);
}
TxtAccno.Focus();
}
else
{
WebMsgBox.Show("Invalid Deposit Code......!", this.Page);
TxtProdName.Text = "";
TxtProdCde.Text = "";
return;
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtAccno_TextChanged(object sender, EventArgs e)
{
try
{
if (ViewState["Flag"].ToString() == "SB")
{
accno = TxtAccno.Text;
string AT = "";
AT = BD.Getstage1(TxtAccno.Text, Session["BRCD"].ToString(), TxtProdCde.Text);
if (AT != null)
{
if (AT != "1003")
{
WebMsgBox.Show("Sorry Customer not Authorise.........!!", this.Page);
TxtAccno.Text = "";
TxtAccname.Text = "";
TxtAccno.Focus();
}
else
{
DataTable DT = new DataTable();
DT = LF.GetCustName(TxtProdCde.Text, TxtAccno.Text, Session["BRCD"].ToString());
if (DT.Rows.Count > 0)
{
string[] CustName = DT.Rows[0]["CustName"].ToString().Split('_');
TxtAccname.Text = CustName[0].ToString();
TxtCustno.Text = CustName[1].ToString();
TxtAccSts.Text = DT.Rows[0]["ACC_STATUS"].ToString();
}
}
}
else
{
WebMsgBox.Show("Enter valid account number...!!", this.Page);
TxtAccno.Text = "";
TxtAccno.Focus();
}
}
if (ViewState["Flag"].ToString() == "AT")
{
string status = "";
sql = "SELECT ACC_STATUS FROM AVS_ACC WHERE BRCD='" + TxtBRCD.Text + "' AND ACCNO='" + TxtAccno.Text + "' AND CUSTNO='" + TxtCustno.Text + "' AND SUBGLCODE='" + TxtProdCde.Text + "' AND STAGE<>1004";
status = conn.sExecuteScalar(sql);
if (status == "9")
{
WebMsgBox.Show("Already Authorized!!", this.Page);
}
else
{
DataTable DT = new DataTable();
DT = LF.GetCustName(TxtProdCde.Text, TxtAccno.Text, TxtBRCD.Text);
if (DT.Rows.Count > 0)
{
string[] CustName = DT.Rows[0]["CustName"].ToString().Split('_');
TxtAccname.Text = CustName[0].ToString();
TxtCustno.Text = CustName[1].ToString();
TxtAccSts.Text = DT.Rows[0]["ACC_STATUS"].ToString();
}
DataTable dt = new DataTable();
dt = LF.GetInfo(TxtAccno.Text, TxtProdCde.Text, TxtBRCD.Text);
if (dt.Rows.Count > 0)
{
TxtCaseOfDate.Text = dt.Rows[0]["CASE_OF_DATE"].ToString();
TxtReason.Text = dt.Rows[0]["REASON"].ToString();
}
else
{
WebMsgBox.Show("Invalid Account number for Loan case File!!", this.Page);
clear();
}
}
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}