public static ScanTimeApprovalCollection GetAllItemByManager(ScanTimeApprovalSqlParameters SearchKey) { ScanTimeApprovalCollection collection = new ScanTimeApprovalCollection(); var pars = new SqlParameter[] { new SqlParameter("@FromDate", SearchKey.FromDate), new SqlParameter("@ToDate", SearchKey.ToDate), new SqlParameter("@User", SearchKey.UserLoggedIn), new SqlParameter("@ShowWaiting", SearchKey.ShowWaiting), new SqlParameter("@StartRow", SearchKey.StartRow), new SqlParameter("@EndRow", SearchKey.EndRow), new SqlParameter("@OrderBy", SearchKey.OrderBy), new SqlParameter("@OrderDirection", SearchKey.OrderDirection), new SqlParameter("@FilterBy", SearchKey.FilterBy), new SqlParameter("@ShowUnNoReg", SearchKey.ShowUnNoReg) }; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "DNH_TimesheetApproval_Get", pars)) { while (reader.Read()) { ScanTimeApprovalReceiver obj = new ScanTimeApprovalReceiver(); obj = GetItemFromReader(reader); obj.TimeIn = MergeTime(obj.RootIn, obj.ManualIn, "in"); obj.TimeOut = MergeTime(obj.RootOut, obj.ManualOut, "out"); collection.Add(obj); } } return(collection); }
public static ScanTimeApprovalCollection Search(ScanTimeApprovalSqlParameters SearchKey) { ScanTimeApprovalCollection collection = new ScanTimeApprovalCollection(); var pars = new SqlParameter[] { new SqlParameter("@FromDate", SearchKey.FromDate), new SqlParameter("@ToDate", SearchKey.ToDate), new SqlParameter("@User", SearchKey.UserLoggedIn), new SqlParameter("@ShowWaiting", SearchKey.ShowWaiting), new SqlParameter("@StartRow", SearchKey.StartRow), new SqlParameter("@EndRow", SearchKey.EndRow), new SqlParameter("@OrderBy", SearchKey.OrderBy), new SqlParameter("@OrderDirection", SearchKey.OrderDirection), new SqlParameter("@FilterBy", SearchKey.FilterBy), new SqlParameter("@ShowUnNoReg", SearchKey.ShowUnNoReg) }; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "USP_TMS_ApproveTimeSheet_Get", pars)) { while (reader.Read()) { ScanTimeApprovalReceiver obj = new ScanTimeApprovalReceiver(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }