68 lines
3.0 KiB
C#
68 lines
3.0 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using Ease.CoreV35.DataAccess;
|
|
using Ease.CoreV35.Model;
|
|
using Payroll.BO;
|
|
|
|
namespace Payroll.Service
|
|
{
|
|
[Serializable]
|
|
internal static class BudgetNewJoinerDA
|
|
{
|
|
public static IDataReader Get(TransactionContext tc, ID nID)
|
|
{
|
|
return tc.ExecuteReader("Select * from BudgetNewJoiner where BudgetNewJoinerID=%n", nID.Integer);
|
|
|
|
}
|
|
|
|
public static IDataReader Get(TransactionContext tc)
|
|
{
|
|
return tc.ExecuteReader("Select * from BudgetNewJoiner");
|
|
}
|
|
public static IDataReader Get(TransactionContext tc,int nID)
|
|
{
|
|
return tc.ExecuteReader("Select * from BudgetNewJoiner where BudgetID=%n", nID);
|
|
}
|
|
|
|
|
|
public static void Insert(TransactionContext tc, BudgetNewJoiner item)
|
|
{
|
|
tc.ExecuteNonQuery("Insert into BudgetNewJoiner(BudgetNewJoinerID,BasicSalary,BudgetID,DepartmentID,GradeID,IncrementPercentage,LocationID,NextIncrementalMonth,NoofEmployee,FromDate,CategoryID,GrossSalary) Values" +
|
|
"(%n,%n,%n,%n,%n,%n,%n,%n,%n,%d,%n,%n)", item.ID.Integer,item.BasicSalary,item.BudgetID.Integer,item.DepartmentID.Integer,item.GradeID.Integer,item.IncrementPercentage,item.LocationID.Integer,item.NextIncrementalMonth,item.NoofEmployee,item.FromDate,item.CategoryID.Integer,item.GrossSalary);
|
|
|
|
}
|
|
|
|
public static void Update(TransactionContext tc, BudgetNewJoiner item)
|
|
{
|
|
tc.ExecuteNonQuery("Update BudgetNewJoiner SET BasicSalary=%n,BudgetID=%n,DepartmentID=%n,GradeID=%n,IncrementPercentage=%n,LocationID=%n,NextIncrementalMonth=%n,NoofEmployee=%n,FromDate=%d,CategoryID=%n,GrossSalary=%n" +
|
|
"Where BudgetNewJoinerID=%n", item.BasicSalary, item.BudgetID.Integer, item.DepartmentID.Integer, item.GradeID.Integer, item.IncrementPercentage, item.LocationID.Integer, item.NextIncrementalMonth, item.NoofEmployee, item.FromDate, item.CategoryID, item.GrossSalary, item.ID.Integer);
|
|
|
|
}
|
|
|
|
public static void Delete(TransactionContext tc, ID nID)
|
|
{
|
|
tc.ExecuteNonQuery("Delete from BudgetNewJoiner where BudgetNewJoinerID=%n", nID.Integer);
|
|
|
|
}
|
|
|
|
public static IDataReader GetBudgetNewJoinerCrGs(TransactionContext tc, ID baseID)
|
|
{
|
|
return tc.ExecuteReader("Select * from BudgetNewJoinerCrG Where BudgetNewJoinerID=%n",baseID.Integer);
|
|
}
|
|
|
|
public static void Delete(TransactionContext tc, string tableName, string columnName, ID id)
|
|
{
|
|
tc.ExecuteNonQuery("Delete from %s where %s=%n", tableName, columnName, id.Integer);
|
|
}
|
|
|
|
public static void Insert(TransactionContext tc, BudgetNewJoinerCrG item)
|
|
{
|
|
tc.ExecuteNonQuery("Insert into BudgetNewJoinerCrG(BudgetNewJoinerCrGID,BudgetNewJoinerID,CCID,Percentage) Values" +
|
|
"(%n,%n,%n,%n)", item.ID.Integer, item.BudgetNewJoinerID.Integer, item.CCID.Integer,item.Percentage );
|
|
}
|
|
}
|
|
}
|