public void BindAcMain() { string AcCode = txtEMcode.Text.ToString(); DataTable dt = new DataTable(); dt = AccountMain.ACCodeGet(AcCode).Tables[0]; if (dt.Rows.Count != 0) { lblID.Text = Convert.ToString(dt.Rows[0]["AutoID"]); txtEMcode.Text = dt.Rows[0]["AC_CODE"].ToString(); txtAcCode.Text = dt.Rows[0]["AC_NAME"].ToString(); txtGroup.Text = Convert.ToString(dt.Rows[0]["GR_HEAD"]); txtAdd1.Text = dt.Rows[0]["AC_ADD1"].ToString(); txtAdd2.Text = dt.Rows[0]["AC_ADD2"].ToString(); txtAdd3.Text = dt.Rows[0]["AC_ADD3"].ToString(); txtpnon1.Text = dt.Rows[0]["TEL1"].ToString(); txtpnon2.Text = dt.Rows[0]["TEL2"].ToString(); txtCityCode.Text = dt.Rows[0]["CITY_CODE"].ToString(); txtPincode.Text = dt.Rows[0]["PIN_CODE"].ToString(); txtCOUNTRY.Text = dt.Rows[0]["COUNTRY"].ToString(); txtZoneCode.Text = dt.Rows[0]["ZONE_CODE"].ToString(); txtbroker.Text = dt.Rows[0]["BROKER"].ToString(); txtMedium.Text = dt.Rows[0]["MEDIUM"].ToString(); txtBrokper.Text = dt.Rows[0]["BROK_PERC"].ToString(); txtPrintint.Text = dt.Rows[0]["PRIN_int"].ToString(); txtBlackList.Text = dt.Rows[0]["BLACKLIST"].ToString(); txtAcType.Text = dt.Rows[0]["AC_TYPE"].ToString(); txtAcStNo.Text = dt.Rows[0]["AC_ST_NO"].ToString(); txtPincode.Text = dt.Rows[0]["AC_PA_NO"].ToString(); txtAC_CST_NO.Text = dt.Rows[0]["AC_CST_NO"].ToString(); txtAcIntRate.Text = dt.Rows[0]["AC_int_RAT"].ToString(); txtAC_TDS_LIM.Text = dt.Rows[0]["AC_TDS_LIM"].ToString(); txtAC_TDS_RAT.Text = dt.Rows[0]["AC_TDS_RAT"].ToString(); txtAC_DEPR_C.Text = dt.Rows[0]["AC_DEPR_C"].ToString(); txtAC_DEPR_N.Text = dt.Rows[0]["AC_DEPR_N"].ToString(); txtDISC_PREC.Text = dt.Rows[0]["DISC_PREC"].ToString(); txtSR_ORDER.Text = dt.Rows[0]["SR_ORDER"].ToString(); txtOPEN_BAL.Text = dt.Rows[0]["OPEN_BAL"].ToString(); txtPROFIT.Text = dt.Rows[0]["PROFIT"].ToString(); txtREMUNA.Text = dt.Rows[0]["REMUNA"].ToString(); txtCR_LIMIT.Text = dt.Rows[0]["CR_LIMIT"].ToString(); txtSP_DISC.Text = dt.Rows[0]["SP_DISC"].ToString(); txtIN_CHARGE.Text = dt.Rows[0]["IN_CHARGE"].ToString(); txtCTYPE_CODE.Text = dt.Rows[0]["CTYPE_CODE"].ToString(); txtL_O.Text = dt.Rows[0]["L_O"].ToString(); txtCF_CODE.Text = dt.Rows[0]["CF_CODE"].ToString(); } else { MessageBox("No Records Found"); } }
public void SetupTest() { this.driver = new ChromeDriver(); driver.Manage().Window.Maximize(); this.shoppingBasket = new ShoppingBasketMain(this.driver); this.homepageMain = new HomePageMain(this.driver); this.accountMain = new AccountMain(this.driver); this.storeMain = new StoresMain(this.driver); }
public DataTable fillTempBookData(string Accode) { DataTable dt = new DataTable(); if (Session["loantempdata"] == null) { //CREATE NEW DATATABLE dt.Columns.Add("AccountCode"); dt.Columns.Add("AccName"); dt.Columns.Add("Interest"); } else { setHistoryView(); dt = (DataTable)Session["loantempdata"]; } DataView dv = new DataView(dt); dv.RowFilter = "AccountCode = '" + Accode + "'"; if (dv.ToTable().Rows.Count > 0) { MessageBox("Already Exist!!!"); } else { DataTable dt1 = new DataTable(); dt1 = AccountMain.ACCodeGet(Accode).Tables[0]; if (dt1.Rows.Count > 0) { if (dt1.Rows.Count > 1) { for (int i = 0; i < dt1.Rows.Count; i++) { dv.RowFilter = "AccountCode = '" + dt1.Rows[i]["Ac_Code"].ToString() + "'"; if (dv.ToTable().Rows.Count <= 0) { dt.Rows.Add(dt1.Rows[i]["Ac_Code"].ToString(), dt1.Rows[i]["Ac_Name"].ToString(), dt1.Rows[i]["Ac_int_Rat"].ToString()); } } } else { dt.Rows.Add(Accode, dt1.Rows[0]["Ac_Name"].ToString(), dt1.Rows[0]["Ac_int_Rat"].ToString()); } } else { MessageBox("Record not found!!!"); } } Session["loantempdata"] = dt; return(dt); }
protected void txtAcCode_TextChanged(object sender, EventArgs e) { string AcCode = txtAcCode.Text.Trim(); bool Auth = AccountMain.ACCodeValidaton(AcCode); if (Auth) { MessageBox("Already Exists..."); txtAcCode.Text = ""; txtAcCode.Focus(); } txtGroup.Focus(); }
protected void gvmaincode_RowEditing(object sender, GridViewEditEventArgs e) { pnlcust.Visible = true; gvmaincode.Visible = false; AccountMain ac = new AccountMain(); try { lblMainHead.Text = ((Label)gvmaincode.Rows[e.NewEditIndex].FindControl("lblMainCode")).Text; txtmain.Text = ((Label)gvmaincode.Rows[e.NewEditIndex].FindControl("lblMainHead")).Text; } catch { } }
protected void btn_Save_Click(object sender, EventArgs e) { try { if (Session["UserName"] != null) { AccountMain ac = new AccountMain(); ac.AutoID = Convert.ToInt32(lblID.Text); ac.AC_CODE = txtEMcode.Text.Trim(); ac.AC_NAME = txtAcCode.Text.Trim(); ac.AC_GROUP = txtGroup.Text.Trim(); ac.AC_ADD1 = txtAdd1.Text.Trim(); ac.AC_ADD2 = txtAdd2.Text.Trim(); ac.AC_ADD3 = txtAdd3.Text.Trim(); ac.TEL1 = txtpnon1.Text.Trim(); ac.TEL2 = txtpnon2.Text.Trim(); ac.CITY_CODE = txtCityCode.Text.Trim(); ac.PIN_CODE = txtPincode.Text.Trim(); ac.COUNTRY = txtCOUNTRY.Text.Trim(); ac.ZONE_CODE = txtZoneCode.Text.Trim(); ac.BROKER = txtbroker.Text.Trim(); ac.MEDIUM = txtMedium.Text.Trim(); if (txtBrokper.Text == "") { ac.BROK_PERC = Convert.ToDecimal(0); } else { ac.BROK_PERC = Convert.ToDecimal(txtBrokper.Text.Trim()); } ac.PRIN_int = txtPrintint.Text.Trim(); ac.BLACKLIST = txtBlackList.Text.Trim(); ac.AC_TYPE = txtAcType.Text.Trim(); ac.AC_ST_NO = txtAcStNo.Text.Trim(); ac.AC_PA_NO = txtPincode.Text.Trim(); ac.AC_CST_NO = txtAC_CST_NO.Text.Trim(); if (txtAcIntRate.Text == "") { ac.AC_int_RAT = Convert.ToDecimal(0); } else { ac.AC_int_RAT = Convert.ToDecimal(txtAcIntRate.Text.Trim()); } if (txtAC_TDS_LIM.Text == "") { ac.AC_TDS_LIM = Convert.ToDecimal(0); } else { ac.AC_TDS_LIM = Convert.ToDecimal(txtAC_TDS_LIM.Text.Trim()); } if (txtAC_TDS_RAT.Text == "") { ac.AC_TDS_RAT = Convert.ToDecimal(0); } else { ac.AC_TDS_RAT = Convert.ToDecimal(txtAC_TDS_RAT.Text.Trim()); } ac.AC_H15 = true; if (txtAC_DEPR_C.Text == "") { ac.AC_DEPR_C = Convert.ToDecimal(0); } else { ac.AC_DEPR_C = Convert.ToDecimal(txtAC_DEPR_C.Text.Trim()); } if (txtAC_DEPR_N.Text == "") { ac.AC_DEPR_N = Convert.ToDecimal(0); } else { ac.AC_DEPR_N = Convert.ToDecimal(txtAC_DEPR_N.Text.Trim()); } if (txtDISC_PREC.Text == "") { ac.DISC_PREC = Convert.ToDecimal(0); } else { ac.DISC_PREC = Convert.ToDecimal(txtDISC_PREC.Text.Trim()); } ac.AREA = txtAREA.Text.Trim(); if (txtSR_ORDER.Text == "") { ac.SR_ORDER = Convert.ToInt32(0); } else { ac.SR_ORDER = Convert.ToInt32(txtSR_ORDER.Text.Trim()); } if (txtOPEN_BAL.Text == "") { ac.OPEN_BAL = Convert.ToDecimal(0); } else { ac.OPEN_BAL = Convert.ToDecimal(txtOPEN_BAL.Text.Trim()); } if (txtPROFIT.Text == "") { ac.PROFIT = Convert.ToDecimal(0); } else { ac.PROFIT = Convert.ToDecimal(txtPROFIT.Text.Trim()); } if (txtREMUNA.Text == "") { ac.REMUNA = Convert.ToDecimal(0); } else { ac.REMUNA = Convert.ToDecimal(txtREMUNA.Text.Trim()); } if (txtCR_LIMIT.Text == "") { ac.CR_LIMIT = Convert.ToDecimal(0); } else { ac.CR_LIMIT = Convert.ToDecimal(txtCR_LIMIT.Text.Trim()); } if (txtSP_DISC.Text == "") { ac.SP_DISC = Convert.ToDecimal(0); } else { ac.SP_DISC = Convert.ToDecimal(txtSP_DISC.Text.Trim()); } ac.IN_CHARGE = txtIN_CHARGE.Text.Trim(); ac.CTYPE_CODE = txtCTYPE_CODE.Text.Trim(); ac.L_O = txtL_O.Text.Trim(); ac.CF_CODE = txtCF_CODE.Text.Trim(); ac.ACTIVE = Convert.ToBoolean(true); ac.CreatedBy = Session["UserName"].ToString(); ac.Save(); Session["tempdata"] = null; message("Record save successfully"); txtAcCode.Text = ""; txtEMcode.Text = ""; txtGroup.Text = ""; txtAdd1.Text = ""; txtAdd2.Text = ""; txtAdd3.Text = ""; txtpnon1.Text = ""; txtpnon2.Text = ""; txtCityCode.Text = ""; txtPincode.Text = ""; txtCOUNTRY.Text = ""; txtZoneCode.Text = ""; txtbroker.Text = ""; txtMedium.Text = ""; txtBrokper.Text = ""; txtPrintint.Text = ""; txtBlackList.Text = ""; txtAcType.Text = ""; txtAcStNo.Text = ""; txtPincode.Text = ""; txtAC_CST_NO.Text = ""; txtAcIntRate.Text = ""; txtAC_TDS_LIM.Text = ""; txtAC_TDS_RAT.Text = ""; txtAC_DEPR_C.Text = ""; txtAC_DEPR_N.Text = ""; txtDISC_PREC.Text = ""; txtSR_ORDER.Text = ""; txtOPEN_BAL.Text = ""; txtPROFIT.Text = ""; txtREMUNA.Text = ""; txtCR_LIMIT.Text = ""; txtSP_DISC.Text = ""; txtIN_CHARGE.Text = ""; txtCTYPE_CODE.Text = ""; txtL_O.Text = ""; txtCF_CODE.Text = ""; } } catch { } }
protected void btn_Save_Click(object sender, EventArgs e) { try { if (Session["UserName"] != null) { AccountMain ac = new AccountMain(); ac.AutoID = Convert.ToInt32(lblID.Text); ac.AC_CODE = txtAcCode.Text.Trim(); ac.AC_NAME = txtEMcode.Text.Trim(); ac.AC_GROUP = txtGroup.Text.Trim(); ac.AC_ADD1 = txtAdd1.Text.Trim(); ac.AC_ADD2 = txtAdd2.Text.Trim(); ac.AC_ADD3 = txtAdd3.Text.Trim(); ac.TEL1 = txtpnon1.Text.Trim(); ac.TEL2 = txtpnon2.Text.Trim(); ac.CITY_CODE = txtCityCode.Text.Trim(); ac.PIN_CODE = txtPin.Text.Trim(); ac.STATE_CODE = ddlStateCode.SelectedValue.Trim(); ac.COUNTRY = txtCOUNTRY.Text.Trim(); ac.ZONE_CODE = txtZoneCode.Text.Trim(); ac.GST_NO = txtGST_NO.Text.Trim(); StringBuilder appgst = new StringBuilder(string.Empty); foreach (ListItem li in chkApplicableGST.Items) { if (li.Selected) { appgst.Append(li.Value).Append(", "); } } string APPLICABLE_GST = appgst.ToString().TrimEnd(' ').TrimEnd(','); ac.APPLICABLE_GST = APPLICABLE_GST; if (txtbroker.Text.Trim() != "") { ac.BROKER = txtbroker.Text.ToString().Split(':')[0].Trim(); } else { ac.BROKER = txtbroker.Text.ToString().Trim(); } ac.MEDIUM = txtMedium.Text.Trim(); if (txtBrokper.Text == "") { ac.BROK_PERC = Convert.ToDecimal(0); } else { ac.BROK_PERC = Convert.ToDecimal(txtBrokper.Text.Trim()); } ac.PRIN_int = txtPrintint.Text.Trim(); ac.BLACKLIST = txtBlackList.Text.Trim(); ac.AC_TYPE = txtAcType.Text.Trim(); ac.AC_ST_NO = txtAcStNo.Text.Trim(); ac.AC_PA_NO = txtPincode.Text.Trim(); ac.AC_CST_NO = txtAC_CST_NO.Text.Trim(); if (txtAcIntRate.Text == "") { ac.AC_int_RAT = Convert.ToDecimal(0); } else { ac.AC_int_RAT = Convert.ToDecimal(txtAcIntRate.Text.Trim()); } if (txtAC_TDS_LIM.Text == "") { ac.AC_TDS_LIM = Convert.ToDecimal(0); } else { ac.AC_TDS_LIM = Convert.ToDecimal(txtAC_TDS_LIM.Text.Trim()); } if (txtAC_TDS_RAT.Text == "") { ac.AC_TDS_RAT = Convert.ToDecimal(0); } else { ac.AC_TDS_RAT = Convert.ToDecimal(txtAC_TDS_RAT.Text.Trim()); } ac.AC_H15 = true; if (txtAC_DEPR_C.Text == "") { ac.AC_DEPR_C = Convert.ToDecimal(0); } else { ac.AC_DEPR_C = Convert.ToDecimal(txtAC_DEPR_C.Text.Trim()); } if (txtAC_DEPR_N.Text == "") { ac.AC_DEPR_N = Convert.ToDecimal(0); } else { ac.AC_DEPR_N = Convert.ToDecimal(txtAC_DEPR_N.Text.Trim()); } if (txtDISC_PREC.Text == "") { ac.DISC_PREC = Convert.ToDecimal(0); } else { ac.DISC_PREC = Convert.ToDecimal(txtDISC_PREC.Text.Trim()); } ac.AREA = txtAREA.Text.Trim(); if (txtSR_ORDER.Text == "") { ac.SR_ORDER = Convert.ToInt32(0); } else { ac.SR_ORDER = Convert.ToInt32(txtSR_ORDER.Text.Trim()); } if (txtOPEN_BAL.Text == "") { ac.OPEN_BAL = Convert.ToDecimal(0); } else { ac.OPEN_BAL = Convert.ToDecimal(txtOPEN_BAL.Text.Trim()); } if (txtPROFIT.Text == "") { ac.PROFIT = Convert.ToDecimal(0); } else { ac.PROFIT = Convert.ToDecimal(txtPROFIT.Text.Trim()); } if (txtREMUNA.Text == "") { ac.REMUNA = Convert.ToDecimal(0); } else { ac.REMUNA = Convert.ToDecimal(txtREMUNA.Text.Trim()); } if (txtCR_LIMIT.Text == "") { ac.CR_LIMIT = Convert.ToDecimal(0); } else { ac.CR_LIMIT = Convert.ToDecimal(txtCR_LIMIT.Text.Trim()); } if (txtSP_DISC.Text == "") { ac.SP_DISC = Convert.ToDecimal(0); } else { ac.SP_DISC = Convert.ToDecimal(txtSP_DISC.Text.Trim()); } ac.IN_CHARGE = txtIN_CHARGE.Text.Trim(); ac.CTYPE_CODE = txtCTYPE_CODE.Text.Trim(); ac.L_O = txtL_O.Text.Trim(); ac.CF_CODE = txtCF_CODE.Text.Trim(); ac.ACTIVE = Convert.ToBoolean(true); ac.CreatedBy = Session["UserName"].ToString(); ac.SaveAccountMain(); message("Record save successfully"); txtAcCode.Text = ""; txtEMcode.Text = ""; txtGroup.Text = ""; txtAdd1.Text = ""; txtAdd2.Text = ""; txtAdd3.Text = ""; txtpnon1.Text = ""; txtpnon2.Text = ""; txtCityCode.Text = ""; txtPincode.Text = ""; ddlStateCode.SelectedValue = ""; txtCOUNTRY.Text = ""; txtZoneCode.Text = ""; txtbroker.Text = ""; txtMedium.Text = ""; txtBrokper.Text = ""; txtPrintint.Text = ""; txtBlackList.Text = ""; txtAcType.Text = ""; txtAcStNo.Text = ""; txtPincode.Text = ""; txtAC_CST_NO.Text = ""; txtAcIntRate.Text = ""; txtAC_TDS_LIM.Text = ""; txtAC_TDS_RAT.Text = ""; txtAC_DEPR_C.Text = ""; txtAC_DEPR_N.Text = ""; txtDISC_PREC.Text = ""; txtSR_ORDER.Text = ""; txtOPEN_BAL.Text = ""; txtPROFIT.Text = ""; txtREMUNA.Text = ""; txtCR_LIMIT.Text = ""; txtSP_DISC.Text = ""; txtIN_CHARGE.Text = ""; txtCTYPE_CODE.Text = ""; txtL_O.Text = ""; txtCF_CODE.Text = ""; txtAREA.Text = ""; txtGST_NO.Text = ""; foreach (ListItem item in chkApplicableGST.Items) { item.Selected = false; } } } catch { } }
public void GetAccountMain() { string AcCode = txtEMcode.Text.ToString(); DataTable dt = new DataTable(); dt = AccountMain.GetAccountMain(AcCode).Tables[0]; if (dt.Rows.Count != 0) { lblID.Text = Convert.ToString(dt.Rows[0]["AutoID"]); txtEMcode.Text = dt.Rows[0]["AC_CODE"].ToString(); txtAcCode.Text = dt.Rows[0]["AC_NAME"].ToString(); txtGroup.Text = Convert.ToString(dt.Rows[0]["GR_HEAD"]); txtAdd1.Text = dt.Rows[0]["AC_ADD1"].ToString(); txtAdd2.Text = dt.Rows[0]["AC_ADD2"].ToString(); txtAdd3.Text = dt.Rows[0]["AC_ADD3"].ToString(); txtpnon1.Text = dt.Rows[0]["TEL1"].ToString(); txtpnon2.Text = dt.Rows[0]["TEL2"].ToString(); txtCityCode.Text = dt.Rows[0]["CITY_CODE"].ToString(); txtPincode.Text = dt.Rows[0]["PIN_CODE"].ToString(); ddlStateCode.SelectedValue = dt.Rows[0]["STATE_CODE"].ToString(); txtCOUNTRY.Text = dt.Rows[0]["COUNTRY"].ToString(); txtZoneCode.Text = dt.Rows[0]["ZONE_CODE"].ToString(); txtbroker.Text = dt.Rows[0]["BROKER"].ToString(); txtMedium.Text = dt.Rows[0]["MEDIUM"].ToString(); txtBrokper.Text = dt.Rows[0]["BROK_PERC"].ToString(); txtPrintint.Text = dt.Rows[0]["PRIN_int"].ToString(); txtBlackList.Text = dt.Rows[0]["BLACKLIST"].ToString(); txtAcType.Text = dt.Rows[0]["AC_TYPE"].ToString(); txtAcStNo.Text = dt.Rows[0]["AC_ST_NO"].ToString(); txtPincode.Text = dt.Rows[0]["AC_PA_NO"].ToString(); txtAC_CST_NO.Text = dt.Rows[0]["AC_CST_NO"].ToString(); txtAcIntRate.Text = dt.Rows[0]["AC_int_RAT"].ToString(); txtAC_TDS_LIM.Text = dt.Rows[0]["AC_TDS_LIM"].ToString(); txtAC_TDS_RAT.Text = dt.Rows[0]["AC_TDS_RAT"].ToString(); txtGST_NO.Text = dt.Rows[0]["GST_NO"].ToString(); DataTable dtable = new DataTable(); dtable.Columns.Add("Key", typeof(string)); string appgst = dt.Rows[0]["APPLICABLE_GST"].ToString(); string[] keys = appgst.Split(','); for (int i = 0; i < keys.Length; i++) { dtable.Rows.Add(new object[] { keys[i] }); } foreach (ListItem agstrow in chkApplicableGST.Items) { agstrow.Selected = false; } for (int i = 0; i < dtable.Rows.Count; i++) { string dkey = dtable.Rows[i]["Key"].ToString(); foreach (ListItem gstrow in chkApplicableGST.Items) { if (gstrow.Value == dkey) { gstrow.Selected = true; } } } txtAC_DEPR_C.Text = dt.Rows[0]["AC_DEPR_C"].ToString(); txtAC_DEPR_N.Text = dt.Rows[0]["AC_DEPR_N"].ToString(); txtDISC_PREC.Text = dt.Rows[0]["DISC_PREC"].ToString(); txtSR_ORDER.Text = dt.Rows[0]["SR_ORDER"].ToString(); txtOPEN_BAL.Text = dt.Rows[0]["OPEN_BAL"].ToString(); txtPROFIT.Text = dt.Rows[0]["PROFIT"].ToString(); txtREMUNA.Text = dt.Rows[0]["REMUNA"].ToString(); txtCR_LIMIT.Text = dt.Rows[0]["CR_LIMIT"].ToString(); txtSP_DISC.Text = dt.Rows[0]["SP_DISC"].ToString(); txtIN_CHARGE.Text = dt.Rows[0]["IN_CHARGE"].ToString(); txtCTYPE_CODE.Text = dt.Rows[0]["CTYPE_CODE"].ToString(); txtL_O.Text = dt.Rows[0]["L_O"].ToString(); txtCF_CODE.Text = dt.Rows[0]["CF_CODE"].ToString(); } else { MessageBox("No Records Found"); } }