private static EmpBudgetSchedule GetItemFromReader(IDataReader dataReader)
{
EmpBudgetSchedule objItem = new EmpBudgetSchedule();
objItem.Code = SqlHelper.GetString(dataReader, "Code");
objItem.Empcode = SqlHelper.GetString(dataReader, "Empcode");
objItem.IsEmp = SqlHelper.GetBoolean(dataReader, "IsEmp");
objItem.Amt = SqlHelper.GetDecimal(dataReader, "Amt");
objItem.PayDate = SqlHelper.GetDateTime(dataReader, "PayDate");
objItem.PayType = SqlHelper.GetInt(dataReader, "PayType");
objItem.EndDate = SqlHelper.GetDateTime(dataReader, "EndDate");
objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");
objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate");
objItem.CurrencyID = SqlHelper.GetString(dataReader, "CurrencyID");
objItem.frequency = SqlHelper.GetInt(dataReader, "frequency");
objItem.isExpense = SqlHelper.GetBoolean(dataReader, "isExpense");
objItem.TranDesc = SqlHelper.GetString(dataReader, "TranDesc");
objItem.Release = SqlHelper.GetBoolean(dataReader, "Release");
return(objItem);
}
public static EmpBudgetSchedule UpdateItem(EmpBudgetSchedule model)
{
String result = String.Empty;
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "tblEmpBudgetSchedule_Update", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (String)reader[0];
}
}
return(GetItemByID(result));
}
public static EmpBudgetScheduleCollection GetAllItem()
{
EmpBudgetScheduleCollection collection = new EmpBudgetScheduleCollection();
using (var reader = SqlHelper.ExecuteReader("tblEmpBudgetSchedule_GetAll", null))
{
while (reader.Read())
{
EmpBudgetSchedule obj = new EmpBudgetSchedule();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static EmpBudgetSchedule GetItemByID(String code)
{
EmpBudgetSchedule item = new EmpBudgetSchedule();
var sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@Code", code);
using (var reader = SqlHelper.ExecuteReader("tblEmpBudgetSchedule_GetByID", sqlParams))
{
while (reader.Read())
{
item = GetItemFromReader(reader);
}
}
return(item);
}
public static EmpBudgetScheduleCollection GetAllByUser(string CreatedUser, int PayType = 0)
{
EmpBudgetScheduleCollection collection = new EmpBudgetScheduleCollection();
using (var reader = SqlHelper.ExecuteReader("tblEmpBudgetSchedule_GetAllByUser", new SqlParameter("@CreatedUser", CreatedUser),
new SqlParameter("@PayType", PayType)))
{
while (reader.Read())
{
EmpBudgetSchedule obj = new EmpBudgetSchedule();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
private static SqlParameter[] CreateSqlParameter(EmpBudgetSchedule model)
{
return(new SqlParameter[]
{
new SqlParameter("@Code", model.Code),
new SqlParameter("@Empcode", model.Empcode),
new SqlParameter("@IsEmp", model.IsEmp),
new SqlParameter("@Amt", model.Amt),
new SqlParameter("@PayDate", model.PayDate),
new SqlParameter("@PayType", model.PayType),
new SqlParameter("@EndDate", model.EndDate),
new SqlParameter("@CreatedUser", model.CreatedUser),
new SqlParameter("@CreatedDate", model.CreatedDate),
new SqlParameter("@CurrencyID", model.CurrencyID),
new SqlParameter("@frequency", model.frequency),
new SqlParameter("@isExpense", model.isExpense),
new SqlParameter("@TranDesc", model.TranDesc),
new SqlParameter("@Release", model.Release),
});
}