public ActionResult GetReportSummaryDependantList([DataSourceRequest] DataSourceRequest request, Hre_ReportSummaryDependantModel model)
{
string status = string.Empty;
var service = new BaseService();
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "MonthOfExpiry", Value = model.MonthOfExpiry };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1 };
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var ReportServices = new Hre_ReportServices();
var actionService = new ActionService(UserLogin);
List<object> paraDependant = new List<object>();
paraDependant.AddRange(new object[11]);
paraDependant[0] = model.ProfileName;
paraDependant[1] = model.CodeEmp;
paraDependant[2] = model.OrgStructureID;
paraDependant[3] = model.JobTitleID;
paraDependant[4] = model.PositionID;
paraDependant[5] = model.DependantName;
paraDependant[6] = model.RelationID;
paraDependant[7] = null;
paraDependant[8] = null;
paraDependant[9] = 1;
paraDependant[10] = int.MaxValue - 1;
var lstDependant = actionService.GetData<Hre_DependantEntity>(paraDependant, ConstantSql.hrm_hr_sp_get_Dependant, ref status);
if (model.MonthOfExpiry != null && lstDependant != null)
{
lstDependant = lstDependant.Where(s => (s.MonthOfEffect <= model.MonthOfExpiry && model.MonthOfExpiry <= s.MonthOfExpiry)
|| (s.MonthOfEffect <= model.MonthOfExpiry && s.MonthOfExpiry == null)).ToList();
}
var result = ReportServices.GetReportSummaryDependant(lstDependant, model.IsCreateTemplate);
var isDataTable = false;
object obj = new DataTable();
if (model.IsCreateTemplateForDynamicGrid)
{
var col = result.Columns.Count;
result.Columns.RemoveAt(col - 1);
obj = result;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportSummaryDependantEntity",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportSummaryDependantModel>(model, "Hre_ReportSummaryDependant", ref message);
if (!checkValidate)
{
return Json(message, JsonRequestBehavior.AllowGet);
}
#endregion
if (model.ExportId != Guid.Empty)
{
string fullPath = "";
if (model.MonthOfExpiry != null)
{
fullPath = ExportService.Export(model.ExportId, result, listHeaderInfo, model.ExportType);
}
else
{
fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType);
}
return Json(fullPath);
}
#region mapping dataTable to dataList
List<Hre_ReportSummaryDependantModel> dataList = new List<Hre_ReportSummaryDependantModel>();
Hre_ReportSummaryDependantModel aTSource = null;
if (result.Rows.Count > 0)
{
const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic;
var objFieldNames = (from PropertyInfo aProp in typeof(Hre_ReportSummaryDependantModel).GetProperties(flags)
select new
{
Name = aProp.Name,
Type = Nullable.GetUnderlyingType(aProp.PropertyType) ?? aProp.PropertyType
}).ToList();
var dataTblFieldNames = (from DataColumn aHeader in result.Columns
select new { Name = aHeader.ColumnName, Type = aHeader.DataType }).ToList();
var commonFields = objFieldNames.Intersect(dataTblFieldNames).ToList();
foreach (DataRow dataRow in result.AsEnumerable().ToList())
{
aTSource = new Hre_ReportSummaryDependantModel();
foreach (var aField in commonFields)
{
PropertyInfo propertyInfos = aTSource.GetType().GetProperty(aField.Name);
if (dataRow[aField.Name] == DBNull.Value)
continue;
propertyInfos.SetValue(aTSource, dataRow[aField.Name], null);
}
dataList.Add(aTSource);
}
}
#endregion
return Json(dataList.ToDataSourceResult(request));
}
public ActionResult GetExpiryContract([DataSourceRequest] DataSourceRequest request, Hre_ReportExpiryContractModel Model)
{
string status = string.Empty;
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
var profileServices = new Hre_ProfileServices();
var contractServices = new Hre_ContractServices();
BaseService baseServices = new BaseService();
bool isshowloopcontract = profileServices.IsNotUseExpiryContractLoop();
var ShowAfterDate1 = actionServices.GetData<Sys_AllSettingEntity>("HRM_HRE_CONTRACT_ALERT_EXPRIDAY_VALUEAFTE", ConstantSql.hrm_sys_sp_get_AllSettingByKey, ref status).FirstOrDefault();
var ShowBeforDate1 = actionServices.GetData<Sys_AllSettingEntity>("HRM_HRE_CONTRACT_ALERT_EXPRIDAY_VALUEBEFOR", ConstantSql.hrm_sys_sp_get_AllSettingByKey, ref status).FirstOrDefault();
DateTime? dateTo = null;
DateTime? dateFrom = null;
if (isshowloopcontract == false)
{
dateTo = DateTime.Now.AddDays(Convert.ToDouble(ShowAfterDate1.Value1));
dateFrom = DateTime.Now.AddDays(-Convert.ToDouble(ShowBeforDate1.Value1));
}
var isDataTable = false;
object obj = new Hre_ReportExpiryContractModel();
//var lstProfile = new List<Hre_ProfileEntity>();
var objProfile = new List<object>();
objProfile.AddRange(new object[2]);
objProfile[0] = 1;
objProfile[1] = int.MaxValue - 1;
var lstProfile = actionServices.GetData<Hre_ProfileEntity>(objProfile, ConstantSql.hrm_hr_sp_get_ProfileDataAll, ref status).ToList();
var lstObjContractType = new List<object>();
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(1);
lstObjContractType.Add(int.MaxValue - 1);
var lstContractType = actionServices.GetData<CatContractTypeModel>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status).ToList();
List<object> listObj = new List<object>();
listObj.Add(Model.OrgStructureID);
listObj.Add(Model.Status);
listObj.Add(dateFrom);
listObj.Add(dateTo);
listObj.Add(Model.CodeEmp);
listObj.Add(Model.ProfileName);
listObj.Add(Model.IDNo);
listObj.Add(Model.WorkPlaceID);
listObj.Add(Model.DateSignedFrom);
listObj.Add(Model.DateSignedTo);
listObj.Add(Model.ContractNo);
listObj.Add(1);
listObj.Add(int.MaxValue - 1);
var result = actionServices.GetData<Hre_ReportExpiryContractEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptExpireContract, ref status).Where(s => s.StatusEvaluation != WorkdayStatus.E_APPROVED.ToString()).ToList().Translate<Hre_ReportExpiryContractModel>();
var objContract = new List<object>();
objContract.AddRange(new object[21]);
objContract[19] = 1;
objContract[20] = int.MaxValue - 1;
var lstContracts = actionServices.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_Contract, ref status).ToList();
Guid[] _RankDetailForNextContract = null;
if (!string.IsNullOrEmpty(Model.RankDetailForNextContractIds))
{
_RankDetailForNextContract = Model.RankDetailForNextContractIds.Split(',').Select(s => Guid.Parse(s)).ToArray();
}
if (Model.ContractTypeID != null)
{
result = result.Where(s => s.ContractTypeID == Model.ContractTypeID).ToList();
}
if (!string.IsNullOrEmpty(Model.Status))
{
result = result.Where(s => s.Status == Model.Status).ToList();
}
var lstModel = new List<Hre_ReportExpiryContractModel>();
if (_RankDetailForNextContract != null)
{
result = result.Where(s => _RankDetailForNextContract.Contains(s.RankDetailForNextContract != null ? s.RankDetailForNextContract.Value : Guid.Empty)).ToList();
}
if (Model.EvaType == EnumDropDown.EvaExpiryContract.E_EVA_CONTRACT.ToString())
{
result = result.Where(s => s.StatusEvaluation != WorkdayStatus.E_APPROVED.ToString() && s.ContractResult != null).ToList();
if (isshowloopcontract == false)
{
var model = new Hre_ReportExpiryContractModel();
foreach (var item in result)
{
var ContractByProfileID = lstContracts.Where(s => s.ProfileID == item.ProfileID).OrderByDescending(s => s.DateCreate).FirstOrDefault();
if (ContractByProfileID != null)
{
if (ContractByProfileID.DateCreate != null && ContractByProfileID.DateCreate.Value.ToShortDateString() != DateTime.Now.ToShortDateString())
{
if (item.DateExtend != null && item.DateExtend >= dateFrom && item.DateExtend <= dateTo)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd >= dateFrom && item.DateEnd <= dateTo)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
else
{
foreach (var item in result)
{
var dateSenior = new TimeSpan();
double monthSenior = 0;
var profileEntity = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault();
if (profileEntity != null && profileEntity.DateHire != null && Model.DateEnd != null)
{
dateSenior = Model.DateEnd.Value.Subtract(profileEntity.DateHire.Value);
monthSenior = Math.Floor(dateSenior.TotalDays / 30);
}
item.MonthSenior = (double?)monthSenior;
var dateCheck = DateTime.Now;
var model = new Hre_ReportExpiryContractModel();
var contractTypeEntity = lstContractType.Where(s => item.ContractTypeID == s.ID).FirstOrDefault();
if (item.ContractResult == null)
{
if (contractTypeEntity != null && contractTypeEntity.ExpiryContractLoop != null)
{
var dateExpiry = dateCheck.AddDays(contractTypeEntity.ExpiryContractLoop.Value);
if (item.DateExtend != null && item.DateExtend <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd.Value <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
}
else if (Model.EvaType == EnumDropDown.EvaExpiryContract.E_NONEEVA_CONTRACT.ToString())
{
result = result.Where(s => s.ContractResult == null).ToList();
if (isshowloopcontract == false)
{
var model = new Hre_ReportExpiryContractModel();
foreach (var item in result)
{
var ContractByProfileID = lstContracts.Where(s => s.ProfileID == item.ProfileID).OrderByDescending(s => s.DateCreate).FirstOrDefault();
if (ContractByProfileID != null)
{
if (ContractByProfileID.DateCreate != null && ContractByProfileID.DateCreate.Value.ToShortDateString() != DateTime.Now.ToShortDateString())
{
if (item.DateExtend != null && item.DateExtend >= dateFrom && item.DateExtend <= dateTo)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd >= dateFrom && item.DateEnd <= dateTo)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
else
{
foreach (var item in result)
{
var dateSenior = new TimeSpan();
double monthSenior = 0;
var profileEntity = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault();
if (profileEntity != null && profileEntity.DateHire != null && Model.DateEnd != null)
{
dateSenior = Model.DateEnd.Value.Subtract(profileEntity.DateHire.Value);
monthSenior = Math.Floor(dateSenior.TotalDays / 30);
}
item.MonthSenior = (double?)monthSenior;
var dateCheck = DateTime.Now;
var model = new Hre_ReportExpiryContractModel();
var contractTypeEntity = lstContractType.Where(s => item.ContractTypeID == s.ID).FirstOrDefault();
if (item.ContractResult == null)
{
if (contractTypeEntity != null && contractTypeEntity.ExpiryContractLoop != null)
{
var dateExpiry = dateCheck.AddDays(contractTypeEntity.ExpiryContractLoop.Value);
if (item.DateExtend != null && item.DateExtend <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd.Value <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
}
else
{
if (isshowloopcontract == false)
{
var model = new Hre_ReportExpiryContractModel();
foreach (var item in result)
{
var ContractByProfileID = lstContracts.Where(s => s.ProfileID == item.ProfileID).OrderByDescending(s => s.DateCreate).FirstOrDefault();
if (ContractByProfileID != null)
{
if (ContractByProfileID.DateCreate != null && ContractByProfileID.DateCreate.Value.ToShortDateString() != DateTime.Now.ToShortDateString())
{
if (item.DateExtend != null && item.DateExtend >= dateFrom && item.DateExtend <= dateTo)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd >= dateFrom && item.DateEnd <= dateTo)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
else
{
foreach (var item in result)
{
var dateSenior = new TimeSpan();
double monthSenior = 0;
var profileEntity = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault();
if (profileEntity != null && profileEntity.DateHire != null && Model.DateEnd != null)
{
dateSenior = Model.DateEnd.Value.Subtract(profileEntity.DateHire.Value);
monthSenior = Math.Floor(dateSenior.TotalDays / 30);
}
item.MonthSenior = (double?)monthSenior;
var dateCheck = DateTime.Now;
var model = new Hre_ReportExpiryContractModel();
var contractTypeEntity = lstContractType.Where(s => item.ContractTypeID == s.ID).FirstOrDefault();
if (contractTypeEntity != null && contractTypeEntity.ExpiryContractLoop != null)
{
var dateExpiry = dateCheck.AddDays(contractTypeEntity.ExpiryContractLoop.Value);
if (item.DateExtend != null && item.DateExtend <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd.Value <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
#region Lấy phụ lục hợp đông
var _ReportService = new Hre_ContractServices();
var lisEntity = result.Translate<Hre_ContractEntity>();
DataTable tb = _ReportService.GetDataContract(lisEntity, UserLogin);
#endregion
#region Xuất template
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = tb,
FileName = "Hre_ContractEntity",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = true
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#endregion
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, tb, Model.ExportType);
return Json(fullPath);
}
return Json(lstModel.ToDataSourceResult(request));
}
public ActionResult GetProfileQuitList([DataSourceRequest] DataSourceRequest request, Hre_ProfileQuitSearchModel model)
{
var profileServices = new Hre_ProfileServices();
var service = new ActionService(UserLogin);
bool isGroup = profileServices.IsGroupByOrgProfileQuit();
if (isGroup == true)
{
#region Group theo DS phòng ban - DDF
var rptServices = new Hre_ReportServices();
string status = string.Empty;
var orgServices = new Cat_OrgStructureServices();
var lstObjOrg = new List<object>();
lstObjOrg.Add(null);
lstObjOrg.Add(null);
lstObjOrg.Add(null);
lstObjOrg.Add(1);
lstObjOrg.Add(int.MaxValue - 1);
var lstOrg = service.GetData<Cat_OrgStructureEntity>(lstObjOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, ref status).ToList();
var orgTypeService = new Cat_OrgStructureTypeServices();
var lstObjOrgType = new List<object>();
lstObjOrgType.Add(null);
lstObjOrgType.Add(null);
lstObjOrgType.Add(1);
lstObjOrgType.Add(int.MaxValue - 1);
var lstOrgType = service.GetData<Cat_OrgStructureTypeEntity>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, ref status).ToList();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var lstEntity = service.GetData<Hre_ProfileEntity>(lstModel, ConstantSql.hrm_hr_sp_get_ProfileQuit, ref status);
var lstProfileEntity = new List<Hre_ProfileEntity>();
var lstProfileModel = new List<Hre_ProfileModel>();
if (lstEntity != null)
{
request.Page = 1;
foreach (var item in lstEntity)
{
var profileEntity = new Hre_ProfileEntity();
var orgName = new List<string>();
if (item.OrgStructureID != null)
{
orgName = rptServices.GetParentOrgName(lstOrg, lstOrgType, item.OrgStructureID);
}
// orgName = rptServices.GetParentOrgName(lstOrg, lstOrgType, item.OrgStructureID);
if (orgName.Count == 0)
continue;
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
}
}
profileEntity = item.CopyData<Hre_ProfileEntity>();
profileEntity.Channel = orgName[2];
profileEntity.Region = orgName[1];
profileEntity.Area = orgName[0];
lstProfileEntity.Add(profileEntity);
}
lstProfileModel = lstProfileEntity.Translate<Hre_ProfileModel>();
var dataSourceResult = lstProfileModel.ToDataSourceResult(request);
if (lstProfileModel.FirstOrDefault().GetPropertyValue("TotalRow") != null)
{
dataSourceResult.Total = lstProfileModel.Count() <= 0 ? 0 : (int)lstProfileModel.FirstOrDefault().GetPropertyValue("TotalRow");
}
return Json(dataSourceResult, JsonRequestBehavior.AllowGet);
}
#endregion
}
return GetListDataAndReturn<Hre_ProfileModel, Hre_ProfileEntity, Hre_ProfileQuitSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_ProfileQuit);
}
public ActionResult GetReportMonthlyHC([DataSourceRequest] DataSourceRequest request, Hre_ReportMonthlyHCModel model)
{
var service = new Hre_ReportServices();
var hrService = new Hre_ProfileServices();
object obj = new Hre_ReportMonthlyHCModel();
var isDataTable = false;
//List<object> listObj = new List<object>();
//listObj.Add(model.OrgStructureID);
//listObj.Add(string.Empty);
//listObj.Add(string.Empty);
//string status = string.Empty;
//var listEntity = hrService.GetData<Hre_ProfileIdEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure, ref status).Select(s => s.ID).ToList();
var result = service.GetReportMonthlyHC(model.dateSearch, model.JobtitleID, model.OrgStructureID, model.OrgStructureTypeID, model.IsCreateTemplate, UserLogin);
var rs = result.Translate<Hre_ReportMonthlyHCModel>();
if (model.IsCreateTemplateForDynamicGrid)
{
obj = result;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportMonthlyHCModel",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportID, result, null, model.ExportType);
return Json(fullPath);
}
//0string dataReturn = result.ConvertDataTabletoString();
return Json(rs.ToDataSourceResult(request));
}
public ActionResult GetReportEducationCharList([DataSourceRequest] DataSourceRequest request, Hre_ReportEducationChartListModel Model)
{
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom != null ? Model.DateFrom : DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo != null ? Model.DateTo : DateTime.Now };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportEducationChartListModel(),
FileName = "Hre_ReportEducationChartList",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportEducationChartListModel>(Model, "Hre_ReportProfileNew", ref message);
if (!checkValidate)
{
return Json(message);
}
DateTime From = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
DateTime To = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(-1);
#endregion
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
List<object> strOrgIDs = new List<object>();
strOrgIDs.AddRange(new object[3]);
strOrgIDs[0] = (object)Model.OrgStructureID;
string status = string.Empty;
List<Guid> lstProfileIDs = actionServices.GetData<Hre_ProfileIdEntity>(strOrgIDs, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).Select(s => s.ID).ToList();
var result = service.GetReportEducationCharList(From, To, lstProfileIDs, Model.AppliedForThisPeriod).ToList().Translate<Hre_ReportEducationChartListModel>();
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportProfileNotContract([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileNotContractModel Model)
{
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
List<object> listObj = new List<object>();
listObj.Add(Model.OrgStructureID);
listObj.Add(Model.DateHireFrom);
listObj.Add(Model.DateHireTo);
listObj.Add(Model.PositionID);
listObj.Add(Model.JobTitleID);
listObj.Add(Model.Gender);
listObj.Add(Model.EmpTypeID);
listObj.Add(1);
listObj.Add(int.MaxValue - 1);
string status = string.Empty;
var result = actionServices.GetData<Hre_ReportProfileNotContractEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptNotContract, ref status).ToList().Translate<Hre_ReportProfileNotContractModel>();
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportSeniority([DataSourceRequest] DataSourceRequest request, Hre_ReportSeniorityModel Model)
{
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateSeniority != null ? Model.DateSeniority.Value : DateTime.Now };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1 };
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportSeniorityModel(),
FileName = "Hre_ReportSeniority",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportSeniorityModel>(Model, "Hre_ReportSeniority", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
DateTime DateSeniority = DateTime.Now;
List<Guid?> OrgIds = new List<Guid?>();
if (Model.DateSeniority != null)
{
DateSeniority = Model.DateSeniority.Value;
}
string strOrgIDs = null;
if (!string.IsNullOrEmpty(Model.OrgStructureID))
{
strOrgIDs = Model.OrgStructureID;
}
List<object> listObj = new List<object>();
listObj.Add(strOrgIDs);
listObj.Add(string.Empty);
listObj.Add(string.Empty);
string status = string.Empty;
var listEntity = actionServices.GetData<Hre_ProfileEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure, ref status).ToList();
if (listEntity.Count == 0)
{
return Json(null);
}
var result = service.GetReportSeniority(DateSeniority, listEntity).ToList().Translate<Hre_ReportSeniorityModel>();
if (Model.ExportID != Guid.Empty)
{
string[] valueField = null;
if (Model.ValueFields != null)
{
valueField = Model.ValueFields.Split(',');
}
var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult ExportProfileListByTemplate([DataSourceRequest] DataSourceRequest request, Hre_ProfileActiveSearchModel model)
{
//if(model.ExportId == Guid.Empty)
//{
// return null;
//}
var actionService = new ActionService(UserLogin);
string status = string.Empty;
var profileServices = new Hre_ProfileServices();
bool isGroup = profileServices.IsGroupByOrgProfileQuit();
var isDataTable = false;
object obj = new Hre_ProfileModel();
var result = GetListData<Hre_ProfileModel, Hre_ProfileEntity, Hre_ProfileActiveSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_ProfileActive, ref status);
if (isGroup == true)
{
var rptServices = new Hre_ReportServices();
var orgServices = new Cat_OrgStructureServices();
var lstObjOrg = new List<object>();
lstObjOrg.Add(null);
lstObjOrg.Add(null);
lstObjOrg.Add(null);
lstObjOrg.Add(1);
lstObjOrg.Add(int.MaxValue - 1);
var lstOrg = actionService.GetData<Cat_OrgStructureEntity>(lstObjOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, ref status).ToList();
var orgTypeService = new Cat_OrgStructureTypeServices();
var lstObjOrgType = new List<object>();
lstObjOrgType.Add(null);
lstObjOrgType.Add(null);
lstObjOrgType.Add(1);
lstObjOrgType.Add(int.MaxValue - 1);
var lstOrgType = actionService.GetData<Cat_OrgStructureTypeEntity>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, ref status).ToList();
result = GetListData<Hre_ProfileModel, Hre_ProfileEntity, Hre_ProfileActiveSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_ProfileActive, ref status);
DataTable table = new DataTable("Hre_ProfileModel");
table.Columns.Add("CodeEmp");
table.Columns.Add("ProfileName");
table.Columns.Add("FirstName");
table.Columns.Add("NameFamily");
table.Columns.Add("Channel");
table.Columns.Add("Region");
table.Columns.Add("Area");
table.Columns.Add("IDNo");
table.Columns.Add("IDDateOfIssue", typeof(DateTime));
table.Columns.Add("IDPlaceOfIssue");
table.Columns.Add("DateOfBirth", typeof(DateTime));
table.Columns.Add("PlaceOfBirth");
table.Columns.Add("Gender");
table.Columns.Add("MarriageStatus");
table.Columns.Add("NationalityName");
table.Columns.Add("ReligionName");
table.Columns.Add("EthnicGroupName");
table.Columns.Add("Email");
table.Columns.Add("CellPhone");
table.Columns.Add("CodeTax");
table.Columns.Add("TDistrictName");
table.Columns.Add("PDistrictName");
table.Columns.Add("JobTitleName");
table.Columns.Add("DateHire", typeof(DateTime));
table.Columns.Add("ContractNo");
table.Columns.Add("DateStartContract");
table.Columns.Add("DateEndContract");
table.Columns.Add("ContractTypeName");
table.Columns.Add("TimesOfContract");
table.Columns.Add("Notes");
table.Columns.Add("TAddress");
table.Columns.Add("PAddress");
table.Columns.Add("BasicSalary", typeof(double));
var salaryServices = new Sal_BasicSalaryServices();
var objSalary = new List<object>();
objSalary.AddRange(new object[10]);
objSalary[8] = 1;
objSalary[9] = int.MaxValue - 1;
var lstBasicSalary = actionService.GetData<Sal_BasicSalaryEntity>(objSalary, ConstantSql.hrm_sal_sp_get_BasicPayroll, ref status).ToList();
var unuServices = new Sal_UnusualAllowanceServices();
var objUnu = new List<object>();
objUnu.AddRange(new object[9]);
objUnu[7] = 1;
objUnu[8] = int.MaxValue - 1;
var lstUnu = actionService.GetData<Sal_UnusualAllowanceEntity>(objUnu, ConstantSql.hrm_sal_sp_get_UnusualED, ref status).ToList();
foreach (var item in result)
{
var basicSalaryEntity = lstBasicSalary.Where(s => s.ProfileID == item.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var lstUnuByProfileID = lstUnu.Where(s => s.ProfileID == item.ID).ToList();
var orgName = new List<string>();
if (item.OrgStructureID != null)
{
orgName = rptServices.GetParentOrgName(lstOrg, lstOrgType, item.OrgStructureID);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
}
}
}
var lstObjPayroll = new List<object>();
lstObjPayroll.Add(item.ID);
lstObjPayroll.Add(null);
lstObjPayroll.Add(null);
lstObjPayroll.Add(null);
lstObjPayroll.Add(1);
lstObjPayroll.Add(int.MaxValue - 1);
var payrollTableByProfileID = actionService.GetData<Sal_PayrollTableItemEntity>(lstObjPayroll, ConstantSql.hrm_sal_sp_get_PayrollTableItemByProfile, ref status).OrderByDescending(s => s.DateCreate);
var lstObjContract = new List<object>();
lstObjContract.Add(item.ID);
var lstContract = actionService.GetData<Hre_ContractEntity>(lstObjContract, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, ref status).OrderBy(s => s.DateCreate).ToList();
var lstObjRelative = new List<object>();
lstObjRelative.Add(item.ID);
lstObjRelative.Add(1);
lstObjRelative.Add(Int32.MaxValue - 1);
var lstDependant = actionService.GetData<Hre_DependantEntity>(lstObjRelative, ConstantSql.hrm_hr_sp_get_DependantByProfileId, ref status).ToList();
DataRow dr = table.NewRow();
dr["CodeEmp"] = item.CodeEmp;
dr["ProfileName"] = item.ProfileName;
dr["FirstName"] = item.FirstName;
dr["NameFamily"] = item.NameFamily;
if (orgName.Count > 0)
{
dr["Channel"] = orgName[2];
dr["Region"] = orgName[1];
dr["Area"] = orgName[0];
}
dr["IDNo"] = item.IDNo;
if (item.IDDateOfIssue != null)
{
dr["IDDateOfIssue"] = item.IDDateOfIssue.Value;
}
dr["IDPlaceOfIssue"] = item.IDPlaceOfIssue;
if (item.DateOfBirth != null)
{
dr["DateOfBirth"] = item.DateOfBirth;
}
dr["Gender"] = item.Gender;
if (item.Gender == EnumDropDown.Gender.E_FEMALE.ToString())
{
dr["Gender"] = "Nữ";
}
if (item.Gender == EnumDropDown.Gender.E_MALE.ToString())
{
dr["Gender"] = "Nam";
}
dr["MarriageStatus"] = item.MarriageStatus;
dr["NationalityName"] = item.NationalityName;
dr["ReligionName"] = item.ReligionName;
dr["EthnicGroupName"] = item.EthnicGroupName;
dr["Email"] = item.Email;
dr["CellPhone"] = item.Cellphone;
dr["CodeTax"] = item.CodeTax;
dr["TDistrictName"] = item.TDistrictName;
dr["PDistrictName"] = item.PDistrictName;
dr["JobTitleName"] = item.JobTitleName;
dr["Notes"] = item.Notes;
dr["TAddress"] = item.TAddress;
dr["PAddress"] = item.PAddress;
if (basicSalaryEntity != null)
{
dr["BasicSalary"] = double.Parse(basicSalaryEntity.GrossAmount);
}
if (item.DateHire != null)
{
dr["DateHire"] = item.DateHire.Value;
}
//if (payrollTableByProfileID != null)
//{
// foreach (var payroll in payrollTableByProfileID)
// {
// Double value = 0;
// if (!table.Columns.Contains(payroll.Code))
// {
// table.Columns.Add(payroll.Code, typeof(Double));
// }
// if (table.Columns.Contains(payroll.Code))
// {
// if (payroll.ValueType == typeof(Double).Name)
// {
// Double.TryParse(payroll.Value, out value);
// }
// dr[payroll.Code] = value;
// }
// }
//}
if (lstContract != null && lstContract.Count > 0)
{
var contractEntity = lstContract.FirstOrDefault();
dr["TimesOfContract"] = lstContract.Count;
dr["ContractNo"] = contractEntity.ContractNo;
dr["ContractTypeName"] = contractEntity.ContractTypeName;
dr["DateStartContract"] = contractEntity.DateStart;
if (contractEntity.DateEnd != null)
{
dr["DateStartContract"] = contractEntity.DateEnd.Value;
}
}
if (lstUnuByProfileID.Count > 0 && lstUnuByProfileID != null)
{
foreach (var unu in lstUnuByProfileID)
{
var titleName = unu.UnusualEDTypeCode + "|" + unu.UnusualAllowanceCfgName;
if (!table.Columns.Contains(titleName))
{
table.Columns.Add(titleName);
}
if (table.Columns.Contains(titleName))
{
dr[titleName] = unu.Amount;
}
}
}
if (lstDependant.Count > 0 && lstDependant != null)
{
foreach (var dependant in lstDependant)
{
var titleName = dependant.DependantName + "|" + dependant.RelativeTypeName;
if (!table.Columns.Contains(titleName))
{
table.Columns.Add(titleName);
}
if (table.Columns.Contains(titleName))
{
dr[titleName] = dependant.DependantName;
}
}
}
table.Rows.Add(dr);
}
if (model.IsCreateTemplateForDynamicGrid)
{
obj = result;
isDataTable = false;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = table,
FileName = "Hre_ProfileModel",
OutPutPath = path,
// HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = true
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportId != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportId, table, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
if (model.IsCreateTemplateForDynamicGrid)
{
obj = result;
isDataTable = false;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ProfileModel",
OutPutPath = path,
// HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportId != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetEvaluationContractWaitingList([DataSourceRequest] DataSourceRequest request, Hre_EvaluationContractWaitingApprovedSearchModel model)
{
int _page = request.Page;
var service = new Hre_ReportServices();
var ActionService = new ActionService(UserLogin);
var contractServices = new Hre_ContractServices();
string status = string.Empty;
request.Page = 1;
request.PageSize = int.MaxValue - 1;
var result = GetListData<Hre_ContractModel, Hre_ContractEntity, Hre_EvaluationContractWaitingApprovedSearchModel>(request, model,
ConstantSql.hrm_hr_sp_get_EvaluationContractWaitingApprove, ref status);
if (result != null)
{
result = result.Where(s => s.StatusEvaluation != "E_APPROVED" && s.ContractResult != null).ToList();
}
var lstObjContractType = new List<object>();
lstObjContractType.AddRange(new object[6]);
lstObjContractType[4] = 1;
lstObjContractType[5] = int.MaxValue - 1;
var lstContractType = ActionService.GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status);
if (model.IsMissingInformation == true)
{
result = result.Where(s => s.DateEndNextContract == null).ToList();
}
var lstContractEntity = result.Translate<Hre_ContractEntity>();
DataTable tableData = contractServices.GetDataContract(lstContractEntity, UserLogin);
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = model.DateStart == null ? DateTime.Now : model.DateStart };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = model.DateEnd == null ? DateTime.Now : model.DateEnd };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
var isDataTable = false;
DataTable obj = null;
if (model.IsCreateTemplateForDynamicGrid)
{
obj = tableData;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ContractEntity",
OutPutPath = path,
HeaderInfo=listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = true
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportID, tableData, listHeaderInfo, model.ExportType);
return Json(fullPath);
}
var listModel = new List<Hre_ContractModel>();
if (result != null)
{
request.Page = _page;
foreach (var item in result)
{
var newModle = (Hre_ContractModel)typeof(Hre_ContractModel).CreateInstance();
foreach (var property in item.GetType().GetProperties())
{
newModle.SetPropertyValue(property.Name, item.GetPropertyValue(property.Name));
}
listModel.Add(newModle);
}
var dataSourceResult = listModel.ToDataSourceResult(request);
if (listModel.FirstOrDefault().GetPropertyValue("TotalRow") != null)
{
dataSourceResult.Total = result.Count;
}
return Json(dataSourceResult, JsonRequestBehavior.AllowGet);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportDependantProfileQuit([DataSourceRequest] DataSourceRequest request, Hre_ReportDependantProfileQuitModel Model)
{
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportDependantProfileQuitModel(),
FileName = "Hre_ReportDependantProfileQuit",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportDependantProfileQuitModel>(Model, "Hre_ReportPayHDTJob", ref message);
if (!checkValidate)
{
return Json(message, JsonRequestBehavior.AllowGet);
}
#endregion
var ReportServices = new Hre_ReportServices();
var result = ReportServices.GetReportDependantProfileQuit(Model.DateQuitFrom, Model.DateQuitTo, Model.WorkPlaceID, Model.OrgStructureID, UserLogin).Translate<Hre_ReportDependantProfileQuitModel>();
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, null, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportHDTJobDecisionAssignWork([DataSourceRequest] DataSourceRequest request, Hre_ReportHDTJobDecisionAssignWorkSearchModel Model)
{
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_HDTJobModel(),
FileName = "Hre_HDTJob",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportHDTJobDecisionAssignWorkSearchModel>(Model, "Hre_ReportHDTJobDecisionAssignWork", ref message);
if (!checkValidate)
{
return Json(message, JsonRequestBehavior.AllowGet);
}
#endregion
var ReportServices = new Hre_ReportServices();
var result = ReportServices.GetReportHDTJobDecisionAssignWork(Model.DateFrom, Model.OrgStructureID, Model.PositionID, Model.JobTitleID, Model.ProfileName, Model.CodeEmp, UserLogin).Translate<Hre_HDTJobModel>();
if (Model.ExportId != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportId, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportSummaryDependantDeduction([DataSourceRequest] DataSourceRequest request, Hre_ReportSummaryDependantDeductionModel model)
{
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "MonthFrom", Value = model.MonthFrom ?? DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "MonthTo", Value = model.MonthTo ?? DateTime.Now };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportSummaryDependantDeductionModel(),
FileName = "Hre_ReportSummaryDependantDeductionModel",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportSummaryDependantDeductionModel>(model, "Hre_ReportSummaryDependantDeduction", ref message);
if (!checkValidate)
{
return Json(message, JsonRequestBehavior.AllowGet);
}
#endregion
string status = string.Empty;
var actionService = new ActionService(UserLogin);
List<object> paraDependant = new List<object>();
paraDependant.AddRange(new object[11]);
paraDependant[9] = 1;
paraDependant[10] = int.MaxValue;
var lstDependant = actionService.GetData<Hre_DependantEntity>(paraDependant, ConstantSql.hrm_hr_sp_get_Dependant, ref status);
var ReportServices = new Hre_ReportServices();
if (model.MonthFrom != null && model.MonthTo != null && lstDependant != null)
{
lstDependant = lstDependant.Where(s =>
((model.MonthFrom <= s.MonthOfExpiry && s.MonthOfExpiry <= model.MonthTo) || (s.MonthOfExpiry == null))
&& (s.MonthOfEffect <= model.MonthTo)).ToList();
}
var result = ReportServices.GetReportSummaryDependantDeduction(lstDependant, model.IsCreateTemplate);
if (model.ExportId != Guid.Empty)
{
if (model.MonthFrom != null && model.MonthTo != null)
{
var fullPath = ExportService.Export(model.ExportId, result, listHeaderInfo, model.ExportType);
return Json(fullPath);
}
else
{
var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType);
return Json(fullPath);
}
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportUnusualHDT([DataSourceRequest] DataSourceRequest request, Hre_ReportUnusualHDTModel model)
{
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportUnusualHDTModel>(model, "Hre_ReportUnusualHDT", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var service = new Hre_ReportServices();
var hrService = new Hre_ProfileServices();
object obj = new Hre_ReportUnusualHDTModel();
var isDataTable = false;
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = DateTime.Now };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
var result = service.GetReportUnusualHDT(
model.DateFrom,
model.DateTo,
model.OrgStructureIDs,
model.IsCreateTemplate, UserLogin);
if (model.IsCreateTemplateForDynamicGrid)
{
var col = result.Columns.Count;
result.Columns.RemoveAt(col - 1);
obj = result;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportUnusualHDTModel",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportID != Guid.Empty)
{
result.Rows[0].Delete();
var col = result.Columns.Count;
result.Columns.RemoveAt(col - 1);
string[] valueField = null;
if (model.ValueFields != null)
{
valueField = model.ValueFields.Split(',');
}
var fullPath = ExportService.Export(model.ExportID, result, listHeaderInfo, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportSumarySeniorHDTProfile([DataSourceRequest] DataSourceRequest request, Hre_ReportSumarySeniorHDTProfileModel Model)
{
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportSumarySeniorHDTProfileModel>(Model, "Hre_ReportSumaryHDTProfile", ref message);
if (!checkValidate)
{
var ls = new object[] { "error", message };
return Json(ls);
}
#endregion
var ReportServices = new Hre_ReportServices();
var result = ReportServices.GetReportSumarySeniorHDTProfile(Model.DateFrom, Model.DateTo, Model.ProfileName, Model.CodeEmp, Model.OrgStructureID, UserLogin).Translate<Hre_ReportSumarySeniorHDTProfileModel>();
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateStart", Value = Model.DateFrom ?? DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateEnd", Value = Model.DateTo ?? DateTime.Now };
HeaderInfo headerInfo3 = new HeaderInfo() { Name = "E_DEPARTMENT", Value = (Model.OrgStructureID != null && result != null) ? result.FirstOrDefault().E_DEPARTMENT : "" };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2, headerInfo3 };
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportSumarySeniorHDTProfileModel(),
FileName = "Hre_ReportSumarySeniorHDTProfile",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (Model.ExportId != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportId, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportReward([DataSourceRequest] DataSourceRequest request, Hre_ReportRewardModel Model)
{
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportRewardModel>(Model, "Hre_ReportReward", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
var isDataTable = false;
object obj = new Hre_ReportRewardModel();
List<object> listObj = new List<object>();
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
List<Guid?> OrgIds = new List<Guid?>();
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
listObj.Add(From);
}
else
{
listObj.Add(null);
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
listObj.Add(To);
}
else
{
listObj.Add(null);
}
string strOrgIDs = null;
if (!string.IsNullOrEmpty(Model.OrgStructureID))
{
strOrgIDs = Model.OrgStructureID;
}
listObj.Add(strOrgIDs);
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = From };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = To };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
string status = string.Empty;
var result = actionServices.GetData<Hre_ReportRewardEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptReward, ref status).ToList().Translate<Hre_ReportRewardModel>();
if (Model.IsCreateTemplateForDynamicGrid)
{
obj = result;
isDataTable = true;
}
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportReward",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportProfileWorking([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileWorkingModel Model)
{
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportProfileWorkingModel>(Model, "Hre_ReportProfileWorking", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
var isDataTable = false;
object obj = new Hre_ReportProfileWorkingEntity();
List<object> listObj = new List<object>();
listObj.Add(Model.OrgStructureID);
listObj.Add(Model.DateFrom);
listObj.Add(Model.DateTo);
listObj.Add(Model.CodeEmp);
string status = string.Empty;
var result = actionServices.GetData<Hre_ReportProfileWorkingEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptWorkingProfile, ref status);
if (Model.IsCreateTemplateForDynamicGrid)
{
obj = result;
isDataTable = true;
}
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportProfileWorkingEntity",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (Model.ExportID != Guid.Empty)
{
string[] valueField = null;
if (Model.ValueFields != null)
{
valueField = Model.ValueFields.Split(',');
}
var fullPath = ExportService.Export(Model.ExportID, result, null, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
public ActionResult GetReportHistoryProfile([DataSourceRequest] DataSourceRequest request, Hre_ReportHistoryProfileModel Model)
{
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
List<object> listObj = new List<object>();
List<Guid?> OrgIds = new List<Guid?>();
listObj.Add(Model.DateHireFrom);
listObj.Add(Model.DateHireTo);
listObj.Add(Model.DateQuitFrom);
listObj.Add(Model.DateQuitTo);
listObj.Add(Model.ProfileName);
listObj.Add(Model.CodeEmp);
string strOrgIDs = null;
if (!string.IsNullOrEmpty(Model.OrgStructureID))
{
strOrgIDs = Model.OrgStructureID;
}
listObj.Add(strOrgIDs);
string status = string.Empty;
var result = actionServices.GetData<Hre_ReportHistoryProfileEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptHistoryProfile, ref status).ToList().Translate<Hre_ReportHistoryProfileModel>();
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportPrenancy([DataSourceRequest] DataSourceRequest request, Hre_ReportPregnancyModel Model)
{
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportPregnancyModel>(Model, "Hre_ReportPregnancy", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
string status = string.Empty;
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateStart != null)
{
From = Model.DateStart.Value;
}
if (Model.DateEnd != null)
{
To = Model.DateEnd.Value;
}
var isDataTable = false;
object obj = new Hre_ReportPregnancyModel();
List<object> listObj = new List<object>();
listObj.Add(Model.DateStart);
listObj.Add(Model.DateEnd);
listObj.Add(Model.OrgStructureID);
listObj.Add(Model.ProfileName);
listObj.Add(Model.CodeEmp);
var result = actionServices.GetData<Hre_ReportPregnancyEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptPrenancy, ref status).ToList();
var orgServices = new Cat_OrgStructureServices();
var lstObjOrg = new List<object>();
lstObjOrg.Add(null);
lstObjOrg.Add(null);
lstObjOrg.Add(null);
lstObjOrg.Add(1);
lstObjOrg.Add(int.MaxValue - 1);
var lstOrg = actionServices.GetData<Cat_OrgStructureEntity>(lstObjOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, ref status).ToList();
var orgTypeService = new Cat_OrgStructureTypeServices();
var lstObjOrgType = new List<object>();
lstObjOrgType.Add(null);
lstObjOrgType.Add(null);
lstObjOrgType.Add(1);
lstObjOrgType.Add(int.MaxValue - 1);
var lstOrgType = actionServices.GetData<Cat_OrgStructureTypeEntity>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, ref status).ToList();
var lstRptPrenancyEntity = new List<Hre_ReportPregnancyEntity>();
foreach (var item in result)
{
var pregnancyEntity = new Hre_ReportPregnancyEntity();
var orgName = service.GetParentOrgName(lstOrg, lstOrgType, item.OrgID);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
}
}
pregnancyEntity = item.CopyData<Hre_ReportPregnancyEntity>();
pregnancyEntity.Channel = orgName[2];
pregnancyEntity.Region = orgName[1];
pregnancyEntity.Area = orgName[0];
lstRptPrenancyEntity.Add(pregnancyEntity);
}
var lstRptPrenancyModel = lstRptPrenancyEntity.Translate<Hre_ReportPregnancyModel>();
if (Model.IsCreateTemplateForDynamicGrid)
{
obj = lstRptPrenancyModel;
isDataTable = true;
}
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportPregnancyModel",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (Model.ExportID != Guid.Empty)
{
string[] valueField = null;
if (Model.ValueFields != null)
{
valueField = Model.ValueFields.Split(',');
}
var fullPath = ExportService.Export(Model.ExportID, lstRptPrenancyModel, null, Model.ExportType);
return Json(fullPath);
}
return Json(lstRptPrenancyModel.ToDataSourceResult(request));
}
public ActionResult GetReportOrgProfle([DataSourceRequest] DataSourceRequest request, CatOrgStructureModel Model)
{
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
List<object> listObj = new List<object>();
List<Guid?> OrgIds = new List<Guid?>();
string strOrgIDs = null;
if (!string.IsNullOrEmpty(Model.OrgStructureID))
{
strOrgIDs = Model.OrgStructureID;
}
listObj.Add(strOrgIDs);
string status = string.Empty;
var result = actionServices.GetData<Cat_OrgStructureEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptOrgProfile, ref status).ToList().Translate<CatOrgStructureModel>();
object obj = new CatOrgStructureModel();
var isDataTable = false;
if (Model.IsCreateTemplateForDynamicGrid)
{
obj = result;
isDataTable = true;
}
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "CatOrgStructureModel",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportProfileQuit([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileQuitModel Model)
{
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateStart != null ? Model.DateStart : DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateEnd != null ? Model.DateEnd : DateTime.Now };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportProfileQuitModel(),
FileName = "Hre_ReportProfileQuit",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportProfileQuitModel>(Model, "Hre_ReportProfileQuit", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
//DateTime From = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
//DateTime To = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(-1);
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateStart != null)
{
From = Model.DateStart.Value;
}
if (Model.DateEnd != null)
{
To = Model.DateEnd.Value;
}
List<object> listObj = new List<object>();
listObj.Add(Model.OrgStructureID);
listObj.Add(From);
listObj.Add(To);
string status = string.Empty;
var result = actionServices.GetData<Hre_ReportProfileQuitEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptQuitProfile, ref status).ToList().Translate<Hre_ReportProfileQuitModel>();
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
//public ActionResult CreateTemplate(CreateTemplateModel model)
//{
// if (model != null)
// {
// var service = new BaseService();
// Cat_ExportEntity exportEntity = new Cat_ExportEntity()
// {
// ExportName = model.TemplateName,
// IsColumnDynamic = model.IsDynamic,
// ScreenName = model.ScreenName,
// TemplateFile = model.TemplateFile
// };
// service.Add(exportEntity);
// }
// return Json("");
//}
public ActionResult GetReportHCGender([DataSourceRequest] DataSourceRequest request, Hre_ReportHCGenderModel model)
{
var service = new Hre_ReportServices();
var hrService = new Hre_ProfileServices();
object obj = new Hre_ReportHCGenderModel();
var isDataTable = false;
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = DateTime.Now };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
var result = service.GetReportHCGender(model.MonthSearch, model.JobtitleID, model.OrgStructureID, model.OrgStructureTypeID, model.Gender, model.isIncludeQuitEmp, model.IsCreateTemplate, UserLogin);
if (model.IsCreateTemplateForDynamicGrid)
{
var col = result.Columns.Count;
result.Columns.RemoveAt(col - 1);
obj = result;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportHCGenderModel",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportID != Guid.Empty)
{
result.Rows[0].Delete();
var col = result.Columns.Count;
result.Columns.RemoveAt(col - 1);
// var row = result.Rows.Count;
// result.Rows[row - 1].Delete();
string[] valueField = null;
if (model.ValueFields != null)
{
valueField = model.ValueFields.Split(',');
}
var fullPath = ExportService.Export(model.ExportID, result, listHeaderInfo, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportWorkHistoryDept([DataSourceRequest] DataSourceRequest request, Hre_ReportWorkHistoryDeptModel Model)
{
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportWorkHistoryDeptModel>(Model, "Hre_ReportWorkHistoryDept", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var actionServices = new ActionService(UserLogin);
var profileServices = new Hre_ProfileServices();
var rptServices = new Hre_ReportServices();
List<object> listObj = new List<object>();
listObj.Add(Model.DateFrom);
listObj.Add(Model.DateTo);
listObj.Add(Model.ProfileName);
listObj.Add(Model.CodeEmp);
listObj.Add(Model.JobTitleID);
listObj.Add(Model.PositionID);
listObj.Add(Model.OrgStructureIDs);
listObj.Add(Model.TypeOfTransferID);
listObj.Add(Model.SalaryClassID);
listObj.Add(Model.WorkPlaceID);
listObj.Add(Model.Status);
listObj.Add(1);
listObj.Add(int.MaxValue - 1);
string status = string.Empty;
var result = actionServices.GetData<Hre_ReportWorkHistoryDeptEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptWorkHistoryDept, ref status).ToList().Translate<Hre_ReportWorkHistoryDeptModel>();
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom != null ? Model.DateFrom : DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo != null ? Model.DateTo : DateTime.Now };
HeaderInfo headerInfo3 = new HeaderInfo() { Name = "WorkPlaceName", Value = ((result != null && result.FirstOrDefault() != null) && result.FirstOrDefault().WorkPlaceName != null) ? result.FirstOrDefault().WorkPlaceName : "" };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2, headerInfo3 };
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportWorkHistoryDeptModel(),
FileName = "Hre_ReportWorkHistoryDept",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
bool isgroup = profileServices.IsGroupByOrgProfileQuit();
if (isgroup == true)
{
List<Hre_ReportWorkHistoryDeptModel> resultNew = new List<Hre_ReportWorkHistoryDeptModel>();
if (result.Count > 0)
{
var orgServices = new Cat_OrgStructureServices();
var lstObjOrg = new List<object>();
lstObjOrg.Add(null);
lstObjOrg.Add(null);
lstObjOrg.Add(null);
lstObjOrg.Add(1);
lstObjOrg.Add(int.MaxValue - 1);
var lstOrg = actionServices.GetData<Cat_OrgStructureEntity>(lstObjOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, ref status).ToList();
var orgTypeService = new Cat_OrgStructureTypeServices();
var lstObjOrgType = new List<object>();
lstObjOrgType.Add(null);
lstObjOrgType.Add(null);
lstObjOrgType.Add(1);
lstObjOrgType.Add(int.MaxValue - 1);
var lstOrgType = actionServices.GetData<Cat_OrgStructureTypeEntity>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, ref status).ToList();
foreach (var item in result)
{
var orgName = new List<string>();
if (item.OrgStructureID != null)
{
orgName = rptServices.GetParentOrgName(lstOrg, lstOrgType, item.OrgStructureID);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
}
}
}
if (orgName.Count > 0)
{
item.Channel = orgName[2];
item.Region = orgName[1];
item.Area = orgName[0];
}
resultNew.Add(item);
}
}
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, resultNew, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(resultNew.ToDataSourceResult(request));
}
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportHCSales([DataSourceRequest] DataSourceRequest request, Hre_ReportHCSalesModel model)
{
var service = new Hre_ReportServices();
var eva_Service = new Eva_ReportServices();
var hrService = new Hre_ProfileServices();
//List<object> listObj = new List<object>();
//listObj.Add(model.OrgStructureID);
//listObj.Add(string.Empty);
//listObj.Add(string.Empty);
//string status = string.Empty;
//var listEntity = hrService.GetData<Hre_ProfileIdEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure, ref status).Select(s => s.ID).ToList();
var result = eva_Service.GetReportHCSales(model.dateSearch, model.OrgStructureID, model.IsCreateTemplate, UserLogin);
//var rs = result.Translate<Hre_ReportMonthlyHCModel>();
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = DateTime.Now };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
object obj = new Hre_ReportHCSalesModel();
var isDataTable = false;
if (model.IsCreateTemplateForDynamicGrid)
{
var col = result.Columns.Count;
result.Columns.RemoveAt(col - 1);
obj = result;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportHCSalesModel",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportID != Guid.Empty)
{
//var row = result.Rows.Count;
// result.Rows[row - 1].Delete();
var col = result.Columns.Count;
result.Columns.RemoveAt(col - 1);
var fullPath = ExportService.Export(model.ExportID, result, listHeaderInfo, model.ExportType);
return Json(fullPath);
}
//0string dataReturn = result.ConvertDataTabletoString();
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportProfileNew([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileNewModel Model)
{
string status = string.Empty;
var services = new Hre_ReportServices();
var isDataTable = false;
object obj = new Hre_ReportProfileNewModel();
#region Validate
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportProfileNewModel>(Model, "Hre_ReportProfileNew", ref message);
if (!checkValidate)
{
return Json(message, JsonRequestBehavior.AllowGet);
}
DateTime From = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
DateTime To = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(-1);
#endregion
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
var result = services.GetReportProfileNew(
From,
To,
Model.OrgStructureID,
Model.IsCreateTemplate,
Model.CodeEmp,
Model.ProfileName,
Model.SalaryClassID,
Model.CodeCandidate,
Model.WorkPlaceID,
Model.EmpTypeID,
UserLogin
);
if (Model != null && Model.IsCreateTemplateForDynamicGrid)
{
obj = result;
isDataTable = true;
}
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportProfileNewModel(),
FileName = "Hre_ReportProfileNew",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportExpiryContract([DataSourceRequest] DataSourceRequest request, Hre_ReportExpiryContractModel Model)
{
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
DateTime From = DateTime.Now.AddMonths(-1);
DateTime To = DateTime.Now.AddMonths(1);
if (Model.DateStart != null)
{
From = Model.DateStart.Value;
}
if (Model.DateEnd != null)
{
To = Model.DateEnd.Value;
}
List<object> listObj = new List<object>();
listObj.Add(Model.OrgStructureID);
listObj.Add(Model.Status);
listObj.Add(From);
listObj.Add(To);
listObj.Add(Model.CodeEmp);
listObj.Add(Model.ProfileName);
listObj.Add(Model.IDNo);
listObj.Add(Model.WorkPlaceID);
listObj.Add(Model.DateSignedFrom);
listObj.Add(Model.DateSignedTo);
listObj.Add(Model.ContractNo);
listObj.Add(1);
listObj.Add(int.MaxValue - 1);
string status = string.Empty;
var result = actionServices.GetData<Hre_ReportExpiryContractEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptExpireContract, ref status).ToList().Translate<Hre_ReportExpiryContractModel>();
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, Model.ExportType);
return Json(fullPath);
//ExportService.ExportWord(@"D:\app\TestHD.doc", @"D:\app\BD_HDLDNV.doc", result);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportBirthday([DataSourceRequest] DataSourceRequest request, Hre_ReportBirthdayModel Model)
{
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom != null ? Model.DateFrom.Value : DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo != null ? Model.DateTo.Value : DateTime.Now };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
#region Tạo Template
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportBirthdayModel(),
FileName = "Hre_ReportBirthday",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#endregion
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportBirthdayModel>(Model, "Hre_ReportBirthday", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
List<object> listObj = new List<object>();
List<Guid?> OrgIds = new List<Guid?>();
listObj.Add(Model.DateFrom);
listObj.Add(Model.DateTo);
listObj.Add(Model.OrgStructureID);
listObj.Add(Model.DateQuitFrom);
listObj.Add(Model.DateQuitTo);
listObj.Add(Model.WorkPlaceID);
string status = string.Empty;
var result = actionServices.GetData<Hre_ReportBirthdayEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptBirthday, ref status).ToList().Translate<Hre_ReportBirthdayModel>();
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult ExportProfileIsBackList([DataSourceRequest] DataSourceRequest request, Hre_ProfileSearchIsBackListModel model)
{
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ProfileSearchIsBackListModel>(model, "Hre_ReportProfileIsBackList", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var service = new Hre_ReportServices();
var hrService = new Hre_ProfileServices();
string status = string.Empty;
object obj = new Hre_ProfileSearchIsBackListModel();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var result = GetListData<Hre_ReportProfileIsBackListModel, Hre_ReportProfileIsBackListEntity, Hre_ProfileSearchIsBackListModel>(request, model, ConstantSql.hrm_hr_sp_get_ProfileIsBackList, ref status);
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportProfileIsBackListModel(),
FileName = "Hre_ReportProfileIsBackList",
OutPutPath = path,
//HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportID, result, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportProfileDiscipline([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileDisciplineModel Model)
{
#region Code cũ
//var service = new Hre_ReportServices();
//var hrService = new Hre_ProfileServices();
//var isDataTable = false;
//object obj = new Hre_ReportProfileDisciplineModel();
//List<object> listObj = new List<object>();
//DateTime From = SqlDateTime.MinValue.Value;
//DateTime To = SqlDateTime.MaxValue.Value;
//List<Guid?> OrgIds = new List<Guid?>();
//if (Model.DateFrom != null)
//{
// From = Model.DateFrom.Value;
// listObj.Add(From);
//}
//else
//{
// listObj.Add(null);
//}
//if (Model.DateTo != null)
//{
// To = Model.DateTo.Value;
// listObj.Add(To);
//}
//else
//{
// listObj.Add(null);
//}
//string strOrgIDs = null;
//if (!string.IsNullOrEmpty(Model.OrgStructureID))
//{
// strOrgIDs = Model.OrgStructureID;
//}
//listObj.Add(strOrgIDs);
//string status = string.Empty;
//var result = hrService.GetData<Hre_ReportProfileDisciplineEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptDiscripline, ref status).ToList().Translate<Hre_ReportProfileDisciplineModel>();
//if (Model.IsCreateTemplateForDynamicGrid)
//{
// obj = result;
// isDataTable = true;
//}
//if (Model != null && Model.IsCreateTemplate)
//{
// var path = Common.GetPath("Templates");
// ExportService exportService = new ExportService();
// ConfigExport cfgExport = new ConfigExport()
// {
// Object = obj,
// FileName = "Hre_ReportProfileDisciplineModel",
// OutPutPath = path,
// DownloadPath = Hrm_Main_Web + "Templates",
// IsDataTable = isDataTable
// };
// var str = exportService.CreateTemplate(cfgExport);
// return Json(str);
//}
//if (Model.ExportID != Guid.Empty)
//{
// if (result != null && result.Count > 0)
// {
// #region lấy Org và OrgType
// var orgServices = new Cat_OrgStructureServices();
// var lstObjOrg = new List<object>();
// lstObjOrg.Add(null);
// lstObjOrg.Add(null);
// lstObjOrg.Add(null);
// lstObjOrg.Add(1);
// lstObjOrg.Add(int.MaxValue - 1);
// var lstOrg = orgServices.GetData<Cat_OrgStructureEntity>(lstObjOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, ref status).ToList();
// var orgTypeService = new Cat_OrgStructureTypeServices();
// var lstObjOrgType = new List<object>();
// lstObjOrgType.Add(null);
// lstObjOrgType.Add(null);
// lstObjOrgType.Add(1);
// lstObjOrgType.Add(int.MaxValue - 1);
// var lstOrgType = orgTypeService.GetData<Cat_OrgStructureTypeEntity>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, ref status).ToList();
// #endregion
// foreach (var item in result)
// {
// Guid? orgId = item.OrgStructureID1;
// var org = lstOrg.FirstOrDefault(s => s.ID == item.OrgStructureID1);
// var orgBranch = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_BRANCH, lstOrg, lstOrgType);
// var orgGroup = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_GROUP, lstOrg, lstOrgType);
// var orgOrg = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_DEPARTMENT, lstOrg, lstOrgType);
// var orgTeam = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_TEAM, lstOrg, lstOrgType);
// var orgSection = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_SECTION, lstOrg, lstOrgType);
// var orgDivision = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_DIVISION, lstOrg, lstOrgType);
// item.BranchName = orgBranch != null ? orgBranch.OrgStructureName : string.Empty;
// item.GroupName = orgGroup != null ? orgGroup.OrgStructureName : string.Empty;
// item.DepartmentName = orgOrg != null ? orgOrg.OrgStructureName : string.Empty;
// item.TeamName = orgTeam != null ? orgTeam.OrgStructureName : string.Empty;
// item.SectionName = orgSection != null ? orgSection.OrgStructureName : string.Empty;
// item.DivisionName = orgDivision != null ? orgDivision.OrgStructureName : string.Empty;
// item.DisciplineCount = result.Where(s => s.ProfileID == item.ProfileID).Count();
// }
// }
// string[] valueField = null;
// if (Model.ValueFields != null)
// {
// valueField = Model.ValueFields.Split(',');
// }
// var fullPath = ExportService.Export(Model.ExportID, result, null, Model.ExportType);
// return Json(fullPath);
//}
//return Json(result.ToDataSourceResult(request));
#endregion
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom ?? DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo ?? DateTime.Now };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportProfileDisciplineModel(),
FileName = "Hre_ReportProfileDiscipline",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportProfileDisciplineModel>(Model, "Hre_ReportProfileDiscipline", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
List<object> listObj = new List<object>();
listObj.Add(Model.DateFrom);
listObj.Add(Model.DateTo);
listObj.Add(Model.OrgStructureID);
string status = string.Empty;
var result = actionServices.GetData<Hre_ReportProfileDisciplineEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptDiscripline, ref status).ToList().Translate<Hre_ReportProfileDisciplineModel>();
var lstprofileids = result.Select(s => s.ProfileID).ToList();
foreach (var item in result)
{
Guid profileID = item.ProfileID;
item.count = result.Count(s => s.ProfileID == profileID);
}
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public DataTable GetReportHCSales(DateTime DateSearch, Guid orgID, bool isCreateTemplate,string userLogin)
{
Hre_ReportServices reportServices = new Hre_ReportServices();
DataTable table = CreateReportHCSalesSchema(userLogin);
string status = string.Empty;
using (var context = new VnrHrmDataContext())
{
if (isCreateTemplate)
{
return table.ConfigTable();
}
string key1 = "SaleIn";
string key2 = "SaleOut";
var count = 1;
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var serviceProfile = new Hre_ProfileServices();
var baseService = new BaseService();
var orgsService = new Cat_OrgStructureServices();
var lstallorgs = orgsService.GetDataNotParam<Cat_OrgStructure>(ConstantSql.hrm_cat_sp_get_AllOrg, userLogin, ref status).ToList();
var orgTypeService = new Cat_OrgStructureTypeServices();
var lstObjOrgType = new List<object>();
lstObjOrgType.Add(null);
lstObjOrgType.Add(null);
lstObjOrgType.Add(1);
lstObjOrgType.Add(int.MaxValue - 1);
var lstOrgType = orgTypeService.GetData<Cat_OrgStructureType>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, userLogin, ref status);
var lstorgs = lstallorgs.Where(s => s.ParentID == orgID).ToList();
var lstOrgName = lstallorgs.Where(s => s.ID == orgID).FirstOrDefault();
var listorgid = lstorgs.Select(s => new { s.ID, s.OrderNumber, s.Code, s.OrgStructureName }).ToList();
//Xử Lý lấy tất cả nhân viên trong phòng ban đã chọn và group 1 cấp
var orgIDs = string.Empty;
orderNumber = string.Empty;
foreach (var item in listorgid)
{
orderNumber += item.OrderNumber.ToString() + ",";
getChildOrgStructure(lstallorgs, item.ID);
}
if (orderNumber.IndexOf(',') > 0)
orderNumber = orderNumber.Substring(0, orderNumber.Length - 1);
var lstObjOrgByOrderNumber = new List<object>();
lstObjOrgByOrderNumber.Add(orderNumber);
var lstOrgByOrderNumber = orgsService.GetData<Cat_OrgStructure>(lstObjOrgByOrderNumber, ConstantSql.hrm_cat_sp_get_OrgStructureByOrderNumber, userLogin, ref status).Select(s => s.ID).ToList();
List<object> listObj = new List<object>();
listObj.Add(orderNumber);
listObj.Add(string.Empty);
listObj.Add(string.Empty);
var lstprofile = reportServices.GetData<Hre_ProfileEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, userLogin, ref status).ToList();
var salesTypeServices = new Eva_SalesTypeServices();
var lstObjSalesType = new List<object>();
lstObjSalesType.Add(null);
lstObjSalesType.Add(1);
lstObjSalesType.Add(int.MaxValue);
var lstSalesType = salesTypeServices.GetData<Eva_SalesTypeEntity>(lstObjSalesType, ConstantSql.hrm_eva_sp_get_SalesType, userLogin, ref status).Select(s => s.Code).ToList();
var saleEvaluationServices = new Eva_SaleEvaluationServices();
var lstObjSaleEvaluation = new List<object>();
lstObjSaleEvaluation.Add(null);
lstObjSaleEvaluation.Add(null);
lstObjSaleEvaluation.Add(null);
lstObjSaleEvaluation.Add(1);
lstObjSaleEvaluation.Add(int.MaxValue);
var lstSaleEvaluation = saleEvaluationServices.GetData<Eva_SaleEvaluationEntity>(lstObjSaleEvaluation, ConstantSql.hrm_eva_sp_get_SaleEvaluation, userLogin, ref status).ToList();
foreach (var org in listorgid)
{
DataRow row = table.NewRow();
row[Hre_ReportHCSalesEntity.FieldNames.CodeEmp] = org == null ? string.Empty : org.OrgStructureName;
//xử lý đếm nhân viên của phòng ban con
orderNumber = string.Empty;
orderNumber += org.OrderNumber.ToString() + ",";
getChildOrgStructure(lstallorgs, org.ID);
if (orderNumber.IndexOf(',') > 0)
orderNumber = orderNumber.Substring(0, orderNumber.Length - 1);
var lstObjOrgByOrderNumberCount = new List<object>();
lstObjOrgByOrderNumberCount.Add(orderNumber);
var lstOrgByOrderNumberCount = orgsService.GetData<Cat_OrgStructure>(lstObjOrgByOrderNumberCount, ConstantSql.hrm_cat_sp_get_OrgStructureByOrderNumber, userLogin, ref status).ToList();
//if(count <= 0){
// continue;
//}
bool addTitle = false;
foreach (var item in lstOrgByOrderNumberCount)
{
var lstprofilebyOrg = lstprofile.Where(s => s.OrgStructureID != null && item.ID == s.OrgStructureID.Value && s.DateHire != null && s.DateHire.Value.Year <= DateSearch.Year && s.DateQuit == null).Select(s => s.ID).ToList();
if (lstprofilebyOrg == null && lstprofilebyOrg.Count <= 0)
{
continue;
}
var lstSaleEvaluations = lstSaleEvaluation.Where(s => lstprofilebyOrg.Contains(s.ProfileID.Value) && s.Year != null && s.Year.Value.Year <= DateSearch.Year).ToList();
count = 0;
count = lstSaleEvaluation.Count;
foreach (var sale in lstSaleEvaluations)
{
var lstProfileResult = lstprofile.Where(s => s.ID == sale.ProfileID.Value).FirstOrDefault();
var orgName = reportServices.GetParentOrg(lstallorgs, lstOrgType, lstProfileResult.OrgStructureID);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
}
}
DataRow row1 = table.NewRow();
row1[Hre_ReportHCSalesEntity.FieldNames.CodeEmp] = lstProfileResult == null ? string.Empty : lstProfileResult.CodeEmp;
row1[Hre_ReportHCSalesEntity.FieldNames.ProfileName] = lstProfileResult == null ? string.Empty : lstProfileResult.ProfileName;
row1[Hre_ReportHCSalesEntity.FieldNames.PositionName] = lstProfileResult == null ? string.Empty : lstProfileResult.PositionName;
row1[Hre_ReportHCSalesEntity.FieldNames.JobTitleName] = lstProfileResult == null ? string.Empty : lstProfileResult.JobTitleName;
row1[Hre_ReportHCSalesEntity.FieldNames.ProfileSupervisorName] = lstProfileResult == null ? string.Empty : lstProfileResult.SupervisorName;
row1[Hre_ReportHCSalesEntity.FieldNames.DateHire] = lstProfileResult == null ? string.Empty : lstProfileResult.DateHire.Value.ToShortDateString();
row1[Hre_ReportHCSalesEntity.FieldNames.Channel] = orgName[2];
row1[Hre_ReportHCSalesEntity.FieldNames.Region] = orgName[1];
row1[Hre_ReportHCSalesEntity.FieldNames.Area] = orgName[0];
row1[Hre_ReportHCSalesEntity.FieldNames.WorkingPlaceName] = lstProfileResult == null ? string.Empty : lstProfileResult.WorkPlaceName;
for (int i = 1; i <= 12; i++)
{
var saleCode = sale.SalesTypeCode + "_" + i;
if (sale.SalesTypeCode == key1 && sale.Year != null && sale.Year.Value.Month == i)
{
row1[Hre_ReportHCSalesEntity.FieldNames.TargetSalesIn + "_" + i] = sale.TagetNumber;
row1[Hre_ReportHCSalesEntity.FieldNames.ActSalesIn + "_" + i] = sale.ResultNumber;
row1[Hre_ReportHCSalesEntity.FieldNames.SalesIn + "_" + i] = sale.ResultPercent != null ? sale.ResultPercent.Value.ToString(ConstantFormat.HRM_Format_Number_Double2) : null;
}
if (sale.SalesTypeCode == key2 && sale.Year != null && sale.Year.Value.Month == i)
{
row1[Hre_ReportHCSalesEntity.FieldNames.TargetSalesOut + "_" + i] = sale.TagetNumber;
row1[Hre_ReportHCSalesEntity.FieldNames.ActSalesOut + "_" + i] = sale.ResultNumber;
row1[Hre_ReportHCSalesEntity.FieldNames.SalesOut + "_" + i] = sale.ResultPercent != null ? sale.ResultPercent.Value.ToString(ConstantFormat.HRM_Format_Number_Double2) : null;
}
if (lstSaleEvaluation.Where(s => s.Year != null).Select(s => s.Year.Value.Month).ToList().Contains(i) && table.Columns.Contains(saleCode))
{
row1[sale.SalesTypeCode + "_" + i] = sale.ResultPercent != null ? sale.ResultPercent.Value.ToString(ConstantFormat.HRM_Format_Number_Double2) : null;
}
}
if (!addTitle)
{
table.Rows.Add(row);
addTitle = true;
}
table.Rows.Add(row1);
}
}
}
return table.ConfigTable(true);
}
}
public ActionResult GetReportRecieveObjectByTime([DataSourceRequest] DataSourceRequest request, Hre_ReportRecieveObjectByTimeModel Model)
{
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportRecieveObjectByTimeModel>(Model, "Hre_ReportRecieveObjectByTime", ref message);
if (!checkValidate)
{
return Json(message, JsonRequestBehavior.AllowGet);
}
#endregion
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateFrom == null ? DateTime.Now : Model.DateFrom };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = Model.DateTo == null ? DateTime.Now : Model.DateTo };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
if (Model.DateFrom == DateTime.MinValue)
{
Model.DateFrom = DateTime.Now;
}
if (Model.DateTo == DateTime.MaxValue)
{
Model.DateTo = DateTime.Now;
}
var ReportServices = new Hre_ReportServices();
var result = ReportServices.GetReportRecieveObjectByTime(Model.OrgStructureID, Model.DateFrom, Model.DateTo, Model.IsCreateTemplate, UserLogin);
object obj = new DataTable();
bool isDataTable = false;
if (Model.IsCreateTemplateForDynamicGrid)
{
obj = result;
isDataTable = true;
}
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportRecieveObjectByTime",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
