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);
}
