private string OutExcelByIdKhachHang(int id)
{
var folderReport = "/Reports";
string filePath = HttpContext.Current.Server.MapPath(folderReport);
if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
// template File
string templateDocument = HttpContext.Current.Server.MapPath("~/Reports/TemplateForReport/ReportLinhHaDetail.xlsx");
string documentName = string.Format("BaoCaoLinhHa-{0}-{1}.xlsx", id, DateTime.Now.ToString("ddmmyyyyss"));
string fullPath = Path.Combine(filePath, documentName);
//result Output
MemoryStream output = new MemoryStream();
//read template
FileStream templateDocumentStream = File.OpenRead(templateDocument);
ExcelPackage package = new ExcelPackage(templateDocumentStream);
ExcelWorksheet sheet = package.Workbook.Worksheets["Sheet1"];
var kh = _khachHangService.GetDetail(id);
sheet.Cells[7, 2, 7, 3].Value = kh.Name;
sheet.Cells[8, 2].Value = kh.Address;
sheet.Cells[9, 2].Value = kh.Id;
sheet.Cells[10, 2].Value = kh.PhoneNumber;
sheet.Cells[5, 10].Value = DateTime.Now.ToString("dd/MM/yyyy");
var khachhang = _chitietKhachHangService.GetMultilById(id);
int i = 0;
decimal totalCountMoney = 0;
foreach (var item in khachhang)
{
totalCountMoney += item.CTNoLai;
sheet.Cells[8 + i, 6].Value = i;
sheet.Cells[8 + i, 7].Value = item.NgayChuaBenh.ToString("dd/MM/yyyy");
sheet.Cells[8 + i, 8].Value = item.ChiPhiChuaBenh;
sheet.Cells[8 + i, 9].Value = item.CTNoLai;
sheet.Cells[8 + i, 10].Value = "Quá dài";
i++;
}
sheet.Cells[11, 2, 14, 3].Value = totalCountMoney;
package.SaveAs(new FileInfo(fullPath));
return(documentName);
}
public HttpResponseMessage GetDetailById(HttpRequestMessage request, int id)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response = null;
var model = _khachHangService.GetDetail(id);
if (model == null)
{
response = request.CreateResponse(HttpStatusCode.BadRequest, "no data");
}
else
{
var mapper = Mapper.Map <KhachHang, KhachHangViewModel>(model);
response = request.CreateResponse(HttpStatusCode.OK, mapper);
}
return response;
}));
}