public async Task <IActionResult> Edit(int id, [Bind("DoitacId,DoitacTen,DoitacMota,DoitacHinhanh")] TbDoiTac tbDoiTac)
{
if (id != tbDoiTac.DoitacId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tbDoiTac);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TbDoiTacExists(tbDoiTac.DoitacId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tbDoiTac));
}
public async Task <IActionResult> Edit(int id, [Bind("VideohuongdanId,VideohuongdanTieude,VideohuongdanHinhanh,VideohuongdanLinkvideo")] TbVideoHuongDan tbVideoHuongDan)
{
if (id != tbVideoHuongDan.VideohuongdanId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tbVideoHuongDan);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TbVideoHuongDanExists(tbVideoHuongDan.VideohuongdanId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tbVideoHuongDan));
}
public async Task <IActionResult> Edit(int id, [Bind("SukienId,SukienNgaygio,SukienDiachi,SukienMota")] TbSuKien tbSuKien)
{
if (id != tbSuKien.SukienId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tbSuKien);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TbSuKienExists(tbSuKien.SukienId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tbSuKien));
}
public async Task <IActionResult> Edit(int id, [Bind("LienheId,LienheCoso,LienheTencose,LienheDiachi,LienheDienthoai,LienheEmail,LienheLinkfb,LienheLinktw,LienheLinkin,LienheLinkgmap")] TbLienHe tbLienHe)
{
if (id != tbLienHe.LienheId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tbLienHe);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TbLienHeExists(tbLienHe.LienheId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tbLienHe));
}
public async Task <IActionResult> Edit(int id, [Bind("LoaicamnangId,LoaicamnangTieude")] TbLoaiCamNang tbLoaiCamNang)
{
if (id != tbLoaiCamNang.LoaicamnangId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tbLoaiCamNang);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TbLoaiCamNangExists(tbLoaiCamNang.LoaicamnangId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tbLoaiCamNang));
}
public async Task <IActionResult> Edit(int id, TbKhachHangDanhGia tbKhachHangDanhGia, IFormFile KhachhangdanhgiaHinhanh)
{
if (id != tbKhachHangDanhGia.KhachhangdanhgiaId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
if (KhachhangdanhgiaHinhanh != null)
{
var fileName = ContentDispositionHeaderValue.Parse(KhachhangdanhgiaHinhanh.ContentDisposition).FileName.Trim('"');
string ImageName = Guid.NewGuid().ToString() + Path.GetExtension(KhachhangdanhgiaHinhanh.FileName);
var path = Path.Combine(Directory.GetCurrentDirectory(), $"wwwroot\\Uploadimages\\{ImageName}");
var pathView = $"\\Uploadimages\\{ImageName}";
using (var stream = new FileStream(path, FileMode.Create))
{
await KhachhangdanhgiaHinhanh.CopyToAsync(stream);
}
tbKhachHangDanhGia.KhachhangdanhgiaHinhanh = pathView;
//tbSlide.CamnangNgaytao = DateTime.Now;
}
try
{
_context.Update(tbKhachHangDanhGia);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TbKhachHangDanhGiaExists(tbKhachHangDanhGia.KhachhangdanhgiaId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tbKhachHangDanhGia));
}
public async Task <IActionResult> Edit(int id, TbCamNang tbCamNang, IFormFile CamnangHinhanh)
{
// string fileName = "";
//if (tbCamNang != null)
//{
// fileName = tbCamNang.CamnangHinhanh;
// var path = Path.Combine(Directory.GetCurrentDirectory(), $"wwwroot\\{fileName}");
// if (System.IO.File.Exists(path)) System.IO.File.Create(path);
// //return NotFound();
//}
//if (id != tbCamNang.CamnangId)
//{
// return NotFound();
//}
if (ModelState.IsValid)
{
if (CamnangHinhanh != null)
{
var fileName = ContentDispositionHeaderValue.Parse(CamnangHinhanh.ContentDisposition).FileName.Trim('"');
string ImageName = Guid.NewGuid().ToString() + Path.GetExtension(CamnangHinhanh.FileName);
var path = Path.Combine(Directory.GetCurrentDirectory(), $"wwwroot\\Uploadimages\\{ImageName}");
var pathView = $"\\Uploadimages\\{ImageName}";
using (var stream = new FileStream(path, FileMode.Create))
{
await CamnangHinhanh.CopyToAsync(stream);
}
tbCamNang.CamnangHinhanh = pathView;
}
//else
//{
// var hinhanh = _context.TbCamNang.FirstOrDefault(x => x.CamnangId == id);
// string anhcu = hinhanh.CamnangHinhanh;
// tbCamNang.CamnangHinhanh = anhcu;
//}
try
{
_context.Update(tbCamNang);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TbCamNangExists(tbCamNang.CamnangId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
IList <CamNang> studentList = new List <CamNang>();
var student = (from tb in _context.TbCamNang
join lcn in _context.TbLoaiCamNang on tb.LoaicamnangId equals lcn.LoaicamnangId
select new
{
tb.CamnangId,
tb.CamnangTieude,
tb.CamnangMota,
tb.CamnangNoidung,
tb.CamnangHinhanh,
tb.LoaicamnangId,
lcn.LoaicamnangTieude,
}).ToList();
foreach (var i in student)
{
studentList.Add(new CamNang()
{
CamnangId = i.CamnangId, CamnangTieude = i.CamnangTieude, CamnangMota = i.CamnangMota, CamnangHinhanh = i.CamnangHinhanh, CamnangNoidung = i.CamnangNoidung, LoaicamnangId = i.LoaicamnangId, LoaicamnangTieude = i.LoaicamnangTieude
});
}
ViewData["students"] = studentList;
return(View());
//return View(tbCamNang);
}
public JsonResult BookingOperation()
{
string OperationID = HttpContext.Request.Form["operationID"];
long ClassID = long.Parse(HttpContext.Request.Form["classID"]);
long RoomID = long.Parse(HttpContext.Request.Form["roomID"]);
long locationID = long.Parse(HttpContext.Request.Form["locationID"]);
Location location = db_context.Locations.AsNoTracking().Single(x => x.LocationID == locationID);
var result = new { StatusCode = "", Message = "" };
switch (OperationID)
{
case "1":
{
long userID = long.Parse(HttpContext.Request.Form["userID"]);
int SpotNumber = int.Parse(HttpContext.Request.Form["spotNumber"]);
if (userID == 0)
{
result = new
{
StatusCode = "Error",
Message = "Please Select a Member"
};
return(Json(result));
}
else
{
if (db_context.Reservations.AsNoTracking().Where(x => x.SeatNumber == SpotNumber && x.RoomLayoutID == RoomID && x.ReservationStatus == 1).Count() > 0)
{
result = new
{
StatusCode = "Error",
Message = "Seat already reserved"
};
return(Json(result));
}
if (db_context.Reservations.AsNoTracking().Where(x => x.ClassID == ClassID && x.RoomLayoutID == RoomID && x.UserID == userID && x.ReservationStatus == 1).Count() > 0)
{
result = new
{
StatusCode = "Error",
Message = "Member already enrolled"
};
return(Json(result));
}
else
{
Reservation r = new Reservation();
r.UserID = userID;
r.RoomLayoutID = RoomID;
r.ClassID = ClassID;
r.ReservationDate = DateTime.UtcNow.ToTimeZoneTime(location.TimeZone);
r.SeatNumber = SpotNumber;
r.ReservationStatus = 1;
r.SignedIn = 0;
db_context.Add(r);
db_context.SaveChanges();
result = new
{
StatusCode = "Success",
Message = "Seat booked successfully"
};
return(Json(result));
}
}
}
case "2": //Cancel Reservation
{
int SpotNumber = int.Parse(HttpContext.Request.Form["spotNumber"]);
long reservationID = long.Parse(HttpContext.Request.Form["reservationID"]);
Reservation r = db_context.Reservations.AsNoTracking().SingleOrDefault(x => x.ReservationID == reservationID && x.ClassID == ClassID && x.RoomLayoutID == RoomID);
r.ReservationStatus = 2;
db_context.Update(r);
db_context.SaveChanges();
Reservation waitlistEntry = db_context.Reservations.AsNoTracking().Where(x => x.ClassID == ClassID && x.RoomLayoutID == RoomID && x.ReservationStatus == 9).OrderBy(x => x.ReservationDate).FirstOrDefault();
List <Reservation> Reservations = db_context.Reservations.AsNoTracking().Where(x => x.ClassID == ClassID && x.RoomLayoutID == RoomID).ToList();
if (waitlistEntry != null)
{
if (RoomID != 0)
{
RoomLayout roomLayout = db_context.RoomLayouts.AsNoTracking().SingleOrDefault(x => x.RoomLayoutID == RoomID);
dynamic layout = System.Json.JsonObject.Parse(roomLayout.SeatMatrix);
foreach (var entry in layout)
{
if (entry.JsonType == System.Json.JsonType.Object)
{
if (entry["S"] == "C")
{
if (Reservations.Where(x => x.SeatNumber == int.Parse(entry["SN"])).Count() == 0)
{
waitlistEntry.SeatNumber = int.Parse(entry["SN"]);
waitlistEntry.ReservationStatus = 1;
db_context.Update(waitlistEntry);
db_context.SaveChanges();
break;
}
}
}
}
}
}
result = new
{
StatusCode = "Success",
Message = "Successfully cancelled the reservation"
};
return(Json(result));
}
case "20": //Put Spot Under Maintenance
{
string SpotNumber = HttpContext.Request.Form["spotNumber"];
Reservation r = new Reservation();
r.UserID = 0;
r.RoomLayoutID = RoomID;
r.ClassID = ClassID;
r.ReservationDate = DateTime.UtcNow.ToTimeZoneTime(location.TimeZone);
r.SeatNumber = int.Parse(SpotNumber);
r.ReservationStatus = 3;
r.SignedIn = 0;
db_context.Add(r);
db_context.SaveChanges();
result = new
{
StatusCode = "Success",
Message = "Seat flagged as Under Maintenance"
};
return(Json(result));
}
default:
{
break;
}
}
return(Json(true));
}
