public static UserTranCollection GetbyUserDate(UserTranFilter model)
{
UserTranCollection collection = new UserTranCollection();
UserTran obj;
try
{
using (var reader = SqlHelper.ExecuteReader("tblUserTran_GetAll_byUserByDate", new SqlParameter[]
{
new SqlParameter("@CreatedUser", model.CreatedUser),
new SqlParameter("@DateFrom", model.FromDate),
new SqlParameter("@DateTo", model.ToDate)
}))
{
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
}
catch (Exception objEx)
{
}
return(collection);
}
public static UserTranCollection GetbyUser(string CreatedUser)
{
UserTranCollection collection = new UserTranCollection();
UserTran obj;
using (var reader = SqlHelper.ExecuteReader("tblUserTran_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser)))
{
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static UserTranCollection GetAllItem()
{
UserTranCollection collection = new UserTranCollection();
using (var reader = SqlHelper.ExecuteReader("tblUserTran_GetAll", null))
{
while (reader.Read())
{
UserTran obj = new UserTran();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
