public static void sua(DOAN d) { var dd = db.DOANs.Find(d.ID); db.Entry(dd).CurrentValues.SetValues(d); db.SaveChanges(); }
public ActionResult Edit([Bind(Include = "ID,TENDOAN,IDTOUR,NGAYBD,NGAYKT,CHITIET,CHIPHI")] DOAN d) { if (ModelState.IsValid) { int t = Core.BUS.QLDOAN_BUS.sua(d); if(t==1) return RedirectToAction("Index"); } ViewBag.IDTOUR = new SelectList(Core.BUS.QLTOUR_BUS.load(), "ID", "TENTOUR"); return View(d); }
public static int sua(DOAN d) { try { DAO.QLDOAN.sua(d); return(1); } catch (Exception ex) { Console.WriteLine(ex.Message); return(0); } }
public static void them(DOAN d) { db.DOANs.Add(d); db.SaveChanges(); }
public void AddNewTrip(string tendoan, int idtour, int slkh, int slpt, string ngaybd, string ngaykt, string mota, string tongchiphi, string doanhthu, ObservableCollection <CUSTOMER> customerlist, ObservableCollection <STAFF> stafflist, ObservableCollection <HOTEL> hotellist, ObservableCollection <VEHICLE> vehiclelist, ObservableCollection <EATING> eatinglist, ObservableCollection <OTHERCOST> othercostlist) { doan = new DOAN(); doan.TENDOAN = tendoan; doan.IDTOUR = idtour; doan.SOLUONGKH = slkh; doan.SOLUONGPT = slpt; doan.NGAYBATDAU = ngaybd; doan.NGAYKETTHUC = ngaykt; doan.MOTA = mota; doan.TONGCHIPHI = tongchiphi; doan.DOANHTHU = doanhthu; DataProvider.Ins.DB.DOAN.Add(doan); DataProvider.Ins.DB.SaveChanges(); if (customerlist != null) { foreach (var item in customerlist) { CUSTOMER_TRIP_DETAIL customer_list_detail = new CUSTOMER_TRIP_DETAIL(); customer_list_detail.AddNewCustomer_Trip_Detail(doan.IDDOAN, item.khachhang.IDKH); } } if (stafflist != null) { foreach (var item in stafflist) { STAFF_TRIP_DETAIL staff_list_detail = new STAFF_TRIP_DETAIL(); staff_list_detail.AddNewStaff_Trip_Detail(doan.IDDOAN, item.nhanvien.IDNV, item.NHIEMVU); } } if (hotellist != null) { foreach (var item in hotellist) { HOTEL_TRIP_DETAIL hotel_list_detail = new HOTEL_TRIP_DETAIL(); hotel_list_detail.AddNewHotel_Trip_Detail(doan.IDDOAN, item.khachsan.IDKS, item.TONGCHIPHI); } } if (eatinglist != null) { foreach (var item in eatinglist) { EATING_TRIP_DETAIL eating_trip_detail = new EATING_TRIP_DETAIL(); eating_trip_detail.AddNewEating_Trip_Detail(doan.IDDOAN, item.CHIPHIBUAAN, item.MOTA); } } if (othercostlist != null) { foreach (var item in othercostlist) { OTHERCOST_TRIP_DETAIL othercost_trip_detail = new OTHERCOST_TRIP_DETAIL(); othercost_trip_detail.AddNewOtherCost_Trip_Detail(doan.IDDOAN, item.CHIPHI, item.MOTA); } } if (vehiclelist != null) { foreach (var item in vehiclelist) { VEHICLE_TRIP_DETAIL vehicle_trip_detail = new VEHICLE_TRIP_DETAIL(); vehicle_trip_detail.AddNewVehicle_Trip_Detail(doan.IDDOAN, item.phuongtien.IDPT, item.phuongtien.GIATHUE); } } }
public ActionResult Edit(int id) { ViewBag.IDTOUR = new SelectList(Core.BUS.QLTOUR_BUS.load(), "ID", "TENTOUR"); DOAN d = Core.BUS.QLDOAN_BUS.findd(id); return View(d); }