/// <summary>
/// [Tho.Bui]:Export Discipline templete
/// </summary>
/// <param name="selectedIds"></param>
/// <param name="valueFields"></param>
/// <returns></returns>
///
public ActionResult ExporProfileDisciplineTemplate(List<Guid> selectedIds, string valueFields)
{
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
ActionService service = new ActionService(UserLogin);
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
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);
objs.Add(strIDs);
var lstProfileDiscipline = service.GetData<Hre_DisciplineEntity>(objs, ConstantSql.hrm_hr_sp_get_TempleteDisciplineByIds, ref status);
if (lstProfileDiscipline == null)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "Discipline" + suffix;
if (lstProfileDiscipline.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var objProfileDiscipline in lstProfileDiscipline)
{
objProfileDiscipline.DateNow = DateTime.Now.ToString("dd/MM/yyyy");
objProfileDiscipline.DateNow_Day = DateTime.Now.Day.ToString();
objProfileDiscipline.DateNow_Month = DateTime.Now.Month.ToString();
objProfileDiscipline.DateNow_Year = DateTime.Now.Year.ToString();
if (objProfileDiscipline.DateOfIssuance.HasValue)
{
objProfileDiscipline.DateOfIssuanceFormat = objProfileDiscipline.DateOfIssuance.Value.ToString("dd/MM/yyyy");
}
if (objProfileDiscipline.DateOfViolation.HasValue)
{
objProfileDiscipline.DateOfViolationFormat = objProfileDiscipline.DateOfViolation.Value.ToString("dd/MM/yyyy");
}
if (objProfileDiscipline.DateOfEffective.HasValue)
{
objProfileDiscipline.DateOfEffectiveFormat = objProfileDiscipline.DateOfEffective.Value.ToString("dd/MM/yyyy");
}
if (objProfileDiscipline.DateHire.HasValue)
{
objProfileDiscipline.DateHireFormat = objProfileDiscipline.DateHire.Value.ToString("dd/MM/yyyy");
}
if (objProfileDiscipline.DateQuit.HasValue)
{
if (objProfileDiscipline.DateHire.HasValue)
{
objProfileDiscipline.MonthWorking = Math.Floor(objProfileDiscipline.DateQuit.Value.Subtract(objProfileDiscipline.DateHire.Value).TotalDays / 30);
if (objProfileDiscipline.MonthWorking.HasValue)
objProfileDiscipline.YearWorking = Math.Floor(objProfileDiscipline.MonthWorking.Value / 12);
if (objProfileDiscipline.YearWorking > 0)
{
objProfileDiscipline.MonthWorking = objProfileDiscipline.MonthWorking - (objProfileDiscipline.YearWorking * 12);
}
}
}
else
{
if (objProfileDiscipline.DateHire.HasValue)
objProfileDiscipline.MonthWorking = Math.Floor(DateTime.Now.Subtract(objProfileDiscipline.DateHire.Value).TotalDays / 30);
if (objProfileDiscipline.MonthWorking.HasValue)
objProfileDiscipline.YearWorking = Math.Floor(objProfileDiscipline.MonthWorking.Value / 12);
if (objProfileDiscipline.YearWorking > 0)
{
objProfileDiscipline.MonthWorking = objProfileDiscipline.MonthWorking - (objProfileDiscipline.YearWorking * 12);
}
}
//if (objProfileReward.DateHire.HasValue)
//{
// objProfileReward.DayOfDateHire = objProfileReward.DateHire.Value.Day;
// objProfileReward.MonthOfDateHire = objProfileReward.DateHire.Value.Month;
// objProfileReward.YearOfDateHire = objProfileReward.DateHire.Value.Year;
//}
//if (objProfileReward.DateEndProbation.HasValue)
//{
// objProfileReward.DayOfDateProbation = objProfileReward.DateEndProbation.Value.Day;
// objProfileReward.MonthOfDateProbation = objProfileReward.DateEndProbation.Value.Month;
// objProfileReward.YearOfDateProbation = objProfileReward.DateEndProbation.Value.Year;
//}
//objProfileReward.Salary = objProfileReward.Salary.HasValue ? objProfileReward.Salary.Value : 0;
//objProfileReward.DateNow = DateTime.Now.ToString("dd/MM/yyyy");
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);
if (!string.IsNullOrEmpty(valueFields))
{
template = service.GetData<Cat_ExportEntity>(Common.DotNetToOracle(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, ref status).FirstOrDefault();
}
if (template == null)
{
continue;
}
string templatepath = Common.GetPath(Common.TemplateURL + template.TemplateFile);
outputPath = folferPath + "/" + Common.ChuyenTVKhongDau(objProfileDiscipline.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(objProfileDiscipline.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
var ilDiscipline = new List<Hre_DisciplineEntity>();
ilDiscipline.Add(objProfileDiscipline);
ExportService.ExportWord(outputPath, templatepath, ilDiscipline);
}
if (lstProfileDiscipline.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportProfileProbationTemplate(List<Guid> selectedIds, string valueFields)
{
ActionService service = new ActionService(UserLogin);
string[] valueFieldsExportID = valueFields.Split(',');
valueFields = valueFieldsExportID[0];
//string _exportID = valueFieldsExportID[1];
Guid exportID;
string messages = string.Empty;
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
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);
objs.Add(strIDs);
var lstProfileProbation = service.GetData<Hre_ProfileEntity>(objs, ConstantSql.hrm_hr_sp_get_ProfileWaitingHireByListId, ref status);
if (lstProfileProbation == null)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_ProfileProbation" + suffix;
if (lstProfileProbation != null && lstProfileProbation.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var objProfileProbation in lstProfileProbation)
{
if (objProfileProbation.DateHire.HasValue)
{
objProfileProbation.DayOfDateHire = objProfileProbation.DateHire.Value.Day;
objProfileProbation.MonthOfDateHire = objProfileProbation.DateHire.Value.Month;
objProfileProbation.YearOfDateHire = objProfileProbation.DateHire.Value.Year;
objProfileProbation.DateHireFormat = objProfileProbation.DateHire.Value.ToString("dd/MM/yyyy");
}
if (objProfileProbation.DateEndProbation.HasValue)
{
objProfileProbation.DayOfDateProbation = objProfileProbation.DateEndProbation.Value.Day;
objProfileProbation.MonthOfDateProbation = objProfileProbation.DateEndProbation.Value.Month;
objProfileProbation.YearOfDateProbation = objProfileProbation.DateEndProbation.Value.Year;
objProfileProbation.DateEndProbationFormat = objProfileProbation.DateEndProbation.Value.ToString("dd/MM/yyyy");
}
objProfileProbation.Salary = objProfileProbation.Salary.HasValue ? objProfileProbation.Salary.Value : 0;
objProfileProbation.DateNow = DateTime.Now.ToString("dd/MM/yyyy");
objProfileProbation.DateNow_Day = DateTime.Now.Day.ToString();
objProfileProbation.DateNow_Month = DateTime.Now.Month.ToString();
objProfileProbation.DateNow_Year = DateTime.Now.Year.ToString();
objProfileProbation.DateNow_Hour = DateTime.Now.ToString("HH:mm:ss");
if (objProfileProbation.DateOfBirth != null)
objProfileProbation.DateOfBirthFormat = objProfileProbation.DateOfBirth.Value.ToString("dd/MM/yyyy");
if (objProfileProbation.IDDateOfIssue != null)
objProfileProbation.IDDateOfIssueFormat = objProfileProbation.IDDateOfIssue.Value.ToString("dd/MM/yyyy");
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);
if (!string.IsNullOrEmpty(valueFields))
{
template = service.GetData<Cat_ExportEntity>(Guid.Parse(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, ref status).FirstOrDefault();
}
if (template == null)
{
messages = "Error";
return Json(messages, JsonRequestBehavior.AllowGet);
}
string templatepath = Common.GetPath(Common.TemplateURL + template.TemplateFile);
outputPath = folferPath + "/" + Common.ChuyenTVKhongDau(objProfileProbation.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(objProfileProbation.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
var ilContract = new List<Hre_ProfileEntity>();
ilContract.Add(objProfileProbation);
ExportService.ExportWord(outputPath, templatepath, ilContract);
}
if (lstProfileProbation != null && lstProfileProbation.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
/// <summary>
/// [Tho.Bui]:Export Reward word templete
/// </summary>
/// <param name="selectedIds"></param>
/// <param name="valueFields"></param>
/// <returns></returns>
///
public ActionResult ExporProfileRewardTemplate(List<Guid> selectedIds, string valueFields)
{
ActionService service = new ActionService(UserLogin);
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
string messages = string.Empty;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
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);
objs.Add(strIDs);
var lstProfileReward = service.GetData<Hre_RewardEntity>(objs, ConstantSql.hrm_hr_sp_get_TempleteRewardByIds, ref status);
if (lstProfileReward == null)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "Reward" + suffix;
if (lstProfileReward.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var objProfileReward in lstProfileReward)
{
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 = service.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(objProfileReward.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(objProfileReward.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
var ilReward = new List<Hre_RewardEntity>();
ilReward.Add(objProfileReward);
ExportService.ExportWord(outputPath, templatepath, ilReward);
}
if (lstProfileReward.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportProfileWorkingByTemplate(List<Guid> selectedIds, string valueFields)
{
var actionService = new ActionService(UserLogin);
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
string messages = string.Empty;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
var contractServices = new Hre_ContractServices();
var ActionService = new ActionService(UserLogin);
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);
objs.Add(strIDs);
var lstProfile = baseService.GetData<Hre_ProfileEntity>(objs, ConstantSql.hrm_hr_sp_get_ProfileWorkingByListId, UserLogin, ref status);
if (lstProfile == null)
return null;
int i = 0;
var lstProfileID = lstProfile.Select(s => s.ID).Distinct().ToList();
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_Contract" + suffix;
if (lstProfileID.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
#region ds nguoi than cua nhan vien duoc chon
string strProfileIDs = "";
if (lstProfileID != null)
{
foreach (var ProfileID in lstProfileID)
{
string _strProfileID = Common.DotNetToOracle(ProfileID.ToString());
strProfileIDs += _strProfileID + ",";
}
}
var lstRelativeByProfileIDs = ActionService.GetData<Hre_RelativesEntity>(strProfileIDs, ConstantSql.hrm_hr_sp_get_RelativeByProfileIds, ref status);
#endregion
foreach (var profile in lstProfile)
{
if (profile.IDDateOfIssue.HasValue)
profile.IDDateOfIssueFormat = profile.IDDateOfIssue.Value.ToString("dd/MM/yyyy");
if (profile.DateOfBirth.HasValue)
profile.DateOfBirthFormat = profile.DateOfBirth.Value.ToString("dd/MM/yyyy");
if (profile.Salary != null)
profile.SalaryFormat = String.Format("{0:0,0}", profile.Salary);
if (profile.Allowance1 != null)
profile.Allowance1Format = String.Format("{0:0,0}", profile.Allowance1);
if (profile.DayOfBirth > 0 && profile.MonthOfBirth > 0 && profile.YearOfBirth > 0)
{
profile.Birthday = profile.DayOfBirth + "/" + profile.MonthOfBirth + "/" + profile.YearOfBirth;
}
if (profile.DateHire.HasValue)
{
profile.DateHireFormat = profile.DateHire.Value.ToString("dd/MM/yyyy");
}
profile.DateNow = DateTime.Now.ToString("dd/MM/yyyy");
if (profile.DateStart.HasValue)
{
profile.DateStartString = "Ngày " + profile.DateStart.Value.Day + " Tháng " + profile.DateStart.Value.Month + " Năm " + profile.DateStart.Value.Year + " ";
profile.DateStartFormat = profile.DateStart.Value.ToString("dd/MM/yyyy");
}
if (profile.DateEnd.HasValue)
{
profile.DateEndString = "Ngày " + profile.DateEnd.Value.Day + " Tháng " + profile.DateEnd.Value.Month + " Năm " + profile.DateEnd.Value.Year + " ";
profile.DateEndFormat = profile.DateEnd.Value.ToString("dd/MM/yyyy");
}
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);
if (!string.IsNullOrEmpty(valueFields))
{
template = actionService.GetData<Cat_ExportEntity>(Guid.Parse(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, ref status).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(profile.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(profile.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
if (!System.IO.File.Exists(templatepath))
{
messages = "NotTemplate";
return Json(messages, JsonRequestBehavior.AllowGet);
}
#region lay nguoi than cua tung nhan vien
List<Hre_RelativesEntity> lstRelativeByProfileID = new List<Hre_RelativesEntity>();
if (lstRelativeByProfileIDs != null)
{
lstRelativeByProfileID = lstRelativeByProfileIDs.Where(s => s.ProfileID == profile.ID).ToList();
}
#endregion
var lstcontract = new List<Hre_ProfileEntity>();
lstcontract.Add(profile);
Hre_ProfileEntity objProfile = new Hre_ProfileEntity();
//string[] FieldtblProfiles = new string[] { "ProfileName","ID"};
//DataTable tblProfiles = Common.ConvertIListToDataTable(lstcontract, FieldtblProfiles);
DataTable tblProfiles = new DataTable();
tblProfiles = lstcontract.Translate();
DataTable tblRelatives = new DataTable();
tblRelatives = lstRelativeByProfileID.Translate();
//Common.ConvertIListToDataTable(lstRelativeByProfileID, FieldtblRelatives);
DataSet dsData = new DataSet();
dsData.Tables.Add(tblProfiles);
dsData.Tables.Add(tblRelatives);
dsData.Tables[0].TableName = "tblProfiles";
dsData.Tables[1].TableName = "tblRelatives";
//ExportService.ExportWord(outputPath, templatepath, dsData);
ExportService.ExportWithRegions(outputPath, templatepath, dsData);
}
if (lstProfileID.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportAppendixContractByTemplate(List<Guid> selectedIds, string valueFields)
{
string messages = string.Empty;
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
var contractServices = new Hre_ContractServices();
var ActionService = new ActionService(UserLogin);
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);
objs.Add(strIDs);
var lstAppendixContract = ActionService.GetData<Hre_AppendixContractEntity>(objs, ConstantSql.hrm_hr_sp_get_AppendixContractByListId, ref status);
if (lstAppendixContract == null)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_AppendixContract" + suffix;
if (lstAppendixContract.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
int count = 0;
List<object> lstObjAppendixContractType = new List<object>();
lstObjAppendixContractType.Add(null);
lstObjAppendixContractType.Add(1);
lstObjAppendixContractType.Add(int.MaxValue - 1);
var lstAppendixContractType = ActionService.GetData<Cat_AppendixContractTypeEntity>(lstObjAppendixContractType, ConstantSql.hrm_cat_sp_get_AppendixContractType, ref status);
foreach (var objAppendixContract in lstAppendixContract)
{
var AppendixContractType = lstAppendixContractType.Where(s => s.ID == objAppendixContract.AppendixContractTypeID).FirstOrDefault();
count++;
ActionService services = new ActionService(UserLogin);
List<object> listObj = new List<object>();
listObj.Add(objAppendixContract.ContractID);
var ResultEntity = services.GetData<Hre_AppendixContractEntity>(listObj, ConstantSql.hrm_hr_sp_get_AppendixContractByIdContractID, ref status);
if (ResultEntity != null && ResultEntity.Count > 0)
{
if (ResultEntity.Count > 2)
{
ResultEntity = ResultEntity.Where(s => s.DateSignedAppendixContract < objAppendixContract.DateSignedAppendixContract).ToList();
ResultEntity = ResultEntity.OrderByDescending(s => s.DateSignedAppendixContract).ToList();
objAppendixContract.CurrentSalary = ResultEntity[0].Salary;
objAppendixContract.CurrentAllowance1 = ResultEntity[0].Allowance1;
objAppendixContract.CurrentAllowance2 = ResultEntity[0].Allowance2;
objAppendixContract.CurrentAllowance3 = ResultEntity[0].Allowance3;
objAppendixContract.CurrentAllowance4 = ResultEntity[0].Allowance4;
}
else
{
var ResultProfile = services.GetByIdUseStore<Hre_ContractEntity>(objAppendixContract.ContractID, ConstantSql.hrm_hr_sp_get_ContractById, ref status);
if (ResultProfile != null)
{
objAppendixContract.CurrentSalary = ResultProfile.Salary;
objAppendixContract.CurrentAllowance1 = ResultProfile.Allowance1;
objAppendixContract.CurrentAllowance2 = ResultProfile.Allowance2;
objAppendixContract.CurrentAllowance3 = ResultProfile.Allowance3;
objAppendixContract.CurrentAllowance4 = ResultProfile.Allowance4;
}
}
}
if (objAppendixContract.DateSignedAppendixContract.HasValue)
{
objAppendixContract.DateSignedAppendixContractFormat = objAppendixContract.DateSignedAppendixContract.Value.ToString("dd/MM/yyyy");
objAppendixContract.DateSignedAppendixContract_Day = objAppendixContract.DateSignedAppendixContract.Value.Day.ToString();
objAppendixContract.DateSignedAppendixContract_Month = objAppendixContract.DateSignedAppendixContract.Value.Month.ToString();
objAppendixContract.DateSignedAppendixContract_Year = objAppendixContract.DateSignedAppendixContract.Value.Year.ToString();
objAppendixContract.PLDateSign = objAppendixContract.DateSignedAppendixContract.Value.ToString("dd-MMM-yyyy");
}
if (objAppendixContract.DateofEffect.HasValue)
{
objAppendixContract.DateofEffectFormat = objAppendixContract.DateofEffect.Value.ToString("dd/MM/yyyy");
objAppendixContract.DateofEffect_Day = objAppendixContract.DateofEffect.Value.Day.ToString();
objAppendixContract.DateofEffect_Month = objAppendixContract.DateofEffect.Value.Month.ToString();
objAppendixContract.DateofEffect_Year = objAppendixContract.DateofEffect.Value.Year.ToString();
objAppendixContract.PLDateStart = objAppendixContract.DateofEffect.Value.ToString("dd-MMM-yyyy");
}
if (objAppendixContract.DateEndAppendixContract.HasValue)
{
objAppendixContract.DateEndAppendixContractFormat = objAppendixContract.DateEndAppendixContract.Value.ToString("dd/MM/yyyy");
objAppendixContract.DateEndAppendixContract_Day = objAppendixContract.DateEndAppendixContract.Value.Day.ToString();
objAppendixContract.DateEndAppendixContract_Month = objAppendixContract.DateEndAppendixContract.Value.Month.ToString();
objAppendixContract.DateEndAppendixContract_Year = objAppendixContract.DateEndAppendixContract.Value.Year.ToString();
objAppendixContract.PLDateEnd = objAppendixContract.DateEndAppendixContract.Value.ToString("dd-MMM-yyyy");
}
if (objAppendixContract.DateOfBirth.HasValue)
{
objAppendixContract.DayOfBirthFormat = objAppendixContract.DateOfBirth.Value.ToString("dd/MM/yyyy");
objAppendixContract.DayOfBirth_Day = objAppendixContract.DateOfBirth.Value.Day.ToString();
objAppendixContract.DayOfBirth_Month = objAppendixContract.DateOfBirth.Value.Month.ToString();
objAppendixContract.DayOfBirth_Year = objAppendixContract.DateOfBirth.Value.Year.ToString();
}
if (objAppendixContract.IDDateOfIssue.HasValue)
{
objAppendixContract.IDDateOfIssueFormat = objAppendixContract.IDDateOfIssue.Value.ToString("dd/MM/yyyy");
objAppendixContract.IDDateOfIssue_Day = objAppendixContract.IDDateOfIssue.Value.Day.ToString();
objAppendixContract.IDDateOfIssue_Month = objAppendixContract.IDDateOfIssue.Value.Month.ToString();
objAppendixContract.IDDateOfIssue_Year = objAppendixContract.IDDateOfIssue.Value.Year.ToString();
}
if (objAppendixContract.DateSign.HasValue)
{
objAppendixContract.HDDateSign = objAppendixContract.DateSign.Value.ToString("dd-MMM-yyyy");
}
if (objAppendixContract.DateStart.HasValue)
{
objAppendixContract.HDStarDate = objAppendixContract.DateStart.Value.ToString("dd-MMM-yyyy");
}
if (objAppendixContract.DateSigned.HasValue)
{
objAppendixContract.DateSignedFormat = objAppendixContract.DateSigned.Value.ToString("dd/MM/yyyy");
objAppendixContract.DateSigned_Day = objAppendixContract.DateSigned.Value.Day.ToString();
objAppendixContract.DateSigned_Month = objAppendixContract.DateSigned.Value.Month.ToString();
objAppendixContract.DateSigned_Year = objAppendixContract.DateSigned.Value.Year.ToString();
}
objAppendixContract.ContractSalaryFormat = String.Format("{0:0,0}", objAppendixContract.ContractSalary);
objAppendixContract.Allowance1Format = String.Format("{0:0,0}", objAppendixContract.Allowance1);
if (objAppendixContract.Gender == "E_FEMALE")
{
objAppendixContract.GenderView = "Nữ";
}
if (objAppendixContract.Gender == "E_MALE")
{
objAppendixContract.GenderView = "Name";
}
objAppendixContract.PLSalary = String.Format("{0:0,0}", objAppendixContract.Salary);
ActionService service = new ActionService(UserLogin);
var exportService = new Cat_ExportServices();
Cat_ExportEntity template = null;
string outputPath = string.Empty;
if (AppendixContractType != null)
{
template = ActionService.GetData<Cat_ExportEntity>(Common.DotNetToOracle(AppendixContractType.ExportID.ToString()), ConstantSql.hrm_cat_sp_get_ExportById, ref status).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(objAppendixContract.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(objAppendixContract.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
if (count == lstAppendixContract.Count)
{
ExportService.ExportWord(outputPath, templatepath, lstAppendixContract);
}
}
if (lstAppendixContract.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
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 ExportWordInterviewCampaignDetailByTemplate(List<Guid> selectedIds, string valueFields)
{
DateTime DateStart = DateTime.Now;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
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);
objs.Add(strIDs);
var lstInterviewCampaignDetail = baseService.GetData<Rec_InterviewCampaignDetailEntity>(objs, ConstantSql.hrm_rec_sp_get_InterviewCampaignDetailByIds, UserLogin, ref status);
if (lstInterviewCampaignDetail == null)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportRec_InterviewCampaignDetail" + suffix;
if (lstInterviewCampaignDetail.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
int count = 0;
foreach (var InterviewCampaignDetail in lstInterviewCampaignDetail)
{
ActionService service = new ActionService(UserLogin);
var exportService = new Cat_ExportServices();
Cat_ExportEntity template = null;
string outputPath = string.Empty;
if (!string.IsNullOrEmpty(valueFields))
{
List<object> lstObjExport = new List<object>();
var exportID = Guid.Parse(valueFields);
lstObjExport.Add(exportID);
template = exportService.GetData<Cat_ExportEntity>(exportID, ConstantSql.hrm_cat_sp_get_ExportById, UserLogin, ref status).FirstOrDefault();
}
if (template == null)
{
continue;
}
string templatepath = Common.GetPath(Common.TemplateURL + template.TemplateFile);
outputPath = folferPath + "/" + Common.ChuyenTVKhongDau(InterviewCampaignDetail.CandidateName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(InterviewCampaignDetail.CandidateName) + suffix + i.ToString() + "_" + template.TemplateFile;
//var ilJobVacancy = new List<Rec_InterviewCampaignDetailEntity>();
//ilJobVacancy.Add(InterviewCampaignDetail);
//ExportService.ExportWord(outputPath, templatepath, ilJobVacancy);
string _Hrm_Hre_Service = ConstantPathWeb.Hrm_Hre_Service;
//var serviceRec = new RestServiceClient<Rec_CandidateModel>(UserLogin);
//var result = serviceRec.Get(_Hrm_Hre_Service, "api/Rec_Candidate/", InterviewCampaignDetail.CandidateID.Value.ToString());
var result = service.GetData<Rec_CandidateModel>(Common.DotNetToOracle(InterviewCampaignDetail.CandidateID.ToString()), ConstantSql.hrm_rec_sp_get_CandidateBusinessById, ref status).FirstOrDefault();
List<Rec_CandidateModel> lstRec = new List<Rec_CandidateModel>();
lstRec.Add(result);
DataTable tblCandidate = new DataTable();
tblCandidate.TableName = "tblCandidate";
tblCandidate = lstRec.Translate();
var lstCandidateHistory = service.GetData<Hre_CandidateHistoryEntity>(Common.DotNetToOracle(InterviewCampaignDetail.CandidateID.ToString()), ConstantSql.hrm_hr_sp_get_CandidateHistoryByCandidateId, ref status);
DataTable tblCandidateHistory = new DataTable();
tblCandidateHistory.TableName = "tblCandidateHistory";
tblCandidateHistory = lstCandidateHistory.Translate();
DataSet dsData = new DataSet();
dsData.Tables.Add(tblCandidate);
dsData.Tables.Add(tblCandidateHistory);
ExportService.ExportWithRegions(outputPath, templatepath, dsData);
}
if (lstInterviewCampaignDetail.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportWordContractExtendByTemplate(List<Guid> selectedIds, string valueFields)
{
string messages = string.Empty;
DateTime DateStart = DateTime.Now;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
{
Directory.CreateDirectory(dirpath);
}
string status = string.Empty;
var actionService = new ActionService(UserLogin);
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);
objs.Add(strIDs);
var lstContractExtend = actionService.GetData<Hre_ContractExtendEntity>(objs, ConstantSql.hrm_hr_sp_get_ContractExtendByListId, ref status);
if (lstContractExtend == null)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_ProfileWaitingHire" + suffix;
if (lstContractExtend.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
int count = 0;
foreach (var ContractExtend in lstContractExtend)
{
ContractExtend.DateSign = DateTime.Now.Day;
ContractExtend.MonthSign = DateTime.Now.Month;
ContractExtend.YearSign = DateTime.Now.Year;
if (ContractExtend.IDDateOfIssue != null)
{
ContractExtend.IDDateOfIssueFormat = ContractExtend.IDDateOfIssue.Value.ToString("dd/MM/yyyy");
}
if (ContractExtend.DateStartContract != null)
{
ContractExtend.DateStartContractFormat = ContractExtend.DateStartContract.Value.ToString("dd/MM/yyyy");
}
if (ContractExtend.DateEndContract != null)
{
ContractExtend.DateEndContractFormat = ContractExtend.DateEndContract.Value.ToString("dd/MM/yyyy");
}
if (ContractExtend.DateStart != null)
{
ContractExtend.DateStartFormat = ContractExtend.DateStart.Value.ToString("dd/MM/yyyy");
}
if (ContractExtend.DateEnd != null)
{
ContractExtend.DateEndFormat = ContractExtend.DateEnd.Value.ToString("dd/MM/yyyy");
}
if (ContractExtend.DateSigned != null)
{
ContractExtend.DateSignedContractFormat = ContractExtend.DateSigned.Value.ToString("dd/MM/yyyy");
}
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);
if (!string.IsNullOrEmpty(valueFields))
{
template = actionService.GetData<Cat_ExportEntity>(Guid.Parse(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, ref status).FirstOrDefault();
}
if (template == null)
{
messages = "Error";
return Json(messages, JsonRequestBehavior.AllowGet);
}
string templatepath = Common.GetPath(Common.TemplateURL + template.TemplateFile);
outputPath = folferPath + "/" + Common.ChuyenTVKhongDau(ContractExtend.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(ContractExtend.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
var ilContract = new List<Hre_ContractExtendEntity>();
ilContract.Add(ContractExtend);
ExportService.ExportWord(outputPath, templatepath, ilContract);
}
if (lstContractExtend.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportProfileQuitByTemplate(List<Guid> selectedIds, string valueFields)
{
string messages = string.Empty;
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
ActionService ActionService = new ActionService(UserLogin);
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
var contractServices = new Hre_ContractServices();
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);
objs.Add(strIDs);
var lstProfile = ActionService.GetData<Hre_ProfileEntity>(objs, ConstantSql.hrm_hr_sp_get_ProfileQuitByListId, ref status);
if (lstProfile == null || lstProfile.Count == 0)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_Contract" + suffix;
if (lstProfile.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var profile in lstProfile)
{
profile.DateNow = DateTime.Now.ToString("dd/MM/yyyy");
profile.DateNow_Day = DateTime.Now.Day.ToString();
profile.DateNow_Month = DateTime.Now.Month.ToString();
profile.DateNow_Year = DateTime.Now.Year.ToString();
if (profile.DateStart.HasValue)
profile.DateStartFormat = profile.DateStart.Value.ToString("dd/MM/yyyy");
if (profile.RequestDate.HasValue)
profile.RequestDateFormat = profile.RequestDate.Value.ToString("dd/MM/yyyy");
if (profile.DateQuit.HasValue)
profile.DateQuitFormat = profile.DateQuit.Value.ToString("dd/MM/yyyy");
if (profile.DateHire.HasValue)
profile.DateHireFormat = profile.DateHire.Value.ToString("dd/MM/yyyy");
if (profile.DateOfBirth.HasValue)
profile.DateOfBirthFormat = profile.DateOfBirth.Value.ToString("dd/MM/yyyy");
if (profile.IDDateOfIssue.HasValue)
profile.IDDateOfIssueFormat = profile.IDDateOfIssue.Value.ToString("dd/MM/yyyy");
if (profile.DateSigned.HasValue)
profile.DateSignedFormat = profile.DateSigned.Value.ToString("dd/MM/yyyy");
if (profile.DateQuitSign.HasValue)
{
profile.DateQuitSignFormat = profile.DateQuitSign.Value.ToString("dd/MM/yyyy");
}
if (profile.Gender == "E_FEMALE")
{
profile.GraveName = "Ms." + profile.ProfileName.Substring(profile.ProfileName.LastIndexOf(' '));
}
else
{
profile.GraveName = "Mr." + profile.ProfileName.Substring(profile.ProfileName.LastIndexOf(' '));
}
if (profile.Gender == "E_FEMALE")
{
profile.GenderView = "Chị";
}
if (profile.Gender == "E_MALE")
{
profile.GenderView = "Anh";
}
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 = ActionService.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(profile.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(profile.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
var lstProfile1 = new List<Hre_ProfileEntity>();
lstProfile1.Add(profile);
ExportService.ExportWord(outputPath, templatepath, lstProfile1);
}
if (lstProfile.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportStopWorkingByTemplate(List<Guid> selectedIds, string valueFields)
{
string messages = string.Empty;
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
var contractServices = new Hre_WorkHistoryServices();
var actionService = new ActionService(UserLogin);
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);
objs.Add(strIDs);
var lstStopWorking = actionService.GetData<Hre_StopWorkingEntity>(objs, ConstantSql.hrm_hr_sp_get_StopWorkingByListId, ref status);
if (lstStopWorking == null)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_StopWorking" + suffix;
if (lstStopWorking.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var stopWorking in lstStopWorking)
{
if (stopWorking.DateStop.HasValue)
{
stopWorking.DateStopFormat = stopWorking.DateStop.Value.ToString("dd/MM/yyyy");
}
if (stopWorking.DateQuit.HasValue)
stopWorking.DateQuitFormat = stopWorking.DateQuit.Value.ToString("dd/MM/yyyy");
if (stopWorking.RequestDate.HasValue)
stopWorking.RequestDateFormat = stopWorking.RequestDate.Value.ToString("dd/MM/yyyy");
stopWorking.RequestDate_Day = stopWorking.RequestDate.Value.Day.ToString();
stopWorking.RequestDate_Month = stopWorking.RequestDate.Value.Month.ToString();
stopWorking.RequestDate_Year = stopWorking.RequestDate.Value.Year.ToString();
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);
if (!string.IsNullOrEmpty(valueFields))
{
template = actionService.GetData<Cat_ExportEntity>(Common.DotNetToOracle(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, ref status).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(stopWorking.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(stopWorking.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
if (!System.IO.File.Exists(templatepath))
{
messages = "NotTemplate";
return Json(messages, JsonRequestBehavior.AllowGet);
}
var lststopworking = new List<Hre_StopWorkingEntity>();
lststopworking.Add(stopWorking);
ExportService.ExportWord(outputPath, templatepath, lststopworking);
}
List<object> lstNo = new List<object>();
lstNo.Add(strIDs);
if (lstStopWorking.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
var updateNoPrint1 = actionService.UpdateData<Hre_StopWorkingEntity>(lstNo, ConstantSql.hrm_hr_sp_set_UpdateNoPrint, ref status);
return Json(fileZip);
}
var updateNoPrint2 = actionService.UpdateData<Hre_StopWorkingEntity>(lstNo, ConstantSql.hrm_hr_sp_set_UpdateNoPrint, ref status);
return Json(fileDoc);
}
// Xuất template đăng ký tạm hoãn theo mẫu word
public ActionResult ExportListSuspenseByTemplate(List<Guid> selectedIds, string valueFields)
{
DateTime DateStart = DateTime.Now;
string messages = string.Empty;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
var contractServices = new Hre_StopWorkingServices();
var actionService = new ActionService(UserLogin);
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);
objs.Add(strIDs);
var lstStopWorking = actionService.GetData<Hre_StopWorkingEntity>(objs, ConstantSql.hrm_hr_sp_get_StopWorkingByListId, ref status);
if (lstStopWorking == null)
return null;
int i = 0;
var lstStopWorkingID = lstStopWorking.Select(s => s.ID).Distinct().ToList();
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_Contract" + suffix;
var objContract = new List<object>();
objContract.AddRange(new object[21]);
objContract[19] = 1;
objContract[20] = int.MaxValue - 1;
var lstContract = actionService.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_Contract, ref status).ToList();
var objAppendixContarct = new List<object>();
objAppendixContarct.AddRange(new object[7]);
objAppendixContarct[5] = 1;
objAppendixContarct[6] = int.MaxValue - 1;
var lstAppendixContract = actionService.GetData<Hre_AppendixContractEntity>(objAppendixContarct, ConstantSql.hrm_hr_sp_get_AppendixContract, ref status).ToList();
if (lstStopWorkingID.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var stopWorking in lstStopWorking)
{
var contractEntity = lstContract.Where(s => s.ProfileID == stopWorking.ProfileID.Value).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
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 = actionService.GetData<Cat_ExportEntity>(Guid.Parse(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, ref status).FirstOrDefault();
if (contractEntity != null)
{
var appendixContract = lstAppendixContract.Where(s => s.ContractID == contractEntity.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
stopWorking.ContractTypeName = contractEntity.ContractTypeName;
stopWorking.DateStartFormat = contractEntity.DateStart.ToString("dd/MM/yyyy");
stopWorking.Salary = contractEntity.Salary != null ? contractEntity.Salary : 0;
stopWorking.ContractNo = contractEntity.ContractNo != null ? contractEntity.ContractNo : string.Empty;
stopWorking.YearOfBirth = contractEntity.YearOfBirth;
stopWorking.MonthOfBirth = contractEntity.MonthOfBirth;
stopWorking.DayOfBirth = contractEntity.DayOfBirth;
if (contractEntity.DateSigned.HasValue)
{
stopWorking.DateSignedFormat = contractEntity.DateSigned.Value.ToString("dd/MM/yyyy");
}
if (contractEntity.DateEnd.HasValue)
{
stopWorking.DateEndFormat = contractEntity.DateEnd.Value.ToString("dd/MM/yyyy");
}
if (appendixContract != null)
{
if (appendixContract.DateEndAppendixContract.HasValue)
{
stopWorking.DateEndAppendixContractFormat = appendixContract.DateEndAppendixContract.Value.ToString("dd/MM/yyyy");
}
}
}
if (stopWorking.RequestDate.HasValue)
{
stopWorking.RequestDateString = stopWorking.RequestDate.Value.ToString("dd/MM/yyyy");
}
if (stopWorking.DateStop.HasValue)
{
stopWorking.DateStopString = stopWorking.DateStop.Value.ToString("dd/MM/yyyy");
}
if (stopWorking.DateComeBack.HasValue)
{
stopWorking.DateComeBackString = stopWorking.DateComeBack.Value.ToString("dd/MM/yyyy");
}
if (stopWorking.DateExpired.HasValue)
{
stopWorking.DateExpiredString = stopWorking.DateExpired.Value.ToString("dd/MM/yyyy");
}
if (stopWorking.DateHire.HasValue)
{
stopWorking.DateHireString = stopWorking.DateHire.Value.ToString("dd/MM/yyyy");
}
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(stopWorking.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(stopWorking.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
if (!System.IO.File.Exists(templatepath))
{
messages = "NotTemplate";
return Json(messages, JsonRequestBehavior.AllowGet);
}
var lststopWorking = new List<Hre_StopWorkingEntity>();
lststopWorking.Add(stopWorking);
ExportService.ExportWord(outputPath, templatepath, lststopWorking);
}
if (lstStopWorkingID.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportWorkHistoryByTemplate(List<Guid> selectedIds, string valueFields)
{
string[] valueFieldsExportID = valueFields.Split(',');
var actionService = new ActionService(UserLogin);
valueFields = valueFieldsExportID[0];
//string _exportID = valueFieldsExportID[1];
Guid exportID;
string messages = string.Empty;
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
string status = string.Empty;
DateTime DateStart = DateTime.Now;
Cat_ExportEntity template = null;
var exportService = new Cat_ExportServices();
if (!string.IsNullOrEmpty(valueFields))
{
template = exportService.GetData<Cat_ExportEntity>(Guid.Parse(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, UserLogin, ref status).FirstOrDefault();
}
if (template == null)
{
messages = "Error";
return Json(messages, JsonRequestBehavior.AllowGet);
}
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
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 lstWorkHistory = baseService.GetData<Hre_WorkHistoryEntity>(strIDs, ConstantSql.hrm_hr_sp_get_ExportWorkHistoryByIds,UserLogin, ref status);
if (lstWorkHistory == null)
return null;
#region Lấy Dữ liệu hợp đồng
Guid[] lstProfileByProfileID = lstWorkHistory.Select(s => (Guid)s.ProfileID).ToList().Distinct().ToArray();
string profileIDs = string.Empty;
foreach (var item in lstProfileByProfileID)
{
profileIDs += Common.DotNetToOracle(item.ToString()) + ",";
}
if (profileIDs.IndexOf(",") > 0)
{
profileIDs = profileIDs.Substring(0, profileIDs.Length - 1);
}
var lstContract = actionService.GetData<Hre_ContractEntity>(profileIDs, ConstantSql.hrm_hr_sp_get_ContractBYProIDs, ref status);
#endregion
#region Lấy danh sách phụ lục hợp hợp đồng
List<object> _lstobj = new List<object>();
_lstobj.AddRange(new object[7]);
_lstobj[5] = 1;
_lstobj[6] = int.MaxValue - 1;
var lstAppdixContract = actionService.GetData<Hre_AppendixContractEntity>(_lstobj, ConstantSql.hrm_hr_sp_get_AppendixContract, ref status);
#endregion
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_ProfileProbation" + suffix;
if (lstWorkHistory != null && lstWorkHistory.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var workHistory in lstWorkHistory)
{
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);
workHistory.DateNow = DateTime.Now.ToString("dd/MM/yyyy");
workHistory.DateNow_Day = DateTime.Now.Day.ToString();
workHistory.DateNow_Month = DateTime.Now.Month.ToString();
workHistory.DateNow_Year = DateTime.Now.Year.ToString();
workHistory.DateEffectiveFormat = workHistory.DateEffective.ToString("dd/MM/yyyy");
if (workHistory.DateNotice.HasValue)
{
workHistory.DateNoticeFormat = workHistory.DateNotice.Value.ToString("dd/MM/yyyy");
}
if (workHistory.DateComeBack.HasValue)
{
workHistory.DateComeBackFormat = workHistory.DateComeBack.Value.ToString("dd/MM/yyyy");
}
if (workHistory.Gender == "E_FEMALE")
{
workHistory.GraveName = "Ms." + workHistory.ProfileName.Substring(workHistory.ProfileName.LastIndexOf(' '));
}
else
{
workHistory.GraveName = "Mr." + workHistory.ProfileName.Substring(workHistory.ProfileName.LastIndexOf(' '));
}
if (workHistory.Gender == "E_FEMALE")
{
workHistory.GenderView = "Chị";
}
if (workHistory.Gender == "E_MALE")
{
workHistory.GenderView = "Anh";
}
#region lấy thông tin hợp đồng
if (lstContract != null && lstContract.Count > 0)
{
var _ContractByProid = lstContract.Where(s => s.ProfileID == workHistory.ProfileID).OrderByDescending(s => s.DateEnd).FirstOrDefault();
if (_ContractByProid != null )
{
//lấy mức lương điều chỉnh theo phuk lục hợp đông mới nhất.
#region lấy mức lương điều chỉnh theo phuk lục hợp đông mới nhất.
var _AppendixContract = lstAppdixContract.Where(s => s.ContractID == _ContractByProid.ID).OrderByDescending(s => s.DateofEffect).ToList();
if (_AppendixContract != null && _AppendixContract.Count > 0)
{
#region Salary
int stt = 0;
do
{
if (_AppendixContract[stt].Salary != null)
{
_ContractByProid.Salary = _AppendixContract[stt].Salary;
break;
}
stt++;
} while (_AppendixContract[stt].Salary == null || stt < _AppendixContract.Count);
#endregion
#region Allowance1
stt = 0;
do
{
if (_AppendixContract[stt].Allowance1 != null)
{
_ContractByProid.Allowance1 = _AppendixContract[stt].Allowance1;
break;
}
stt++;
} while (_AppendixContract[stt].Allowance1 == null || stt < _AppendixContract.Count);
#endregion
#region Allowance2
stt = 0;
do
{
if (_AppendixContract[stt].Allowance2 != null)
{
_ContractByProid.Allowance2 = _AppendixContract[stt].Allowance2;
break;
}
stt++;
} while (_AppendixContract[stt].Allowance2 == null || stt < _AppendixContract.Count);
#endregion
#region Allowance3
stt = 0;
do
{
if (_AppendixContract[stt].Allowance3 != null)
{
_ContractByProid.Allowance3 = _AppendixContract[stt].Allowance3;
break;
}
stt++;
} while (_AppendixContract[stt].Allowance3 == null || stt < _AppendixContract.Count);
#endregion
#region Allowance4
stt = 0;
do
{
if (_AppendixContract[stt].Allowance4 != null)
{
_ContractByProid.Allowance4 = _AppendixContract[stt].Allowance4;
break;
}
stt++;
} while (_AppendixContract[stt].Allowance4 == null || stt < _AppendixContract.Count);
#endregion
}
workHistory.Salary = _ContractByProid.Salary;
workHistory.Allowance1 = _ContractByProid.Allowance1;
workHistory.Allowance2 = _ContractByProid.Allowance2;
workHistory.Allowance3 = _ContractByProid.Allowance3;
workHistory.Allowance4 = _ContractByProid.Allowance4;
#endregion
}
}
#endregion
string templatepath = Common.GetPath(Common.TemplateURL + template.TemplateFile);
outputPath = folferPath + "/" + Common.ChuyenTVKhongDau(workHistory.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(workHistory.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
var ilContract = new List<Hre_WorkHistoryEntity>();
ilContract.Add(workHistory);
ExportService.ExportWord(outputPath, templatepath, ilContract);
}
if (lstWorkHistory != null && lstWorkHistory.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportJobVacancyByTemplate(List<Guid> selectedIds, string valueFields)
{
DateTime DateStart = DateTime.Now;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
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 lstJobVacancy = baseService.GetData<Rec_JobVacancyEntity>(strIDs, ConstantSql.hrm_rec_sp_get_JobVacancyByIds, UserLogin, ref status);
if (lstJobVacancy == null)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportRec_JobVacancy" + suffix;
if (lstJobVacancy.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
int count = 0;
foreach (var JobVacancy in lstJobVacancy)
{
if (JobVacancy.DateProposal.HasValue)
{
JobVacancy.DateProposalFormat = JobVacancy.DateProposal.Value.ToString("dd/MM/yyyy");
}
if (JobVacancy.DateStart.HasValue)
{
JobVacancy.DateStartFormat = JobVacancy.DateStart.Value.ToString("dd/MM/yyyy");
}
if (JobVacancy.DateEnd.HasValue)
{
JobVacancy.DateEndFormat = JobVacancy.DateEnd.Value.ToString("dd/MM/yyyy");
}
if (JobVacancy.DateComplete.HasValue)
{
JobVacancy.DateCompleteFormat = JobVacancy.DateComplete.Value.ToString("dd/MM/yyyy");
}
if (JobVacancy.DateEndReceiveCV.HasValue)
{
JobVacancy.DateEndReceiveCVFormat = JobVacancy.DateEndReceiveCV.Value.ToString("dd/MM/yyyy");
}
ActionService service = new ActionService(UserLogin);
var exportService = new Cat_ExportServices();
Cat_ExportEntity template = null;
string outputPath = string.Empty;
if (!string.IsNullOrEmpty(valueFields))
{
List<object> lstObjExport = new List<object>();
var exportID = Guid.Parse(valueFields);
lstObjExport.Add(exportID);
template = exportService.GetData<Cat_ExportEntity>(exportID, ConstantSql.hrm_cat_sp_get_ExportById, UserLogin, ref status).FirstOrDefault();
}
if (template == null)
{
continue;
}
string templatepath = Common.GetPath(Common.TemplateURL + template.TemplateFile);
outputPath = folferPath + "/" + Common.ChuyenTVKhongDau(JobVacancy.Code) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(JobVacancy.Code) + suffix + i.ToString() + "_" + template.TemplateFile;
var ilJobVacancy = new List<Rec_JobVacancyEntity>();
ilJobVacancy.Add(JobVacancy);
ExportService.ExportWord(outputPath, templatepath, ilJobVacancy);
}
if (lstJobVacancy.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportWordEnrolledCandidateByTemplate(List<Guid> selectedIds, string valueFields)
{
DateTime DateStart = DateTime.Now;
string messages = string.Empty;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
var contractServices = new Rec_CandidateModel();
var baseService = new BaseService();
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 lstCandidate = baseService.GetData<Rec_CandidateEntity>(strIDs, ConstantSql.hrm_rec_sp_get_EnrolledCanIds, UserLogin, ref status);
if (lstCandidate == null)
return null;
int i = 0;
var lstCandidateID = lstCandidate.Select(s => s.ID).Distinct().ToList();
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_Contract" + suffix;
if (lstCandidateID.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var candidate in lstCandidate)
{
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 = exportService.GetData<Cat_ExportEntity>(lstObjExport, ConstantSql.hrm_cat_sp_get_ExportWord, ref status).Where(s => s.ScreenName == valueFields).FirstOrDefault();
if (!string.IsNullOrEmpty(valueFields))
{
template = exportService.GetData<Cat_ExportEntity>(Guid.Parse(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, UserLogin, ref status).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(candidate.CandidateName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(candidate.CandidateName) + suffix + i.ToString() + "_" + template.TemplateFile;
if (!System.IO.File.Exists(templatepath))
{
messages = "NotTemplate";
return Json(messages, JsonRequestBehavior.AllowGet);
}
var profile = service.GetByIdUseStore<Hre_ProfileEntity>(candidate.ID, ConstantSql.hrm_hr_sp_get_ProfileByCandidateID, ref status);
if (profile != null)
{
var liscontract = baseService.GetData<Hre_ContractEntity>(profile.ID, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, UserLogin, ref status);
if (liscontract.Count > 0)
{
liscontract = liscontract.OrderBy(m => m.DateSigned).ToList();
var contract = liscontract[0];
candidate.Salary = contract.Salary;
candidate.ContractNo = contract.ContractNo;
candidate.DateApplyContract = contract.DateStart;
candidate.DateSignedConstract = contract.DateSigned;
candidate.Currency = contract.CurenncyInsName;
}
}
var lstcontract = new List<Rec_CandidateEntity>();
lstcontract.Add(candidate);
ExportService.ExportWord(outputPath, templatepath, lstcontract);
}
if (lstCandidateID.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportContractWaitingByTemplate(List<Guid> selectedIds, string valueFields)
{
string messages = string.Empty;
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
var contractServices = new Hre_ContractServices();
var actionServices = new ActionService(UserLogin);
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);
objs.Add(strIDs);
var lstContract = actionServices.GetData<Hre_ContractEntity>(objs, ConstantSql.hrm_hr_sp_get_ContractsByListId, ref status);
if (lstContract == null)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_Contract" + suffix;
if (lstContract.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var contract in lstContract)
{
contract.DateNow = DateTime.Now.ToString("dd/MM/yyyy");
contract.DateNow_Day = DateTime.Now.Day.ToString();
contract.DateNow_Month = DateTime.Now.Month.ToString();
contract.DateNow_Year = DateTime.Now.Year.ToString();
contract.IDDateOfIssueFormat = contract.IDDateOfIssue.HasValue ? contract.IDDateOfIssue.Value.ToString("dd/MM/yyyy") : null;
if (contract.DateStart != null)
contract.DateStartFormat = contract.DateStart.ToString("dd/MM/yyyy");
if (contract.DateEnd.HasValue)
contract.DateEndFormat = contract.DateEnd.Value.ToString("dd/MM/yyyy");
if (contract.DateHire.HasValue)
contract.DateHireFormat = contract.DateHire.Value.ToString("dd/MM/yyyy");
if (contract.DateEndProbation.HasValue)
contract.DateEndProbationFormat = contract.DateEndProbation.Value.ToString("dd/MM/yyyy");
contract.SalaryFormat = contract.Salary.HasValue ? contract.Salary.Value.ToString("N") : "0";
if (contract.DateOfEffect.HasValue)
{
contract.DateOfEffectFormat = contract.DateOfEffect.Value.ToString("dd MMM yyyy");
contract.DateOfEffectMoreTwoMonthFormat = contract.DateOfEffect.Value.AddMonths(+2).ToString("dd MMM yyyy");
}
if (contract.Gender == "E_FEMALE")
{
contract.GraveName = "Ms." + contract.ProfileName.Substring(contract.ProfileName.LastIndexOf(' '));
}
else
{
contract.GraveName = "Mr." + contract.ProfileName.Substring(contract.ProfileName.LastIndexOf(' '));
}
if (contract.DateQuit.HasValue)
{
if (contract.DateHire.HasValue)
{
contract.MonthWorking = Math.Floor(contract.DateQuit.Value.Subtract(contract.DateHire.Value).TotalDays / 30);
contract.YearWorking = Math.Floor(contract.MonthWorking.Value / 12);
if (contract.YearWorking > 0)
{
contract.MonthWorking = contract.MonthWorking - (contract.YearWorking * 12);
}
}
}
else
{
contract.MonthWorking = Math.Floor(DateTime.Now.Subtract(contract.DateHire.Value).TotalDays / 30);
contract.YearWorking = Math.Floor(contract.MonthWorking.Value / 12);
if (contract.YearWorking > 0)
{
contract.MonthWorking = contract.MonthWorking - (contract.YearWorking * 12);
}
}
ActionService service = new ActionService(UserLogin);
var exportService = new Cat_ExportServices();
Cat_ExportEntity template = null;
string outputPath = string.Empty;
if (!string.IsNullOrEmpty(valueFields))
template = actionServices.GetData<Cat_ExportEntity>(Common.DotNetToOracle(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, ref status).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(contract.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(contract.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
var lstcontract = new List<Hre_ContractEntity>();
lstcontract.Add(contract);
ExportService.ExportWord(outputPath, templatepath, lstcontract);
}
if (lstContract.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportProfileRetirementByTemplate(List<Guid> selectedIds, string valueFields)
{
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
string messages = string.Empty;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
var contractServices = new Hre_ContractServices();
var actionService = new ActionService(UserLogin);
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);
objs.Add(strIDs);
var lstProfile = actionService.GetData<Hre_ProfileEntity>(objs, ConstantSql.hrm_hr_sp_get_ProfileRetirementByListId, ref status);
if (lstProfile == null)
return null;
int i = 0;
var lstProfileID = lstProfile.Select(s => s.ID).Distinct().ToList();
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_Contract" + suffix;
if (lstProfileID.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var profile in lstProfile)
{
if (profile.IDDateOfIssue.HasValue)
profile.IDDateOfIssueFormat = profile.IDDateOfIssue.Value.ToString("dd/MM/yyyy");
if (profile.DateOfBirth.HasValue)
profile.DateOfBirthFormat = profile.DateOfBirth.Value.ToString("dd/MM/yyyy");
if (profile.SocialInsIssueDate.HasValue)
profile.SocialInsIssueDateFormat = profile.SocialInsIssueDate.Value.ToString("dd/MM/yyyy");
if (profile.Salary != null)
profile.SalaryFormat = String.Format("{0:0,0}", profile.Salary);
if (profile.Allowance1 != null)
profile.Allowance1Format = String.Format("{0:0,0}", profile.Allowance1);
if (profile.DayOfBirth > 0 && profile.MonthOfBirth > 0 && profile.YearOfBirth > 0)
{
profile.Birthday = profile.DayOfBirth + "/" + profile.MonthOfBirth + "/" + profile.YearOfBirth;
}
if (profile.DateHire.HasValue)
{
profile.DateHireFormat = profile.DateHire.Value.ToString("dd/MM/yyyy");
}
profile.DateNow = DateTime.Now.ToString("dd/MM/yyyy");
if (profile.DateStart.HasValue)
{
profile.DateStartString = "Ngày " + profile.DateStart.Value.Day + " Tháng " + profile.DateStart.Value.Month + " Năm " + profile.DateStart.Value.Year + " ";
profile.DateStartFormat = profile.DateStart.Value.ToString("dd/MM/yyyy");
}
if (profile.DateEnd.HasValue)
{
profile.DateEndString = "Ngày " + profile.DateEnd.Value.Day + " Tháng " + profile.DateEnd.Value.Month + " Năm " + profile.DateEnd.Value.Year + " ";
profile.DateEndFormat = profile.DateEnd.Value.ToString("dd/MM/yyyy");
}
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);
if (!string.IsNullOrEmpty(valueFields))
{
template = actionService.GetData<Cat_ExportEntity>(Guid.Parse(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, ref status).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(profile.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(profile.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
if (!System.IO.File.Exists(templatepath))
{
messages = "NotTemplate";
return Json(messages, JsonRequestBehavior.AllowGet);
}
var lstcontract = new List<Hre_ProfileEntity>();
lstcontract.Add(profile);
ExportService.ExportWord(outputPath, templatepath, lstcontract);
}
if (lstProfileID.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportExpiryContractByTemplate(List<Guid> selectedIds, string valueFields)
{
string[] valueFieldsExportID = valueFields.Split(',');
valueFields = valueFieldsExportID[0];
string _exportID = valueFieldsExportID[1];
Guid exportID;
string messages = string.Empty;
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
var contractServices = new Hre_ContractServices();
var actionServices = new ActionService(UserLogin);
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 lstContract = actionServices.GetData<Hre_ContractEntity>(strIDs, ConstantSql.hrm_hr_sp_get_ContractsByListId, ref status);
if (lstContract == null)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_Contract" + suffix;
if (lstContract.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var contract in lstContract)
{
contract.DateNow = DateTime.Now.ToString("dd/MM/yyyy");
contract.IDDateOfIssueFormat = contract.IDDateOfIssue.HasValue ? contract.IDDateOfIssue.Value.ToString("dd/MM/yyyy") : null;
if (contract.DateStart != null)
{
contract.DateStartFormat = contract.DateStart.ToString("dd/MM/yyyy");
}
if (contract.DateEnd.HasValue)
{
contract.DateEndFormat = contract.DateEnd.Value.ToString("dd/MM/yyyy");
contract.DateEndMonth = contract.DateEnd.Value.Month;
contract.DateEndYear = contract.DateEnd.Value.Year;
contract.DateEndFormatEN = contract.DateEnd.Value.ToString("dd-MMM-yyyy");
}
if (contract.DateHire.HasValue)
{
contract.DateHireFormat = contract.DateHire.Value.ToString("dd/MM/yyyy");
contract.DateEndMonth = contract.DateHire.Value.Month;
contract.DateEndYear = contract.DateHire.Value.Year;
contract.DateHireFormatEN = contract.DateHire.Value.ToString("dd-MMM-yyyy");
}
if (contract.DateEndProbation.HasValue)
contract.DateEndProbationFormat = contract.DateEndProbation.Value.ToString("dd/MM/yyyy");
contract.SalaryFormat = contract.Salary.HasValue ? contract.Salary.Value.ToString("N") : "0";
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(Common.DotNetToOracle(valueFields));
//template = service.GetData<Cat_ExportEntity>(Common.DotNetToOracle(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, ref status).FirstOrDefault();
List<object> lstObjExport = new List<object>();
lstObjExport.Add(null);
lstObjExport.Add(null);
lstObjExport.Add(null);
lstObjExport.Add(null);
lstObjExport.Add(1);
lstObjExport.Add(10000000);
if (_exportID != "")
{
exportID = Guid.Parse(_exportID);
template = actionServices.GetData<Cat_ExportEntity>(lstObjExport, ConstantSql.hrm_cat_sp_get_ExportWord, ref status).Where(s => s.ScreenName == valueFields && s.ID == exportID).FirstOrDefault();
}
else
{
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(contract.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(contract.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
var lstcontract = new List<Hre_ContractEntity>();
lstcontract.Add(contract);
ExportService.ExportWord(outputPath, templatepath, lstcontract);
}
if (lstContract.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportWordProfileByTemplate(Guid selectedIds, string valueFields)
{
var actionService = new ActionService(UserLogin);
string messages = string.Empty;
//string folderStore = DateTime.Now.ToString("ddMMyyyyHHmmss");
DateTime DateStart = DateTime.Now;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
Directory.CreateDirectory(dirpath);
string status = string.Empty;
var contractServices = new Hre_ContractServices();
var baseService = new BaseService();
var lstProfile = actionService.GetData<Hre_ProfileEntity>(Common.DotNetToOracle(selectedIds.ToString()), ConstantSql.hrm_hr_sp_get_ProfileById, ref status);
if (lstProfile == null || lstProfile.Count == 0)
return null;
int i = 0;
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "ExportHre_Contract" + suffix;
if (lstProfile.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
foreach (var profile in lstProfile)
{
profile.DateNow = DateTime.Now.ToString("dd/MM/yyyy");
if (profile.DateStart.HasValue)
profile.DateStartFormat = profile.DateStart.Value.ToString("dd/MM/yyyy");
if (profile.RequestDate.HasValue)
profile.RequestDateFormat = profile.RequestDate.Value.ToString("dd/MM/yyyy");
if (profile.DateQuit.HasValue)
profile.DateQuitFormat = profile.DateQuit.Value.ToString("dd/MM/yyyy");
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 = actionService.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(profile.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(profile.ProfileName) + suffix + i.ToString() + "_" + template.TemplateFile;
var lstProfile1 = new List<Hre_ProfileEntity>();
lstProfile1.Add(profile);
ExportService.ExportWord(outputPath, templatepath, lstProfile1);
}
if (lstProfile.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public ActionResult ExportProfileComeBackByTemplate(List<Guid> selectedIds, string valueFields)
{
DateTime DateStart = DateTime.Now;
string messages = string.Empty;
string dirpath = Common.GetPath(Common.DownloadURL); ;
if (!Directory.Exists(dirpath))
{
Directory.CreateDirectory(dirpath);
}
string status = string.Empty;
var actionServices = new ActionService(UserLogin);
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);
}
objs.Add(strIDs);
var lstPerformance = actionServices.GetData<Hre_ReportProfileComeBackModel>(strIDs, ConstantSql.hrm_hr_sp_get_RptProfileComBackByID, ref status);
if (lstPerformance == null)
{
return null;
}
int i = 0;
var lstPerformanceID = lstPerformance.Select(s => s.ID).Distinct().ToList();
String suffix = DateStart.ToString("_ddMMyyyyHHmmss");
string folferPath = string.Empty;
string folderName = "Hre_ReportProfileComeBackModel" + suffix;
if (lstPerformanceID.Count > 1)
{
folferPath = dirpath + "/" + folderName;
Directory.CreateDirectory(folferPath);
}
else
{
folferPath = dirpath;
}
var fileDoc = string.Empty;
int fileOrderNumber = 0;
foreach (var performance in lstPerformance)
{
fileOrderNumber++;
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);
if (!string.IsNullOrEmpty(valueFields))
{
template = actionServices.GetData<Cat_ExportEntity>(Guid.Parse(valueFields), ConstantSql.hrm_cat_sp_get_ExportById, ref status).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(performance.ProfileName) + fileOrderNumber + suffix + i.ToString() + "_" + template.TemplateFile;
fileDoc = NotificationType.Success.ToString() + "," + Common.DownloadURL + "/" + Common.ChuyenTVKhongDau(performance.ProfileName) + fileOrderNumber + suffix + i.ToString() + "_" + template.TemplateFile;
if (!System.IO.File.Exists(templatepath))
{
messages = "NotTemplate";
return Json(messages, JsonRequestBehavior.AllowGet);
}
var lstPers = new List<Hre_ReportProfileComeBackModel>();
lstPers.Add(performance);
ExportService.ExportWord(outputPath, templatepath, lstPers);
}
if (lstPerformanceID.Count > 1)
{
var fileZip = Common.MultiExport("", true, folderName);
return Json(fileZip);
}
return Json(fileDoc);
}
public JsonResult GetScreenNameWord(string screenName)
{
var service = new Cat_ExportServices();
string status = string.Empty;
var result = service.GetData<CatExportModel>(screenName, ConstantSql.hrm_cat_sp_get_ExportWord_multi, UserLogin, ref status);
return Json(result, JsonRequestBehavior.AllowGet);
}
