public ActionResult PrintCareTracking(int careTrackingID) { CareTrackingVM viewModel = new CareTrackingVM(); CareTrackingRepository repository = new CareTrackingRepository(); CareTrackingDTO careTrackingDTO = repository.GetCareTrackingByID(careTrackingID); viewModel.ID = careTrackingDTO.CareTrackingID; viewModel.CareDate = careTrackingDTO.CareDate; viewModel.BusinessCenterID = careTrackingDTO.BusinessCenterID; viewModel.BusinessCenterDesc = careTrackingDTO.BusinessCenterName; viewModel.MachineGroupID = careTrackingDTO.MachineGroupID; viewModel.MachineGroupDesc = careTrackingDTO.MachineGroupName; viewModel.MachineID = careTrackingDTO.MachineID; viewModel.MachineDesc = careTrackingDTO.MachineName; viewModel.CareDescription = careTrackingDTO.CareDescription; viewModel.CareType = careTrackingDTO.CareType; viewModel.CareTypeDesc = careTrackingDTO.CareTypeDesc; viewModel.PlanedCareType = careTrackingDTO.PlanedCareType; viewModel.PlanedCareTypeDesc = careTrackingDTO.PlanedCareTypeDesc; viewModel.CareTeamType = careTrackingDTO.CareTeamType; viewModel.CareTeamTypeDesc = careTrackingDTO.CareTeamTypeDesc; //viewModel.ResultTypeDesc = careTrackingDTO.ResultTypeDesc; //viewModel.ResultDescription = careTrackingDTO.ResultDescription; viewModel.RCareTrackingDetailList = repository.GetCareTrackingDetailsByCTID(careTrackingDTO.CareTrackingID); return(View(viewModel)); }
public ActionResult Index(int?page, string vl, string prm = null) { CareTrackingRepository repository = new CareTrackingRepository(); try { Search search = new Search(); search = SetValue(page, vl, prm); int pageSize = 15; int pageNumber = (page ?? 1); CareTrackingVM viewModel = new CareTrackingVM(); viewModel.Search = search; viewModel.Search.pageSize = pageSize; viewModel.Search.pageNumber = pageNumber; viewModel.RCareTrackingList = repository.SW_GetCareTrackings(viewModel.Search); viewModel.ListCount = repository.SW_GetCareTrackingsCount(viewModel.Search); int[] pc = new int[viewModel.ListCount]; viewModel.Paging = pc.ToPagedList(pageNumber, pageSize); return(Request.IsAjaxRequest() ? (ActionResult)PartialView("PartialIndex", viewModel) : View(viewModel)); } catch (Exception ex) { return(View("Error", new HandleErrorInfo(ex, "Error", "Error"))); } }
public ActionResult CareTrackingDetailIndex(int careTrackingID) { CareTrackingRepository repository = new CareTrackingRepository(); List <CareTrackingDetailDTO> careTrackingDetailDTOs = repository.GetCareTrackingDetailsByCTID(careTrackingID); CareTrackingVM viewModel = new CareTrackingVM(); viewModel.ID = careTrackingID; viewModel.RCareTrackingDetailList = careTrackingDetailDTOs; return(View(viewModel)); }
public void DownloadExcel(int?careTrackingID) { Search search = new Search(); // search = SetValue(page, vl, prm); if (careTrackingID != null) { search.Id = (int)careTrackingID; } //int pageSize = 15; //int pageNumber = (page ?? 1); CareTrackingRepository careTrackingRepository = new CareTrackingRepository(); IList <CareTrackingDTO> careTrackingDTOs = careTrackingRepository.SW_GetCareTrackingsForExcel(search); ExcelPackage Ep = new ExcelPackage(); ExcelWorksheet Sheet = Ep.Workbook.Worksheets.Add("Baxim Izləmə"); #region Əsas başlıq Sheet.Cells[1, 1, 1, 18].Merge = true; Sheet.Cells[1, 1].Value = "BAXIM İZLƏMƏ HESABATI"; Sheet.Cells[1, 1].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[1, 1].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[1, 1].Style.Fill.BackgroundColor.SetColor(Color.Red); Sheet.Cells[1, 1].Style.Font.Bold = true; Sheet.Cells[1, 1].Style.Font.Size = 14; Sheet.Cells[1, 1].Style.Font.Color.SetColor(Color.White); #endregion #region Cədvəl başlığı Sheet.Cells[2, 1].Value = "Baxım vaxtı"; Sheet.Cells[2, 1].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 1].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 1].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 1].Style.Font.Bold = true; Sheet.Cells[2, 1].Style.Font.Size = 12; Sheet.Cells[2, 1].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 2].Value = "İş merkezi adı"; Sheet.Cells[2, 2].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 2].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 2].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 2].Style.Font.Bold = true; Sheet.Cells[2, 2].Style.Font.Size = 12; Sheet.Cells[2, 2].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 3].Value = "Makina grubu adı"; Sheet.Cells[2, 3].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 3].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 3].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 3].Style.Font.Bold = true; Sheet.Cells[2, 3].Style.Font.Size = 12; Sheet.Cells[2, 3].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 4].Value = "Makina adı"; Sheet.Cells[2, 4].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 4].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 4].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 4].Style.Font.Bold = true; Sheet.Cells[2, 4].Style.Font.Size = 12; Sheet.Cells[2, 4].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 5].Value = "Təmir və ya baxım işinin təsviri"; Sheet.Cells[2, 5].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 5].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 5].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 5].Style.Font.Bold = true; Sheet.Cells[2, 5].Style.Font.Size = 12; Sheet.Cells[2, 5].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 6].Value = "Baxım növü"; Sheet.Cells[2, 6].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 6].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 6].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 6].Style.Font.Bold = true; Sheet.Cells[2, 6].Style.Font.Size = 12; Sheet.Cells[2, 6].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 7].Value = "Planlı baxım növü"; Sheet.Cells[2, 7].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 7].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 7].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 7].Style.Font.Bold = true; Sheet.Cells[2, 7].Style.Font.Size = 12; Sheet.Cells[2, 7].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 8].Value = "Baxım komandası"; Sheet.Cells[2, 8].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 8].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 8].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 8].Style.Font.Bold = true; Sheet.Cells[2, 8].Style.Font.Size = 12; Sheet.Cells[2, 8].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 9].Value = "Başlama tarixi"; Sheet.Cells[2, 9].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 9].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 9].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 9].Style.Font.Bold = true; Sheet.Cells[2, 9].Style.Font.Size = 12; Sheet.Cells[2, 9].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 10].Value = "Başlama zamanı"; Sheet.Cells[2, 10].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 10].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 10].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 10].Style.Font.Bold = true; Sheet.Cells[2, 10].Style.Font.Size = 12; Sheet.Cells[2, 10].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 11].Value = "Bitiş tarixi"; Sheet.Cells[2, 11].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 11].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 11].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 11].Style.Font.Bold = true; Sheet.Cells[2, 11].Style.Font.Size = 12; Sheet.Cells[2, 11].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 12].Value = "Bitiş zamanı"; Sheet.Cells[2, 12].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 12].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 12].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 12].Style.Font.Bold = true; Sheet.Cells[2, 12].Style.Font.Size = 12; Sheet.Cells[2, 12].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 13].Value = "Keçən zaman"; Sheet.Cells[2, 13].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 13].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 13].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 13].Style.Font.Bold = true; Sheet.Cells[2, 13].Style.Font.Size = 12; Sheet.Cells[2, 13].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 14].Value = "Aciqlama"; Sheet.Cells[2, 14].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 14].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 14].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 14].Style.Font.Bold = true; Sheet.Cells[2, 14].Style.Font.Size = 12; Sheet.Cells[2, 14].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 15].Value = "Mexanik(Soyad Ad Ata adı)"; Sheet.Cells[2, 15].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 15].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 15].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 15].Style.Font.Bold = true; Sheet.Cells[2, 15].Style.Font.Size = 12; Sheet.Cells[2, 15].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 16].Value = "Təhvil alan şexs (Soyad Ad Ata adı)"; Sheet.Cells[2, 16].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 16].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 16].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 16].Style.Font.Bold = true; Sheet.Cells[2, 16].Style.Font.Size = 12; Sheet.Cells[2, 16].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 17].Value = "Nəticə"; Sheet.Cells[2, 17].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 17].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 17].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 17].Style.Font.Bold = true; Sheet.Cells[2, 17].Style.Font.Size = 12; Sheet.Cells[2, 17].Style.Font.Color.SetColor(Color.Black); Sheet.Cells[2, 18].Value = "Nəticə təsviri"; Sheet.Cells[2, 18].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[2, 18].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[2, 18].Style.Fill.BackgroundColor.SetColor(Color.LightGray); Sheet.Cells[2, 18].Style.Font.Bold = true; Sheet.Cells[2, 18].Style.Font.Size = 12; Sheet.Cells[2, 18].Style.Font.Color.SetColor(Color.Black); #endregion int rowcounter = 2; foreach (CareTrackingDTO careTracking in careTrackingDTOs) { rowcounter++; bool flagResultType = false; if (careTracking.careTrackingDetailDTO != null && careTracking.careTrackingDetailDTO.ResultType == 5) { flagResultType = true; } if (flagResultType) { Sheet.Cells[rowcounter, 1].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 1].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 1].Value = careTracking.CareDate.ToShortDateString(); Sheet.Cells[rowcounter, 1].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 1].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 2].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 2].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 2].Value = careTracking.BusinessCenterName; Sheet.Cells[rowcounter, 2].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 2].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 3].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 3].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 3].Value = careTracking.MachineGroupName; Sheet.Cells[rowcounter, 3].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 3].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 4].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 4].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 4].Value = careTracking.MachineName; Sheet.Cells[rowcounter, 4].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 4].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 5].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 5].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 5].Value = careTracking.CareDescription; Sheet.Cells[rowcounter, 5].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[rowcounter, 5].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 6].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 6].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 6].Value = careTracking.CareTypeDesc; Sheet.Cells[rowcounter, 6].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 6].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 7].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 7].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 7].Value = careTracking.PlanedCareTypeDesc; Sheet.Cells[rowcounter, 7].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[rowcounter, 7].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 8].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 8].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 8].Value = careTracking.CareTeamTypeDesc; Sheet.Cells[rowcounter, 8].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[rowcounter, 8].Style.Font.Size = 12; if (careTracking.careTrackingDetailDTO != null) { if (flagResultType) { Sheet.Cells[rowcounter, 9].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 9].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 9].Value = careTracking.careTrackingDetailDTO.StartDate == null?null:((DateTime)careTracking.careTrackingDetailDTO.StartDate).ToShortDateString(); Sheet.Cells[rowcounter, 9].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 9].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 10].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 10].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 10].Value = careTracking.careTrackingDetailDTO.StartTimeDesc; Sheet.Cells[rowcounter, 10].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[rowcounter, 10].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 11].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 11].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 11].Value = careTracking.careTrackingDetailDTO.EndDate == null ? null : ((DateTime)careTracking.careTrackingDetailDTO.EndDate).ToShortDateString(); Sheet.Cells[rowcounter, 11].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 11].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 12].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 12].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 12].Value = careTracking.careTrackingDetailDTO.EndTimeDesc; Sheet.Cells[rowcounter, 12].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[rowcounter, 12].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 13].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 13].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 13].Value = careTracking.careTrackingDetailDTO.DurationTime; Sheet.Cells[rowcounter, 13].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 13].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 14].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 14].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 14].Value = careTracking.careTrackingDetailDTO.Description; Sheet.Cells[rowcounter, 14].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 14].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 15].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 15].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 15].Value = careTracking.careTrackingDetailDTO.MechanicSAA; Sheet.Cells[rowcounter, 15].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 15].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 16].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 16].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 16].Value = careTracking.careTrackingDetailDTO.ReceivingPersonSAA; Sheet.Cells[rowcounter, 16].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 16].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 17].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 17].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 17].Value = careTracking.careTrackingDetailDTO.ResultTypeDesc; Sheet.Cells[rowcounter, 17].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; Sheet.Cells[rowcounter, 17].Style.Font.Size = 12; if (flagResultType) { Sheet.Cells[rowcounter, 18].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; Sheet.Cells[rowcounter, 18].Style.Fill.BackgroundColor.SetColor(Color.Coral); } Sheet.Cells[rowcounter, 18].Value = careTracking.careTrackingDetailDTO.ResultDescription; Sheet.Cells[rowcounter, 18].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; Sheet.Cells[rowcounter, 18].Style.Font.Size = 12; } } Sheet.Cells["A:AZ"].AutoFitColumns(); for (int k = 1; k <= rowcounter; k++) { Sheet.Row(k).Height = 23; Sheet.Row(k).Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; } using (ExcelRange range = Sheet.Cells[1, 1, rowcounter, 18]) { range.Style.Border.Top.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; range.Style.Border.Top.Color.SetColor(Color.Gray); range.Style.Border.Left.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; range.Style.Border.Left.Color.SetColor(Color.Gray); range.Style.Border.Right.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; range.Style.Border.Right.Color.SetColor(Color.Gray); range.Style.Border.Bottom.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; range.Style.Border.Bottom.Color.SetColor(Color.Gray); } Response.Clear(); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", "attachment; filename=" + "Baxim_Izleme_Hesabati_" + String.Format("{0:yyyyMMdd_HHmmss}", DateTime.Now) + ".xlsx;"); Response.BinaryWrite(Ep.GetAsByteArray()); Ep.Dispose(); Response.End(); }