public ActionResult Upload(HttpPostedFileBase file)
{
if (file.ContentLength > 0)
{
string _FileName = "DemoUploadFile.xlsx";
string _path = Path.Combine(Server.MapPath("~/Uploads/Excels"), _FileName);
file.SaveAs(_path);
ViewBag.upload = _path;
DataTable dt = new DataTable();
dt = xl.ReadDataFromExcelFile(_path);
for (int i = 0; i < dt.Rows.Count; i++)
{
Bangchamcong bcc = new Bangchamcong();
bcc.Mabangcong = "BCC01";
bcc.Maphongban = dt.Rows[i][0].ToString();
db.Bangchamcongs.Add(bcc);
db.SaveChanges();
}
}
else
{
ViewBag.upload = "Upload file không thành công";
}
return(View());
}