private void BindBaseCity() { UserPrefenceDAL objUserPrefence = new UserPrefenceDAL(); var objUserPref = objUserPrefence.SelectBaseCity(); objUserPrefence = null; // ddlCity.DataSource = objUserPref; // ddlCity.DataTextField = "City_Name"; //ddlCity.DataValueField = "City_Idno"; // ddlCity.DataBind(); // ddlCity.Items.Insert(0, new ListItem("< Choose City Name >", "0")); }
protected void lnkbtnSaveGroup_OnClick(object sender, EventArgs e) { UserPrefenceDAL obj = new UserPrefenceDAL(); Int32 intItemType = Convert.ToInt32((ddlItemGropForPopup.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlItemGropForPopup.SelectedValue)); Int32 intTaxType = Convert.ToInt32((ddlTaxType.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlTaxType.SelectedValue)); double dValue = Convert.ToDouble((txtPercentage.Text.Trim()) == "" ? 0.00 : Convert.ToDouble(txtPercentage.Text.Trim())); DataTable dt = obj.UpdateTaxVat(intItemType, intTaxType, dValue, ApplicationFunction.ConnectionString()); if (dt != null && dt.Rows.Count > 0) { ShowMessage("Record updated successfully."); ddlItemGropForPopup.SelectedValue = ddlTaxType.SelectedValue = "0"; txtPercentage.Text = "0.00"; } else { ShowMessageErr("Record Not updated."); } }
protected void lnkbtnUpload_Click(object sender, EventArgs e) { string fileName = string.Empty; string filePath = string.Empty; try { if (flupPic.HasFile) { UserPrefenceDAL obj = new UserPrefenceDAL(); fileName = flupPic.FileName; filePath = Server.MapPath("LogoImage/" + System.Guid.NewGuid() + fileName); flupPic.SaveAs(filePath); fs = new FileStream(filePath, FileMode.Open, FileAccess.Read); br = new BinaryReader(fs); bytes = br.ReadBytes(Convert.ToInt32(fs.Length)); br.Close(); fs.Close(); Int64 Result = obj.UpdateLogo(bytes, ((chkLogoReq.Checked == true) ? true : false)); if (Result > 0) { this.Populate(); this.ShowMessage("Logo Upload successfully."); } else { this.ShowMessage("Logo not Upload."); return; } } } catch (Exception ex) { this.ShowMessage("Logo not Upload."); return; } }
/// <summary> /// To Populate all controls /// </summary> /// <param name="LorryIdno"></param> private void Populate() { UserPrefenceDAL objUserPrefence = new UserPrefenceDAL(); var objUserPref = objUserPrefence.SelectById(); objUserPrefence = null; if (objUserPref != null) { txtBilty.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.Bilty_Amnt)) ? "0" : String.Format("{0:0,0.00}", objUserPref.Bilty_Amnt); ddlType.SelectedValue = Convert.ToString(objUserPref.Work_Type); ddlInvoicePrt.SelectedValue = Convert.ToString(objUserPref.InvPrint_Type); chkTbbRate.Checked = Convert.ToBoolean(objUserPref.TBB_Rate); ddlRateInvoGr.SelectedValue = Convert.ToString(objUserPref.Rate_Invo_Gr); chkTbbRate_OnCheckedChanged(new Object(), EventArgs.Empty); hidUserPrefidno.Value = Convert.ToString(objUserPref.UserPref_Idno); ddlChallanPrint.SelectedValue = Convert.ToString(objUserPref.ChlnPrint_Type); txtServTax.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.ServTax_Perc)) ? "0" : String.Format("{0:0,0.00}", objUserPref.ServTax_Perc); txtSurchage.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.Surchg_Per)) ? "0" : String.Format("{0:0,0.00}", objUserPref.Surchg_Per); txtTollTax.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.TollTax_Amnt)) ? "0" : String.Format("{0:0,0.00}", objUserPref.TollTax_Amnt); txtWages.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.Wages_Amnt)) ? "" : String.Format("{0:0,0.00}", objUserPref.Wages_Amnt); txtRenameWages.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.WagesLabel_Print)) ? "" : String.Format("{0:0,0.00}", objUserPref.WagesLabel_Print); txtServTaxValid.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.ServTax_Valid)) ? "0" : String.Format("{0:0,0.00}", objUserPref.ServTax_Valid); TxtStaxPan.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.STaxPer_TDS)) ? "0" : String.Format("{0:0,0.00}", objUserPref.STaxPer_TDS); ddlamntrcptagnst.SelectedValue = Convert.ToString(objUserPref.AmntRecvdAgnst_GRInvce); chkTDS.Checked = Convert.ToBoolean(objUserPref.TDSEdit); chkGRRate.Checked = Convert.ToBoolean(objUserPref.GRRate); chkChlnUpload.Checked = Convert.ToBoolean(objUserPref.Chln_Excel); ddlPayChln.SelectedValue = Convert.ToString(objUserPref.PayChln_Print); chkContRate.Checked = Convert.ToBoolean(objUserPref.Cont_Rate); chkCntrSBillReq.Checked = Convert.ToBoolean(objUserPref.CntrSBill_Req); chkShrtgEdit.Checked = Convert.ToBoolean(objUserPref.ShrtgRateChlnConf); chkdisChln.Checked = Convert.ToBoolean(objUserPref.DisableChlnEntry); chkAdminApp.Checked = Convert.ToBoolean(objUserPref.AdminApp_Inv); chkWeightWiseRate.Checked = Convert.ToBoolean(objUserPref.WeightWise_Rate); chkheader.Checked = Convert.ToBoolean(objUserPref.GRPrint_WithoutHeader); chkGradeReq.Checked = Convert.ToBoolean(objUserPref.ItemGrade_Req); txtPFChanges.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.PFLabel_GR)) ? "" : String.Format("{0:0,0.00}", objUserPref.PFLabel_GR); txtTollRename.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.TollTaxLabel_GR)) ? "" : String.Format("{0:0,0.00}", objUserPref.TollTaxLabel_GR); txtrefrename.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.Reflabel_Gr)) ? "" : String.Format("{0:0,0.00}", objUserPref.Reflabel_Gr); txtCartageRename.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.CartageLabel_GR)) ? "" : String.Format("{0:0,0.00}", objUserPref.CartageLabel_GR); txtComRename.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.CommissionLabel_Gr)) ? "" : String.Format("{0:0,0.00}", objUserPref.CommissionLabel_Gr); txtBiltyRename.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.BiltyLabel_GR)) ? "" : String.Format("{0:0,0.00}", objUserPref.BiltyLabel_GR); txtStCharge.Text = string.IsNullOrEmpty(Convert.ToString(objUserPref.StChargLabel_GR)) ? "" : String.Format("{0:0,0.00}", objUserPref.StChargLabel_GR); chkLogoReq.Checked = Convert.ToBoolean(objUserPref.Logo_Req); ddlInvGen.SelectedValue = (string.IsNullOrEmpty(objUserPref.InvGen_GrType.ToString()) ? "1" : Convert.ToString(objUserPref.InvGen_GrType)); ddlGRPrint.SelectedValue = (string.IsNullOrEmpty(objUserPref.GRPrintPref.ToString()) ? "1" : Convert.ToString(objUserPref.GRPrintPref)); string Terms1 = objUserPref.Terms; txtterms.Text = string.IsNullOrEmpty(Terms1) == true? "" : Convert.ToString(Terms1); string Terms = objUserPref.Terms1; txtterms2.Text = string.IsNullOrEmpty(Terms) == true ? "" : Convert.ToString(Terms); string Termshieslip = objUserPref.HireslipTerms; txttermshireslip.Text = string.IsNullOrEmpty(Termshieslip) == true ? "" : Convert.ToString(Termshieslip); string TermsGRRet = objUserPref.Terms_Con_Retailer; txtGRRetTnC.Text = string.IsNullOrEmpty(TermsGRRet) == true ? "" : Convert.ToString(TermsGRRet); chkRateReq.Checked = Convert.ToBoolean(objUserPref.GRRetRequired); chkDelPlace.Checked = Convert.ToBoolean(objUserPref.TypeDelPlace); ChkWithoutGst.Checked = Convert.ToBoolean(objUserPref.With_GstAmnt); chkLessChlnAmntInv.Checked = Convert.ToBoolean(objUserPref.LessChlnAmnt_Inv); ChkGstCalGr.Checked = Convert.ToBoolean(objUserPref.GstCal_Gr); if (chkWeightWiseRate.Checked) { hidToggleWeightWiseRate.Value = "1"; } if (Convert.ToBoolean(objUserPref.Logo_Req)) { if (objUserPref.Logo_Image != null) { byte[] img = objUserPref.Logo_Image; string base64String = Convert.ToBase64String(img, 0, img.Length); hideimgvalue.Value = "data:image/png;base64," + base64String; imgLogoShow.ImageUrl = hideimgvalue.Value; } } else { hideimgvalue.Value = ""; imgLogoShow.ImageUrl = hideimgvalue.Value; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "hide();", true); } } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { bool bLessChlnAmntInv = false; if (hidToggleWeightWiseRate.Value == "1") { bLessChlnAmntInv = true; } if (chkLogoReq.Checked) { if (hideimgvalue.Value == "") { this.ShowMessageErr("Logo Required."); imgLogoShow.ImageUrl = hideimgvalue.Value; return; } } string strMsg = string.Empty; UserPrefenceDAL objUserPrefence = new UserPrefenceDAL(); Int64 intUsrPrefIdno = 0; Int64 iCity = 0; Int32 itype = Convert.ToInt32((ddlType.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlType.SelectedValue)); Int32 iInvoice = Convert.ToInt32((ddlInvoicePrt.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlInvoicePrt.SelectedValue)); Int32 iChallan = Convert.ToInt32((ddlChallanPrint.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlChallanPrint.SelectedValue)); String sWagesAs = Convert.ToString((txtRenameWages.Text.Trim()) == "" ? "" : Convert.ToString(txtRenameWages.Text.Trim())); String PFAs = Convert.ToString((txtPFChanges.Text.Trim()) == "" ? "" : Convert.ToString(txtPFChanges.Text.Trim())); String RenameTollTax = Convert.ToString((txtTollRename.Text.Trim()) == "" ? "" : Convert.ToString(txtTollRename.Text.Trim())); String RenameRefno = Convert.ToString((txtrefrename.Text.Trim()) == "" ? "" : Convert.ToString(txtrefrename.Text.Trim())); double dServTax = Convert.ToDouble((txtServTax.Text.Trim()) == "" ? 0 : Convert.ToDouble(txtServTax.Text.Trim())); double dSurchge = Convert.ToDouble((txtSurchage.Text.Trim()) == "" ? 0 : Convert.ToDouble(txtSurchage.Text.Trim())); double dBility = Convert.ToDouble((txtBilty.Text.Trim()) == "" ? 0 : Convert.ToDouble(txtBilty.Text.Trim())); double dWages = Convert.ToDouble((txtWages.Text.Trim()) == "" ? 0 : Convert.ToDouble(txtWages.Text.Trim())); double dTaxToll = Convert.ToDouble((txtTollTax.Text.Trim()) == "" ? 0 : Convert.ToDouble(txtTollTax.Text.Trim())); double dServTxValid = Convert.ToDouble((txtServTaxValid.Text.Trim()) == "" ? 0 : Convert.ToDouble(txtServTaxValid.Text.Trim())); double dStaxPan = Convert.ToDouble((TxtStaxPan.Text.Trim()) == "" ? 0 : Convert.ToDouble(TxtStaxPan.Text.Trim())); Int32 AmntRcvdAgnst = Convert.ToInt32((ddlamntrcptagnst.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlamntrcptagnst.SelectedValue)); Int32 Rate_Invo_Gr = Convert.ToInt32(ddlRateInvoGr.SelectedValue); Int32 PayChlnPrint = Convert.ToInt32(ddlPayChln.SelectedValue); Int32 GRPrint = Convert.ToInt32(ddlGRPrint.SelectedValue); bool LogoReq = Convert.ToBoolean(chkLogoReq.Checked); bool WeightWiseRate = Convert.ToBoolean(chkWeightWiseRate.Checked); bool TypeDelPlace = Convert.ToBoolean(chkDelPlace.Checked); Int32 InvGrType = Convert.ToInt32(ddlInvGen.SelectedValue); string Terms = Convert.ToString((txtterms.Text.Trim()) == "" ? "" : Convert.ToString(txtterms.Text.Trim())); string Terms1 = Convert.ToString((txtterms2.Text.Trim()) == "" ? "" : Convert.ToString(txtterms2.Text.Trim())); string TnCGRRetailer = Convert.ToString((txtGRRetTnC.Text.Trim()) == "" ? "" : Convert.ToString(txtGRRetTnC.Text.Trim())); string strCartage = Convert.ToString((txtCartageRename.Text.Trim()) == "" ? "" : Convert.ToString(txtCartageRename.Text.Trim())); string strCommission = Convert.ToString((txtComRename.Text.Trim()) == "" ? "" : Convert.ToString(txtComRename.Text.Trim())); string strBilty = Convert.ToString((txtBiltyRename.Text.Trim()) == "" ? "" : Convert.ToString(txtBiltyRename.Text.Trim())); string strStCharge = Convert.ToString((txtStCharge.Text.Trim()) == "" ? "" : Convert.ToString(txtStCharge.Text.Trim())); //string Termcondition = Terms.Replace("#", "</br>"); //string Terms2 = Terms1.Replace("#", "</br>"); string hireSlipTerms = Convert.ToString((txttermshireslip.Text.Trim()) == "" ? "" : Convert.ToString(txttermshireslip.Text.Trim())); bool strWithGstAmnt = Convert.ToBoolean(ChkWithoutGst.Checked); //string TermconditionHireSlip = hireSlipTerms.Replace("#", "</br>"); intUsrPrefIdno = objUserPrefence.UpdateUserPrefence(iCity, itype, iInvoice, iChallan, sWagesAs, dServTax, dSurchge, dBility, dWages, dTaxToll, dServTxValid, dStaxPan, Convert.ToBoolean(chkTbbRate.Checked), Convert.ToBoolean(chkTDS.Checked), Convert.ToBoolean(chkGRRate.Checked), AmntRcvdAgnst, Rate_Invo_Gr, Convert.ToBoolean(chkChlnUpload.Checked), PayChlnPrint, Convert.ToBoolean(chkContRate.Checked), Convert.ToBoolean(chkCntrSBillReq.Checked), Convert.ToBoolean(chkShrtgEdit.Checked), Convert.ToBoolean(chkdisChln.Checked), Convert.ToBoolean(chkAdminApp.Checked), Convert.ToBoolean(chkheader.Checked), GRPrint, Convert.ToBoolean(chkGradeReq.Checked), PFAs, RenameTollTax, RenameRefno, LogoReq, (string.IsNullOrEmpty(ddlInvGen.SelectedValue) ? 1 : Convert.ToInt32(ddlInvGen.SelectedValue)), Terms, Terms1, TnCGRRetailer, WeightWiseRate, hireSlipTerms, Convert.ToBoolean(chkRateReq.Checked), strCartage, strCommission, strBilty, TypeDelPlace, strStCharge, strWithGstAmnt, bLessChlnAmntInv, Convert.ToBoolean(ChkGstCalGr.Checked)); objUserPrefence = null; if (intUsrPrefIdno > 0) { strMsg = "Record updated successfully."; this.ClearControls(); } Populate(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertstrMsg", "PassMessage('" + strMsg + "')", true); }