public string UpdateBorrower(BorrowerReturnDto data)
{
var model = new BorrowerDao().UpdateBorrower(data);
if (model == true)
{
return("OK");
}
else
{
return("Fail");
}
}
public bool InsertBorrower(List <BorrowerDto> data)
{
new EmployDao().InsertAndUpdate(data);
var borrower = new BorrowerDao().InsertBorrower(data);
if (borrower)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult ExportBorrower()
{
int idCate = 0;
var data = new BorrowerDao().GetAllBorrower(idCate);
var result = data.Select(x => new
{
x.DepartName,
x.EmployName,
x.DevcieName,
x.Quantity,
x.DateBorrow
}).ToList();
var excelPackage = new ExcelPackage();
// Add Sheet vào file Excel
excelPackage.Workbook.Worksheets.Add("Report Sheet");
var workSheet = excelPackage.Workbook.Worksheets[1];
workSheet.Cells[2, 1].LoadFromCollection(result);
workSheet.Cells[1, 1].Value = "Bộ Phận ";
workSheet.Cells[1, 2].Value = "Người mượn";
workSheet.Cells[1, 3].Value = "Tên thiết bị";
workSheet.Cells[1, 4].Value = "Số lượng mượn";
workSheet.Cells[1, 5].Value = "Ngày mượn";
using (var range = workSheet.Cells[1, 1, 1, 5])
{
// Set PatternType
range.Style.Fill.PatternType = ExcelFillStyle.Solid;
// Set color Background
range.Style.Fill.BackgroundColor.SetColor(Color.Green);
// Canh gi?a cho các text
range.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
// Set Font cho text trong Range hi?n t?i
range.Style.Font.SetFromFont(new System.Drawing.Font("Arial", 14));
//Set Border
//range.Style.Border.Bottom.Style = ExcelBorderStyle.Medium;
////// Set color Border
//range.Style.Border.Bottom.Color.SetColor(Color.Blue);
// Set color text
range.Style.Font.Color.SetColor(Color.White);
}
var rowData = result.Count() + 1;
workSheet.Cells[1, 1, rowData, 5].AutoFitColumns();
using (var range = workSheet.Cells[1, 1, rowData, 5])
{
range.Style.Font.Size = 12;
range.Style.Border.Top.Style = ExcelBorderStyle.Thin;
range.Style.Border.Left.Style = ExcelBorderStyle.Thin;
range.Style.Border.Right.Style = ExcelBorderStyle.Thin;
range.Style.Border.Bottom.Style = ExcelBorderStyle.Thin;
range.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
}
workSheet.Cells[2, 5, rowData, 5].Style.Numberformat.Format = "dd-mm-yyyy";
excelPackage.Save();
var buffer = excelPackage.Stream as MemoryStream;
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("Content-Disposition", "attachment; filename=List_Borrower" + DateTime.Now.ToString("-ddMMyy_hhmmss") + ".xlsx");
// Luu file excel c?a chúng ta nhu 1 m?ng byte d? tr? v? response
Response.BinaryWrite(buffer.ToArray());
// Send t?t c? ouput bytes v? phía clients
Response.Flush();
Response.End();
return(View());
}
