public string UpdBateooking([FromBody] dynamic id) { try { //ObservableCollection<IDictionary<string, object>> obj = JsonConvert.DeserializeObject<ObservableCollection<IDictionary<string, object>>>(Convert.ToString(id)); //string Status = string.Empty; //foreach (Dictionary<string, object> header in obj) //{ // prxybooking = JsonConvert.DeserializeObject<ProxyBooking>(Convert.ToString(header["hostHeader"].ToString())); //} int bookid = Convert.ToInt32(id); // var tblboking = (from rec in _TripstarContext.TblBooking where rec.BookingId == bookid select rec).FirstOrDefault(); TblBooking tblbooking = (from rec in _TripstarContext.TblBooking where rec.BookingId == bookid select rec).FirstOrDefault(); if (tblbooking != null) { tblbooking.IsApproved = true; // _TripstarContext.Add(tblbooking); _TripstarContext.SaveChanges(); } return("true"); } catch (Exception ex) { return("false"); } }
public string PostBooking([FromBody] dynamic id) { try { ObservableCollection <IDictionary <string, object> > obj = JsonConvert.DeserializeObject <ObservableCollection <IDictionary <string, object> > >(Convert.ToString(id)); string Status = string.Empty; foreach (Dictionary <string, object> header in obj) { prxybooking = JsonConvert.DeserializeObject <ProxyBooking>(Convert.ToString(header["hostHeader"].ToString())); } TblBooking tblbooking = new TblBooking(); tblbooking.CheckIn = Convert.ToDateTime(prxybooking.booking_CheckIn); tblbooking.CheckOut = Convert.ToDateTime(prxybooking.booking_CheckOut); tblbooking.HostId = prxybooking.booking_HostID; tblbooking.UsreId = prxybooking.booking_UserID; tblbooking.Nofguests = prxybooking.booking_Noofguests; tblbooking.IsApproved = prxybooking.booking_IsApproved; _TripstarContext.Add(tblbooking); _TripstarContext.SaveChanges(); var bookingid = tblbooking.BookingId; return(Convert.ToString(bookingid)); } catch (Exception ex) { return("false"); } }
public async Task <IActionResult> Create([Bind("BoatId,CustomerName")] TblBooking tblBooking) { if (ModelState.IsValid) { var isRegistered = _context.TblRegister.ToList().Exists(x => x.Id == tblBooking.BoatId); if (isRegistered) { var isExist = _context.TblBooking.ToList().Exists(x => x.BoatId == tblBooking.BoatId); if (isExist) { ViewBag.Message = "Already Exist"; return(View()); } _context.Add(tblBooking); await _context.SaveChangesAsync(); ViewBag.Message = "Booking Confirmed!!!"; } else { ViewBag.Message = "Boat Number is Invalid"; } } return(View()); }
public void deleteBooking([FromBody] dynamic id) { // ObservableCollection<IDictionary<string, object>> obj = JsonConvert.DeserializeObject<ObservableCollection<IDictionary<string, object>>>(Convert.ToString(id)); int bookingID = Convert.ToInt32(id); tblBooking = (from rec in _TripstarContext.TblBooking where rec.BookingId == bookingID select rec).FirstOrDefault(); _TripstarContext.Remove(tblBooking); _TripstarContext.SaveChanges(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { bookList = new List <TblBooking>(); DataTable dt = db.DisplayBookings(); foreach (DataRow row in dt.Rows) { TblBooking r = new TblBooking(); r.FullName = row[0].ToString(); r.RoomType = row[1].ToString(); r.RoomNo = row[2].ToString(); r.Guests = Convert.ToInt32(row[3].ToString()); r.CheckedIn = row[4].ToString(); r.CheckedOut = row[5].ToString(); r.Total = Convert.ToDecimal(row[6].ToString()); bookList.Add(r); } BindEvent(); } }