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 async Task <IActionResult> Create([Bind("Id,BoatName,HourlyRate")] TblRegister tblRegister) { if (ModelState.IsValid) { var isExist = _context.TblRegister.ToList().Exists(x => x.BoatName.ToLower() == tblRegister.BoatName.ToLower() && x.HourlyRate == tblRegister.HourlyRate); if (isExist) { return(RedirectToAction(nameof(Error))); } _context.Add(tblRegister); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(tblRegister)); }