//using System; //using Payroll.BO; //using System.Data; //using System.Linq; //using Ease.CoreV35.Model; //using System.Data.SqlClient; //using Ease.CoreV35.DataAccess; //using System.Collections.Generic; //using Ease.CoreV35.DataAccess.SQL; //namespace Payroll.Service //{ // #region TaxParameterSlabDA // internal class TaxParameterSlabDA // { // #region Constructor // private TaxParameterSlabDA() { } // #endregion // #region Insert function // internal static void Insert(TransactionContext tc, TaxParameterSlab item) // { // tc.ExecuteNonQuery("INSERT INTO TaxParameterSlab(TaxParameterSlabID, taxParamID, incomeAmount, taxPercent, sequenceNo, type)" + // " VALUES(%n, %n, %n, %n, %n, %n)", item.ID.Integer, item.TaxparamID.Integer, item.IncomeAmount, item.TaxPercent, item.SequenceNo, item.ParamType); // } // #endregion // #region Update function // internal static void Update(TransactionContext tc, TaxParameterSlab item) // { // tc.ExecuteNonQuery("UPDATE TaxParameterSlab SET taxParamID=%n, incomeAmount=%n, taxPercent=%n, sequenceNo=%n, type=%n" + // " WHERE TaxParameterSlabID=%n", item.TaxparamID.Integer, item.IncomeAmount, item.TaxPercent, item.SequenceNo, item.ParamType, item.ID.Integer); // } // #endregion // #region Get Function // internal static IDataReader Get(TransactionContext tc) // { // return tc.ExecuteReader("SELECT * FROM TaxParameterSlab"); // } // internal static IDataReader Get(TransactionContext tc, ID nID) // { // return tc.ExecuteReader("SELECT * FROM TaxParameterSlab WHERE TaxParameterSlabID=%n", nID); // } // #endregion // #region Delete function // internal static void Delete(TransactionContext tc, ID nID) // { // tc.ExecuteNonQuery("DELETE FROM [TaxParameterSlab] WHERE TaxParameterSlabID=%n", nID); // } // #endregion // } // #endregion //}