public ActionResult ExportDateEndVisaInfoList([DataSourceRequest] DataSourceRequest request, Hre_VisaInfoSearchModel model)
{
return ExportAllAndReturn<Hre_VisaInfoEntity, Hre_VisaInfoModel, Hre_VisaInfoSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_VisaInfoDateEndList);
}
public ActionResult GetDateEndInfoListss([DataSourceRequest] DataSourceRequest request, Hre_VisaInfoSearchModel Model)
{
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = Model.DateEnd ?? 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_VisaInfoModel(),
FileName = "Hre_VisaInfoModel",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
var service = new ActionService(UserLogin);
List<object> listObj = new List<object>();
listObj.Add(Model.DateEnd);
listObj.Add(Model.DateTo);
listObj.Add(null);
listObj.Add(null);
string status = string.Empty;
var result = service.GetData<Hre_VisaInfoEntity>(listObj, ConstantSql.hrm_hr_sp_get_VisaInfoDateEndList, ref status).ToList().Translate<Hre_VisaInfoModel>();
var lstprofileids = result.Select(s => s.Visa_ID).ToList();
foreach (var item in result)
{
Guid profileID = item.Visa_ID;
// item.Visa_ID. = result.Count(s => s.Visa_ID == profileID);
}
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result, listHeaderInfo, Model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}