public void NUnit_Domain_AddCatOvertimeType()
{
Cat_OvertimeTypeServices service = new Cat_OvertimeTypeServices();
bool result = false;
int rs = 0;
for (int i = 0; i < 10; i++)
{
var OvertimeType = new Cat_OvertimeType
{
OvertimeTypeCode = "tt" + i,
OvertimeTypeName = "Overtime Type Name Test" + i,
Rate = i,
TaxRate = i,
TimeOffInLieuRate = i
};
if (service.Add(OvertimeType) == "0")
{
result = true;
}
if (result == true)
{
rs += 1;
Console.WriteLine("Process Success >>> Create >>> " + OvertimeType.Id + " | " + OvertimeType.OvertimeTypeCode + " | " + OvertimeType.OvertimeTypeName
+ " | " + OvertimeType.Rate + " | " + OvertimeType.TaxRate + " | " + OvertimeType.TimeOffInLieuRate);
}
}
Console.WriteLine("Total success record: " + rs);
}
public void NUnit_Domain_UpdateCatOvertimeType()
{
Cat_OvertimeTypeServices service = new Cat_OvertimeTypeServices();
var OvertimeType = new Cat_OvertimeType
{
Id = 3,
OvertimeTypeCode = "Overtime Type Name tt",
OvertimeTypeName = "Overtime Type Name Test",
Rate = 1,
TaxRate = 1,
TimeOffInLieuRate = 1
};
var result = false;
if (service.Edit(OvertimeType) == "0")
{
result = true;
}
NUnit.Framework.Assert.IsTrue(result);
if (result == true)
{
Console.WriteLine("==>>> Result After Update: " + OvertimeType.Id + " | " + OvertimeType.OvertimeTypeCode + " | " + OvertimeType.OvertimeTypeName
+ " | " + OvertimeType.Rate + " | " + OvertimeType.TaxRate + " | " + OvertimeType.TimeOffInLieuRate);
}
}
public void NUnit_Domain_AddCatOvertimeType()
{
Cat_OvertimeTypeServices service = new Cat_OvertimeTypeServices();
bool result = false;
int rs = 0;
for (int i = 0; i < 10; i++)
{
var OvertimeType = new Cat_OvertimeType
{
OvertimeTypeCode = "tt" + i,
OvertimeTypeName = "Overtime Type Name Test" + i,
Rate = i,
TaxRate = i,
TimeOffInLieuRate = i
};
if (service.Add(OvertimeType) == "0")
{
result = true;
}
if (result == true)
{
rs += 1;
Console.WriteLine("Process Success >>> Create >>> " + OvertimeType.Id + " | " + OvertimeType.OvertimeTypeCode + " | " + OvertimeType.OvertimeTypeName
+ " | " + OvertimeType.Rate + " | " + OvertimeType.TaxRate + " | " + OvertimeType.TimeOffInLieuRate);
}
}
Console.WriteLine("Total success record: " + rs);
}
public void NUnit_Domain_GetCatOvertimeType()
{
string status = string.Empty;
Cat_OvertimeTypeServices service = new Cat_OvertimeTypeServices();
int count = service.GetAllUseEntity<Cat_OvertimeTypeEntity>(ref status).Count();
//NUnit.Framework.Assert.AreNotEqual(0, count);
Console.Write("Total Record: " + count);
}
public void NUnit_Domain_GetCatOvertimeType()
{
string status = string.Empty;
Cat_OvertimeTypeServices service = new Cat_OvertimeTypeServices();
int count = service.GetAllUseEntity <Cat_OvertimeTypeEntity>(ref status).Count();
//NUnit.Framework.Assert.AreNotEqual(0, count);
Console.Write("Total Record: " + count);
}
public void NUnit_Domain_GetByIdCatOvertimeType()
{
string status = string.Empty;
Cat_OvertimeTypeServices service = new Cat_OvertimeTypeServices();
var OvertimeType = new Cat_OvertimeType { Id = 2 };
var result = service.GetById<Cat_OvertimeTypeEntity>(OvertimeType.Id, ref status) as Cat_OvertimeTypeEntity;
NUnit.Framework.Assert.IsNotNull(result);
Console.Write("SearchResult: " + result.Id + " | " + result.OvertimeTypeCode + " | " + result.OvertimeTypeName + " | " +
result.Rate + " | " + result.TaxRate + " | " + result.TimeOffInLieuRate + " | " + result.IsNightShift);
}
public void NUnit_Domain_GetByIdCatOvertimeType()
{
string status = string.Empty;
Cat_OvertimeTypeServices service = new Cat_OvertimeTypeServices();
var OvertimeType = new Cat_OvertimeType {
Id = 2
};
var result = service.GetById <Cat_OvertimeTypeEntity>(OvertimeType.Id, ref status) as Cat_OvertimeTypeEntity;
NUnit.Framework.Assert.IsNotNull(result);
Console.Write("SearchResult: " + result.Id + " | " + result.OvertimeTypeCode + " | " + result.OvertimeTypeName + " | " +
result.Rate + " | " + result.TaxRate + " | " + result.TimeOffInLieuRate + " | " + result.IsNightShift);
}
public IEnumerable <Att_OvertimeModel> Post(Att_ComputeOvertimeModel model)
{
Att_WorkDayServices serviceWorkDay = new Att_WorkDayServices();
var status = string.Empty;
var lstWorkDay = serviceWorkDay.GetWorkDaysByInOut(model.DateFrom, model.DateTo);
Cat_ShiftServices serviceShift = new Cat_ShiftServices();
var lstShift = serviceShift.GetDataNotParam <Cat_ShiftEntity>(ConstantSql.hrm_cat_sp_get_Shift, UserLogin, ref status);
//Cat_ShiftItemServices serviceShiftItem = new Cat_ShiftItemServices();
//var lstShiftItem = serviceShiftItem.GetCatShiftItem();
var lstShiftItem = new List <Cat_ShiftItemEntity>();
Cat_DayOffServices servicesDayOff = new Cat_DayOffServices();
var lstDayOff = servicesDayOff.GetAllUseEntity <Cat_DayOffEntity>(ref status).ToList();
Cat_OvertimeTypeServices servicesOvertimeType = new Cat_OvertimeTypeServices();
var lstOvertimeType = servicesOvertimeType.GetDataNotParam <Cat_OvertimeTypeEntity>(ConstantSql.hrm_cat_sp_get_OvertimeType, UserLogin, ref status);
var Att_OvertimeInfoFillterAnalyze = new Att_OvertimeInfoFillterAnalyze()
{
isAllowGetAfterShift = model.isAllowGetAfterShift,
isAllowGetBeforeShift = model.isAllowGetBeforeShift,
isAllowGetInShift = model.isAllowGetInShift,
isAllowGetOTOutterShift = model.isAllowGetOTOutterShift,
isAllowGetTypeBaseOnActualDate = model.isAllowGetTypeBaseOnActualDate,
isAllowGetTypeBaseOnBeginShift = model.isAllowGetTypeBaseOnBeginShift,
isAllowGetTypeBaseOnEndShift = model.isAllowGetTypeBaseOnEndShift,
MininumOvertimeHour = model.MininumOvertimeHour
};
var service = new Att_OvertimeServices();
var result = service.AnalyzeOvertime(lstWorkDay,
lstShift,
lstShiftItem,
lstDayOff,
lstOvertimeType,
Att_OvertimeInfoFillterAnalyze, UserLogin).ToList().Translate <Att_OvertimeModel>();
return(result);
}
public void NUnit_Domain_DeleteCatOvertimeType()
{
Cat_OvertimeTypeServices service = new Cat_OvertimeTypeServices();
string result = string.Empty;
int rs = 0;
for (int i = 3; i <= 5; i++)
{
var OvertimeType = new Cat_OvertimeType {
Id = i
};
result = service.Delete <Cat_OvertimeTypeEntity>(OvertimeType.Id);
if (result != string.Empty)
{
rs += 1;
Console.WriteLine("Process Success >>> Delete >>> " + i);
}
}
Console.WriteLine("Total success record: " + rs);
//NUnit.Framework.Assert.IsTrue(result);
}
public IEnumerable<Att_OvertimeModel> Post(Att_ComputeOvertimeModel model)
{
Att_WorkDayServices serviceWorkDay = new Att_WorkDayServices();
var status = string.Empty;
var lstWorkDay = serviceWorkDay.GetWorkDaysByInOut(model.DateFrom, model.DateTo);
Cat_ShiftServices serviceShift = new Cat_ShiftServices();
var lstShift = serviceShift.GetDataNotParam<Cat_ShiftEntity>(ConstantSql.hrm_cat_sp_get_Shift, UserLogin, ref status);
//Cat_ShiftItemServices serviceShiftItem = new Cat_ShiftItemServices();
//var lstShiftItem = serviceShiftItem.GetCatShiftItem();
var lstShiftItem = new List<Cat_ShiftItemEntity>();
Cat_DayOffServices servicesDayOff = new Cat_DayOffServices();
var lstDayOff = servicesDayOff.GetAllUseEntity<Cat_DayOffEntity>(ref status).ToList();
Cat_OvertimeTypeServices servicesOvertimeType = new Cat_OvertimeTypeServices();
var lstOvertimeType = servicesOvertimeType.GetDataNotParam<Cat_OvertimeTypeEntity>(ConstantSql.hrm_cat_sp_get_OvertimeType, UserLogin, ref status);
var Att_OvertimeInfoFillterAnalyze = new Att_OvertimeInfoFillterAnalyze()
{
isAllowGetAfterShift = model.isAllowGetAfterShift,
isAllowGetBeforeShift = model.isAllowGetBeforeShift,
isAllowGetInShift = model.isAllowGetInShift,
isAllowGetOTOutterShift = model.isAllowGetOTOutterShift,
isAllowGetTypeBaseOnActualDate = model.isAllowGetTypeBaseOnActualDate,
isAllowGetTypeBaseOnBeginShift = model.isAllowGetTypeBaseOnBeginShift,
isAllowGetTypeBaseOnEndShift = model.isAllowGetTypeBaseOnEndShift,
MininumOvertimeHour = model.MininumOvertimeHour
};
var service = new Att_OvertimeServices();
var result = service.AnalyzeOvertime(lstWorkDay,
lstShift,
lstShiftItem,
lstDayOff,
lstOvertimeType,
Att_OvertimeInfoFillterAnalyze, UserLogin).ToList().Translate<Att_OvertimeModel>();
return result;
}
public void NUnit_Domain_UpdateCatOvertimeType()
{
Cat_OvertimeTypeServices service = new Cat_OvertimeTypeServices();
var OvertimeType = new Cat_OvertimeType
{
Id = 3,
OvertimeTypeCode = "Overtime Type Name tt",
OvertimeTypeName = "Overtime Type Name Test",
Rate = 1,
TaxRate = 1,
TimeOffInLieuRate = 1
};
var result = false;
if (service.Edit(OvertimeType) == "0")
{
result = true;
}
NUnit.Framework.Assert.IsTrue(result);
if (result == true)
{
Console.WriteLine("==>>> Result After Update: " + OvertimeType.Id + " | " + OvertimeType.OvertimeTypeCode + " | " + OvertimeType.OvertimeTypeName
+ " | " + OvertimeType.Rate + " | " + OvertimeType.TaxRate + " | " + OvertimeType.TimeOffInLieuRate);
}
}
DataTable CreateReportGeneralMonthlyAttendanceSchema(string UserLogin)
{
using (var context = new VnrHrmDataContext())
{
string status = string.Empty;
DataTable tb = new DataTable("Att_ReportGeneralMonthlyAttendanceEntity");
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.CodeEmp);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.ProfileName);
//tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.CodeOrg);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.DepartmentCode);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.PositionName);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.JobTitleName);
//tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.Department);
//tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.DeptCode);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.OrderExcel);
//tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.Cat_Section);
//tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.SectCode);
//tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.LaborType);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.DateHire, typeof(DateTime));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.DateQuit, typeof(DateTime));
for (int i = 1; i <= 31; i++)
{
//DataColumn column = new DataColumn(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.Data + i);
//column.Caption = i.ToString();
//tb.Columns.Add(column);
if (!tb.Columns.Contains(i.ToString()))
tb.Columns.Add(i.ToString());
}
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.StandardWorkDays, typeof(double));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.StandardWorkDaysFormula, typeof(double));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.RealWorkingDays, typeof(double));
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.LateEarlyHours);
var leavedayTypeServices = new Cat_LeaveDayTypeServices();
var lstObjLeavedayType = new List<object>();
lstObjLeavedayType.Add(null);
lstObjLeavedayType.Add(null);
lstObjLeavedayType.Add(1);
lstObjLeavedayType.Add(100000000);
var lstLeavedayType = leavedayTypeServices.GetData<Cat_LeaveDayTypeEntity>(lstObjLeavedayType, ConstantSql.hrm_cat_sp_get_LeaveDayType, UserLogin, ref status).Where(s => s.Code != null).Select(m => new { m.Code, m.CodeStatistic }).ToList();
var overtimeTypeServices = new Cat_OvertimeTypeServices();
var lstObjOvertimeType = new List<object>();
lstObjOvertimeType.Add(null);
lstObjOvertimeType.Add(null);
lstObjOvertimeType.Add(null);
lstObjOvertimeType.Add(1);
lstObjOvertimeType.Add(10000000);
foreach (var leaveDayType in lstLeavedayType)
{
string fieldName = leaveDayType.Code;
string aliasName = leaveDayType.Code;
if (!string.IsNullOrWhiteSpace(leaveDayType.CodeStatistic))
{
fieldName = leaveDayType.CodeStatistic;
aliasName = leaveDayType.CodeStatistic;
}
fieldName = fieldName.ToString().Replace('.', '_');
if (!string.IsNullOrWhiteSpace(fieldName))
{
if (!tb.Columns.Contains(fieldName))
{
DataColumn column = new DataColumn(fieldName, typeof(double));
column.Caption = aliasName.ToString();
tb.Columns.Add(column);
}
if (!tb.Columns.Contains("h" + fieldName))
{
DataColumn column = new DataColumn("h" + fieldName, typeof(double));
column.Caption = "h" + aliasName.ToString();
tb.Columns.Add(column);
}
}
}
if (!tb.Columns.Contains(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.ANL))
{
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.ANL);
}
var lstOvertimeType = overtimeTypeServices.GetData<Cat_OvertimeTypeEntity>(lstObjOvertimeType, ConstantSql.hrm_cat_sp_get_OvertimeType, UserLogin, ref status).Where(s => s.Code != null && s.OvertimeTypeName != null).Select(m => m.Code).ToList();
// lstLeavedayType.AddRange(lstOvertimeType);
foreach (var overtimeTypeCode in lstOvertimeType)
{
string typeCode = overtimeTypeCode.ToString().Replace('.', '_');
if (!string.IsNullOrWhiteSpace(typeCode))
{
if (!tb.Columns.Contains(typeCode))
{
DataColumn column = new DataColumn(typeCode, typeof(double));
column.Caption = overtimeTypeCode.ToString();
tb.Columns.Add(column);
}
}
}
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.Count);
//tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.Cat_OrgStructure);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.Comment);
// ngay lam tra luong
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.PaidWorkDayCount, typeof(double));
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.Hour);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.LateEarlyDeductionHours, typeof(double));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.LateEarlyDeductionDays, typeof(double));
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.WorkingPlace);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.AnlDayAvailable, typeof(double));
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.WorkHours);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.WorkPaidHours, typeof(double));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.LateEarlyMinutes, typeof(double));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.LateInMinutes, typeof(double));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.EarlyOutMinutes, typeof(double));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.NightShiftHours, typeof(double));
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.Cat_WorkPlace);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.TotalNightShiftHours, typeof(double));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.WorkPaidHourOver8, typeof(double));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.NightHourOver6, typeof(double));
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.UsableLeave);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.CurrentMonth);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.YearToDate);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.SickLeave);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.SickYearToDate);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.CountLateLess2H);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.CountLateMore2H);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.SumMuteLateEarly);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.CountLateEarly);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.SumCODayOT);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.CountCOLeavday);
// tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.SickCurrentMonth);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.BranchCode);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.TeamCode);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.SectionCode);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.DepartmentName);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.BranchName);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.TeamName);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.SectionName);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.DateFrom, typeof(DateTime));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.DateTo, typeof(DateTime));
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.UserExport);
tb.Columns.Add(Att_ReportGeneralMonthlyAttendanceEntity.FieldNames.DateExport, typeof(DateTime));
return tb;
}
}
/// <summary>
/// Lấy Dữ Liệu BC BẢNG CÔNG HÀNG THÁNG
/// </summary>
/// <returns></returns>
DataTable CreateReportMonthlyTimeSheetSchema(string UserLogin)
{
using (var context = new VnrHrmDataContext())
{
string status = string.Empty;
DataTable tb = new DataTable();
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.CodeEmp);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.ProfileName);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.CodeOrg);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.DepartmentCode);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.BranchCode);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.TeamCode);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.SectionCode);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.DepartmentName);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.BranchName);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.TeamName);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.SectionName);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.PositionName);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.JobTitleName);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.CodeCenter);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.StdWorkDayCount);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.RealWorkDayCount);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.PaidWorkDayCount);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.AnlDayAvailable);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.NightShiftHours);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.LateEarlyDeductionHours);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.AnlDayTaken);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.Note);
#region MyRegion
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.UnPaidLeave);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.Allowance1);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.Allowance2);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.COBeginPeriod);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.COEndPeriod);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.UsableLeave);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.CurrentMonth);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.YearToDate);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.SickLeave);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.SickYearToDate);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.CountLateLess2H);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.CountLateMore2H);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.SumMuteLateEarly);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.CountLateEarly);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.SumCODayOT);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.CountCOLeavday);
tb.Columns.Add(Att_ReportMonthlyTimeSheetEntity.FieldNames.SickCurrentMonth);
#endregion
#region MyRegion
var leavedayTypeServices = new Cat_LeaveDayTypeServices();
var lstObjLeavedayType = new List<object>();
lstObjLeavedayType.Add(null);
lstObjLeavedayType.Add(null);
lstObjLeavedayType.Add(1);
lstObjLeavedayType.Add(100000000);
var lstLeavedayType = leavedayTypeServices.GetData<Cat_LeaveDayTypeEntity>(lstObjLeavedayType, ConstantSql.hrm_cat_sp_get_LeaveDayType, UserLogin, ref status).Where(s => s.Code != null).Select(m => m.Code).ToList();
var overtimeTypeServices = new Cat_OvertimeTypeServices();
var lstObjOvertimeType = new List<object>();
lstObjOvertimeType.Add(null);
lstObjOvertimeType.Add(null);
lstObjOvertimeType.Add(null);
lstObjOvertimeType.Add(1);
lstObjOvertimeType.Add(10000000);
var lstOvertimeType = overtimeTypeServices.GetData<Cat_OvertimeTypeEntity>(lstObjOvertimeType, ConstantSql.hrm_cat_sp_get_OvertimeType, UserLogin, ref status).Where(s => s.Code != null && s.OvertimeTypeName != null).Select(m => m.OvertimeTypeName).ToList();
lstLeavedayType.AddRange(lstOvertimeType);
foreach (var item in lstLeavedayType)
{
if (!tb.Columns.Contains(item))
{
tb.Columns.Add(item);
}
}
#endregion
return tb;
}
}
public void NUnit_Domain_DeleteCatOvertimeType()
{
Cat_OvertimeTypeServices service = new Cat_OvertimeTypeServices();
string result = string.Empty;
int rs = 0;
for (int i = 3; i <= 5; i++)
{
var OvertimeType = new Cat_OvertimeType { Id = i };
result = service.Delete<Cat_OvertimeTypeEntity>(OvertimeType.Id);
if (result != string.Empty)
{
rs += 1;
Console.WriteLine("Process Success >>> Delete >>> " + i);
}
}
Console.WriteLine("Total success record: " + rs);
//NUnit.Framework.Assert.IsTrue(result);
}
