public string Update(int id, string doanTen, DateTime?doanNgayDi, DateTime?doanNgayVe, float?doanHotelCost, float?doanFoodCost, float?doanVehicleCost, float?doanAdditionalCost, string tourCode) { var dateQuery = _db.Database.SqlQuery <DateTime>("SELECT getdate()"); DateTime serverDate = dateQuery.AsEnumerable().First(); var message = ""; try { Tour a = Models.TourModel.Instance.GetByCode(tourCode); Doan updateItem = _db.Doans.Find(id); updateItem.DoanTen = doanTen; updateItem.DoanNgayTao = serverDate; updateItem.DoanTourPrice = a.TourPrice; updateItem.DoanAdditionalCost = doanAdditionalCost; updateItem.DoanHotelCost = doanHotelCost; updateItem.DoanFoodCost = doanFoodCost; updateItem.DoanVehicleCost = doanVehicleCost; updateItem.DoanNgayDi = doanNgayDi; updateItem.DoanNgayVe = doanNgayVe; updateItem.FkTour = a.TourId; updateItem.DoanTourPrice = a.TourPrice; _db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); message = e.Message; } return(message); }
public string Insert(string doanTen, DateTime?doanNgayDi, DateTime?doanNgayVe, float?doanHotelCost, float?doanFoodCost, float?doanVehicleCost, float?doanAdditionalCost, string tourCode) { var dateQuery = _db.Database.SqlQuery <DateTime>("SELECT getdate()"); DateTime serverDate = dateQuery.AsEnumerable().First(); var message = ""; try { Tour a = Models.TourModel.Instance.GetByCode(tourCode); Doan newItem = new Doan() { DoanTen = doanTen, DoanCode = GenerateCode(), DoanNgayTao = serverDate, DoanTourPrice = a.TourPrice, FkTour = a.TourId, DoanAdditionalCost = doanAdditionalCost, DoanHotelCost = doanHotelCost, DoanFoodCost = doanFoodCost, DoanNgayDi = doanNgayDi, DoanNgayVe = doanNgayVe, DoanVehicleCost = doanVehicleCost, DoanTrangThai = Applications.Constants.Db.Doan.STATUS_INIT }; _db.Doans.Add(newItem); _db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); message = e.Message; } return(message); }
public string UpdateStatus(int id, int status) { var message = ""; try { Doan updateItem = _db.Doans.Find(id); updateItem.DoanTrangThai = status; _db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e); message = e.Message; } return(message); }