public ActionResult Update_GV(FormCollection form) { if (!AuthCheck("admin")) { return(RedirectToAction("Index", "QLHome")); } string id = form["idGV_edit"].ToString(); gia_ve gv = db.gia_ve.Where(item => item.id == id).FirstOrDefault(); gv.ten = form["tenGV_edit"].ToString(); gv.don_gia = int.Parse(form["dongiaGV_edit"]); db.SaveChanges(); return(Redirect(Url.Action("Index", "QLSetting") + "#GV")); }
private static void InitDataGenerator(string type) { QLBanVePhimEntities db = new QLBanVePhimEntities(); switch (type) { case "GiaVe": if (db.gia_ve.Where(x => x.id == "WEEKDAY").ToList().Count() == 0) { gia_ve gv = new gia_ve(); gv.id = "WEEKDAY"; gv.ten = "Ngay Thuong"; gv.don_gia = 50000; db.gia_ve.Add(gv); } if (db.gia_ve.Where(x => x.id == "WEEKEND").ToList().Count() == 0) { gia_ve gv2 = new gia_ve(); gv2.id = "WEEKEND"; gv2.ten = "Cuoi Tuan"; gv2.don_gia = 70000; db.gia_ve.Add(gv2); } db.SaveChanges(); break; case "LoaiGhe": if (db.loai_ghe.Where(x => x.id == "NORMAL").ToList().Count() == 0) { loai_ghe lg = new loai_ghe(); lg.id = "NORMAL"; lg.ten_ghe = "Normal"; lg.phu_thu = 0; db.loai_ghe.Add(lg); } if (db.loai_ghe.Where(x => x.id == "VIP").ToList().Count() == 0) { loai_ghe lg2 = new loai_ghe(); lg2.id = "VIP"; lg2.ten_ghe = "VIP"; lg2.phu_thu = 0; db.loai_ghe.Add(lg2); } db.SaveChanges(); break; case "FoodSize": if (db.kich_co_do_an.Where(x => x.id == "S").ToList().Count() == 0) { kich_co_do_an fs = new kich_co_do_an { id = "S", ten = "Nhỏ" }; db.kich_co_do_an.Add(fs); } if (db.kich_co_do_an.Where(x => x.id == "M").ToList().Count() == 0) { kich_co_do_an fs2 = new kich_co_do_an { id = "M", ten = "Vừa" }; db.kich_co_do_an.Add(fs2); } if (db.kich_co_do_an.Where(x => x.id == "L").ToList().Count() == 0) { kich_co_do_an fs3 = new kich_co_do_an { id = "L", ten = "Lớn" }; db.kich_co_do_an.Add(fs3); } db.SaveChanges(); break; case "DDP": if (db.dinh_dang_phim.Where(x => x.id == "2d").ToList().Count() == 0) { dinh_dang_phim ddp = new dinh_dang_phim { id = "2d", ten = "2D", phu_thu = 0 }; db.dinh_dang_phim.Add(ddp); } if (db.dinh_dang_phim.Where(x => x.id == "3d").ToList().Count() == 0) { dinh_dang_phim ddp2 = new dinh_dang_phim { id = "3d", ten = "3D", phu_thu = 20000 }; db.dinh_dang_phim.Add(ddp2); } db.SaveChanges(); break; default: break; } }
public ActionResult OrderTicket(string suatChieu, string dsGhe) { try { Random random = new Random(); string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789qwertyuiopasdfghjklzxcvbnm"; //Session["Id"] = 1; //Dòng trên chỉ để test code suat_chieu sc = database.suat_chieu.Where(s => s.id == suatChieu).FirstOrDefault(); ve_dat veDat = new ve_dat(); string[] listGhe = dsGhe.Split(','); int tienDinhDangPhim = 0; int tongTien = 0; if (sc.dinh_dang_phim_id != "2D") { tienDinhDangPhim = (int)sc.dinh_dang_phim.phu_thu; } string randomChar = new string(Enumerable.Repeat(chars, 3).Select(s => s[random.Next(s.Length)]).ToArray()); veDat.id = Session["Id"].ToString() + "-" + sc.id + "-" + DateTime.Now.Second + randomChar; veDat.khach_hang_id = Convert.ToInt32(Session["Id"]); veDat.ngay_dat = DateTime.Now.Date; database.ve_dat.Add(veDat); database.SaveChanges(); string randomChr = new string(Enumerable.Repeat(chars, 5).Select(s => s[random.Next(s.Length)]).ToArray()); foreach (var item in listGhe) { ve_ban veBan = new ve_ban(); ve_dat_chi_tiet veDatChiTiet = new ve_dat_chi_tiet(); ghe_ngoi ghe = database.ghe_ngoi.Where(g => g.id == item).FirstOrDefault(); ghe.da_chon = true; veBan.id = sc.id + "-" + ghe.id + "-" + randomChr; veBan.suat_chieu_id = sc.id; if (DateTime.Today.DayOfWeek == DayOfWeek.Saturday || DateTime.Today.DayOfWeek == DayOfWeek.Sunday) { veBan.gia_ve_id = "WEEKEND"; gia_ve giaVe = database.gia_ve.Where(gv => gv.id == veBan.gia_ve_id).FirstOrDefault(); veBan.tong__tien = tienDinhDangPhim + ghe.loai_ghe.phu_thu + giaVe.don_gia; tongTien += (int)veBan.tong__tien; } else { veBan.gia_ve_id = "WEEKDAY"; gia_ve giaVe = database.gia_ve.Where(gv => gv.id == veBan.gia_ve_id).FirstOrDefault(); veBan.tong__tien = tienDinhDangPhim + ghe.loai_ghe.phu_thu + giaVe.don_gia; tongTien += (int)veBan.tong__tien; } veBan.ghe_id = ghe.id; veBan.trang_thai = "Book"; veBan.nhan_vien_id = database.nguoi_dung.FirstOrDefault().id; //Dòng trên chỉ để test code veDatChiTiet.id = veBan.id; veDatChiTiet.ve_dat_id = veDat.id; database.ve_ban.Add(veBan); database.ve_dat_chi_tiet.Add(veDatChiTiet); database.SaveChanges(); } TempData["CodeDatVe"] = veDat.id.ToString(); TempData["MaKhachHang"] = veDat.khach_hang_id.ToString(); TempData["Phim"] = sc.phim.ten.ToString(); TempData["ThoiLuong"] = sc.phim.thoi_luong.ToString(); TempData["BatDau"] = sc.gio_bat_dau.ToString(); TempData["TongTien"] = tongTien.ToString(); return(Redirect("Confirmation")); } catch (Exception ex) { return(Content(ex.ToString())); } }