public ActionResult ReportWorkHistoryDeptValidate(Hre_ReportWorkHistoryDeptModel model)
{
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_ReportWorkHistoryDeptModel>(model, "Hre_ReportWorkHistoryDeptValidate", ref message);
if (!checkValidate)
{
var ls = new object[] { "error", message };
return Json(ls);
}
return Json(message);
}
public ActionResult ExportWordReportWorkHistoryDeptByTemplate(List<Guid> selectedIds, string valueFields, Hre_ReportWorkHistoryDeptModel model)
{
DateTime DateStart = DateTime.Now;
string messages = string.Empty;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
var contractServices = new Hre_ReportWorkHistoryDeptModel();
var baseService = new BaseService();
var objs = new List<object>();
string strIDs = string.Empty;
foreach (var item in selectedIds)
{
strIDs += Common.DotNetToOracle(item.ToString()) + ",";
}
if (strIDs.IndexOf(",") > 0)
strIDs = strIDs.Substring(0, strIDs.Length - 1);
var actionServices = new ActionService(UserLogin);
List<object> listObj = new List<object>();
listObj.Add(strIDs);
listObj.Add(model.DateFrom);
listObj.Add(model.DateTo);
string status = string.Empty;
var lstReportWorkHistory = actionServices.GetData<Hre_ReportWorkHistoryDeptEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptWorkHistoryDeptByids, ref status).ToList();
if (lstReportWorkHistory == null)
return null;
int i = 0;
var lstReportWorkHistoryID = lstReportWorkHistory.Select(s => s.ID).Distinct().ToList();
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_Contract" + suffix;
if (lstReportWorkHistory.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var ReportWorkHistory in lstReportWorkHistory)
{
ActionService service = new ActionService(UserLogin);
var exportService = new Cat_ExportServices();
Cat_ExportEntity template = null;
string outputPath = string.Empty;
List<object> lstObjExport = new List<object>();
lstObjExport.Add(null);
lstObjExport.Add(null);
lstObjExport.Add(null);
lstObjExport.Add(null);
lstObjExport.Add(1);
lstObjExport.Add(10000000);
template = actionServices.GetData<Cat_ExportEntity>(lstObjExport, ConstantSql.hrm_cat_sp_get_ExportWord, ref status).Where(s => s.ScreenName == valueFields).FirstOrDefault();
if (template == null)
{
messages = "Error";
return Json(messages, JsonRequestBehavior.AllowGet);
}
string templatepath = Common.GetPath(Common.TemplateURL + template.TemplateFile);
if (!System.IO.File.Exists(templatepath))
{
messages = "NotTemplate";
return Json(messages, JsonRequestBehavior.AllowGet);
}
outputPath = folferPath + "/" + Common.ChuyenTVKhongDau(ReportWorkHistory.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(ReportWorkHistory.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
if (!System.IO.File.Exists(templatepath))
{
messages = "NotTemplate";
return Json(messages, JsonRequestBehavior.AllowGet);
}
var lst = new List<Hre_ReportWorkHistoryDeptEntity>();
lst.Add(ReportWorkHistory);
ExportService.ExportWord(outputPath, templatepath, lst);
}
if (lstReportWorkHistory.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
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));
}