protected void BtnDelete_Click(object sender, EventArgs e)
{
try
{
int DeleteId = 0;
if (ViewState["EditID"] != null)
{
DeleteId = Convert.ToInt32(ViewState["EditID"]);
}
if (DeleteId != 0)
{
Entity_SupplierMaster.SuplierId = DeleteId;
Entity_SupplierMaster.UserId = Convert.ToInt32(Session["UserID"]);
Entity_SupplierMaster.LoginDate = DateTime.Now;
Entity_SupplierMaster.IsDeleted = true;
int iDelete = Obj_SupplierMaster.DeleteRecord(ref Entity_SupplierMaster, out StrError);
if (iDelete != 0)
{
obj_Comman.ShowPopUpMsg("Record Deleted Successfully..!", this.Page);
MakeEmptyForm();
}
}
Entity_SupplierMaster = null;
Obj_SupplierMaster = null;
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
public static string[] GetCompletionList(string prefixText, int count, string contextKey)
{
DMSupplierMaster Obj_SupplierMaster = new DMSupplierMaster();
String[] SearchList = Obj_SupplierMaster.GetSuggestedRecord(prefixText);
return(SearchList);
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
int UpdateRow = 0; int UpdateRowDtls = 0;
try
{
if (ViewState["EditID"] != null)
{
Entity_SupplierMaster.CustomerId = Convert.ToInt32(ViewState["EditID"]);
}
Entity_SupplierMaster.CustomerCode = TxtSuppCode.Text;
Entity_SupplierMaster.CustomerName = TxtSuppName.Text.Trim();
Entity_SupplierMaster.TelNo = TxtTelNo.Text;
Entity_SupplierMaster.MobileNo = TxtMobile.Text;
Entity_SupplierMaster.Address = TxtSuppAddress.Text;
Entity_SupplierMaster.Email = TxtEmail.Text;
Entity_SupplierMaster.Note = TxtNotes.Text;
//--------Newly Added Fields---------
Entity_SupplierMaster.WebSite = TxtWebsite.Text;
Entity_SupplierMaster.PersonName = TxtPerName.Text;
Entity_SupplierMaster.PDesignation = TxtDesignation.Text;
Entity_SupplierMaster.PMobileNo = TxtContPerMobileNo.Text;
Entity_SupplierMaster.PEmailId = TxtContPerEmail.Text;
Entity_SupplierMaster.PWebsite = TxtContPerWebsite.Text;
Entity_SupplierMaster.STaxRegNo = TxtSTRN.Text;
Entity_SupplierMaster.ImgTaxRegNoPath = lblSerTaxNopath.Text;
Entity_SupplierMaster.STaxJurisdiction = "0";
Entity_SupplierMaster.VATNo = "0";
Entity_SupplierMaster.TINNo = "0";
Entity_SupplierMaster.StateID = Convert.ToInt32(ddlState.SelectedValue);
Entity_SupplierMaster.CentralSaleTaxRagNo = "0";
Entity_SupplierMaster.ExciseRange = "0";
Entity_SupplierMaster.ExciseDivision = "0";
Entity_SupplierMaster.ExciseCircle = "0";
Entity_SupplierMaster.ExciseZone = "0";
Entity_SupplierMaster.ExciseCollectorate = "0";
Entity_SupplierMaster.ExciseECCNO = "0";
Entity_SupplierMaster.TIN_BINNo = "0";
Entity_SupplierMaster.PANNo = TxtPanNo.Text;
Entity_SupplierMaster.ImgPanNoPath = lblPanNo.Text;
Entity_SupplierMaster.TDSCertificate = TxtTDSCertificate.Text;
Entity_SupplierMaster.StateID = Convert.ToInt32(ddlState.SelectedValue);
Entity_SupplierMaster.UserId = Convert.ToInt32(Session["UserId"]);
Entity_SupplierMaster.LoginDate = DateTime.Now;
UpdateRow = Obj_SupplierMaster.UpdateRecord(ref Entity_SupplierMaster, out StrError);
if (UpdateRow > 0)
{
if (ViewState["TermsTable"] != null)
{
for (int J = 0; J < GridTermCond.Rows.Count; J++)
{
DMSupplierMaster ODMSM = new DMSupplierMaster();
SuplierMaster ENSM = new SuplierMaster();
CheckBox GrdSelectAll = (CheckBox)GridTermCond.Rows[J].FindControl("GrdSelectAll");
TextBox txtTitle1 = (TextBox)GridTermCond.Rows[J].FindControl("GrtxtTermCondition_Head");
TextBox txtDesc = (TextBox)GridTermCond.Rows[J].FindControl("GrtxtDesc");
if (GrdSelectAll.Checked == true && txtTitle1.Text != "" && txtDesc.Text != "")
{
ENSM.SuplierId = Convert.ToInt32(ViewState["EditID"]);
ENSM.TermsTitle = txtTitle1.Text;
ENSM.TermsDetls = txtDesc.Text;
UpdateRowDtls = ODMSM.Insert_SupplierTandC(ref ENSM, out StrError);
}
ODMSM = null;
ENSM = null;
}
}
obj_Comman.ShowPopUpMsg("Record Updated Successfully", this.Page);
MakeEmptyForm();
Entity_SupplierMaster = null;
Obj_SupplierMaster = null;
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
protected void GrdReport_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
switch (e.CommandName)
{
case ("Select"):
{
if (Convert.ToInt32(e.CommandArgument) != 0)
{
ViewState["EditID"] = Convert.ToInt32(e.CommandArgument);
Ds = Obj_SupplierMaster.GetSupplierForEdit(Convert.ToInt32(e.CommandArgument), out StrError);
if (Ds.Tables.Count > 0 && Ds.Tables[0].Rows.Count > 0)
{
TxtSuppCode.Text = Ds.Tables[0].Rows[0]["SuplierCode"].ToString();
TxtSuppName.Text = Ds.Tables[0].Rows[0]["SuplierName"].ToString();
TxtSuppAddress.Text = Ds.Tables[0].Rows[0]["Address"].ToString();
TxtTelNo.Text = Ds.Tables[0].Rows[0]["TelNo"].ToString();
TxtMobile.Text = Ds.Tables[0].Rows[0]["MobileNo"].ToString();
TxtEmail.Text = Ds.Tables[0].Rows[0]["Email"].ToString();
TxtNotes.Text = Ds.Tables[0].Rows[0]["Note"].ToString();
//-------Newly Added Fields-------
TxtWebsite.Text = Ds.Tables[0].Rows[0]["WebSite"].ToString();
TxtPerName.Text = Ds.Tables[0].Rows[0]["PersonName"].ToString();
TxtDesignation.Text = Ds.Tables[0].Rows[0]["PDesignation"].ToString();
TxtContPerMobileNo.Text = Ds.Tables[0].Rows[0]["PMobileNo"].ToString();
TxtContPerEmail.Text = Ds.Tables[0].Rows[0]["PEmailId"].ToString();
TxtContPerWebsite.Text = Ds.Tables[0].Rows[0]["PWebsite"].ToString();
TxtSTRN.Text = Ds.Tables[0].Rows[0]["STaxRegNo"].ToString();
lblSerTaxNopath.Text = Ds.Tables[0].Rows[0]["ImgTaxRegNoPath"].ToString();
ImgTaxRegNoPath.ImageUrl = lblSerTaxNopath.Text;
if (!string.IsNullOrEmpty(Ds.Tables[0].Rows[0]["StateID"].ToString()))
{
ddlState.SelectedValue = Ds.Tables[0].Rows[0]["StateID"].ToString();
}
else
{
ddlState.SelectedValue = "0";
}
//TxtSTJ.Text = Ds.Tables[0].Rows[0]["STaxJurisdiction"].ToString();
//TxtVatNo.Text = Ds.Tables[0].Rows[0]["VATNo"].ToString();
//TxtTINNO.Text = Ds.Tables[0].Rows[0]["TINNo"].ToString();
//TxtCSTRN.Text = Ds.Tables[0].Rows[0]["CentralSaleTaxRagNo"].ToString();
//TxtExciseRange.Text = Ds.Tables[0].Rows[0]["ExciseRange"].ToString();
//TxtExciseDivision.Text = Ds.Tables[0].Rows[0]["ExciseDivision"].ToString();
//TxtExciseCircle.Text = Ds.Tables[0].Rows[0]["ExciseCircle"].ToString();
//TxtExciseZone.Text = Ds.Tables[0].Rows[0]["ExciseZone"].ToString();
//TxtExciseCollectorate.Text = Ds.Tables[0].Rows[0]["ExciseCollectorate"].ToString();
//TxtExciseECCNO.Text = Ds.Tables[0].Rows[0]["ExciseECCNO"].ToString();
//TxtTINBINNO.Text = Ds.Tables[0].Rows[0]["TIN_BINNo"].ToString();
TxtPanNo.Text = Ds.Tables[0].Rows[0]["PANNo"].ToString();
lblPanNo.Text = Ds.Tables[0].Rows[0]["ImgPanNoPath"].ToString();
ImgPanNoPath.ImageUrl = lblPanNo.Text;
TxtTDSCertificate.Text = Ds.Tables[0].Rows[0]["TDSCertificate"].ToString();
if (Ds.Tables[1].Rows.Count > 0)
{
GridTermCond.DataSource = Ds.Tables[1];
GridTermCond.DataBind();
ViewState["TermsTable"] = Ds.Tables[1];
}
else
{
GridTermCond.DataSource = null;
GridTermCond.DataBind();
SetInitialRow();
}
}
else
{
MakeEmptyForm();
}
Ds = null;
Obj_SupplierMaster = null;
if (!FlagEdit)
{
BtnUpdate.Visible = true;
}
BtnSave.Visible = false;
if (!FladDel)
{
BtnDelete.Visible = true;
}
TxtSuppCode.Focus();
}
break;
}
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
