//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 SalaryMonthlyDetailDA // internal class SalaryMonthlyDetailDA // { // #region Constructor // private SalaryMonthlyDetailDA() { } // #endregion // #region Insert function // internal static void Insert(TransactionContext tc, SalaryMonthlyDetail item) // { // tc.ExecuteNonQuery("INSERT INTO SalaryMonthlyDetail(SalaryMonthlyDetailID, SalaryMonthlyID, ItemID, SupportID, Description, Position, CalculatedAmount, ChangedAmount, ItemCode)" + // " VALUES(%n, %n, %n, %n, %s, %n, %n, %n, %n)", item.ID.Integer, item.SalaryMonthlyID, item.ItemID, item.SupportID, item.Description, item.Position, item.CalculatedAmount, item.ChangedAmount, item.ItemCode); // } // #endregion // #region Update function // internal static void Update(TransactionContext tc, SalaryMonthlyDetail item) // { // tc.ExecuteNonQuery("UPDATE SalaryMonthlyDetail SET SalaryMonthlyID=%n, ItemID=%n, SupportID=%n, Description=%s, Position=%n, CalculatedAmount=%n, ChangedAmount=%n, ItemCode=%n" + // " WHERE SalaryMonthlyDetailID=%n", item.SalaryMonthlyID, item.ItemID, item.SupportID, item.Description, item.Position, item.CalculatedAmount, item.ChangedAmount, item.ItemCode, item.ID.Integer); // } // #endregion // #region Get Function // internal static IDataReader Get(TransactionContext tc) // { // return tc.ExecuteReader("SELECT * FROM SalaryMonthlyDetail"); // } // internal static IDataReader Get(TransactionContext tc, ID nID) // { // return tc.ExecuteReader("SELECT * FROM SalaryMonthlyDetail WHERE SalaryMonthlyDetailID=%n", nID); // } // #endregion // #region Delete function // internal static void Delete(TransactionContext tc, ID nID) // { // tc.ExecuteNonQuery("DELETE FROM SalaryMonthlyDetail WHERE SalaryMonthlyDetailID=%n", nID); // } // #endregion // } // #endregion //}