public ActionResult SaveAirBooking(AirInfo model, string FlightBookingId)
{
try
{
//check exist
var FlightBooking = db.FlightBookings.Find(Guid.Parse(FlightBookingId));
try
{
model.UpdatedAt = DateTime.Now;
model.UpdatedBy = user.Staff.UserName;
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
}
catch
{
model.CreatedAt = model.UpdatedAt = DateTime.Now;
model.CreatedBy = model.UpdatedBy = user.Staff.UserName;
db.AirInfoes.Add(model);
FlightBooking.AirId = model.Id;
db.SaveChanges();
}
return(Json(new { message = "Lưu chuyến bay thành công", status = true }, JsonRequestBehavior.AllowGet));
}
catch { return(Json(new { message = "Đã xảy ra lỗi trong quá trình lưu dữ liệu", status = false }, JsonRequestBehavior.AllowGet)); }
}
// GET: AirInfo/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AirInfo airInfo = db.AirInfoes.Find(id);
if (airInfo == null)
{
return(HttpNotFound());
}
return(View(airInfo));
}
public ActionResult Create(AirInfo airinfo)
{
try
{
if (ModelState.IsValid)
{
db.AirInfos.Add(airinfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
ModelState.AddModelError(String.Empty, ex);
}
return(View(airinfo));
}
public ActionResult Edit(AirInfo airInfo)
{
airInfo.UpdatedBy = user.Staff.UserName;
airInfo.UpdatedAt = DateTime.Now;
if (ModelState.IsValid)
{
try
{
db.Entry(airInfo).State = EntityState.Modified;
db.SaveChanges();
return(PartialView("~/views/Message/Add.cshtml"));
}
catch (Exception)
{
ModelState.AddModelError("error", "Có lỗi xảy ra, vui lòng kiểm tra lại dữ liệu");
}
}
return(View(airInfo));
}
public ActionResult Create()
{
AirInfo airinfo = new AirInfo();
return(View(airinfo));
}
private List <AirInfoCollection> DataSetToList(DataSet ds, AirTravelType att)
{
List <AirInfoCollection> list = new List <AirInfoCollection>();
AirInfoCollection airInfoCollection;
AirInfo airInfo;
foreach (DataTable dt in ds.Tables)
{
airInfoCollection = new AirInfoCollection()
{
FlightNum = dt.TableName
};
foreach (DataRow row in dt.Rows)
{
airInfo = new AirInfo()
{
CarrCode = CommonMethod.GetFomartString(row["CarrCode"]),
Carrier = CommonMethod.GetFomartString(row["Carrier"]),
FlightNo = CommonMethod.GetFomartString(row["FlightNo"]),
StartTime = CommonMethod.GetFomartString(row["StartTime"]),
FromCity = CommonMethod.GetFomartString(row["FromCity"]),
EndTime = CommonMethod.GetFomartString(row["EndTime"]),
ToCity = CommonMethod.GetFomartString(row["ToCity"]),
Model = CommonMethod.GetFomartString(row["Model"]),
IsStop = CommonMethod.GetFomartString(row["IsStop"]),
ABFee = CommonMethod.GetFomartString(row["ABFee"]),
FuelAdultFee = CommonMethod.GetFomartString(row["FuelAdultFee"]),
Space = CommonMethod.GetFomartString(row["Space"]),
TickNum = CommonMethod.GetFomartString(row["TickNum"]),
DiscountRate = CommonMethod.GetFomartString(row["DiscountRate"]),
XSFee = CommonMethod.GetFomartString(row["XSFee"]),
PMFee = CommonMethod.GetFomartString(row["PMFee"]),
DishonoredBillPrescript = CommonMethod.GetFomartString(row["DishonoredBillPrescript"]),
LogChangePrescript = CommonMethod.GetFomartString(row["LogChangePrescript"]),
UpCabinPrescript = CommonMethod.GetFomartString(row["UpCabinPrescript"]),
SpecialType = CommonMethod.GetFomartString(row["SpecialType"]),
aterm = CommonMethod.GetFomartString(row["aterm"]),
GUID = CommonMethod.GetFomartString(row["GUID"]),
};
if (att == AirTravelType.OneWay)
{
airInfo.PolicyGUID = CommonMethod.GetFomartString(row["PolicyGUID"]);
airInfo.HighPolicyFlag = CommonMethod.GetFomartString(row["HighPolicyFlag"]);
airInfo.LaterPoint = CommonMethod.GetFomartString(row["LaterPoint"]);
airInfo.Policy = CommonMethod.GetFomartString(row["Policy"]);
airInfo.ReturnMoney = CommonMethod.GetFomartString(row["ReturnMoney"]);
airInfo.Commission = CommonMethod.GetFomartString(row["Commission"]);
airInfo.SJFee = CommonMethod.GetFomartString(row["SJFee"]);
airInfo.GenerationType = CommonMethod.GetFomartString(row["GenerationType"]);
airInfo.SeatPrice = CommonMethod.GetFomartString(row["SeatPrice"]);
}
else
{
airInfo.PolicyGUID = string.Empty;
airInfo.HighPolicyFlag = string.Empty;
airInfo.LaterPoint = string.Empty;
airInfo.Policy = string.Empty;
airInfo.ReturnMoney = string.Empty;
airInfo.Commission = string.Empty;
airInfo.SJFee = string.Empty;
airInfo.GenerationType = string.Empty;
airInfo.SeatPrice = string.Empty;
}
airInfoCollection.AirInfoList.Add(airInfo);
}
if (airInfoCollection.AirInfoList.Count > 0)
{
list.Add(airInfoCollection);
}
}
return(list);
}
