public JsonResult DeleteDonHang(int?ID) { using (ShopMusicAlbumContext _context = new ShopMusicAlbumContext()) { var donHang = _context.DonHangs.Find(ID); var chiTietDonHang = _context.ChiTietDonHangs.Where(m => m.DonHangID == ID); if (ID == null) { return(Json(data: "Not Deleted", behavior: JsonRequestBehavior.AllowGet)); } _context.DonHangs.Remove(donHang); foreach (var item in chiTietDonHang.ToList()) { var diemDanhGia = _context.DiemDanhGias.Where(m => m.ChiTietDonHangID == item.ChiTietDonHangID); foreach (var item2 in diemDanhGia.ToList()) { _context.DiemDanhGias.Remove(item2); } _context.ChiTietDonHangs.Remove(item); } var thongBao = _context.ThongBaos.Where(m => m.DongHangID == ID); foreach (var item3 in thongBao.ToList()) { _context.ThongBaos.Remove(item3); } _context.SaveChanges(); return(Json(data: "Deleted", behavior: JsonRequestBehavior.AllowGet)); } }
public ActionResult LoadData() { try { //Creating instance of DatabaseContext class using (ShopMusicAlbumContext _context = new ShopMusicAlbumContext()) { var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault(); var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault(); var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault(); //Paging Size (10,20,50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; // Getting all Book data var baiHatData = (from baiHat in _context.BaiHats join album in _context.Albums on baiHat.AlbumID equals album.AlbumID select new { baiHat.BaiHatID, baiHat.TenBaiHat, baiHat.ThoiLuong, Album = album.TenAlbum, }); //Sorting if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir))) { baiHatData = baiHatData.OrderBy(sortColumn + " " + sortColumnDir); } //Search if (!string.IsNullOrEmpty(searchValue)) { baiHatData = baiHatData.Where(m => m.TenBaiHat.Contains(searchValue)); } //total number of rows count recordsTotal = baiHatData.Count(); //Paging var data = baiHatData.Skip(skip).Take(pageSize).ToList(); //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data })); } } catch (Exception) { throw; } }
public JsonResult DeleteTheLoai(int?ID) { using (ShopMusicAlbumContext _context = new ShopMusicAlbumContext()) { var theLoai = _context.TheLoais.Find(ID); if (ID == null) { return(Json(data: "Not Deleted", behavior: JsonRequestBehavior.AllowGet)); } _context.TheLoais.Remove(theLoai); _context.SaveChanges(); return(Json(data: "Deleted", behavior: JsonRequestBehavior.AllowGet)); } }
public ActionResult LoadData() { try { //Creating instance of DatabaseContext class using (ShopMusicAlbumContext _context = new ShopMusicAlbumContext()) { var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault(); var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault(); var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault(); //Paging Size (10,20,50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; // Getting all Book data var khachHangData = (from khachHang in _context.KhachHangs select new { khachHang.KhachHangID, khachHang.TenKhachHang, khachHang.SDT, khachHang.DiaChi, khachHang.EmailKhachHang, khachHang.DiemKhachHang }); //Sorting if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir))) { khachHangData = khachHangData.OrderBy(sortColumn + " " + sortColumnDir); } //Search if (!string.IsNullOrEmpty(searchValue)) { khachHangData = khachHangData.Where(m => m.TenKhachHang.Contains(searchValue) || m.SDT.ToString().Contains(searchValue) || m.EmailKhachHang.ToString().Contains(searchValue) || m.DiaChi.ToString().Contains(searchValue)); } //total number of rows count recordsTotal = khachHangData.Count(); //Paging var data = khachHangData.Skip(skip).Take(pageSize).ToList(); //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data })); } } catch (Exception) { throw; } }
public ActionResult LoadData() { try { //Creating instance of DatabaseContext class using (ShopMusicAlbumContext _context = new ShopMusicAlbumContext()) { var draw = Request.Form.GetValues("draw").FirstOrDefault(); var start = Request.Form.GetValues("start").FirstOrDefault(); var length = Request.Form.GetValues("length").FirstOrDefault(); var sortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][name]").FirstOrDefault(); var sortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault(); var searchValue = Request.Form.GetValues("search[value]").FirstOrDefault(); //Paging Size (10,20,50,100) int pageSize = length != null?Convert.ToInt32(length) : 0; int skip = start != null?Convert.ToInt32(start) : 0; int recordsTotal = 0; // Getting all Book data var albumData = (from album in _context.Albums join tacGia in _context.TacGias on album.TacGiaID equals tacGia.TacGiaID join theLoai in _context.TheLoais on album.TheLoaiID equals theLoai.TheLoaiID join quocGia in _context.QuocGias on album.QuocGiaID equals quocGia.QuocGiaID select new { album.AlbumID, album.TenAlbum, album.GiaBan, album.SoLuong, album.NgayPhatHanh, album.DaBan, album.XuatXu, album.PhuKien, album.HinhAnh, TheLoai = theLoai.TenTheLoai, TacGia = tacGia.TenTacGia, QuocGia = quocGia.TenQuocGia, }); //Sorting if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDir))) { albumData = albumData.OrderBy(sortColumn + " " + sortColumnDir); } //Search if (!string.IsNullOrEmpty(searchValue)) { albumData = albumData.Where(m => m.TenAlbum.Contains(searchValue) || m.GiaBan.ToString().Contains(searchValue) || m.SoLuong.ToString().Contains(searchValue)); } //total number of rows count recordsTotal = albumData.Count(); //Paging var data = albumData.Skip(skip).Take(pageSize).ToList(); //Returning Json Data return(Json(new { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = data })); } } catch (Exception) { throw; } }