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