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);
}
public static ScanTimeApprovalReceiver GetItemById(int id)
{
ScanTimeApprovalReceiver item = new ScanTimeApprovalReceiver();
var sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@ID", id);
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "USP_TMS_ApproveTimeSheet_GetByID", sqlParams))
{
while (reader.Read())
{
item = GetItemFromReader(reader);
}
}
return(item);
}
private static ScanTimeApprovalReceiver GetItemFromReader(IDataReader dataReader)
{
ScanTimeApprovalReceiver objItem = new ScanTimeApprovalReceiver
{
EmployeeCode = SqlHelper.GetInt(dataReader, "EmployeeCode"),
EmployeeNo = SqlHelper.GetString(dataReader, "EmployeeNo"),
EmployeeName = SqlHelper.GetString(dataReader, "EmployeeName"),
EmployeeNameVN = SqlHelper.GetString(dataReader, "EmployeeNameVN"),
WorkDate = SqlHelper.GetDateTime(dataReader, "WorkDate"),
RootIn = SqlHelper.GetString(dataReader, "RootIn"),
RootOut = SqlHelper.GetString(dataReader, "RootOut"),
ManualIn = SqlHelper.GetString(dataReader, "ManualIn"),
ManualOut = SqlHelper.GetString(dataReader, "ManualOut"),
ScanIn = SqlHelper.GetBoolean(dataReader, "ScanIn"),
ScanOut = SqlHelper.GetBoolean(dataReader, "ScanOut"),
ShiftCode = SqlHelper.GetString(dataReader, "ShiftCode"),
Leave = SqlHelper.GetString(dataReader, "Leave"),
OverTime = SqlHelper.GetString(dataReader, "OverTime"),
IsApproved = SqlHelper.GetInt(dataReader, "IsApproved"),
IsSubmited = SqlHelper.GetInt(dataReader, "IsSubmited"),
IsRejected = SqlHelper.GetBoolean(dataReader, "IsRejected"),
StatusName = SqlHelper.GetString(dataReader, "StatusName"),
RequestorNote = SqlHelper.GetString(dataReader, "RequestorNote"),
ApproverNote = SqlHelper.GetString(dataReader, "ApproverNote"),
IsHoliday = SqlHelper.GetInt(dataReader, "IsHoliday"),
IsWeekend = SqlHelper.GetBoolean(dataReader, "IsWeekend"),
OverDue = SqlHelper.GetInt(dataReader, "OverDue"),
RowNum = SqlHelper.GetInt(dataReader, "RowNum"),
TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord")
};
if (SqlHelper.ColumnExists(dataReader, "TotalRecord"))
{
objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord");
}
return(objItem);
}
