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