예제 #1
0
파일: QLDOAN.cs 프로젝트: Viet-Hoa/qltour
        public static void sua(DOAN d)
        {
            var dd = db.DOANs.Find(d.ID);

            db.Entry(dd).CurrentValues.SetValues(d);
            db.SaveChanges();
        }
예제 #2
0
 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);
 }
예제 #3
0
 public static int sua(DOAN d)
 {
     try
     {
         DAO.QLDOAN.sua(d);
         return(1);
     }
     catch (Exception ex)
     {
         Console.WriteLine(ex.Message);
         return(0);
     }
 }
예제 #4
0
파일: QLDOAN.cs 프로젝트: Viet-Hoa/qltour
 public static void them(DOAN d)
 {
     db.DOANs.Add(d);
     db.SaveChanges();
 }
예제 #5
0
        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);
                }
            }
        }
예제 #6
0
 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);
 }