public JsonResult EditBooking(int id) { int timeId = id; //Set time var now = preUni.getCurrentTime(); string branchName; int branchCode; using (NCBranch db = new NCBranch()) { using (Db dbUser = new Db()) { var user = dbUser.Users.Find(User.Identity.Name); branchCode = user.BranchCode; branchName = user.BranchName; } var booking = db.Bookings.Where(x => x.BranchCode == branchCode).OrderByDescending(x => x.BookDate).FirstOrDefault(); booking.UpdateDate = now; booking.ScanTimeID = id; db.SaveChanges(); preUni.logging(User.Identity.Name, "Booking change : " + booking.BookDate + booking.ScanTimeID); } return(Json(new { success = true, message = "Booking changed", branchName = branchName })); }
public JsonResult MakeBooking(int id) { int timeId = id; //Set time var now = preUni.getCurrentTime(); //Get this friday(5) DayOfWeek desiredDay = DayOfWeek.Friday; int offsetAmount = (int)desiredDay - (int)DateTime.Now.DayOfWeek; var bookDate = new DateTime(now.Year, now.Month, now.Day).AddDays(offsetAmount); string branchName; using (NCBranch db = new NCBranch()) { var booking = new BranchBookingDTO() { ScanTimeID = timeId, BookDate = bookDate, CreateDate = now, }; using (Db dbUser = new Db()){ var user = dbUser.Users.Find(User.Identity.Name); booking.BranchCode = user.BranchCode; branchName = user.BranchName; } if (booking.BranchCode == 4) { return(Json(new { success = false, message = "Only branch can book.", branchName = branchName })); } if (db.Bookings.Any(x => x.BookDate == bookDate && x.ScanTimeID == booking.ScanTimeID)) { return(Json(new { success = false, message = "This time is aready booked.", branchName = branchName })); } db.Bookings.Add(booking); preUni.logging(User.Identity.Name, "Booking : " + booking.BookDate + booking.ScanTimeID); db.SaveChanges(); } return(Json(new { success = true, message = "Booking succeed.", branchName = branchName })); }