public string Get(int id, string tp, string qh, int rp, DateTime nc, DateTime gc, int p, int idnd, int lg, string ghe, DateTime nd, decimal gv)
{
JArray array = JsonConvert.DeserializeObject <JArray>(ghe);
LinkedList <VeModel> list = new LinkedList <VeModel>();
for (int i = 0; i < array.Count; i++)
{
VeModel veModel = new VeModel
{
IdPhim = id,
ThanhPho = tp,
QuanHuyen = qh,
IdRap = rp,
NgayChieu = nc,
GioChieu = gc,
IdPhong = p,
IdNguoiDung = idnd,
IdLoaiGhe = lg,
TenGhe = array[i].ToString(),
NgayDat = nd,
GiaVe = gv,
};
list.AddLast(veModel);
_context.Add(veModel);
_context.SaveChanges();
}
return(JsonConvert.SerializeObject(list));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,IdNguoiDung,IdLoaiGhe,IdPhong,IdPhim,ThanhPho,QuanHuyen,IdRap,NgayChieu,GioChieu,TenGhe,NgayDat,GiaVe")] VeModel veModel)
{
if (id != veModel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(veModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VeModelExists(veModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["IdLoaiGhe"] = new SelectList(_context.LoaiGhe, "Id", "TenLoaiGhe", veModel.IdLoaiGhe);
ViewData["IdNguoiDung"] = new SelectList(_context.NguoiDung, "Id", "TaiKhoan", veModel.IdNguoiDung);
ViewData["IdPhim"] = new SelectList(_context.Phim, "Id", "TenPhim", veModel.IdPhim);
ViewData["IdPhong"] = new SelectList(_context.Phong, "Id", "TenPhong", veModel.IdPhong);
return(View(veModel));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Gia,MaHoaDon,MaGhe,MaSuat,TrangThai")] VeModel veModel)
{
if (id != veModel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(veModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VeModelExists(veModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["MaGhe"] = new SelectList(_context.tb_Ghe, "Id", "Id", veModel.MaGhe);
ViewData["MaHoaDon"] = new SelectList(_context.tb_HoaDon, "Id", "Id", veModel.MaHoaDon);
ViewData["MaSuat"] = new SelectList(_context.tb_SuatChieu, "Id", "Id", veModel.MaSuat);
return(View(veModel));
}
public async Task <IActionResult> Create([Bind("Id,Gia,MaHoaDon,MaGhe,MaSuat,TrangThai")] VeModel veModel)
{
if (ModelState.IsValid)
{
_context.Add(veModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["MaGhe"] = new SelectList(_context.tb_Ghe, "Id", "Id", veModel.MaGhe);
ViewData["MaHoaDon"] = new SelectList(_context.tb_HoaDon, "Id", "Id", veModel.MaHoaDon);
ViewData["MaSuat"] = new SelectList(_context.tb_SuatChieu, "Id", "Id", veModel.MaSuat);
return(View(veModel));
}
public async Task <IActionResult> Create([Bind("Id,IdNguoiDung,IdLoaiGhe,IdPhong,IdPhim,ThanhPho,QuanHuyen,IdRap,NgayChieu,GioChieu,TenGhe,NgayDat,GiaVe")] VeModel veModel)
{
if (ModelState.IsValid)
{
_context.Add(veModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["IdLoaiGhe"] = new SelectList(_context.LoaiGhe, "Id", "TenLoaiGhe", veModel.IdLoaiGhe);
ViewData["IdNguoiDung"] = new SelectList(_context.NguoiDung, "Id", "TaiKhoan", veModel.IdNguoiDung);
ViewData["IdPhim"] = new SelectList(_context.Phim, "Id", "TenPhim", veModel.IdPhim);
ViewData["IdPhong"] = new SelectList(_context.Phong, "Id", "TenPhong", veModel.IdPhong);
return(Json(veModel));
}
public async Task <string> PostVe(Ve ve)
{
var tt = from r in _context.RapChieuPhim
join p in _context.Phong on r.Id equals p.IdRapChieu
join lc in _context.LichChieu on p.Id equals lc.IdPhong
join sc in _context.SuatChieu on lc.Id equals sc.IdLichChieu
where sc.Id == ve.id
select new
{
Tp = r.ThanhPho,
qh = r.QuanHuyen,
idr = r.Id,
nd = DateTime.Now.Date,
};
JObject nguoidung = JObject.Parse(HttpContext.Session.GetString("nguoidung"));
NguoiDungModel mem = new NguoiDungModel();
mem.Id = (int)nguoidung.SelectToken("Id");
decimal Gia = 0;
if (tt != null)
{
foreach (string ghe in ve.dsghe.Split(","))
{
VeModel Ve = new VeModel();
Ve.IdSuatChieu = (int)ve.id;
Ve.TenGhe = ghe;
Ve.ThanhPho = tt.Select(t => t.Tp).FirstOrDefault();
Ve.QuanHuyen = tt.Select(t => t.qh).FirstOrDefault();
Ve.IdRap = tt.Select(t => t.idr).FirstOrDefault();
Ve.NgayDat = tt.Select(t => t.nd).FirstOrDefault();
Ve.IdLoaiGhe = LoaiGhe(ghe);
Ve.GiaVe = TinhTien(Ve.IdSuatChieu, Ve.IdLoaiGhe);
Ve.IdNguoiDung = mem.Id;
try
{
_context.Add(Ve);
await _context.SaveChangesAsync();
Gia += Ve.GiaVe;
}
catch { return("{\"result\":\"" + false + "\"}"); }
}
}
return("{\"result\":\"" + Gia + "vnd\"}");
}
