public static DataTable Service_Tax_ByFeesHead_Report(Entity.Accounts.Tax tax) { using (DataManager oDm = new DataManager()) { oDm.Add("@FeesHeadId", SqlDbType.Int, tax.FeesHeadId); oDm.Add("@FromDate", SqlDbType.DateTime, tax.FromDate); oDm.Add("@ToDate", SqlDbType.DateTime, tax.ToDate); oDm.Add("@CompanyId", SqlDbType.Int, tax.CompanyId); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_Service_Tax_ByFeesHead_Report")); } }
public static int Save(Entity.Accounts.Tax tax) { using (DataManager oDm = new DataManager()) { oDm.Add("@TaxId", SqlDbType.Int, tax.TaxId); oDm.Add("@TaxHead", SqlDbType.VarChar, 50, tax.TaxHead); oDm.Add("@TaxPercent", SqlDbType.Decimal, tax.TaxPercent); oDm.Add("@MessageCode", SqlDbType.Int, ParameterDirection.InputOutput, 0); oDm.CommandType = CommandType.StoredProcedure; oDm.ExecuteNonQuery("Tax_Save"); return((int)oDm["@MessageCode"].Value); } }
protected void PopulateTax() { BusinessLayer.Accounts.Tax objTax = new BusinessLayer.Accounts.Tax(); tax = objTax.GetTaxById(TaxId); if (tax != null) { TaxId = tax.TaxId; txtTaxHead.Text = tax.TaxHead.ToString(); txtTaxPercent.Text = tax.TaxPercent.ToString(); Message.Show = false; btnSave.Text = "Update"; } }
protected void btnSearch_Click(object sender, EventArgs e) { BusinessLayer.Accounts.Tax objTax = new BusinessLayer.Accounts.Tax(); Entity.Accounts.Tax tax = new Entity.Accounts.Tax(); tax.FeesHeadId = int.Parse(ddlFeesHead.SelectedValue); tax.FromDate = DateTime.Parse(txtFromDate.Text); tax.ToDate = DateTime.Parse(txtToDate.Text); tax.CompanyId = int.Parse(Session["CompanyId"].ToString()); DataTable dt = new DataTable(); dt = objTax.Service_Tax_ByFeesHead_Report(tax); gvServiceTax.DataSource = dt; gvServiceTax.DataBind(); }
protected void btnSearch2_Click(object sender, EventArgs e) { BusinessLayer.Accounts.Tax objTax = new BusinessLayer.Accounts.Tax(); Entity.Accounts.Tax tax = new Entity.Accounts.Tax(); tax.LedgerId = int.Parse(ddlLedger.SelectedValue); tax.ParentLedgerId = int.Parse(ddlCashBankLedger.SelectedValue); tax.FromDate = DateTime.Parse(txtFromDate2.Text); tax.ToDate = DateTime.Parse(txtToDate2.Text); tax.BranchId = int.Parse(Session["BranchID"].ToString()); tax.CompanyId = int.Parse(Session["CompanyId"].ToString()); DataTable dt = new DataTable(); dt = objTax.Service_Tax_ByLedgerId_Report(tax); gvServiceTax2.DataSource = dt; gvServiceTax2.DataBind(); }
public static DataTable Service_Tax_ByLedgerId_Report(Entity.Accounts.Tax tax) { using (DataManager oDm = new DataManager()) { oDm.Add("@LedgerId", SqlDbType.Int, tax.LedgerId); if (tax.ParentLedgerId == 0) { oDm.Add("@ParentLedgerID", SqlDbType.Int, DBNull.Value); } else { oDm.Add("@ParentLedgerID", SqlDbType.Int, tax.ParentLedgerId); } oDm.Add("@FromDate", SqlDbType.DateTime, tax.FromDate); oDm.Add("@ToDate", SqlDbType.DateTime, tax.ToDate); oDm.Add("@BranchId", SqlDbType.Int, tax.BranchId); oDm.Add("@CompanyId", SqlDbType.Int, tax.CompanyId); oDm.CommandType = CommandType.StoredProcedure; return(oDm.ExecuteDataTable("usp_Service_Tax_ByLedgerId_Report")); } }
public static Entity.Accounts.Tax GetTaxById(int taxid) { using (DataManager oDm = new DataManager()) { oDm.CommandType = CommandType.StoredProcedure; oDm.Add("@TaxId", SqlDbType.Int, ParameterDirection.Input, taxid); SqlDataReader dr = oDm.ExecuteReader("Tax_GetById"); Entity.Accounts.Tax tax = new Entity.Accounts.Tax(); if (dr.HasRows) { while (dr.Read()) { tax.TaxId = taxid; tax.TaxHead = (dr["TaxHead"] == DBNull.Value) ? "" : dr["TaxHead"].ToString(); tax.TaxPercent = (dr["TaxPercent"] == DBNull.Value) ? 0 : decimal.Parse(dr["TaxPercent"].ToString()); } } return(tax); } }
public DataTable Service_Tax_ByLedgerId_Report(Entity.Accounts.Tax tax) { return(DataAccess.Accounts.Tax.Service_Tax_ByLedgerId_Report(tax)); }
public int Save(Entity.Accounts.Tax tax) { return(DataAccess.Accounts.Tax.Save(tax)); }