protected void txtProdName_TextChanged(object sender, EventArgs e)
{
try
{
string CUNAME = txtProdName.Text;
string[] custnob = CUNAME.Split('_');
if (DD.GetProdOperate(txtFrBranch.Text.Trim().ToString(), (string.IsNullOrEmpty(custnob[1].ToString()) ? "" : custnob[1].ToString())).ToString() != "3")
{
txtProdName.Text = custnob[0].ToString();
txtProdType.Text = (string.IsNullOrEmpty(custnob[1].ToString()) ? "" : custnob[1].ToString());
TxtFDate.Focus();
return;
}
else
{
txtProdType.Text = "";
txtProdName.Text = "";
txtProdType.Focus();
WebMsgBox.Show("Product is not operating...!!", this.Page);
return;
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtFprdcode_TextChanged(object sender, EventArgs e)
{
try
{
string GL = BD.GetAccTypeGL(TxtFprdcode.Text, Session["BRCD"].ToString());
string[] GLCODE = GL.Split('_');
ViewState["DRGL"] = GL[1].ToString();
string PDName = customcs.GetProductName(TxtFprdcode.Text, Session["BRCD"].ToString());
if (PDName != null)
{
TxtFprdname.Text = PDName;
TxtFDate.Focus();
}
else
{
WebMsgBox.Show("Product Number is Invalid....!", this.Page);
TxtFprdcode.Text = "";
TxtFDate.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtATName_TextChanged(object sender, EventArgs e)
{
try
{
if (TxtBRCD.Text != "")
{
// string custno = TxtATName.Text;
// string[] CT = custno.Split('_');
// if (CT.Length > 0)
{
// TxtAccType.Text = CT[0].ToString();
// TxtATName.Text = CT[1].ToString();
// string[] GLS = BD.GetAccTypeGL(TxtAccType.Text, TxtBRCD.Text).Split('_');
ViewState["GL"] = "2";
TxtFDate.Focus();
}
}
else
{
WebMsgBox.Show("Enter Branch Code First....!", this.Page);
// TxtATName.Text = "";
TxtBRCD.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtToCustno_TextChanged(object sender, EventArgs e)
{
try
{
DT = CD.GetStage(TxtToCustno.Text);
if (DT.Rows[0]["STAGE"].ToString() == "1001")
{
WebMsgBox.Show("Customer Not Authoried...!!", this.Page);
return;
}
else if (DT.Rows[0]["STAGE"].ToString() == "1004")
{
WebMsgBox.Show("Customer is Deleted...!!", this.Page);
return;
}
else if (DT.Rows[0]["STAGE"].ToString() == "" || DT.Rows[0]["STAGE"].ToString() == null)
{
WebMsgBox.Show("Customer Not Exists...!!", this.Page);
return;
}
else
{
DT1 = CD.GetCustName(TxtToCustno.Text.ToString());
TxtToCustName.Text = DT1.Rows[0]["CUSTNAME"].ToString();
DT = CD.GetCustAccInfo(Session["BRCD"].ToString(), TxtToCustno.Text);
TxtFDate.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void txtcusno_TextChanged(object sender, EventArgs e)
{
string AT = "";
AT = CLS.Getstage1(txtcusno.Text, Session["BRCD"].ToString());
if (AT != "1003")
{
WebMsgBox.Show("Sorry Customer not Authorise.........!!", this.Page);
ModalPopup.Show(this.Page);
txtcusno.Text = "";
txtcusname.Text = "";
txtcusno.Focus();
}
else
{
string CUSTNAME = CLS.GetCustNAme(txtcusno.Text, Session["BRCD"].ToString());
BindGrid();
if (CUSTNAME != null || CUSTNAME != "")
{
txtcusname.Text = CUSTNAME;
TxtAccno.Text = txtcusno.Text;
TxtFDate.Focus();
}
else
{
WebMsgBox.Show("Cust No Not Exit In Master ...!!", this.Page);
ModalPopup.Show(this.Page);
return;
}
}
}
protected void TxtAccType_TextChanged(object sender, EventArgs e)
{
try
{
string AC1;
AC1 = LC.Getaccno(TxtAccType.Text, Session["BRCD"].ToString(), "");
if (AC1 != null)
{
string[] AC = AC1.Split('-');;
ViewState["ACCNO"] = AC[0].ToString();
ViewState["GLCODE"] = AC[1].ToString();
TxtATName.Text = AC[2].ToString();
AutoAccname.ContextKey = Session["BRCD"].ToString() + "_" + TxtAccType.Text + "_" + ViewState["GLCODE"].ToString();
TxtFDate.Focus();
}
else
{
WebMsgBox.Show("Enter valid Product code!.....", this.Page);
TxtAccType.Text = "";
TxtATName.Text = "";
TxtAccType.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserName"] == null)
{
Response.Redirect("FrmLogin.aspx");
}
if (!IsPostBack)
{
//added by ankita 07/10/2017 to make user frndly
//DateTime dateI = Convert.ToDateTime(Session["EntryDate"].ToString());
//dateI = new DateTime(dateI.Year, dateI.Month, 1);
TxtFDate.Text = Conn.sExecuteScalar("select '01/04/'+ convert(varchar(10),(year(dateadd(month, -3,'" + Conn.ConvertDate(Session["EntryDate"].ToString()) + "'))))");
TxtTDate.Text = Session["EntryDate"].ToString();
TxtBrID.Text = Session["BRCD"].ToString();
if (cmn.MultiBranch(Session["LOGINCODE"].ToString()) != "Y")
{
TxtBrID.Enabled = false;
TxtFDate.Focus();
}
else
{
TxtBrID.Enabled = true;
TxtBrID.Focus();
}
}
}
protected void TxtTaccno_TextChanged(object sender, EventArgs e)
{
{
try
{
string[] AN;
AN = customcs.GetAccountName(TxtTaccno.Text, TxtTprdcode.Text, Session["BRCD"].ToString()).Split('_');
if (AN != null)
{
TxtTaccname.Text = AN[1].ToString();
TxtFDate.Focus();
}
else
{
WebMsgBox.Show("Account Number is Invalid....!", this.Page);
TxtTaccno.Text = "";
TxtTaccno.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 txtProdName_TextChanged(object sender, EventArgs e)
{
try
{
string[] custnob = txtProdName.Text.ToString().Split('_');
if (custnob.Length > 1)
{
if (BD.GetProdOperate(txtBrCode.Text.ToString(), string.IsNullOrEmpty(custnob[2].ToString()) ? "" : custnob[2].ToString()).ToString() != "3")
{
txtProdName.Text = custnob[0].ToString();
ViewState["GlCode"] = custnob[1].ToString();
txtProdType.Text = (string.IsNullOrEmpty(custnob[2].ToString()) ? "" : custnob[2].ToString());
TxtFDate.Focus();
}
else
{
ClearProdText();
lblMessage.Text = "Product is not operating...!!";
ModalPopup.Show(this.Page);
return;
}
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Session["UserName"] == null)
{
Response.Redirect("FrmLogin.aspx");
}
TxtBrID.Focus();
//added by ankita 07/10/2017 to make user frndly
TxtBrID.Text = Session["BRCD"].ToString();
TxtFDate.Text = conn.sExecuteScalar("select '01/04/'+ convert(varchar(10),(year(dateadd(month, -3,'" + conn.ConvertDate(Session["EntryDate"].ToString()) + "'))))");
TxtTDate.Text = Session["EntryDate"].ToString();
if (cmn.MultiBranch(Session["LOGINCODE"].ToString()) != "Y")
{
TxtBrID.Enabled = false;
TxtFDate.Focus();
}
else
{
TxtBrID.Enabled = true;
TxtBrID.Focus();
}
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
public void Clear()
{
TxtFDate.Text = "";
TxtTDate.Text = "";
TxtFBRCD.Text = "";
TxtFBRCDName.Text = "";
TxtFPRD.Text = "";
TxtFPRDName.Text = "";
TxtFDate.Focus();
}
protected void ClearData()
{
TxtFDate.Text = "";
TxtFBankcode.Text = "";
TxtFBankname.Text = "";
TxtTDate.Text = "";
TxtTBankcode.Text = "";
TxtTBankname.Text = "";
TxtFDate.Focus();
}
protected void ddlAppType_TextChanged(object sender, EventArgs e)
{
try
{
TxtFDate.Focus();
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
TxtFDate.Focus();
if (Session["UserName"] == null)
{
Response.Redirect("FrmLogin.aspx");
}
//added by ankita 07/10/2017 to make user frndly
TxtFDate.Text = conn.sExecuteScalar("select '01/04/'+ convert(varchar(10),(year(dateadd(month, -3,'" + conn.ConvertDate(Session["EntryDate"].ToString()) + "'))))");
TxtTDate.Text = Session["EntryDate"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["UserName"] == null)
{
Response.Redirect("FrmLogin.aspx");
}
TxtFDate.Focus();
autoglname.ContextKey = Session["BRCD"].ToString();
// autoglname1.ContextKey = Session["BRCD"].ToString();
AutoGlname3.ContextKey = Session["BRCD"].ToString();
AutoGlname4.ContextKey = Session["BRCD"].ToString();
Hf_WorkingDt.Value = Session["EntryDate"].ToString();
BD.BindCalType(DdlCalcType);
}
ScriptManager.GetCurrent(this).AsyncPostBackTimeout = 50000;
}
protected void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (txtBrCode.Text.ToString() == "")
{
txtBrCode.Focus();
WebMsgBox.Show("Enter branch code first...!!", this.Page);
return;
}
else if (txtProdType.Text.ToString() == "")
{
txtProdType.Focus();
WebMsgBox.Show("Enter product code first...!!", this.Page);
return;
}
else if (TxtFDate.Text.ToString() == "")
{
TxtFDate.Focus();
WebMsgBox.Show("Enter From Date first...!!", this.Page);
return;
}
else if (TxtTDate.Text.ToString() == "")
{
TxtTDate.Focus();
WebMsgBox.Show("Enter To date Fisrt...!!", this.Page);
return;
}
else if (Rdeatils.SelectedValue == "1")
{
string redirectURL = "FrmRView.aspx?BC=" + txtBrCode.Text.Trim().ToString() + "&PC=" + txtProdType.Text.Trim().ToString() + "&FDate=" + TxtFDate.Text + "&TDate=" + TxtTDate.Text + "&MID=" + Session["MID"].ToString() + "&FL=" + "D" + "&rptname=RptSBIntCalcReport_DT.rdlc";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "popup", "window.open('" + redirectURL + "','_blank')", true);
}
else if (Rdeatils.SelectedValue == "2")
{
string redirectURL = "FrmRView.aspx?BC=" + txtBrCode.Text.Trim().ToString() + "&PC=" + txtProdType.Text.Trim().ToString() + "&FDate=" + TxtFDate.Text + "&TDate=" + TxtTDate.Text + "&MID=" + Session["MID"].ToString() + "&FL=" + "S" + "&rptname=RptSBIntCalcReport_Sumry.rdlc";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "popup", "window.open('" + redirectURL + "','_blank')", true);
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtFprdname_TextChanged(object sender, EventArgs e)
{
try
{
string custno = TxtFprdname.Text;
string[] CT = custno.Split('_');
if (CT.Length > 0)
{
TxtFprdname.Text = CT[0].ToString();
TxtFprdcode.Text = CT[1].ToString();
TxtFDate.Focus();
string[] GLS = DD.GetAccTypeGL(TxtFprdcode.Text, Session["BRCD"].ToString()).Split('_');
ViewState["DRGL"] = GLS[1].ToString();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtPType_TextChanged(object sender, EventArgs e)
{
try
{
string[] GL = BD.GetAccTypeGL(TxtPType.Text, Session["BRCD"].ToString()).Split('_');;
TxtProName.Text = GL[0].ToString();
ViewState["GL"] = GL[1].ToString();
if (rdbAll.Checked == true)
{
TxtTDate.Focus();
}
else
{
TxtFDate.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
public void Clear()
{
TxtFDate.Text = "";
TxtTDate.Text = "";
// TxtTPRD.Text = "";
TxtFPRD.Text = "";
TxtFPRDName.Text = "";
// TXtTPRDName.Text = "";
TxtFAcc.Text = "";
TxtTAcc.Text = "";
TxtFAccName.Text = "";
TxtTAccName.Text = "";
TxtDiviProdCode.Text = "";
TxtDiviProdName.Text = "";
TxtDebitPrdCode.Text = "";
TxtDebitPrdName.Text = "";
TxtDiviRate.Text = "";
DdlCalcType.SelectedValue = "0";
TxtNarr.Text = "";
TxtFDate.Focus();
}
protected void BtnParameter_Click(object sender, EventArgs e)
{
try
{
if (txtBrCode.Text.ToString() == "")
{
txtBrCode.Focus();
WebMsgBox.Show("Enter branch code first...!!", this.Page);
return;
}
else if (txtProdType.Text.ToString() == "")
{
txtProdType.Focus();
WebMsgBox.Show("Enter product code first...!!", this.Page);
return;
}
else if (TxtFDate.Text.ToString() == "")
{
TxtFDate.Focus();
WebMsgBox.Show("Enter From Date first...!!", this.Page);
return;
}
else if (TxtTDate.Text.ToString() == "")
{
TxtTDate.Focus();
WebMsgBox.Show("Enter To date Fisrt...!!", this.Page);
return;
}
else
{
string redirectURL = "FrmRView.aspx?BC=" + txtBrCode.Text.Trim().ToString() + "&PC=" + txtProdType.Text.Trim().ToString() + "&rptname=RptSB_INTCalcPara.rdlc";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "popup", "window.open('" + redirectURL + "','_blank')", true);
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtATName_TextChanged(object sender, EventArgs e)
{
try
{
string CUNAME = TxtATName.Text;
string[] custnob = CUNAME.Split('_');
if (custnob.Length > 1)
{
TxtATName.Text = custnob[0].ToString();
TxtAccType.Text = (string.IsNullOrEmpty(custnob[1].ToString()) ? "" : custnob[1].ToString());
string[] AC = LC.Getaccno(TxtAccType.Text, Session["BRCD"].ToString(), custnob[2].ToString()).Split('-');
ViewState["ACCNO"] = AC[0].ToString();
ViewState["GLCODE"] = AC[1].ToString();
AutoAccname.ContextKey = Session["BRCD"].ToString() + "_" + TxtAccType.Text;
TxtFDate.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void txtProdType_TextChanged(object sender, EventArgs e)
{
try
{
if (DD.GetProdOperate(txtFrBranch.Text.Trim().ToString(), txtProdType.Text.Trim().ToString()).ToString() != "3")
{
string AC1 = SA.Getaccno(txtProdType.Text, txtFrBranch.Text.Trim().ToString());
if (AC1 != null)
{
string[] AC = AC1.Split('_');;
txtProdName.Text = AC[1].ToString();
TxtFDate.Focus();
return;
}
else
{
txtProdType.Text = "";
txtProdName.Text = "";
txtProdType.Focus();
WebMsgBox.Show("Enter valid Product code...!!", this.Page);
return;
}
}
else
{
txtProdType.Text = "";
txtProdName.Text = "";
txtProdType.Focus();
WebMsgBox.Show("Product is not operating...!!", this.Page);
return;
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtAccType_TextChanged(object sender, EventArgs e)
{
try
{
if (TxtBRCD.Text != "")
{
// TxtATName.Text = AST.GetAccType(TxtAccType.Text, TxtBRCD.Text);
//string[] GL = BD.GetAgentType(TxtAccType.Text, TxtBRCD.Text).Split('_');
// TxtATName.Text = GL[0].ToString();
// ViewState["GL"] = GL[1].ToString();
TxtFDate.Focus();
}
else
{
WebMsgBox.Show("Enter Branch Code First....!", this.Page);
// TxtAccType.Text = "";
TxtBRCD.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtPtype_TextChanged(object sender, EventArgs e)
{
try
{
if (TxtPtype.Text != null)
{
int Result = 0;
int.TryParse(TxtPtype.Text, out Result);
string GL = custcs.GetProductName(Result.ToString(), Session["BRCD"].ToString());
string GLS1 = BD.GetAccTypeGL(TxtPtype.Text, Session["BRCD"].ToString());
if (GLS1 != null)
{
string[] NameC = GLS1.Split('_');
TxtPname.Text = NameC[0].ToString();
ViewState["DRGL"] = NameC[1].ToString();
TxtFDate.Focus();
}
else
{
WebMsgBox.Show("Enter valid Product Type!!!!.....", this.Page);
TxtPtype.Focus();
TxtPtype.Text = "";
}
}
else
{
WebMsgBox.Show("Enter valid Product Type!!!!.....", this.Page);
TxtPtype.Focus();
TxtPtype.Text = "";
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void txtProdType_TextChanged(object sender, EventArgs e)
{
try
{
sResult = SB.GetProduct(txtBrCode.Text.ToString(), txtProdType.Text.ToString());
if (sResult != null)
{
if (BD.GetProdOperate(txtBrCode.Text.ToString(), txtProdType.Text.ToString()).ToString() != "3")
{
string[] ACC = sResult.Split('_');;
ViewState["GlCode"] = ACC[0].ToString();
txtProdName.Text = ACC[2].ToString();
TxtFDate.Focus();
}
else
{
ClearProdText();
lblMessage.Text = "Product is not operating...!!";
ModalPopup.Show(this.Page);
return;
}
}
else
{
ClearProdText();
WebMsgBox.Show("Enter valid Product code!.....", this.Page);
txtProdType.Focus();
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtCustName_TextChanged(object sender, EventArgs e)
{
try
{
string CUNAME = TxtCustName.Text;
string[] custnob = CUNAME.Split('_');
if (custnob.Length > 1)
{
TxtCustName.Text = custnob[0].ToString();
TxtCustNo.Text = (string.IsNullOrEmpty(custnob[1].ToString()) ? "" : custnob[1].ToString());
string AT = CM.GetStage(Session["BRCD"].ToString(), TxtCustNo.Text);
if (AT == "1003")
{
TxtFDate.Focus();
return;
}
else if (AT == "1004")
{
//ClearData();
WebMsgBox.Show("Customer is Deleted...!!", this.Page);
return;
}
else if (AT == "1001" || AT == "1002")
{
WebMsgBox.Show("Customer is not authorized...!!", this.Page);
return;
}
}
}
catch (Exception Ex)
{
ExceptionLogging.SendErrorToText(Ex);
}
}
protected void TxtToBrcd_TextChanged(object sender, EventArgs e)
{
TxtTBname.Text = AST.GetBranchName(TxtToBrcd.Text);
TxtFDate.Focus();
}
protected void TxtCTRL_TextChanged(object sender, EventArgs e)
{
TxtTPRDName.Text = BD.GetAccType(TxtCTRL.Text, Session["BRCD"].ToString());
TxtFDate.Focus();
}
protected void RdbChkBoth_CheckedChanged(object sender, EventArgs e)
{
FTBANK.Visible = true;
FTDT.Visible = true;
TxtFDate.Focus();
}