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;
}
}
