public JsonResult Edit(int id)
{
Dictionary <string, object> result = new Dictionary <string, object>();
try
{
switch (Request["entity"])
{
case "callout_room":
callout_room calloutRoom = _dbContext.callout_room.Find(id);
serializeToCalloutRoomModel(ref calloutRoom);
_dbContext.SaveChanges();
break;
case "airticket":
airticket airticket = _dbContext.airtickets.Find(id);
serializeToAirticketModel(ref airticket);
_dbContext.SaveChanges();
break;
case "transfer":
transfer transfer = _dbContext.transfers.Find(id);
serializeToTransferModel(ref transfer);
_dbContext.SaveChanges();
break;
case "excursion_order":
excursion_order excursionOrder = _dbContext.excursion_order.Find(id);
serializeToExcursionOrderModel(ref excursionOrder);
_dbContext.SaveChanges();
break;
case "hotel_service_order":
hotel_service_order hotelServiceOrder = _dbContext.hotel_service_order.Find(id);
serializeToHotelServiceOrderModel(ref hotelServiceOrder);
_dbContext.SaveChanges();
break;
default:
throw new Exception("Error! Unexcepted entity");
}
_dbContext.SaveChanges();
}
catch (Exception exc)
{
result.Add("error", exc.Message);
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
public JsonResult Delete(int id, string type)
{
Dictionary <string, object> result = new Dictionary <string, object>();
try
{
switch (type)
{
case "callout_room":
callout_room calloutRoom = _dbContext.callout_room.Find(id);
_dbContext.callout_room.Remove(calloutRoom);
_dbContext.SaveChanges();
break;
case "airticket":
airticket airticket = _dbContext.airtickets.Find(id);
_dbContext.airtickets.Remove(airticket);
_dbContext.SaveChanges();
break;
case "transfer":
transfer transfer = _dbContext.transfers.Find(id);
_dbContext.transfers.Remove(transfer);
_dbContext.SaveChanges();
break;
case "excursion_order":
excursion_order excursionOrder = _dbContext.excursion_order.Find(id);
_dbContext.excursion_order.Remove(excursionOrder);
_dbContext.SaveChanges();
break;
case "hotel_service_order":
hotel_service_order hotelServiceOrder = _dbContext.hotel_service_order.Find(id);
_dbContext.hotel_service_order.Remove(hotelServiceOrder);
_dbContext.SaveChanges();
break;
default:
throw new Exception("Error! Unexcepted entity");
}
}
catch (Exception exc)
{
result.Add("error", exc.Message);
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
private void serializeToExcursionOrderModel(ref excursion_order excursionOrder)
{
excursionOrder.excursion_id = int.Parse(Request.Form["excursion_id"]);
excursionOrder.starting_address = Request.Form["starting_address"];
excursionOrder.starting_at = Utils.dtToTimestamp(Convert.ToDateTime(Request.Form["starting_at"]));
excursionOrder.created_at = Utils.dtToTimestamp(DateTime.Now);
excursionOrder.callout_id = int.Parse(Request.Form["callout_id"]);
excursionOrder.is_baby = Request.Form["is_baby"] == "on" ? 1 : 0;
excursionOrder.is_privilege = Request.Form["is_privilege"] == "on" ? 1 : 0;
excursion excursion = _dbContext.excursions.Find(excursionOrder.excursion_id);
excursionOrder.payment = excursionOrder.is_privilege == 1 ? (excursion.cost - excursion.cost / 2) : excursion.cost;
excursionOrder.payment = excursionOrder.is_baby == 1 ? 0 : excursionOrder.payment;
}
public ActionResult CalloutCreate(FavotiteListView favListView)
{
callout callout = new callout
{
fullname = favListView.Fullname,
email = favListView.Email,
phone = favListView.Phone,
created_at = Utils.dtToTimestamp(DateTime.Now)
};
if (Request.Form["is_predefined"] != null)
{
callout.is_predefined = sbyte.Parse(Request.Form["is_predefined"]);
}
_dbContext.callouts.Add(callout);
_dbContext.SaveChanges();
var rooms = _dbContext.rooms;
var list = Session["selected-check"] as List <int>;
if (list != null)
{
foreach (var item in list)
{
_dbContext.callout_room.Add(
new callout_room
{
callout_id = callout.id,
room_id = item,
created_at = Utils.dtToTimestamp(DateTime.Now)
});
_dbContext.SaveChanges();
}
}
Session["selected-check"] = null;
var list2 = Session["flight-check"] as List <int>;
if (list2 != null)
{
foreach (var item in list2)
{
_dbContext.airtickets.Add(
new airticket
{
callout_id = callout.id,
flight_id = item,
created_at = Utils.dtToTimestamp(DateTime.Now)
});
_dbContext.SaveChanges();
}
}
Session["flight-check"] = null;
var list3 = Session["route-check"] as List <int>;
if (list3 != null)
{
foreach (var item in list3)
{
_dbContext.transfers.Add(
new transfer
{
callout_id = callout.id,
route_id = item,
created_at = Utils.dtToTimestamp(DateTime.Now)
});
_dbContext.SaveChanges();
}
}
Session["route-check"] = null;
var list4 = Session["excursion-check"] as List <int>;
if (list4 != null)
{
foreach (var item in list4)
{
var eo = new excursion_order
{
callout_id = callout.id,
excursion_id = item,
created_at = Utils.dtToTimestamp(DateTime.Now),
starting_address = ""
};
_dbContext.excursion_order.Add(eo);
_dbContext.SaveChanges();
}
}
Session["excursion-check"] = null;
var list5 = Session["hotelservice-check"] as List <int>;
if (list5 != null)
{
foreach (var item in list5)
{
_dbContext.hotel_service_order.Add(
new hotel_service_order
{
callout_id = callout.id,
hotel_service_id = item,
created_at = Utils.dtToTimestamp(DateTime.Now)
});
_dbContext.SaveChanges();
}
}
Session["hotelservice-check"] = null;
_dbContext.SaveChanges();
return(View());
}
