public ActionResult ExportExcelAssignings() { BaseAssigningsBLL AssigningBLL = AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal); var data = Json(new { data = AssigningBLL.GetAssignings().Select(x => new { x.AssigningID, EmployeeCodeNo = x.EmployeeCareerHistory.EmployeeCode.EmployeeCodeNo, EmployeeNameAr = x.EmployeeCareerHistory.EmployeeCode.Employee.EmployeeNameAr, AssigningStartDate = Globals.Calendar.GetUmAlQuraDate(x.AssigningStartDate), AssigningEndDate = x.AssigningEndDate.HasValue ? Globals.Calendar.GetUmAlQuraDate(x.AssigningEndDate.Value) : "", OrganizationName = x.AssigningType.AssigningTypeID == (int)AssigningsTypesEnum.Internal ? ((InternalAssigningBLL)x).Organization.FullOrganizationName : ((ExternalAssigningBLL)x).ExternalOrganization, JobName = x.AssigningType.AssigningTypeID == (int)AssigningsTypesEnum.Internal ? ((InternalAssigningBLL)x).Job.JobName : string.Empty, IsFinished = x.IsFinished, }) }, JsonRequestBehavior.AllowGet); Dictionary <string, string> ColumnNames = new Dictionary <string, string> { { "AssigningID", Resources.Globalization.SequenceNoText }, { "EmployeeCodeNo", Resources.Globalization.EmployeeCodeNoText }, { "EmployeeNameAr", Resources.Globalization.EmployeeNameArText }, { "AssigningStartDate", Resources.Globalization.AssigningStartDateText }, { "AssigningEndDate", Resources.Globalization.AssigningEndDateText }, { "IsFinished", Resources.Globalization.AssigningIsFinishedText }, { "OrganizationName", Resources.Globalization.OrganizationNameText }, { "JobName", Resources.Globalization.JobNameText } }; string fileName = ExcelHelper.ExportToExcel(Json(data), ColumnNames); return(Json(new { DownLoadFile = fileName }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetAssignings() { BaseAssigningsBLL AssigningBLL = AssigingsFactory.CreateAssigning(AssigningsTypesEnum.Internal); AssigningBLL.Search = Search; AssigningBLL.Order = Order; AssigningBLL.OrderDir = OrderDir; AssigningBLL.StartRec = StartRec; AssigningBLL.PageSize = PageSize; var data = AssigningBLL.GetAssignings(out TotalRecordsOut, out RecFilterOut).Select(x => new { x.AssigningID, EmployeeCodeNo = x.EmployeeCareerHistory.EmployeeCode.EmployeeCodeNo, EmployeeNameAr = x.EmployeeCareerHistory.EmployeeCode.Employee.EmployeeNameAr, AssigningStartDate = x.AssigningStartDate, AssigningEndDate = x.AssigningEndDate, IsFinished = x.IsFinished, }); return(Json(new { draw = Convert.ToInt32(Draw), recordsTotal = TotalRecordsOut, recordsFiltered = RecFilterOut, data = data }, JsonRequestBehavior.AllowGet)); }