//public static TMSMissingScanTimeCollection Search(SearchFilter SearchKey)
//{
// TMSMissingScanTimeCollection collection = new TMSMissingScanTimeCollection();
// using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "TMSMissingScanTime_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey)))
// {
// while (reader.Read())
// {
// TMSMissingScanTime obj = new TMSMissingScanTime();
// obj = GetItemFromReader(reader);
// collection.Add(obj);
// }
// }
// return collection;
//}
public static TMSMissingScanTimeCollection GetbyUser(string CreatedUser)
{
TMSMissingScanTimeCollection collection = new TMSMissingScanTimeCollection();
TMSMissingScanTime obj;
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "TMSMissingScanTime_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser)))
{
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
public static TMSMissingScanTimeCollection GetMissingData(int EmployeeCode, DateTime StartDate, DateTime EndDate, int EntityID)
{
TMSMissingScanTimeCollection collection = new TMSMissingScanTimeCollection();
var pars = new SqlParameter[]
{
new SqlParameter("@EmployeeCode", EmployeeCode),
new SqlParameter("@StartDate", StartDate),
new SqlParameter("@EndDate", EndDate),
new SqlParameter("@EntityID", EntityID),
};
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "USP_TMS_NotFillScanTime_Report", pars))
{
TMSMissingScanTime obj;
while (reader.Read())
{
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}