public void ValidateDate()
{
if (hiddenfildYear.Value == "")
{
if (Session["FY"] != null)
{
strChetanaCompanyName = Session["ChetanaCompanyName"].ToString();
strFY = Session["FY"].ToString();
DataTable dt = Customer_cs.Idv_Chetana_Customer_BlackList(2, "", "", 0, 0, 0, Convert.ToInt32(strFY)).Tables[0];
if (dt.Rows.Count > 0)
{
hiddenfildYear.Value = dt.Rows[0][0].ToString();
}
string year = hiddenfildYear.Value;
MaskedEditValidator1.MinimumValue = "01/04/" + year;
MaskedEditValidator1.MaximumValue = "31/03/" + (Convert.ToInt32(year) + 1).ToString();
MaskedEditValidator1.MinimumValueMessage = "Date should be greater than 01/04/" + year;
MaskedEditValidator1.MaximumValueMessage = "Date should be less than 31/03/" + (Convert.ToInt32(year) + 1).ToString();
}
else
{
Session.Clear();
}
}
}
public DataTable BindGvCustDetail(string CustCode)
{
DataTable dt = new DataTable();
dt = Customer_cs.Get_CustList("", CustCode);
return(dt);
}
protected void grdBankDetails_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
pnlBank.Visible = false;
Panel1.Visible = true;
btnsave.Visible = true;
filter.Visible = false;
txtbankCode.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblBnkCode")).Text;
DDLstate.DataSource = Customer_cs.Get_DestinationMaster("state");
DDLstate.DataBind();
DDLstate.Items.Insert(0, new ListItem("--Select State--", "0"));
DDLstate.Enabled = true;
//
pnlBank.Visible = false;
Panel1.Visible = true;
lblBankId.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblbankID")).Text;
txtbankName.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblBnkName")).Text;
txtbDesc.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblbankdecp")).Text;
txtcountry.Text = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblcountry")).Text;
DDLCity.SelectedValue = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblcity")).Text;
DDLstate.SelectedValue = ((Label)grdBankDetails.Rows[e.NewEditIndex].FindControl("lblstate")).Text;
DDLCity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString());
DDLCity.DataBind();
DDLCity.Items.Insert(0, new ListItem("--Select City--", "0"));
DDLCity.Enabled = true;
chekactive.Checked = ((CheckBox)grdBankDetails.Rows[e.NewEditIndex].FindControl("chkactive")).Checked;
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
SetView();
if (!Page.IsPostBack)
{
grdCustomerMaster.DataSource = BindCustomerMasterDetail();
grdCustomerMaster.DataBind();
//MessageBox("coming1" + grdCustomerMaster.Rows.Count.ToString());
DataView dv = new DataView(BindCustomerMasterDetail().Table);
Session["data"] = dv;
//Bind_DDL_SDZone();
repAlfabets.DataSource = Customer_cs.GetAlphabets();
repAlfabets.DataBind();
pnlCustomerMaster.Visible = true;
}
else
{
pnlCustomerMaster.Visible = true;
}
}
catch (Exception ex)
{
MessageBox(ex.ToString());
}
}
protected void DDLstate_SelectedIndexChanged(object sender, EventArgs e)
{
DDLCity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString());
DDLCity.DataBind();
DDLCity.Items.Insert(0, new ListItem("--Select City--", "0"));
DDLCity.Enabled = true;
}
protected void grdCustDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
bool _objct = new CustomerToTransport().isDelete("customer", (((Label)grdCustDetails.Rows[e.RowIndex].FindControl("lblCustID")).Text));
if (_objct)
{
Customer_cs _objCM = new Customer_cs();
_objCM.CustID = Convert.ToInt32(((Label)grdCustDetails.Rows[e.RowIndex].FindControl("lblCustID")).Text);
_objCM.CustCode = ((Label)grdCustDetails.Rows[e.RowIndex].FindControl("lblCustCode")).Text;
_objCM.CustName = ((Label)grdCustDetails.Rows[e.RowIndex].FindControl("lblCustName")).Text;
_objCM.IsActive = Convert.ToBoolean(false);
_objCM.IsDeleted = Convert.ToBoolean(true);
_objCM.IsDeleted1 = Convert.ToBoolean(true);
try
{
_objCM.Update();
MessageBox("Your record is Deleted");
PnlDetails.Visible = true;
PnlAdd.Visible = false;
}
catch
{
}
}
else
{
MessageBox("You Can not Delete This Customer");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
DataView dv = new DataView(BindGvCustDetail().Table);
Session["data"] = dv;
grdCustDetails.DataSource = dv;
grdCustDetails.DataBind();
DdlSection.Enabled = false;
DdlSection.DataSource = SectionMaster.Get_SectionList();
DdlSection.DataBind();
repAlfabets.DataSource = Customer_cs.GetAlphabets();
repAlfabets.DataBind();
LblCustId.Text = "0";
fillzones();
TxtCustCode.Focus();
custRating();
getDDLdata();
getDDLarezo();
getDDLarea();
SetView();
//dv = (DataView)Session["data"];
////string val = ((LinkButton)(sender)).Text;
//dv.RowFilter = "CustName='A'";
//grdCustDetails.DataSource = dv;
//grdCustDetails.DataBind();
//((LinkButton)(sender)).BackColor = System.Drawing.Color.Red;
//((LinkButton)(sender)).ForeColor = System.Drawing.Color.White;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["ChetanaCompanyName"] != "" || Session["ChetanaCompanyName"] != null)
{
if (Session["FY"] != null)
{
strChetanaCompanyName = Session["ChetanaCompanyName"].ToString();
strFY = Session["FY"].ToString();
}
}
if (!Page.IsPostBack)
{
Session["data"] = null;
//DataView dv = new DataView(BindGvBookDetail().Table);
DataView dv = new DataView(BindGvBookDetail(strChetanaCompanyName).Table);
Session["data"] = dv;
grdBookDetails.DataSource = dv;
grdBookDetails.DataBind();
repAlfabets.DataSource = Customer_cs.GetAlphabets();
repAlfabets.DataBind();
SetView();
//txtcode.Focus();
}
else
{
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = Customer_cs.Get_CustList("ActiveNonActive", strFY.ToString(), DDLSuperZone.SelectedValue.ToString());
ViewState["ActiveNonActive"] = dt;
ShowDetails(dt);
}
public void getdata(int a)
{
string fromdate = txtFromdate.Text.Split('/')[1] + "/" + txtFromdate.Text.Split('/')[0] + "/" + txtFromdate.Text.Split('/')[2];
string todate = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2];
string custCode = "";
ReportDocument crystalReport = new ReportDocument();
if (ddlZone.SelectedIndex != 0)
{
txtcustomer.Text = "";
lblCustName.Text = "";
custCode = "1";
}
else
{
custCode = txtcustomer.Text;
}
DataSet dt = new DataSet();
if (a == 1 || Session["tstlData"] == null)
{
dt = Customer_cs.Get_TStyle_Report(custCode, Convert.ToInt32(ddlZone.SelectedValue), Convert.ToInt32(strFY), "parent",
Convert.ToDateTime(fromdate), Convert.ToDateTime(todate));
Session["tstlData"] = dt;
}
else
{
dt = (DataSet)Session["tstlData"];
}
crystalReport.Load(Server.MapPath("Report/TStyleReport.rpt"));
crystalReport.SetDataSource(dt.Tables[0]);
crystalReport.OpenSubreport("test").SetDataSource(dt.Tables[1]);
crystalReport.OpenSubreport("tstlCr").SetDataSource(dt.Tables[2]);
crystalReport.OpenSubreport("monthlysummery").SetDataSource(dt.Tables[3]);
if (dt.Tables[0].Rows.Count > 0)
{
crtcustomer.ReportSource = crystalReport;
}
else
{
if (a == 1)
{
MessageBox("No Data Found!!!");
}
}
if (txtcustomer.Enabled == true)
{
txtcustomer.Focus();
}
else
{
ddlZone.Focus();
}
}
public DataView BindGvCustDetail()
{
DataTable dt = new DataTable();
dt = Customer_cs.Get_CustList();
DataView dv = new DataView(dt);
return(dv);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
lblBankId.Visible = false;
Panel1.Visible = true;
BindGvBankDetails();
DDLstate.DataSource = Customer_cs.Get_DestinationMaster("state");
DDLstate.DataBind();
DDLstate.Items.Insert(0, new ListItem("--Select State--", "0"));
SetView();
}
}
protected void btnget_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
if (rdbselect.SelectedValue == "Customer")
{
dt = Customer_cs.Get_CustListReport("SuperZone", DDLCC.SelectedValue.ToString(), DDLSuperZone.SelectedValue.ToString(), ddlZone.SelectedValue.ToString());
}
else
{
dt = Customer_cs.Get_CustList("Supplier", ddlSupplier.SelectedValue.ToString());
}
ViewState["Data"] = dt;
BindData(dt);
}
public DataView BindCustomerMasterDetail()
{
try
{
DataTable dt = new DataTable();
dt = Customer_cs.Get_CustList("ExportCustomer", "");
DataView dv = new DataView(dt);
return(dv);
}
catch (Exception ex)
{
DataView dv = new DataView();
return(dv);
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetView();
if (!Page.IsPostBack)
{
grdSuperZoneDetails.DataSource = BindGvSuperZoneDetail();
grdSuperZoneDetails.DataBind();
DataView dv = new DataView(BindGvSuperZoneDetail().Table);
Session["data"] = dv;
repAlfabets.DataSource = Customer_cs.GetAlphabets();
repAlfabets.DataBind();
}
else
{
// pnlSuperZone.Visible = true;
}
}
protected void DDLstate_SelectedIndexChanged(object sender, EventArgs e)
{
if (DDLstate.SelectedValue == "0")
{
DDLcity.Items.Clear(); //rajnish
DDLcity.Items.Insert(0, new ListItem("--Select City--", "0")); //rajnish
}
else
{
DDLcity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString());
DDLcity.DataBind();
DDLcity.Items.Insert(0, new ListItem("--Select City--", "0"));
//DDLcity.Items.Insert(0, new ListItem("--Select City--", "0"));
DDLcity.Enabled = true;
DDLcity.Focus();
}
}
public void fillReport(int ISPRINT)
{
if (txtRs.Text.Trim() == "")
{
txtRs.Text = "0";
}
DataTable dt = new DataTable();
string date = "";
if (ISPRINT == 1)
{
if (txtcustomer.Text != "")
{
if (txttoDate.Text != "")
{
date = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2];
Session["DATAREP"] = Customer_cs.Idv_Chetana_Customer_BlackList(0, "_C$" + txtcustomer.Text, date, Convert.ToDecimal(txtRs.Text.Trim()), Convert.ToInt32(HidFY.Value), 0, 0).Tables[0];
}
}
else
{
if (txttoDate.Text != "")
{
date = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2];
Session["DATAREP"] = Customer_cs.Idv_Chetana_Customer_BlackList(0, "_Z$" + txtcustomer.Text, date, Convert.ToDecimal(txtRs.Text.Trim()), Convert.ToInt32(HidFY.Value), 0, Convert.ToInt32(ddlZone.SelectedValue.Trim())).Tables[0];
}
}
}
if (Session["DATAREP"] != null)
{
dt = (DataTable)Session["DATAREP"];
}
if (dt.Rows.Count > 0)
{
fillReport();
}
else
{
lblMessage.Visible = true;
}
if (ISPRINT == 1)
{
//crystalReport.PrintToPrinter(0, false, 0, 0);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
LblEmpID.Visible = false;
DdlRole.DataSource = Rolemaster.Get_RoleMaster();
DdlRole.DataBind();
fillQualification();
fillDesignation();
PnlLoginDetails.Visible = false;
grdEmpDetails.DataSource = BindGvEmpDetail();
grdEmpDetails.DataBind();
//
// DDLsuperzone.DataSource = SuperZone.GetSuperzonemaster();
// DDLsuperzone.DataBind();
DDLSDZone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(0, "SDZone");
DDLSDZone.DataBind();
DDLSDZone.Items.Insert(0, new ListItem("All", "0"));
DDLsuperzone.Items.Insert(0, new ListItem("All", "0"));
DDLzone.Items.Insert(0, new ListItem("All", "0"));
DDLareazone.Items.Insert(0, new ListItem("All", "0"));
// DDLarea.Items.Insert(0, new ListItem("All", "0"));
//
DDLstate.DataSource = Customer_cs.Get_DestinationMaster("state");
DDLstate.DataBind();
DDLstate.Items.Insert(0, new ListItem("--Select State--", "0"));
DDLcity.Items.Insert(0, new ListItem("--Select City--", "0"));
SetView();
//
txtjoin.Text = DateTime.Now.ToString("dd/MM/yyyy");
txtResign.Text = "30/01/2050";
EmpId();
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (ConfigurationManager.AppSettings["access"].ToString() != ConfigurationManager.AppSettings["accessok"].ToString())
{
string page = Request.Url.Segments[Request.Url.Segments.Length - 1].ToString();
if (Session["Role"] != null)
{
if (!Other.Get_UserAccess(page, Session["Role"].ToString()))
{
Response.Redirect("dashboard.aspx");
}
}
}
EmpCode = Convert.ToString(Session["UserName"]);
DataSet ds = new DataSet();
ds = Customer_cs.GetSchool_Names(EmpCode);
DdlCustomer.DataSource = ds;
DdlCustomer.DataBind();
DdlCustomer.Items.Insert(0, new ListItem("-Select-", "0"));
}
public DataSet getBlackListedCustomer(int showdata, int view)
{
DataSet ds = new DataSet();
if (txtRs.Text == "")
{
txtRs.Text = "0";
}
try
{
string date = "";
if (view != 1)
{
date = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2];
}
ds = Customer_cs.Idv_Chetana_Customer_BlackList(view, "", date, Convert.ToDecimal(txtRs.Text.Trim()), 1, IsShowData, 0);
lblTotalOS.Text = "Total Outstanding : " + ds.Tables[1].Rows[0][0].ToString();
}
catch (Exception ex)
{
return(ds = null);
}
return(ds);
}
protected void grdACC_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
int CustId;
string CustCode = "";
decimal NETBILLAMT = 0;
decimal NETCNAMT = 0;
decimal NETAMT = 0;
decimal NETADDDIS = 0;
decimal GROSSBILLAMT = 0;
decimal GROSSCNAMT = 0;
decimal GROSSNETAMT = 0;
decimal GROSSADDDIS = 0;
decimal Amount = 0;
string Details = "";
int DACId;
Customer_cs objDAC = new Customer_cs();
for (int i = 0; i <= grdACC.Rows.Count - 1; i++)
{
System.Web.UI.WebControls.CheckBox cb = (System.Web.UI.WebControls.CheckBox)grdACC.Rows[i].Cells[0].Controls[1];
if (cb.Checked == true)
{
try
{
System.Web.UI.WebControls.Label WbCustCode = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[1].Controls[1];
CustCode = WbCustCode.Text.ToString();
System.Web.UI.WebControls.Label Wb1 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[11].Controls[1];
NETBILLAMT = Convert.ToDecimal(Wb1.Text.ToString());
// try
//{
if (NETBILLAMT > 0)
{
PnlAddDAC.Visible = true;
System.Web.UI.WebControls.Label Wb2 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[12].Controls[1];
NETCNAMT = Convert.ToDecimal(Wb2.Text.ToString());
System.Web.UI.WebControls.Label Wb3 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[13].Controls[1];
NETAMT = Convert.ToDecimal(Wb3.Text.ToString());
System.Web.UI.WebControls.Label Wb4 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[14].Controls[1];
NETADDDIS = Convert.ToDecimal(Wb4.Text.ToString());
System.Web.UI.WebControls.Label Wb5 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[15].Controls[1];
GROSSBILLAMT = Convert.ToDecimal(Wb5.Text.ToString());
System.Web.UI.WebControls.Label Wb6 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[16].Controls[1];
GROSSCNAMT = Convert.ToDecimal(Wb6.Text.ToString());
System.Web.UI.WebControls.Label Wb7 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[17].Controls[1];
GROSSNETAMT = Convert.ToDecimal(Wb7.Text.ToString());
System.Web.UI.WebControls.Label Wb8 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[18].Controls[1];
GROSSADDDIS = Convert.ToDecimal(Wb8.Text.ToString());
System.Web.UI.WebControls.Label Wb9 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[19].Controls[1];
System.Web.UI.WebControls.Label Wb10 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[20].Controls[1];
txtAmount.Text = ((Label)grdACC.Rows[e.NewEditIndex].FindControl("lblDACAmount")).Text;
// txtDetails.Text = ((Label)grdACC.Rows[e.NewEditIndex].FindControl("lblDetails")).Text;
}
else
{
MessageBox("Bill Amount Should not be Zero");
}
//}
// catch
// {
// MessageBox("Bill Amount Should not be Zero");
// }
}
catch (Exception ex)
{
MessageBox(ex.Message);
}
}
}
}
catch { }
}
protected void Save_Click(object sender, EventArgs e)
{
try
{
int CustId;
string CustCode = "";
decimal NETBILLAMT = 0;
decimal NETCNAMT = 0;
decimal NETAMT = 0;
decimal NETADDDIS = 0;
decimal GROSSBILLAMT = 0;
decimal GROSSCNAMT = 0;
decimal GROSSNETAMT = 0;
decimal GROSSADDDIS = 0;
decimal Amount = 0;
string Details = "";
int DACId;
Customer_cs objDAC = new Customer_cs();
for (int i = 0; i <= grdACC.Rows.Count - 1; i++)
{
System.Web.UI.WebControls.CheckBox cb = (System.Web.UI.WebControls.CheckBox)grdACC.Rows[i].Cells[0].Controls[1];
if (cb.Checked == true)
{
try
{
System.Web.UI.WebControls.Label WbCustCode = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[1].Controls[1];
CustCode = WbCustCode.Text.ToString();
System.Web.UI.WebControls.Label Wb1 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[11].Controls[1];
NETBILLAMT = Convert.ToDecimal(Wb1.Text.ToString());
try
{
if (NETBILLAMT > 0)
{
System.Web.UI.WebControls.Label Wb2 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[12].Controls[1];
NETCNAMT = Convert.ToDecimal(Wb2.Text.ToString());
System.Web.UI.WebControls.Label Wb3 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[13].Controls[1];
NETAMT = Convert.ToDecimal(Wb3.Text.ToString());
System.Web.UI.WebControls.Label Wb4 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[14].Controls[1];
NETADDDIS = Convert.ToDecimal(Wb4.Text.ToString());
System.Web.UI.WebControls.Label Wb5 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[15].Controls[1];
GROSSBILLAMT = Convert.ToDecimal(Wb5.Text.ToString());
System.Web.UI.WebControls.Label Wb6 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[16].Controls[1];
GROSSCNAMT = Convert.ToDecimal(Wb6.Text.ToString());
System.Web.UI.WebControls.Label Wb7 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[17].Controls[1];
GROSSNETAMT = Convert.ToDecimal(Wb7.Text.ToString());
System.Web.UI.WebControls.Label Wb8 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[18].Controls[1];
GROSSADDDIS = Convert.ToDecimal(Wb8.Text.ToString());
System.Web.UI.WebControls.Label Wb9 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[19].Controls[1];
System.Web.UI.WebControls.Label Wb10 = (System.Web.UI.WebControls.Label)grdACC.Rows[i].Cells[20].Controls[1];
objDAC.Idv_Chetana_Rep_Customer_SaveDisburseAdditionalCommission(CustCode, NETBILLAMT, NETCNAMT, NETAMT, NETADDDIS, GROSSBILLAMT, GROSSCNAMT,
GROSSNETAMT, GROSSADDDIS, Convert.ToDecimal(txtAmount.Text), txtDetails.Text.ToString(), Convert.ToInt32(strFY), Convert.ToString(Session["UserName"]), out DACId);
MessageBox("Record saved successfully");
PnlAddDAC.Visible = false;
ShowDetails();
}
else
{
MessageBox("Bill Amount Should not be Zero");
}
}
catch (Exception ex)
{
MessageBox(ex.Message);
}
}
catch (Exception ex)
{
MessageBox(ex.Message);
}
}
}
}
catch { }
}
protected void btnSave_Click(object sender, EventArgs e)
{
// DdlSection.Text = "----";
try
{
//string Area = TxtArea.Text.Split(':')[0].Trim();
Customer_cs _objCust = new Customer_cs();
_objCust.CustID = Convert.ToInt32(LblCustId.Text);
_objCust.CustCode = TxtCustCode.Text.Trim();
_objCust.ShortForm = TxtShortForm.Text.Trim();
_objCust.FamilyCode = TxtFamilyCode.Text.Trim();
_objCust.Address = TxtAddress.Text.Trim();
_objCust.Zip = TxtZip.Text.Trim();
_objCust.Phone1 = TxtPhone1.Text.Trim();
_objCust.Phone2 = TxtPhone2.Text.Trim();
_objCust.EmailID = TxtEmailID.Text.Trim();
_objCust.CUSTOMERTYPE = TxtCustomerType.Text.Trim();
_objCust.IsDeleted = false;
_objCust.IsActive = true;
_objCust.CreatedBy = Convert.ToString(Session["UserName"]);
_objCust.CustName = TxtCustName.Text.Trim();
_objCust.ZoneID = Convert.ToInt32(DDLzone.SelectedValue);
_objCust.SuperZoneID = Convert.ToInt32(DDLsuperzone.SelectedValue);
_objCust.AreaZoneID = Convert.ToInt32(DDLareazone.SelectedValue);
_objCust.AreaID = Convert.ToInt32(DDLarea.SelectedValue);
_objCust.DMID = Convert.ToInt32(ddLStates.SelectedValue);
_objCust.City = Convert.ToInt32(ddlCity.SelectedValue);
_objCust.CustRating = Convert.ToInt32(DdlCustRating.SelectedValue);
string TxtPrincipalDOB1 = "";
string TxtKeyPersonDOB1 = "";
try
{
TxtPrincipalDOB1 = TxtPrincipalDOB.Text.Split('/')[1] + "/" + TxtPrincipalDOB.Text.Split('/')[0] + "/" + TxtPrincipalDOB.Text.Split('/')[2];
TxtKeyPersonDOB1 = TxtKeyPersonDOB.Text.Split('/')[1] + "/" + TxtKeyPersonDOB.Text.Split('/')[0] + "/" + TxtKeyPersonDOB.Text.Split('/')[2];
}
catch
{
}
if (LblCustId.Text == "0")
{
_objCust.Save(out CID);
// TxtCustId.Text = Convert.ToString(CID);
string Medium = TxtMedium.Text.Split(':')[0].Trim();
CustomerDetails _objCustDetails = new CustomerDetails();
_objCustDetails.CustId = CID;
_objCustDetails.CustCode = TxtCustCode.Text.Trim();
_objCustDetails.CreditLimit = TxtCreditLimit.Text.Trim();
// _objCustDetails.Creditdays = txtcreditdays.Text.Trim();
_objCustDetails.BlackList = ChkBlacklist.Checked;
_objCustDetails.CreatedBy = Convert.ToString(Session["UserName"]);
_objCustDetails.PrincipalName = TxtPrincipalName.Text.Trim();
_objCustDetails.PrincipalMobile = TxtPrincipalMobile.Text.Trim();
_objCustDetails.PrincipalDOB = TxtPrincipalDOB1;
_objCustDetails.KeyPersonName = TxtKeyPersonName.Text.Trim();
_objCustDetails.KeyPersonMobile = TxtKeyPersonMobile.Text.Trim();
_objCustDetails.KeyPersonDOB = TxtKeyPersonDOB.Text.Trim();
_objCustDetails.AdditinalDis = TxtAdditinalDis.Text.Trim();
_objCustDetails.VIPRemark = TxtVIPRemark.Text.Trim();
_objCustDetails.SectionID = 0;
//_objCustDetails.SectionID = Convert.ToInt32(DdlSection.SelectedValue);
_objCustDetails.Medium = Medium;
_objCustDetails.Save();
grdCustDetails.Visible = true;
PnlDetails.Visible = true;
MessageBox("Record saved successfully");
if (btnSave.Text == "Update")
{
PnlDetails.Visible = true;
PnlAdd.Visible = false;
btnSave.Visible = false;
filter.Visible = true;
}
else
{
PnlDetails.Visible = false;
PnlAdd.Visible = true;
btnSave.Visible = true;
}
}
else
{
string Medium = TxtMedium.Text.Split(':')[0].Trim();
_objCust.CustID = Convert.ToInt32(LblCustId.Text);
_objCust.CustDetailID = Convert.ToInt32(LblCustDetailID1.Text);
if (TxtCreditLimit.Text == "")
{
TxtCreditLimit.Text = "0";
}
_objCust.CreditLimit = Convert.ToInt32(TxtCreditLimit.Text.Trim());
_objCust.CreditDays = txtcreditdays.Text.Trim();
_objCust.BlackList = ChkBlacklist.Checked;
_objCust.IsDeleted1 = false;
_objCust.PrincipalName = TxtPrincipalName.Text.Trim();
_objCust.PrincipalMobile = TxtPrincipalMobile.Text.Trim();
_objCust.PrincipalDOB = TxtPrincipalDOB.Text.Trim();
_objCust.KeyPersonName = TxtKeyPersonName.Text.Trim();
_objCust.KeyPersonMobile = TxtKeyPersonMobile.Text.Trim();
_objCust.KeyPersonDOB = TxtKeyPersonDOB.Text.Trim();
_objCust.AdditinalDis = TxtAdditinalDis.Text.Trim();
_objCust.VIPRemark = TxtVIPRemark.Text.Trim();
//_objCust.SectionID = Convert.ToInt32(DdlSection.SelectedValue);
_objCust.SectionID = 0;
_objCust.Medium = Medium;
_objCust.Update();
DataView dv1 = new DataView(BindGvCustDetail().Table);
Session["data"] = dv1;
grdCustDetails.DataSource = dv1;
grdCustDetails.DataBind();
MessageBox("Record updated successfully");
TxtCustCode.Enabled = true;
if (btnSave.Text.ToLower() == "update")
{
PnlDetails.Visible = true;
PnlAdd.Visible = false;
btnSave.Visible = false;
filter.Visible = true;
}
else
{
PnlDetails.Visible = false;
PnlAdd.Visible = true;
btnSave.Visible = true;
}
}
TxtCustCode.Text = "";
TxtShortForm.Text = "";
TxtFamilyCode.Text = "";
TxtAddress.Text = "";
TxtZip.Text = "";
TxtPhone1.Text = "";
TxtPhone2.Text = "";
TxtEmailID.Text = "";
TxtCustName.Text = "";
TxtCreditLimit.Text = "";
TxtPrincipalName.Text = "";
TxtPrincipalMobile.Text = "";
TxtPrincipalDOB.Text = "";
TxtKeyPersonName.Text = "";
TxtKeyPersonMobile.Text = "";
TxtKeyPersonDOB.Text = "";
TxtAdditinalDis.Text = "";
TxtVIPRemark.Text = "";
TxtMedium.Text = "";
TxtCustomerType.Text = "";
DDLzone.SelectedValue = "0";
DDLareazone.SelectedValue = "0";
DDLarea.SelectedValue = "0";
ddLStates.SelectedValue = "0";
DDLsuperzone.SelectedValue = "0";
DdlCustRating.SelectedValue = "0";
}
catch (SqlException ex)
{
Response.Write(ex.Message.ToString());
}
catch (Exception ex1)
{
Response.Write(ex1.Message.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (ChkBlacklist.Checked == true)
{
lblblkremark.Visible = true;
LblblkDate.Visible = true;
TxtblkRemark.Visible = true;
TxtblkDate.Visible = true;
}
else
{
lblblkremark.Visible = false;
LblblkDate.Visible = false;
TxtblkRemark.Visible = false;
TxtblkDate.Visible = false;
}
if (Session["ChetanaCompanyName"] != "" || Session["ChetanaCompanyName"] != null)
{
if (Session["FY"] != "" || Session["FY"] != null)
{
strChetanaCompanyName = Session["ChetanaCompanyName"].ToString();
strFY = Session["FY"].ToString();
}
else
{
Session.Clear();
}
}
if (!Page.IsPostBack)
{
btnAddAccess.Enabled = false;
txtBookType.Enabled = false;
txtFromQty.Enabled = false;
txtToQty.Enabled = false;
txtDiscount.Enabled = false;
DdlSection.Enabled = false;
DdlSection.DataSource = SectionMaster.Get_SectionList();
DdlSection.DataBind();
repAlfabets.DataSource = Customer_cs.GetAlphabets();
repAlfabets.DataBind();
LblCustId.Text = "0";
fillzones();
custRating();
getDDLdata();
getDDLarezo();
getDDLarea();
GetSBUCode();
Session["saved"] = null;
Session["TempDataTable"] = null;
Session["TempAssorted"] = null;
checkAction.Checked = true;
SetView();
TxtCustCode.Focus();
if (ChkBlacklist.Checked == true)
{
lblblkremark.Visible = true;
LblblkDate.Visible = true;
TxtblkRemark.Visible = true;
TxtblkDate.Visible = true;
}
else
{
lblblkremark.Visible = false;
LblblkDate.Visible = false;
TxtblkRemark.Visible = false;
TxtblkDate.Visible = false;
}
}
}
protected void grdEmpDetails_RowEditing(object sender, GridViewEditEventArgs e)
{
try
{
pnlEmployeeDetails.Visible = false;
Panel1.Visible = true;
btnSavE.Visible = false;
filter.Visible = false;
txtempCode.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblEmpcode")).Text;
//DDLsuperzone.DataSource = SuperZone.GetSuperzonemaster();
//DDLsuperzone.DataBind();
// DDLsuperzone.Items.Insert(0, new ListItem("--Select SuperZone--", "0"));
//
DDLSDZone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(0, "SDZone");
DDLSDZone.DataBind();
DDLSDZone.Items.Insert(0, new ListItem("All", "0"));
DDLstate.DataSource = Customer_cs.Get_DestinationMaster("state");
DDLstate.DataBind();
DDLstate.Items.Insert(0, new ListItem("--Select State--", "0"));
//
pnlEmployeeDetails.Visible = false;
Panel1.Visible = true;
LblEmpID.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblEID")).Text;
txtFname.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblFName")).Text;
txtMname.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblMiddleName")).Text;
txtLname.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblLastName")).Text;
Rdogender.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblGender")).Text;
txtDob.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblDOB")).Text;
//
txtphne1.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblPhone1")).Text;
txtphne2.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblPhone2")).Text;
txtzipCode.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblZip")).Text;
txtEmail.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblEmailID")).Text;
txtAdd.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblAddress")).Text;
///
DDLSDZone.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblSDZoneId")).Text;
DDLsuperzone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLSDZone.SelectedValue.ToString()), "SuperZone1");
DDLsuperzone.DataBind();
DDLsuperzone.Items.Insert(0, new ListItem("All", "0"));
///
//
DDLsuperzone.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblSuperZoneID")).Text;
DDLzone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLsuperzone.SelectedValue.ToString()), "Zone");
DDLzone.DataBind();
DDLzone.Items.Insert(0, new ListItem("All", "0"));
DDLzone.Enabled = true;
////
DDLzone.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblZoneID")).Text;
DDLareazone.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLzone.SelectedValue.ToString()), "AreaZone");
DDLareazone.DataBind();
DDLareazone.Items.Insert(0, new ListItem("All", "0"));
DDLareazone.Enabled = true;
////
DDLareazone.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblAreaZoneID")).Text;
Chkarea.DataSource = Masters.Get_AreaZone_Zone_SuperZone(Convert.ToInt32(DDLareazone.SelectedValue.ToString()), "Area");
Chkarea.DataBind();
Chkarea.Items.Insert(0, new ListItem("All", "0"));
Chkarea.Enabled = true;
selectArea(Convert.ToInt32(LblEmpID.Text.Trim()));
//Chkarea.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblAreaID")).Text;
txtDepCode.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblDeptId")).Text;
string JoinDate = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblJoinDate")).Text;
string ResignationDate = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblResignationDate")).Text;
Chekacv.Checked = ((CheckBox)grdEmpDetails.Rows[e.NewEditIndex].FindControl("chkisActive")).Checked;
txtjoin.Text = JoinDate;
txtResign.Text = ResignationDate;
DDLstate.SelectedValue = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblState")).Text;
DDLcity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString());
DDLcity.DataBind();
DDLcity.Items.Insert(0, new ListItem("--Select City--", "0"));
DDLcity.Enabled = true;
DDLcity.Focus();
// DDLcity.DataSource = Customer_cs.Get_DestinationMaster(DDLstate.SelectedValue.ToString());
// DDLcity.DataBind();
// DDLcity.Items.Insert(0, new ListItem("--Select City--", "0"));
// DDLcity.Enabled = true;
DDLcity.SelectedItem.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblCity")).Text;
imgprof.ImageUrl = "../Images/profileimg/" + ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblphoto")).Text;
lblImage.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("lblphoto")).Text;
ddlqulification.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblQualification")).Text;
fillQualification();
DDlDesignation.Text = ((Label)grdEmpDetails.Rows[e.NewEditIndex].FindControl("LblDesignation")).Text;
fillDesignation();
}
catch
{
}
}
