public ActionResult Index(FormCollection coll) { string mess = ""; ViewBag.Title = Conf.TITLE + "Phương thức thanh toán"; List <phuong_thuc_thanh_toan> listPT = this.GetData(); for (int i = 0; i < listPT.Count; i++) { if (coll[i.ToString()] != null) { phuong_thuc_thanh_toan pt = db.phuong_thuc_thanh_toans.Where(x => x.id_pt == int.Parse(coll[i.ToString()])).Single(); List <dat_hang> listOrder = db.dat_hangs.Where(x => x.id_pt == pt.id_pt).ToList(); foreach (dat_hang dh in listOrder) { List <dat_hang_detail> listOrderDetailt = db.dat_hang_details.Where(id => id.id_dathang == dh.id_dathang).ToList(); db.dat_hang_details.DeleteAllOnSubmit(listOrderDetailt); } db.dat_hangs.DeleteAllOnSubmit(listOrder); db.phuong_thuc_thanh_toans.DeleteOnSubmit(pt); } } try { db.SubmitChanges(); mess = Lib.messenger(0, "Xóa thành công!"); } catch (Exception ex) { mess = Lib.messenger(2, "Xóa thất bại! " + ex.ToString()); } ViewBag.error = mess; return(View(this.GetData())); }
public ActionResult Add(FormCollection coll) { string mess = ""; ViewBag.Title = Conf.TITLE + "Thêm phương thức thanh toán"; try { phuong_thuc_thanh_toan pt = new phuong_thuc_thanh_toan(); pt.ten_phuongthuc = coll["txtTen"].ToString(); pt.chitiet = coll["txtChiTiet"].ToString(); db.phuong_thuc_thanh_toans.InsertOnSubmit(pt); db.SubmitChanges(); mess = Lib.messenger(0, "Thêm thành công!"); } catch (Exception ex) { mess = Lib.messenger(2, "Thêm thất bại!"); } ViewBag.error = mess; return(View()); }