protected void BtnDelete_Click(object sender, EventArgs e)
{
int DeleteId = 0;
try
{
if (ViewState["EditID"] != null)
{
DeleteId = Convert.ToInt32(ViewState["EditID"]);
}
if (DeleteId != 0)
{
Entity_CM.CompanyId = DeleteId;
Entity_CM.UserId = Convert.ToInt32(Session["UserID"]);
Entity_CM.LoginDate = DateTime.Now;
int iDelete = Obj_CM.DeleteRecord(ref Entity_CM, out StrError);
if (iDelete != 0)
{
obj_Comm.ShowPopUpMsg("Record Deleted Successfully..!", this.Page);
MakeEmptyForm();
}
}
Entity_CM = null;
Obj_CM = null;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static string[] GetCompletionList(string prefixText, int count, string contextKey)
{
DMCompanyMaster Obj_CM = new DMCompanyMaster();
String[] SearchList = Obj_CM.GetSuggestRecord(prefixText);
return(SearchList);
}
protected void GrdReport_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
try
{
switch (e.CommandName)
{
case ("Select"):
{
if (Convert.ToInt32(e.CommandArgument) != 0)
{
ViewState["EditID"] = Convert.ToInt32(e.CommandArgument);
DS = Obj_CM.GetCompanyForEdit(Convert.ToInt32(e.CommandArgument), out StrError);
if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
TxtCompanyName.Text = DS.Tables[0].Rows[0]["CompanyName"].ToString();
Txtabbreviations.Text = DS.Tables[0].Rows[0]["abbreviation"].ToString();
TxtAddress.Text = DS.Tables[0].Rows[0]["CAddress"].ToString();
TxtPhoneNo.Text = DS.Tables[0].Rows[0]["PhoneNo"].ToString();
TxtEmail.Text = DS.Tables[0].Rows[0]["EmailId"].ToString();
TxtWebsite.Text = DS.Tables[0].Rows[0]["Website"].ToString();
TxtFaxNo.Text = DS.Tables[0].Rows[0]["FaxNo"].ToString();
TxtTinNo.Text = DS.Tables[0].Rows[0]["TinNo"].ToString();
TxtVatNo.Text = DS.Tables[0].Rows[0]["VatNo"].ToString();
TxtServiceTaxNo.Text = DS.Tables[0].Rows[0]["ServiceTaxNo"].ToString();
TxtNoteC.Text = DS.Tables[0].Rows[0]["Note"].ToString();
}
else
{
MakeEmptyForm();
}
DS = null;
Obj_CM = null;
if (!FlagEdit)
{
BtnUpdate.Visible = true;
}
BtnSave.Visible = false;
if (!FlagDel)
{
BtnDelete.Visible = true;
}
TxtCompanyName.Focus();
}
break;
}
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
int InsertRow = 0, InsertRowDtls = 0;
try
{
if (ChkDetails() == true)
{
DS = Obj_CM.ChkDuplicate(TxtCompanyName.Text.Trim(), out StrError);
if (DS.Tables[0].Rows.Count > 0)
{
obj_Comm.ShowPopUpMsg("Record is Already Present..", this.Page);
TxtCompanyName.Focus();
}
else
{
Entity_CM.CompanyName = TxtCompanyName.Text;
Entity_CM.abbreviation = Txtabbreviations.Text;
Entity_CM.CAddress = TxtAddress.Text;
Entity_CM.PhoneNo = TxtPhoneNo.Text.Trim();
Entity_CM.EmailId = TxtEmail.Text.Trim();
Entity_CM.Website = TxtWebsite.Text.Trim();
Entity_CM.FaxNo = TxtFaxNo.Text.Trim();
Entity_CM.TinNo = TxtTinNo.Text.Trim();
Entity_CM.VatNo = TxtVatNo.Text.Trim();
Entity_CM.ServiceTaxNo = TxtServiceTaxNo.Text.Trim();
Entity_CM.Note = TxtNoteC.Text.Trim();
Entity_CM.UserId = Convert.ToInt32(Session["UserId"]);
Entity_CM.LoginDate = DateTime.Now;
InsertRow = Obj_CM.InsertRecord(ref Entity_CM, out StrError);
if (InsertRow > 0)
{
obj_Comm.ShowPopUpMsg("Record Saved Successfully", this.Page);
MakeEmptyForm();
Entity_CM = null;
Obj_CM = null;
}
}
}
else
{
obj_Comm.ShowPopUpMsg("Please Enter Details ..!", this.Page);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
int UpdateRow = 0, InsertRowDtls = 0;
try
{
if (ChkDetails() == true)
{
if (ViewState["EditID"] != null)
{
Entity_CM.CompanyId = Convert.ToInt32(ViewState["EditID"]);
}
Entity_CM.CompanyName = TxtCompanyName.Text;
Entity_CM.abbreviation = Txtabbreviations.Text;
Entity_CM.CAddress = TxtAddress.Text;
Entity_CM.PhoneNo = TxtPhoneNo.Text.Trim();
Entity_CM.EmailId = TxtEmail.Text.Trim();
Entity_CM.Website = TxtWebsite.Text.Trim();
Entity_CM.FaxNo = TxtFaxNo.Text.Trim();
Entity_CM.TinNo = TxtTinNo.Text.Trim();
Entity_CM.VatNo = TxtVatNo.Text.Trim();
Entity_CM.ServiceTaxNo = TxtServiceTaxNo.Text.Trim();
Entity_CM.Note = TxtNoteC.Text.Trim();
Entity_CM.UserId = Convert.ToInt32(Session["UserId"]);
Entity_CM.LoginDate = DateTime.Now;
UpdateRow = Obj_CM.UpdateRecord(ref Entity_CM, out StrError);
if (UpdateRow > 0)
{
obj_Comm.ShowPopUpMsg("Record Updated Successfully", this.Page);
MakeEmptyForm();
Entity_CM = null;
Obj_CM = null;
}
}
else
{
obj_Comm.ShowPopUpMsg("Please Enter Details ..!", this.Page);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void ReportGrid(string RepCondition)
{
try
{
DS = Obj_CM.GetCompanyDtls(RepCondition, out StrError);
if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
GrdReport.DataSource = DS.Tables[0];
GrdReport.DataBind();
}
else
{
GrdReport.DataSource = null;
GrdReport.DataBind();
}
Obj_CM = null;
DS = null;
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
protected void GrdReport_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
try
{
switch (e.CommandName)
{
case ("Select"):
{
if (Convert.ToInt32(e.CommandArgument) != 0)
{
ViewState["EditID"] = Convert.ToInt32(e.CommandArgument);
DS = Obj_CM.GetCompanyForEdit(Convert.ToInt32(e.CommandArgument), out StrError);
if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
{
TxtCompanyName.Text = DS.Tables[0].Rows[0]["CompanyName"].ToString();
Txtabbreviations.Text = DS.Tables[0].Rows[0]["abbreviation"].ToString();
TxtAddress.Text = DS.Tables[0].Rows[0]["CAddress"].ToString();
lblLogopath.Text = DS.Tables[0].Rows[0]["CLogo"].ToString();
ImgCompanyLogo.ImageUrl = lblLogopath.Text;
TxtPhoneNo.Text = DS.Tables[0].Rows[0]["PhoneNo"].ToString();
TxtEmail.Text = DS.Tables[0].Rows[0]["EmailId"].ToString();
TxtWebsite.Text = DS.Tables[0].Rows[0]["Website"].ToString();
TxtFaxNo.Text = DS.Tables[0].Rows[0]["FaxNo"].ToString();
TxtTinNo.Text = DS.Tables[0].Rows[0]["TinNo"].ToString();
TxtVatNo.Text = DS.Tables[0].Rows[0]["VatNo"].ToString();
TxtServiceTaxNo.Text = DS.Tables[0].Rows[0]["ServiceTaxNo"].ToString();
LblSignPath.Text = DS.Tables[0].Rows[0]["DigitalSignature"].ToString();
LblSignPath1.Text = DS.Tables[0].Rows[0]["DigitalSignature1"].ToString();
LblSignPath2.Text = DS.Tables[0].Rows[0]["DigitalSignature2"].ToString();
ImgSign.ImageUrl = LblSignPath.Text;
ImgSign1.ImageUrl = LblSignPath1.Text;
ImgSign2.ImageUrl = LblSignPath2.Text;
TxtNoteC.Text = DS.Tables[0].Rows[0]["Note"].ToString();
}
else
{
MakeEmptyForm();
}
if (DS.Tables[1].Rows.Count > 0)
{
GridDetails.DataSource = DS.Tables[1];
GridDetails.DataBind();
ViewState["CurrentTable"] = DS.Tables[1];
}
else
{
SetInitialRow();
}
DS = null;
Obj_CM = null;
if (!FlagEdit)
{
BtnUpdate.Visible = true;
}
BtnSave.Visible = false;
if (!FlagDel)
{
BtnDelete.Visible = true;
}
TxtCompanyName.Focus();
MakeControlEmpty();
}
break;
}
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
int UpdateRow = 0, InsertRowDtls = 0;
try
{
if (ChkDetails() == true)
{
if (ViewState["EditID"] != null)
{
Entity_CM.CompanyId = Convert.ToInt32(ViewState["EditID"]);
}
Entity_CM.CompanyName = TxtCompanyName.Text;
Entity_CM.abbreviation = Txtabbreviations.Text;
Entity_CM.CAddress = TxtAddress.Text;
if (!string.IsNullOrEmpty(lblLogopath.Text))
{
Entity_CM.CLogo = lblLogopath.Text;
}
else
{
Entity_CM.CLogo = "";
}
Entity_CM.PhoneNo = TxtPhoneNo.Text.Trim();
Entity_CM.EmailId = TxtEmail.Text.Trim();
Entity_CM.Website = TxtWebsite.Text.Trim();
Entity_CM.FaxNo = TxtFaxNo.Text.Trim();
Entity_CM.TinNo = TxtTinNo.Text.Trim();
Entity_CM.VatNo = TxtVatNo.Text.Trim();
Entity_CM.ServiceTaxNo = TxtServiceTaxNo.Text.Trim();
if (!string.IsNullOrEmpty(LblSignPath.Text))
{
Entity_CM.DigitalSignature = LblSignPath.Text;
}
else
{
Entity_CM.DigitalSignature = "";
}
if (!string.IsNullOrEmpty(LblSignPath1.Text))
{
Entity_CM.DigitalSignature1 = LblSignPath1.Text;
}
else
{
Entity_CM.DigitalSignature1 = "";
}
if (!string.IsNullOrEmpty(LblSignPath2.Text))
{
Entity_CM.DigitalSignature2 = LblSignPath2.Text;
}
else
{
Entity_CM.DigitalSignature2 = "";
}
Entity_CM.Note = TxtNoteC.Text.Trim();
Entity_CM.UserId = Convert.ToInt32(Session["UserId"]);
Entity_CM.LoginDate = DateTime.Now;
UpdateRow = Obj_CM.UpdateRecord(ref Entity_CM, out StrError);
if (UpdateRow > 0)
{
if (ViewState["CurrentTable"] != null)
{
DataTable dtInsert = new DataTable();
dtInsert = (DataTable)ViewState["CurrentTable"];
for (int i = 0; i < dtInsert.Rows.Count; i++)
{
Entity_CM.BankId = Convert.ToInt32(dtInsert.Rows[i]["BankId"].ToString());
Entity_CM.AccountNo = dtInsert.Rows[i]["AccountNo"].ToString();
Entity_CM.NoteB = dtInsert.Rows[i]["NoteB"].ToString();
InsertRowDtls = Obj_CM.InsertDetailsRecord(ref Entity_CM, out StrError);
}
}
if (UpdateRow > 0)
{
obj_Comm.ShowPopUpMsg("Record Updated Successfully", this.Page);
MakeControlEmpty();
MakeEmptyForm();
Entity_CM = null;
Obj_CM = null;
}
}
}
else
{
obj_Comm.ShowPopUpMsg("Please Enter Details ..!", this.Page);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
