private static EmpTrans GetItemFromReader(IDataReader dataReader)
{
EmpTrans objItem = new EmpTrans();
objItem.TranCode = SqlHelper.GetString(dataReader, "TranCode");
objItem.EmpCode = SqlHelper.GetString(dataReader, "EmpCode");
objItem.Amt = SqlHelper.GetDecimal(dataReader, "Amt");
objItem.CuryAmt = SqlHelper.GetDecimal(dataReader, "CuryAmt");
objItem.Rate = SqlHelper.GetDecimal(dataReader, "Rate");
objItem.TranDesc = SqlHelper.GetString(dataReader, "TranDesc");
objItem.PaymentName = SqlHelper.GetString(dataReader, "PaymentName");
objItem.RevieveName = SqlHelper.GetString(dataReader, "RevieveName");
objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate");
objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");
objItem.IsEmp = SqlHelper.GetBoolean(dataReader, "IsEmp");
objItem.RefNbr = SqlHelper.GetString(dataReader, "RefNbr");
objItem.Paydate = SqlHelper.GetDateTime(dataReader, "Paydate");
objItem.PayFinPeriod = SqlHelper.GetInt(dataReader, "PayFinPeriod");
objItem.Posted = SqlHelper.GetBoolean(dataReader, "Posted");
return(objItem);
}
public static EmpTrans UpdateItem(EmpTrans model)
{
String result = String.Empty;
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "tblEmpTrans_Update", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (String)reader[0];
}
}
return(GetItemByID(result));
}
public static EmpTransCollection GetAllItem()
{
EmpTransCollection collection = new EmpTransCollection();
using (var reader = SqlHelper.ExecuteReader("tblEmpTrans_GetAll", null))
{
while (reader.Read())
{
EmpTrans obj = new EmpTrans();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static EmpTrans GetItemByID(String tranCode)
{
EmpTrans item = new EmpTrans();
var sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@TranCode", tranCode);
using (var reader = SqlHelper.ExecuteReader("tblEmpTrans_GetByID", sqlParams))
{
while (reader.Read())
{
item = GetItemFromReader(reader);
}
}
return(item);
}
private static SqlParameter[] CreateSqlParameter(EmpTrans model)
{
return(new SqlParameter[]
{
new SqlParameter("@TranCode", model.TranCode),
new SqlParameter("@EmpCode", model.EmpCode),
new SqlParameter("@Amt", model.Amt),
new SqlParameter("@CuryAmt", model.CuryAmt),
new SqlParameter("@Rate", model.Rate),
new SqlParameter("@TranDesc", model.TranDesc),
new SqlParameter("@PaymentName", model.PaymentName),
new SqlParameter("@RevieveName", model.RevieveName),
new SqlParameter("@CreatedDate", model.CreatedDate),
new SqlParameter("@CreatedUser", model.CreatedUser),
new SqlParameter("@IsEmp", model.IsEmp),
new SqlParameter("@RefNbr", model.RefNbr),
new SqlParameter("@Paydate", model.Paydate),
new SqlParameter("@PayFinPeriod", model.PayFinPeriod),
new SqlParameter("@Posted", model.Posted),
});
}
