public ActionResult DeleteConfirmed(int id)
{
Nhomhang nhomhang = db.Nhomhangs.Find(id);
db.Nhomhangs.Remove(nhomhang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Manhomhang,Tennhomhang,Mota")] Nhomhang nhomhang)
{
if (ModelState.IsValid)
{
db.Entry(nhomhang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nhomhang));
}
public ActionResult Create([Bind(Include = "Manhomhang,Tennhomhang,Mota")] Nhomhang nhomhang)
{
if (ModelState.IsValid)
{
db.Nhomhangs.Add(nhomhang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nhomhang));
}
// GET: Nhomhangs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Nhomhang nhomhang = db.Nhomhangs.Find(id);
if (nhomhang == null)
{
return(HttpNotFound());
}
return(View(nhomhang));
}
public ActionResult UploadFile(HttpPostedFileBase file)
{
//dat ten cho file
string _FileName = "NhomHang.xlsx";
//duong dan luu file
string _path = Path.Combine(Server.MapPath("~/Uploads/Excels"), _FileName);
//luu file len server
file.SaveAs(_path);
//doc du lieu tu file excel
DataTable dt = ReadDataFromExcelFile(_path);
for (int i = 0; i < dt.Rows.Count; i++)
{
Nhomhang kh = new Nhomhang();
kh.Tennhomhang = dt.Rows[i][0].ToString();
kh.Mota = dt.Rows[i][1].ToString();
db.Nhomhangs.Add(kh);
db.SaveChanges();
}
try
{
//upload file thanh cong va file co du lieu
if (file.ContentLength > 0)
{
//CopyDataByBulk(ReadDataFromExcelFile(_path));
ViewBag.ThongBao = "Upload file thanh cong";
}
}
catch (Exception ex)
{
//neu upload file that bai
ViewBag.ThongBao = "Upload file that bai";
}
return(RedirectToAction("Index"));
}
