private void BindGrid() { LedgerAccountDAL objAccountDAL = new LedgerAccountDAL(); var lstGridData = objAccountDAL.SelectForSearch(txtAccountPrtyName.Text.Trim(), TxtMobile.Text.Trim(), Convert.ToInt32(ddlAccountType.SelectedValue), Convert.ToInt32(ddlState.SelectedValue), Convert.ToInt32(ddlBalanceType.SelectedValue)); CSVTable.Columns.Add("S.No.", typeof(string)); CSVTable.Columns.Add("Acnt_Name", typeof(string)); CSVTable.Columns.Add("MobileNo", typeof(double)); CSVTable.Columns.Add("AcntType_Name", typeof(string)); CSVTable.Columns.Add("Address", typeof(string)); CSVTable.Columns.Add("State_Name", typeof(string)); CSVTable.Columns.Add("City_Name", typeof(string)); CSVTable.Columns.Add("OpBalnce", typeof(double)); int i = 0; foreach (var item in lstGridData) { DataRow dr = CSVTable.NewRow(); dr["S.No."] = ++i; dr["Acnt_Name"] = DataBinder.Eval(item, "Acnt_Name"); dr["MobileNo"] = Convert.ToString(DataBinder.Eval(item, "MobileNo")) == "" ? 0 : DataBinder.Eval(item, "MobileNo"); dr["AcntType_Name"] = DataBinder.Eval(item, "AcntType_Name"); dr["Address"] = Convert.ToString(DataBinder.Eval(item, "Address")).Contains(",") ? Convert.ToString(DataBinder.Eval(item, "Address")).Replace(',', ' ') : Convert.ToString(DataBinder.Eval(item, "Address")); dr["State_Name"] = DataBinder.Eval(item, "State_Name"); dr["City_Name"] = DataBinder.Eval(item, "City_Name"); dr["OpBalnce"] = DataBinder.Eval(item, "OpBalnce"); CSVTable.Rows.Add(dr); } ViewState["CSVdt"] = CSVTable; objAccountDAL = null; if (lstGridData != null && lstGridData.Count > 0) { grdUser.DataSource = lstGridData; grdUser.DataBind(); lblTotalRecord.Text = "T. Record (s): " + lstGridData.Count; imgBtnExcel.Visible = false; int startRowOnPage = (grdUser.PageIndex * grdUser.PageSize) + 1; int lastRowOnPage = startRowOnPage + grdUser.Rows.Count - 1; lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString(); lblcontant.Visible = true; imgBtnExcel.Visible = true; divpaging.Visible = true; } else { grdUser.DataSource = null; grdUser.DataBind(); lblTotalRecord.Text = "T. Record (s): 0"; imgBtnExcel.Visible = false; lblcontant.Visible = false; divpaging.Visible = false; } }
protected void grdUser_RowDataBound(object sender, GridViewRowEventArgs e) { LedgerAccountDAL accountDAL = new LedgerAccountDAL(); if (e.Row.RowType == DataControlRowType.DataRow) { ImageButton imgBtnStatus = (ImageButton)e.Row.FindControl("imgBtnStatus"); bool status = Convert.ToBoolean(DataBinder.Eval(e.Row.DataItem, "Status")); Label lblDealerid = (Label)e.Row.FindControl("lblDealerid"); LinkButton lnkbtnEdit = (LinkButton)e.Row.FindControl("lnkbtnEdit"); LinkButton imgBtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete"); LinkButton lnkbtnClaimDetails = (LinkButton)e.Row.FindControl("lnkbtnClaimDetails"); base.CheckUserRights(intFormId); // Used to hide Delete button if ItemgrpId exists in Lorry Master,Goods Received, Quotation,GR Preparation, Challan Booking,Voucher Entry,Bank Re-Conciliation, F.Mgmt Purchase Bill,F.Mgmt Material Issue LinkButton lnkbtnDelete = (LinkButton)e.Row.FindControl("lnkbtnDelete"); string AcntIdno = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "AcntIdno")); string AcntTypeName = Convert.ToString(DataBinder.Eval(e.Row.DataItem, "AcntType_Name")); if (AcntTypeName == "ClaimParty") { lnkbtnClaimDetails.Visible = true; } else { lnkbtnClaimDetails.Visible = false; } if (AcntIdno != "") { LedgerAccountDAL obj = new LedgerAccountDAL(); var ItemExist = obj.CheckItemExistInOtherMaster(Convert.ToInt32(AcntIdno)); if (ItemExist != null && ItemExist.Count > 0) { lnkbtnDelete.Visible = false; } else { lnkbtnDelete.Visible = true; } } // end---- imgBtnStatus.Visible = true; if (status == false) { imgBtnStatus.ImageUrl = "~/Images/inactive.png"; } else { imgBtnStatus.ImageUrl = "~/Images/active.png"; } } accountDAL = null; }
public void BindSender() { LedgerAccountDAL obj = new LedgerAccountDAL(); var lst = obj.FetchSender(); obj = null; drpSender.DataSource = lst; drpSender.DataTextField = "Acnt_Name"; drpSender.DataValueField = "Acnt_Idno"; drpSender.DataBind(); drpSender.Items.Insert(0, new ListItem("--Select--", "0")); }
private void BindAcntType() { LedgerAccountDAL accountDAL = new LedgerAccountDAL(); var lst = accountDAL.FetchAcntType(); accountDAL = null; ddlAccountType.DataSource = lst; ddlAccountType.DataTextField = "AcntType_Name"; ddlAccountType.DataValueField = "AcntType_Idno"; ddlAccountType.DataBind(); ddlAccountType.Items.Insert(0, new ListItem("--Select Type--", "0")); }
private void BindCategory() { LedgerAccountDAL accountDAL = new LedgerAccountDAL(); var lst = accountDAL.FetchCategory(); accountDAL = null; ddlCategory.DataSource = lst; ddlCategory.DataTextField = "Category_Name"; ddlCategory.DataValueField = "Category_Idno"; ddlCategory.DataBind(); ddlCategory.Items.Insert(0, new ListItem("-Select-", "0")); }
private void BindState() { LedgerAccountDAL objAccountDAL = new LedgerAccountDAL(); var lst = objAccountDAL.SelectState(0); objAccountDAL = null; ddlState.DataSource = lst; ddlState.DataTextField = "State_Name"; ddlState.DataValueField = "State_Idno"; ddlState.DataBind(); ddlState.Items.Insert(0, new ListItem("--Select State--", "0")); }
private void BindAcntSubGroup() { LedgerAccountDAL accountDAL = new LedgerAccountDAL(); var lst = accountDAL.FetchAcntSubHead(); accountDAL = null; ddlAccountSubGroup.DataSource = lst; ddlAccountSubGroup.DataTextField = "ASubHead_Name"; ddlAccountSubGroup.DataValueField = "ASubHead_Idno"; ddlAccountSubGroup.DataBind(); ddlAccountSubGroup.Items.Insert(0, new ListItem("< Choose Type >", "0")); }
private void TotalCount() { LedgerAccountDAL objAccountDAL = new LedgerAccountDAL(); Int64 CountGridData = objAccountDAL.CountTotal(0, Convert.ToInt32(ddlBalanceType.SelectedValue)); if (CountGridData > 0) { lblTotalRecord.Text = "T. Record (s): " + CountGridData; } else { lblTotalRecord.Text = "T. Record (s): 0"; } }
private void BindDistrictwithStateId(int stateIdno) { if (ddlAccountType.SelectedValue != "1" && ddlAccountType.SelectedValue != "3") { ddlDistrict.DataSource = null; LedgerAccountDAL accountDAL = new LedgerAccountDAL(); var lst = accountDAL.BindDistrictwithStateId(stateIdno); accountDAL = null; ddlDistrict.DataSource = lst; ddlDistrict.DataTextField = "District_Name"; ddlDistrict.DataValueField = "District_Idno"; ddlDistrict.DataBind(); } ddlDistrict.Items.Insert(0, new ListItem("--Select District--", "0")); }
private void BindUserCityState() { if (ddlAccountType.SelectedValue != "1" && ddlAccountType.SelectedValue != "3") { Int64 userId = Convert.ToInt64(Session["UserIdno"].ToString()); LedgerAccountDAL accountDAL = new LedgerAccountDAL(); var lst = accountDAL.SelectStateCity(userId); accountDAL = null; if (lst.Count > 0) { if (Convert.ToInt32(DataBinder.Eval(lst[0], "StateId")) > 0) { ddlState.SelectedValue = Convert.ToString(DataBinder.Eval(lst[0], "StateId")); this.BindCitywithStateId(Convert.ToInt32(DataBinder.Eval(lst[0], "StateId"))); ddlCity.SelectedValue = Convert.ToString(DataBinder.Eval(lst[0], "CityId")); } } } }
protected void grdUser_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "cmdEdit") { string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' }); string DlrHeadid = commandArgs[0]; string DlrTyp = commandArgs[1]; Response.Redirect("LedgerMaster.aspx?AcntIdno=" + DlrHeadid + "&DlrType=" + DlrTyp, true); } else if (e.CommandName == "cmddelete") { LedgerAccountDAL accountDAL = new LedgerAccountDAL(); string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' }); string DlrHeadid = commandArgs[0]; string DlrTyp = commandArgs[1]; long value = accountDAL.Delete(Convert.ToInt64(DlrHeadid), Convert.ToInt32(DlrTyp)); accountDAL = null; if (value > 0) { //tblmsgallSave.Visible = false; //commented by Lokesh } BindGrid(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessage('Record deleted successfully')", true); } else if (e.CommandName == "cmdstatus") { Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString()); int intitemIdno = 0; bool bStatus = false; string[] strStatus = Convert.ToString(e.CommandArgument).Split(new char[] { '_' }); if (strStatus.Length > 1) { intitemIdno = Convert.ToInt32(strStatus[0]); if (Convert.ToBoolean(strStatus[1]) == true) { bStatus = false; } else { bStatus = true; } LedgerAccountDAL accountDAL = new LedgerAccountDAL(); int value = accountDAL.UpdateStatus(intitemIdno, bStatus, empIdno); accountDAL = null; if (value > 0) { this.BindGrid(); ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessage('Status updated successfully')", true); txtAccountPrtyName.Focus(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessage('Status not updated.')", true); } } } else if (e.CommandName == "CmdeditDetails") { string url = "VechDetlClmPrty.aspx?AcntIdno=" + e.CommandArgument; string fullURL = "window.open('" + url + "', '_blank' );"; ScriptManager.RegisterStartupScript(this, typeof(string), "OPEN_WINDOW", fullURL, true); } }
protected void lnkbtnSave_OnClick(object sender, EventArgs e) { bool validGSTIN = Convert.ToBoolean((hidValidGSTIN.Value == null || hidValidGSTIN.Value == "") ? "true" : hidValidGSTIN.Value); if (!validGSTIN) { return; } string GSTINNO = string.IsNullOrEmpty(Convert.ToString(txtGST.Text.Trim())) ? "" : Convert.ToString(txtGST.Text.Trim()); //if (ddlAccountType.SelectedValue == "2") //{ // if (GSTINNO.Length != 15) // { // ShowMessageErr("GST Number must be 15 digit!"); // return; // } //} Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString()); string strMsg = string.Empty; LedgerAccountDAL objAcntMaster = new LedgerAccountDAL(); Int64 intAcntIdno = 0; DateTime?ExpiryDate = null; DateTime?HazardousExpiryDate = null; if ((ViewState["ExpiryDate"] != null) && (Convert.ToString(ViewState["ExpiryDate"]) != "")) { ExpiryDate = Convert.ToDateTime(Classes.ApplicationFunction.mmddyyyy(ViewState["ExpiryDate"].ToString())); } else { ExpiryDate = null; } if ((ViewState["HazardousExpiryDate"] != null) && (Convert.ToString(ViewState["HazardousExpiryDate"]) != "")) { HazardousExpiryDate = Convert.ToDateTime(Classes.ApplicationFunction.mmddyyyy(ViewState["HazardousExpiryDate"].ToString())); } else { HazardousExpiryDate = null; } if ((Convert.ToInt32(ddlAccountType.SelectedValue) == 3) || (Convert.ToInt32(ddlAccountType.SelectedValue) == 1)) { rfvState.Enabled = false; rfvCity.Enabled = false; rfvCity.Visible = false; rfvState.Visible = false; } if (ddlAccountType.SelectedItem.Text == "Driver") { if (ViewState["LincenceNo"] != null && ViewState["ExpiryDate"] != null) { if (Convert.ToString(hidid.Value) == "") { txtAccount.Text = ""; txtBankName.Text = ""; txtBranchName.Text = ""; txtIfscNo.Text = ""; txtdetenPlantchrg.Text = ""; txtcontainerchrg.Text = ""; txtdetenPortchrg.Text = ""; dtTemp = CreateDt(); dtTemp = (DataTable)ViewState["DocumentHolderTable"]; intAcntIdno = objAcntMaster.Insert(Convert.ToInt64(ddlTitle.SelectedValue), txtAccountPrtyName.Text.Trim(), txtAccountPrtyNameHindi.Text.Trim(), Convert.ToInt64(ddlAccountType.SelectedValue), Convert.ToInt64(ddlAccountSubGroup.SelectedValue), Convert.ToInt32(ddlBalanceType.SelectedValue), (txtOpBal.Text.Trim() == "") ? 0 : Convert.ToDouble(txtOpBal.Text.Trim()), (txtagntCommision.Text.Trim() == "") ? 0 : Convert.ToDouble(txtagntCommision.Text.Trim()), Convert.ToBoolean(chkServExmpt.Checked), txtcontPrsn.Text.Trim(), txtContMob.Text.Trim(), txtContEmail.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), Convert.ToInt64(ddlState.SelectedValue), Convert.ToInt64(ddlCity.SelectedValue), Convert.ToInt64(ddlDistrict.SelectedValue), Convert.ToBoolean(chkStatus.Checked), (txtPinCode.Text.Trim() == "") ? 0 : Convert.ToInt32(txtPinCode.Text.Trim()), txtFax.Text.Trim(), Convert.ToInt32(ddlDateRange.SelectedValue), ViewState["LincenceNo"].ToString(), ExpiryDate, ViewState["Authority"].ToString(), ViewState["Account"].ToString(), Convert.ToInt32(ViewState["Guarantor"].ToString()), Convert.ToBoolean(ViewState["varified"].ToString()), ViewState["FatherName"].ToString(), ViewState["Address"].ToString(), ViewState["Mobile1"].ToString(), ViewState["Mobile2"].ToString(), ViewState["BankName"].ToString(), ViewState["BankAddress"].ToString(), ViewState["RTGScode"].ToString(), ViewState["HazardousLicence"].ToString(), HazardousExpiryDate, Convert.ToInt64(ddlCompany.SelectedValue), Convert.ToInt32(ddlCategory.SelectedValue), txtTin.Text.Trim(), empIdno, Convert.ToInt64(ddlPrincComp.SelectedValue), Convert.ToString(txtPanNo.Text), txtAccount.Text, txtBankName.Text, txtBranchName.Text, txtIfscNo.Text, (txtdetenPlantchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtdetenPlantchrg.Text.Trim()), (txtdetenPortchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtdetenPortchrg.Text.Trim()), (txtcontainerchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtcontainerchrg.Text.Trim()), txtLSTNo.Text.Trim(), txtcstNo.Text.Trim(), GSTINNO, Convert.ToString(txtShortName.Text.Trim()), dtTemp); } else if (Convert.ToString(hidid.Value) != "") { dtTemp = CreateDt(); dtTemp = (DataTable)ViewState["DocumentHolderTable"]; intAcntIdno = objAcntMaster.Update(Convert.ToInt64(ddlTitle.SelectedValue), txtAccountPrtyName.Text.Trim(), txtAccountPrtyNameHindi.Text.Trim(), Convert.ToInt64(ddlAccountType.SelectedValue), Convert.ToInt64(ddlAccountSubGroup.SelectedValue), Convert.ToInt32(ddlBalanceType.SelectedValue), ((Convert.ToString(txtOpBal.Text) == "") ? 0.00 : Convert.ToDouble(txtOpBal.Text.Trim())), ((Convert.ToString(txtagntCommision.Text) == "") ? 0.00 : Convert.ToDouble(txtagntCommision.Text.Trim())), Convert.ToBoolean(chkServExmpt.Checked), txtcontPrsn.Text.Trim(), txtContMob.Text.Trim(), txtContEmail.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), Convert.ToInt64(ddlState.SelectedValue), Convert.ToInt64(ddlCity.SelectedValue), Convert.ToInt64(ddlDistrict.SelectedValue), Convert.ToBoolean(chkStatus.Checked), (txtPinCode.Text.Trim() == "") ? 0 : Convert.ToInt32(txtPinCode.Text.Trim()), txtFax.Text.Trim(), Convert.ToInt32(hidid.Value), Convert.ToInt32(ddlDateRange.SelectedValue), ViewState["LincenceNo"].ToString(), ExpiryDate, ViewState["Authority"].ToString(), ViewState["Account"].ToString(), Convert.ToInt32(ViewState["Guarantor"].ToString()), Convert.ToBoolean(ViewState["varified"].ToString()), ViewState["FatherName"].ToString(), ViewState["Address"].ToString(), ViewState["Mobile1"].ToString(), ViewState["Mobile2"].ToString(), ViewState["BankName"].ToString(), ViewState["BankAddress"].ToString(), ViewState["RTGScode"].ToString(), ViewState["HazardousLicence"].ToString(), HazardousExpiryDate, Convert.ToInt64(ddlCompany.SelectedValue), Convert.ToInt32(ddlCategory.SelectedValue), txtTin.Text.Trim(), empIdno, Convert.ToInt64(Request.Form[ddlPrincComp.UniqueID]), Convert.ToString(txtPanNo.Text), txtAccount.Text, txtBankName.Text, txtBranchName.Text, txtIfscNo.Text, (txtdetenPlantchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtdetenPlantchrg.Text.Trim()), (txtdetenPortchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtdetenPortchrg.Text.Trim()), (txtcontainerchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtcontainerchrg.Text.Trim()), txtLSTNo.Text.Trim(), txtcstNo.Text.Trim(), GSTINNO, Convert.ToString(txtShortName.Text.Trim()), dtTemp); } objAcntMaster = null; if (intAcntIdno > 0) { if (string.IsNullOrEmpty(hidid.Value) == false) { ShowMessage("Record updated successfully."); } else { ShowMessage("Record saved successfully."); } this.ClearControls(); } else if (intAcntIdno < 0) { ShowMessageErr("Record already exists!"); } else { if (string.IsNullOrEmpty(hidid.Value) == false) { ShowMessageErr("Record not updated!"); } else { ShowMessageErr("Record not saved!"); } } ddlTitle.Focus(); } else { ShowMessageErr("Please check driver licence number and expiry date"); } } else { if (Convert.ToString(hidid.Value) == "") { dtTemp = CreateDt(); dtTemp = (DataTable)ViewState["DocumentHolderTable"]; intAcntIdno = objAcntMaster.Insert(Convert.ToInt64(ddlTitle.SelectedValue), txtAccountPrtyName.Text.Trim(), txtAccountPrtyNameHindi.Text.Trim(), Convert.ToInt64(ddlAccountType.SelectedValue), Convert.ToInt64(ddlAccountSubGroup.SelectedValue), Convert.ToInt32(ddlBalanceType.SelectedValue), (txtOpBal.Text.Trim() == "") ? 0 : Convert.ToDouble(txtOpBal.Text.Trim()), (txtagntCommision.Text.Trim() == "") ? 0 : Convert.ToDouble(txtagntCommision.Text.Trim()), Convert.ToBoolean(chkServExmpt.Checked), txtcontPrsn.Text.Trim(), txtContMob.Text.Trim(), txtContEmail.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), Convert.ToInt64(ddlState.SelectedValue), Convert.ToInt64(ddlCity.SelectedValue), Convert.ToInt64(ddlDistrict.SelectedValue), Convert.ToBoolean(chkStatus.Checked), (txtPinCode.Text.Trim() == "") ? 0 : Convert.ToInt32(txtPinCode.Text.Trim()), txtFax.Text.Trim(), Convert.ToInt32(ddlDateRange.SelectedValue), null, ExpiryDate, null, null, 0, false, null, null, null, null, null, null, null, null, HazardousExpiryDate, Convert.ToInt64(ddlCompany.SelectedValue), Convert.ToInt32(ddlCategory.SelectedValue), txtTin.Text.Trim(), empIdno, Convert.ToInt64(ddlPrincComp.SelectedValue), Convert.ToString(txtPanNo.Text.Trim()), string.IsNullOrEmpty(txtAccount.Text) ? "" : Convert.ToString(txtAccount.Text.Trim()), string.IsNullOrEmpty(txtBankName.Text) ? "" : Convert.ToString(txtBankName.Text), string.IsNullOrEmpty(txtBranchName.Text) ? "" : Convert.ToString(txtBranchName.Text), string.IsNullOrEmpty(txtIfscNo.Text) ? "" : Convert.ToString(txtIfscNo.Text), (txtdetenPlantchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtdetenPlantchrg.Text.Trim()), (txtdetenPortchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtdetenPortchrg.Text.Trim()), (txtcontainerchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtcontainerchrg.Text.Trim()), txtLSTNo.Text.Trim(), txtcstNo.Text.Trim(), GSTINNO, Convert.ToString(txtShortName.Text.Trim()), dtTemp); } else if (Convert.ToString(hidid.Value) != "") { dtTemp = CreateDt(); dtTemp = (DataTable)ViewState["DocumentHolderTable"]; intAcntIdno = objAcntMaster.Update(Convert.ToInt64(ddlTitle.SelectedValue), txtAccountPrtyName.Text.Trim(), txtAccountPrtyNameHindi.Text.Trim(), Convert.ToInt64(ddlAccountType.SelectedValue), Convert.ToInt64(ddlAccountSubGroup.SelectedValue), Convert.ToInt32(ddlBalanceType.SelectedValue), ((Convert.ToString(txtOpBal.Text) == "") ? 0.00 : Convert.ToDouble(txtOpBal.Text.Trim())), ((Convert.ToString(txtagntCommision.Text) == "") ? 0.00 : Convert.ToDouble(txtagntCommision.Text.Trim())), Convert.ToBoolean(chkServExmpt.Checked), txtcontPrsn.Text.Trim(), txtContMob.Text.Trim(), txtContEmail.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), Convert.ToInt64(ddlState.SelectedValue), Convert.ToInt64(ddlCity.SelectedValue), Convert.ToInt64(ddlDistrict.SelectedValue), Convert.ToBoolean(chkStatus.Checked), (txtPinCode.Text.Trim() == "") ? 0 : Convert.ToInt32(txtPinCode.Text.Trim()), txtFax.Text.Trim(), Convert.ToInt32(hidid.Value), Convert.ToInt32(ddlDateRange.SelectedValue), null, ExpiryDate, null, null, 0, false, null, null, null, null, null, null, null, null, HazardousExpiryDate, Convert.ToInt64(ddlCompany.SelectedValue), Convert.ToInt32(ddlCategory.SelectedValue), txtTin.Text.Trim(), empIdno, Convert.ToInt64(ddlPrincComp.SelectedValue), Convert.ToString(txtPanNo.Text.Trim()), string.IsNullOrEmpty(txtAccount.Text) ? "" : Convert.ToString(txtAccount.Text.Trim()), string.IsNullOrEmpty(txtBankName.Text) ? "" : Convert.ToString(txtBankName.Text), string.IsNullOrEmpty(txtBranchName.Text) ? "" : Convert.ToString(txtBranchName.Text), string.IsNullOrEmpty(txtIfscNo.Text) ? "" : Convert.ToString(txtIfscNo.Text), (txtdetenPlantchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtdetenPlantchrg.Text.Trim()), (txtdetenPortchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtdetenPortchrg.Text.Trim()), (txtcontainerchrg.Text.Trim() == "") ? 0 : Convert.ToDouble(txtcontainerchrg.Text.Trim()), txtLSTNo.Text.Trim(), txtcstNo.Text.Trim(), GSTINNO, Convert.ToString(txtShortName.Text.Trim()), dtTemp); } objAcntMaster = null; if (intAcntIdno > 0) { if (string.IsNullOrEmpty(hidid.Value) == false) { ShowMessage("Record updated successfully."); } else { ShowMessage("Record saved successfully."); } this.ClearControls(); } else if (intAcntIdno < 0) { ShowMessageErr("Record already exists."); } else { if (string.IsNullOrEmpty(hidid.Value) == false) { ShowMessageErr("Record not updated."); } else { ShowMessageErr("Record not saved."); } } ddlTitle.Focus(); } ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "OnChangeDriver();onChangeAccSubGrp();EnabaleDisable();", true); if (ddlAccountType.SelectedValue == "10") { rfvpetroCompany.Enabled = true; } else { rfvpetroCompany.Enabled = false; } }
private void Populate(int AcntIdno) { LedgerAccountDAL objAcntMaster = new LedgerAccountDAL(); var objAcntMast = objAcntMaster.SelectById(AcntIdno); var lst = objAcntMaster.CheckInvGen(AcntIdno); var objDocHolder = objAcntMaster.SelectDocHolder(AcntIdno); objAcntMaster = null; if (objAcntMast != null) { hiddriverPopulate.Value = Convert.ToString(lst); txtAccountPrtyName.Text = Convert.ToString(objAcntMast.Acnt_Name); txtAccountPrtyNameHindi.Text = Convert.ToString(objAcntMast.AcntName_Hindi); txtAddress1.Text = Convert.ToString(objAcntMast.Address1); txtAddress2.Text = Convert.ToString(objAcntMast.Address2); txtAccount.Text = Convert.ToString(objAcntMast.Account_No); txtBankName.Text = Convert.ToString(objAcntMast.Bank_Name); txtBranchName.Text = Convert.ToString(objAcntMast.Branch_Name); txtIfscNo.Text = Convert.ToString(objAcntMast.Ifsc_Code); txtagntCommision.Text = Convert.ToString(objAcntMast.Agnt_Commson); ddlAccountType.SelectedValue = Convert.ToString(objAcntMast.Acnt_Type); txtContEmail.Text = Convert.ToString(objAcntMast.Cont_Email); if ((Convert.ToInt32(ddlAccountType.SelectedValue) == 3) || (Convert.ToInt32(ddlAccountType.SelectedValue) == 1)) { txtcontPrsn.Enabled = false; txtContMob.Enabled = false; txtContEmail.Enabled = false; txtAddress1.Enabled = false; txtAddress2.Enabled = false; ddlState.Enabled = false; ddlCity.Enabled = false; chkStatus.Enabled = false; txtPinCode.Enabled = false; txtTin.Enabled = false; txtFax.Enabled = false; ddlCategory.Enabled = false; rfvState.Enabled = false; rfvCity.Enabled = false; rfvpetroCompany.Enabled = false; rfvpetroCompany.Visible = false; rfvCity.Visible = false; rfvState.Visible = false; SpanCityRefresh.Visible = false; ddlState.SelectedIndex = 0; ddlCity.SelectedIndex = 0; ddlDistrict.SelectedIndex = 0; } else { ddlState.SelectedValue = Convert.ToString(objAcntMast.State_Idno); this.BindCitywithStateId(Convert.ToInt32(objAcntMast.State_Idno)); if ((Convert.ToString(objAcntMast.City_Idno) != "") && (Convert.ToInt64(objAcntMast.City_Idno) > 0)) { ddlCity.SelectedValue = Convert.ToString(objAcntMast.City_Idno); } } ddlTitle.SelectedValue = Convert.ToString(objAcntMast.Titl_Idno); if (Convert.ToInt32(ddlAccountType.SelectedValue) != 12) { DivlnkClaimDetails.Visible = false; } else { DivbtnDriver.Visible = false; DivlnkClaimDetails.Visible = true; } if (Convert.ToString(objAcntMast.Acnt_Type) == "9") { txtlicense.Text = Convert.ToString(objAcntMast.DrvLicnc_NO); if (objAcntMast.DrvLNo_ExpDate != null) { txtExpiryDate.Text = Convert.ToDateTime(objAcntMast.DrvLNo_ExpDate).ToString("dd-MM-yyyy"); } txtauthority.Text = Convert.ToString(objAcntMast.DrvAuthrty_Plc); txtaccountno.Text = Convert.ToString(objAcntMast.DrvAcnt_No); Drpgurenter.SelectedValue = Convert.ToString(objAcntMast.DrvGurntr_Idno); chkVarified.Checked = Convert.ToBoolean(objAcntMast.DrvLNo_Verfd); txtDriverSOF.Text = Convert.ToString(objAcntMast.DrvFather_Nm); txtDriverAddress.Text = Convert.ToString(objAcntMast.Drv_Adres); txtDriverMobileNo1.Text = Convert.ToString(objAcntMast.Drv_MobNo1); txtDriverMobileNo2.Text = Convert.ToString(objAcntMast.Drv_MobNo2); txtDriverBankName.Text = Convert.ToString(objAcntMast.DrvBankAc_Nm); txtDriverBankAddrs.Text = Convert.ToString(objAcntMast.DrvBankAc_Adres); txtDriverRTGC.Text = Convert.ToString(objAcntMast.DrvAc_RtgsCode); txtDriverHazardousL.Text = Convert.ToString(objAcntMast.DrvHazardLic_No); if (objAcntMast.DrvHazardLic_NoExpDt != null) { txtHazardousExpiryDate.Text = Convert.ToDateTime(objAcntMast.DrvHazardLic_NoExpDt).ToString("dd-MM-yyyy"); } ViewState["LincenceNo"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLicnc_NO)) ? "" : Convert.ToString(objAcntMast.DrvLicnc_NO); ViewState["ExpiryDate"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLNo_ExpDate)) ? "" : Convert.ToDateTime(objAcntMast.DrvLNo_ExpDate).ToString("dd-MM-yyyy"); ViewState["Authority"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAuthrty_Plc)) ? "" : Convert.ToString(objAcntMast.DrvAuthrty_Plc); ViewState["Account"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAcnt_No)) ? "" : Convert.ToString(objAcntMast.DrvAcnt_No); ViewState["Guarantor"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvGurntr_Idno)) ? "0" : Convert.ToString(objAcntMast.DrvGurntr_Idno); ViewState["varified"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvLNo_Verfd)) ? "0" : Convert.ToString(objAcntMast.DrvLNo_Verfd); ViewState["FatherName"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvFather_Nm)) ? "" : Convert.ToString(objAcntMast.DrvFather_Nm); ViewState["Address"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_Adres)) ? "" : Convert.ToString(objAcntMast.Drv_Adres); ViewState["Mobile1"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_MobNo1)) ? "" : Convert.ToString(objAcntMast.Drv_MobNo1); ViewState["Mobile2"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Drv_MobNo2)) ? "" : Convert.ToString(objAcntMast.Drv_MobNo2); ViewState["BankName"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvBankAc_Nm)) ? "" : Convert.ToString(objAcntMast.DrvBankAc_Nm); ViewState["BankAddress"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvBankAc_Adres)) ? "" : Convert.ToString(objAcntMast.DrvBankAc_Adres); ViewState["RTGScode"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvAc_RtgsCode)) ? "" : Convert.ToString(objAcntMast.DrvAc_RtgsCode); ViewState["HazardousLicence"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvHazardLic_No)) ? "" : Convert.ToString(objAcntMast.DrvHazardLic_No); ViewState["HazardousExpiryDate"] = string.IsNullOrEmpty(Convert.ToString(objAcntMast.DrvHazardLic_NoExpDt)) ? "" : Convert.ToDateTime(objAcntMast.DrvHazardLic_NoExpDt).ToString("dd-MM-yyyy"); } //Other Charge......... txtdetenPlantchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.detenPlant_charg)) ? "0.00" :Convert.ToString(objAcntMast.detenPlant_charg); txtdetenPortchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.detenPort_charg)) ? "0.00" : Convert.ToString(objAcntMast.detenPort_charg); txtcontainerchrg.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Container_charg)) ? "0.00" : Convert.ToString(objAcntMast.Container_charg); // //ddlAccountType.Enabled = false; ddlAccountSubGroup.SelectedValue = Convert.ToString(objAcntMast.ASubGrp_Idno); ddlBalanceType.SelectedValue = Convert.ToString(objAcntMast.Bal_Type); txtOpBal.Text = Convert.ToString(objAcntMast.Open_Bal); chkServExmpt.Checked = Convert.ToBoolean(objAcntMast.ServTax_Exmpt); txtcontPrsn.Text = Convert.ToString(objAcntMast.Cont_Person); txtContMob.Text = Convert.ToString(objAcntMast.Cont_Mobile); txtPinCode.Text = (Convert.ToString(objAcntMast.Pin_Code) == "0")? "" : Convert.ToString(objAcntMast.Pin_Code); txtFax.Text = Convert.ToString(objAcntMast.Fax_No); chkStatus.Checked = Convert.ToBoolean(objAcntMast.Status); ddlCompany.SelectedValue = Convert.ToString(objAcntMast.PetrolComp_Idno); ddlPrincComp.SelectedValue = string.IsNullOrEmpty(Convert.ToString(objAcntMast.PComp_Idno)) ? "0" : Convert.ToString(objAcntMast.PComp_Idno); txtPanNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Pan_No)) ? "" : Convert.ToString(objAcntMast.Pan_No); txtLSTNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Lst_No)) ? "" : Convert.ToString(objAcntMast.Lst_No); txtcstNo.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Cst_No)) ? "" : Convert.ToString(objAcntMast.Cst_No); hidid.Value = Convert.ToString(objAcntMast.Acnt_Idno); txtGST.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.LdgrGSTIN_No)) ? "" : Convert.ToString(objAcntMast.LdgrGSTIN_No); txtShortName.Text = string.IsNullOrEmpty(Convert.ToString(objAcntMast.Short_Name)) ? "" : Convert.ToString(objAcntMast.Short_Name); if (objDocHolder != null && objDocHolder.Count > 0) { dtTemp = CreateDt(); for (int counter = 0; counter < objDocHolder.Count; counter++) { string strDocName = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocName")); string strRemark = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocRemark")); string strImage = Convert.ToString(DataBinder.Eval(objDocHolder[counter], "DocImage")); ApplicationFunction.DatatableAddRow(dtTemp, counter + 1, strDocName, strRemark, strImage); } ViewState["DocumentHolderTable"] = dtTemp; this.BindDocumentDataGrid(); } ddlTitle.Focus(); } }