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_TaxMaster.TaxId = DeleteId; Entity_TaxMaster.UserId = Convert.ToInt32(Session["UserID"]); Entity_TaxMaster.LoginDate = DateTime.Now; int iDelete = Obj_TaxMaster.DeleteRecord(ref Entity_TaxMaster, out StrError); if (iDelete != 0) { obj_Comman.ShowPopUpMsg("Record Deleted Successfully..!", this.Page); MakeEmptyForm(); } } Entity_TaxMaster = null; Obj_TaxMaster = null; } catch (Exception ex) { throw new Exception(ex.Message); } }
public static string[] GetCompletionList(string prefixText, int count, string contextKey) { DMTaxMaster Obj_TaxMaster = new DMTaxMaster(); String[] SearchList = Obj_TaxMaster.GetSuggestedRecord(prefixText); return(SearchList); }
protected void BtnUpdate_Click(object sender, EventArgs e) { int UpdateRow = 0, InserRow = 0; try { if (ViewState["EditID"] != null) { Entity_TaxMaster.TaxId = Convert.ToInt32(ViewState["EditID"]); } Entity_TaxMaster.TaxName = TxtTaxName.Text.Trim(); //Entity_TaxMaster.TaxPer = Convert.ToDecimal(TxtTaxPer.Text.Trim()); //Entity_TaxMaster.EffectiveFrom = Convert.ToDateTime(TXTEFFECTIVEDATE.Text.Trim()); Entity_TaxMaster.UserId = Convert.ToInt32(Session["UserId"]); Entity_TaxMaster.LoginDate = DateTime.Now; //Entity_TaxMaster.TaxTypeID = Convert.ToInt32(RdoTaxType.SelectedValue.ToString()); UpdateRow = Obj_TaxMaster.UpdateRecord(ref Entity_TaxMaster, out StrError); for (int i = 0; i < GridDetails.Rows.Count; i++) { Entity_TaxMaster.TaxId = Convert.ToInt32(ViewState["EditID"]); if ((GridDetails.Rows[i].Cells[2]).Text != " ") { Entity_TaxMaster.ApplicableDate = DateTime.Parse((GridDetails.Rows[i].Cells[2]).Text); } else { Entity_TaxMaster.ApplicableDate = DateTime.Parse(DateTime.Now.ToString("dd/MMM/yyyy")); } Entity_TaxMaster.GST = Convert.ToDecimal(GridDetails.Rows[i].Cells[1].Text.ToString()); if (Convert.ToInt32(GridDetails.Rows[i].Cells[19].Text) == 0) { InserRow = Obj_TaxMaster.InsertTaxtls(ref Entity_TaxMaster, out StrError); } else { Entity_TaxMaster.TaxDtlsId = Convert.ToInt32(GridDetails.Rows[i].Cells[19].Text); InserRow = Obj_TaxMaster.UpdateTaskDetails(ref Entity_TaxMaster, out StrError); } } if (UpdateRow != 0) { obj_Comman.ShowPopUpMsg("Record Updated Successfully", this.Page); MakeEmptyForm(); Entity_TaxMaster = null; Obj_TaxMaster = 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_TaxMaster.GetTaxMasterForEdit(Convert.ToInt32(e.CommandArgument), out StrError); if (Ds.Tables.Count > 0 && Ds.Tables[0].Rows.Count > 0) { TxtTaxName.Text = Ds.Tables[0].Rows[0]["TaxName"].ToString(); //TxtTaxPer.Text = Ds.Tables[0].Rows[0]["TaxPer"].ToString(); //TXTEFFECTIVEDATE.Text =!string.IsNullOrEmpty(Ds.Tables[0].Rows[0]["EffectiveFrom"].ToString())?Ds.Tables[0].Rows[0]["EffectiveFrom"].ToString():DateTime.Now.ToString("dd-MMM-yyyy"); ////TxtTaxName.Enabled = false; //RdoTaxType.SelectedValue = !string.IsNullOrEmpty(Ds.Tables[0].Rows[0]["TaxTypeID"].ToString()) ? Convert.ToString((Ds.Tables[0].Rows[0]["TaxTypeID"].ToString())) : "1"; } else { MakeEmptyForm(); } if (Ds.Tables.Count > 0 && Ds.Tables[1].Rows.Count > 0) { GridDetails.DataSource = Ds.Tables[1]; GridDetails.DataBind(); ViewState["CurrentTable"] = Ds.Tables[1]; } else { GridDetails.DataSource = null; GridDetails.DataBind(); ViewState["CurrentTable"] = null; } Ds = null; Obj_TaxMaster = null; if (!FlagEdit) { BtnUpdate.Visible = true; } BtnSave.Visible = false; if (!FlagDel) { BtnDelete.Visible = true; } TxtTaxName.Focus(); } break; } } } catch (Exception ex) { throw new Exception(ex.Message); } }
protected void BtnSave_Click(object sender, EventArgs e) { int InsertRow = 0, InserRowDtls = 0; try { Ds = Obj_TaxMaster.ChkDuplicate(TxtTaxName.Text.Trim(), out StrError); if (Ds.Tables[0].Rows.Count > 0) { obj_Comman.ShowPopUpMsg("Please Enter Another Tax Name..", this.Page); TxtTaxName.Focus(); } else { Entity_TaxMaster.TaxName = TxtTaxName.Text.Trim(); //Entity_TaxMaster.TaxPer = Convert.ToDecimal(TxtTaxPer.Text.Trim()); //Entity_TaxMaster.EffectiveFrom = Convert.ToDateTime(TXTEFFECTIVEDATE.Text.Trim()); Entity_TaxMaster.UserId = Convert.ToInt32(Session["UserId"]); Entity_TaxMaster.LoginDate = DateTime.Now; ////Entity_TaxMaster.TaxTypeID = Convert.ToInt32(RdoTaxType.SelectedValue.ToString()); InsertRow = Obj_TaxMaster.InsertRecord(ref Entity_TaxMaster, out StrError); for (int i = 0; i < GridDetails.Rows.Count; i++) { Entity_TaxMaster.TaxId = InsertRow; if ((GridDetails.Rows[i].Cells[2]).Text != " ") { Entity_TaxMaster.ApplicableDate = DateTime.Parse((GridDetails.Rows[i].Cells[2]).Text); } else { Entity_TaxMaster.ApplicableDate = DateTime.Parse(DateTime.Now.ToString("dd/MMM/yyyy")); } Entity_TaxMaster.GST = Convert.ToDecimal(GridDetails.Rows[i].Cells[1].Text.ToString()); InserRowDtls = Obj_TaxMaster.InsertTaxtls(ref Entity_TaxMaster, out StrError); } if (InsertRow != 0) { obj_Comman.ShowPopUpMsg("Record Saved Successfully", this.Page); MakeEmptyForm(); Entity_TaxMaster = null; Obj_TaxMaster = null; } } } catch (Exception ex) { throw new Exception(ex.Message); } }
public void ReportGrid(string RepCondition) { try { Ds = Obj_TaxMaster.GetTaxMaster(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_TaxMaster = null; Ds = null; } catch (Exception ex) { throw new Exception(ex.Message); } }