public ActionResult UploadFile(HttpPostedFileBase file)
{
string _FileName = "thonggtin.xls";
string _path = Path.Combine(Server.MapPath("~/Uploads/Excels"), _FileName);
file.SaveAs(_path);
DataTable dt = ReadDataFromExcelFile(_path);
/* CopyDataByBulk(dt);*/
for (int i = 0; i < dt.Rows.Count; i++)
{
ThongTinKhachhang kr = new ThongTinKhachhang();
kr.TenKhachHang = dt.Rows[i][0].ToString();
kr.DiaChi = dt.Rows[i][1].ToString();
kr.SoDienThoai = dt.Rows[i][2].ToString();
db.ThongTinKhachhangs.Add(kr);
db.SaveChanges();
}
/* CopyDataByBulk(ReadDataFromExcelFile(_path));*/
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
ThongTinKhachhang thongTinKhachhang = db.ThongTinKhachhangs.Find(id);
db.ThongTinKhachhangs.Remove(thongTinKhachhang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,TenKhachHang,DiaChi,SoDienThoai")] ThongTinKhachhang thongTinKhachhang)
{
if (ModelState.IsValid)
{
db.Entry(thongTinKhachhang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thongTinKhachhang));
}
public ActionResult Create([Bind(Include = "ID,TenKhachHang,DiaChi,SoDienThoai")] ThongTinKhachhang thongTinKhachhang)
{
if (ModelState.IsValid)
{
db.ThongTinKhachhangs.Add(thongTinKhachhang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(thongTinKhachhang));
}
// GET: ThongTinKhachhangs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ThongTinKhachhang thongTinKhachhang = db.ThongTinKhachhangs.Find(id);
if (thongTinKhachhang == null)
{
return(HttpNotFound());
}
return(View(thongTinKhachhang));
}
