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();
}
}
