public IHttpActionResult GetListKhuyenMaiDangDuocApDung()
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
DateTime dateTime = DateTime.Now;
var tongKhuyenMai = db.KhuyenMais.Where(v => v.NgayBatDau.Value <= dateTime && v.NgayKetThuc.Value > dateTime).Select(n => new KhuyenMaiViewModel
{
MaKhuyenMai = n.MaKhuyenMai,
TenKhuyenMai = n.TenKhuyenMai,
GiaTri = n.GiaTri,
MoTa = n.MoTa,
NgayBatDau = n.NgayBatDau,
NgayKetThuc = n.NgayKetThuc,
});
if (tongKhuyenMai != null)
{
return(Ok(tongKhuyenMai.ToList()));
}
else
{
return(BadRequest());
}
}
}
public IHttpActionResult GetListHoaDonByMonth(int maNhanVien, int month)
{
using (var db = new QuanLyTraSuaEntities())
{
DateTime now = DateTime.Now;
var result = db.HoaDons
.Where(v => v.MaNhanVien == maNhanVien &&
v.NgayTao.Value.Year == now.Year &&
v.NgayTao.Value.Month == month)
.Select(v => new HoaDonViewModel
{
MaHoaDon = v.MaHoaDon,
MaKhachHang = v.MaKhachHang,
MaNhanVien = v.MaNhanVien,
NgayTao = v.NgayTao,
MoTa = v.MoTa
});
if (result != null)
{
return(Ok(result.ToList()));
}
else
{
return(NotFound());
}
}
}
// [ActionName("GetListHoaDonByThang")]
public IHttpActionResult GetListHoaDonByThang(int nam, int thang)
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
var hoaDonList = db.HoaDons.Select(v => new HoaDonViewModel
{
MaHoaDon = v.MaHoaDon,
MaKhachHang = v.MaKhachHang,
MaNhanVien = v.MaNhanVien,
MoTa = v.MoTa,
NgayTao = v.NgayTao
//var hoaDonList = db.HoaDons.Select(v => new
//{
// v.MaHoaDon,
// v.NgayTao
}).Where(v => v.NgayTao.Value.Month == thang && v.NgayTao.Value.Year == nam);
if (hoaDonList != null)
{
return(Ok(hoaDonList.ToList()));
}
else
{
return(NotFound());
}
}
}
public IHttpActionResult GetListHoaDonByMaNhanVien(NhanVienBanHang nhanVienBanHang)
{
using (var db = new QuanLyTraSuaEntities())
{
DateTime now = DateTime.Now;
var result = db.HoaDons
.Where(v => v.MaNhanVien == nhanVienBanHang.MaNhanVien)
.Select(v => new HoaDonViewModel
{
MaHoaDon = v.MaHoaDon,
MaKhachHang = v.MaKhachHang,
MaNhanVien = v.MaNhanVien,
NgayTao = v.NgayTao,
MoTa = v.MoTa
});
if (result != null)
{
return(Ok(result.ToList()));
}
else
{
return(NotFound());
}
}
}
public IHttpActionResult GetListSanPhamByMaHoaDon(int maHoaDon)
{
using (var db = new QuanLyTraSuaEntities())
{
var maLuaChon = db.HoaDonChiTiets.SingleOrDefault(v => v.MaHoaDon == maHoaDon).MaLuaChon;
var maSanPham = db.LuaChons.Where(v => v.MaLuaChon == maLuaChon).ToList();
var result = new List <SanPhamViewModel>();
maSanPham.ForEach(v =>
{
var temp = db.SanPhams.Single(n => n.MaSanPham == v.MaSanPham);
var resultItem = new SanPhamViewModel()
{
MaSanPham = temp.MaSanPham,
TenSanPham = temp.TenSanPham,
KichCo = temp.KichCo,
DonGia = temp.DonGia,
HinhAnh = temp.HinhAnh,
MaChuDe = temp.MaChuDe
};
result.Add(resultItem);
});
return(Ok(result.ToList()));
}
}
public IHttpActionResult GetListHoaDonByPeriodOfTime(int maNhanVien, int date1, int month1, int year1, int date2, int month2, int year2)
{
using (var db = new QuanLyTraSuaEntities())
{
//DateTime tuNgay = Convert.ToDateTime(nhanVienBanHang.TuNgay);
// DateTime denNgay = Convert.ToDateTime(nhanVienBanHang.DenNgay);
var result = db.HoaDons
.Where(v => v.MaNhanVien == maNhanVien &&
(v.NgayTao.Value.Year >= year1 &&
v.NgayTao.Value.Month >= month1 &&
v.NgayTao.Value.Day >= date1) &&
(v.NgayTao.Value.Year <= year2 &&
v.NgayTao.Value.Month <= month2 &&
v.NgayTao.Value.Day <= date2))
.Select(v => new HoaDonViewModel
{
MaHoaDon = v.MaHoaDon,
MaKhachHang = v.MaKhachHang,
MaNhanVien = v.MaNhanVien,
NgayTao = v.NgayTao,
MoTa = v.MoTa
});
if (result != null)
{
return(Ok(result.ToList()));
}
else
{
return(NotFound());
}
}
}
//[ActionName("CountTopping")]
public IHttpActionResult GetAllTopping()
{
using (var db = new QuanLyTraSuaEntities())
{
var result = db.Toppings.Count();
return(Content(HttpStatusCode.OK, result));
}
}
public IHttpActionResult GetSumLuaChon()
{
using (var db = new QuanLyTraSuaEntities())
{
var result = db.MaLuaChons.Count();
return(Ok(result));
}
}
public IHttpActionResult GetAllSanPham()
{
using (var db = new QuanLyTraSuaEntities())
{
var result = db.SanPhams.Count();
return(Ok(result));
}
}
public IHttpActionResult GetTongHoaDonTheoThang()
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
var result = db.ThongKeHoaDonTheoCacThang().ToList();
if (result == null)
{
return(BadRequest());
}
else
{
return(Ok(result));
}
}
}
public IHttpActionResult GetTongHoaDonTheoNgay()
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
DateTime dateTime = DateTime.Now;
var tongHoaDon = db.HoaDons.Where(v => v.NgayTao.Value.Year == dateTime.Year && v.NgayTao.Value.Month == dateTime.Month && v.NgayTao.Value.Day == dateTime.Day);
if (tongHoaDon != null)
{
return(Ok(tongHoaDon.Count()));
}
else
{
return(BadRequest());
}
}
}
// [ActionName("GetListHoaDonByThang")]
public IHttpActionResult GetListHoaDonByThangByMaNhanVien(int maNhanVien)
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
var result = db.ThongKeHoaDonTheoCacThangByMaNhanVien(maNhanVien);
if (result != null)
{
return(Ok(result.ToList()));
}
else
{
return(BadRequest());
}
}
}
public IHttpActionResult GetSumHoaDonTheoThang(int thang)
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
var result = db.ThongKeHoaDonTheoCacThang().Where(v => v.thang == thang);
if (result == null)
{
// return Request.CreateResponse(HttpStatusCode.NotFound, "Thang nhap vao khong co don hang");
return(Content(HttpStatusCode.NotFound, "Thang nhap vao khong co don hang"));
}
else
{
return(Ok(result.ToList().Count()));
}
};
}
public IHttpActionResult GetTongKhuyenMaiApDungDangApDung()
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
DateTime dateTime = DateTime.Now;
var tongKhuyenMai = db.KhuyenMais.Where(v => v.NgayBatDau.Value <= dateTime && v.NgayKetThuc.Value > dateTime);
if (tongKhuyenMai != null)
{
return(Ok(tongKhuyenMai.Count()));
}
else
{
return(BadRequest());
}
}
}
public IHttpActionResult GetGiamsGia()
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
var giamGiaList = db.GetAllGiamGia().Select(v => new GiamGiaViewModel {
MaHoaDon = (int)v.MaHoaDon, MaKhuyenMai = (int)v.MaKhuyenMai
});
if (giamGiaList != null)
{
return(Ok(giamGiaList.ToList()));
}
else
{
return(BadRequest());
}
}
}
public IHttpActionResult GetListChuDe()
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
var chuDeList = db.ChuDes.OrderBy(v => v.TenChuDe).Select(n => new ChuDeViewModel
{
MaChuDe = n.MaChuDe,
TenChuDe = n.TenChuDe,
MoTa = n.MoTa
});
if (chuDeList != null)
{
return(Ok(chuDeList.ToList()));
}
else
{
return(BadRequest());
}
}
}
//public override Task TokenEndpoint(OAuthTokenEndpointContext context)
//{
// context.AdditionalResponseParameters.Add("username", context.Identity.Name);
// // context.AdditionalResponseParameters.Add("aa", context.);
// return base.TokenEndpoint(context);
//}
public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
taiKhoan = db.TaiKhoans.SingleOrDefault(v => v.TenTaiKhoan == context.UserName && v.MatKhau == context.Password);
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
if (taiKhoan != null)
{
var listMaQuyen = db.GetPhanQuyenByMaTaiKhoan((int)taiKhoan.MaTaiKhoan).ToList();
var quyenList = new List <string>();
listMaQuyen.ForEach(v =>
{
quyenList.Add(db.Quyens.SingleOrDefault(n => n.MaQuyen == v.MaQuyen).TenQuyen);
});
quyenList.ForEach(v =>
{
identity.AddClaim(new Claim(ClaimTypes.Role, v.Trim().ToString()));
});
identity.AddClaim(new Claim("username", taiKhoan.TenTaiKhoan));
if (taiKhoan.MaNhanVien != null)
{
identity.AddClaim(new Claim(ClaimTypes.Name, db.NhanViens.SingleOrDefault(v => v.MaNhanVien == taiKhoan.MaNhanVien).TenNhanVien.ToString()));
}
else
{
identity.AddClaim(new Claim(ClaimTypes.Name, db.KhachHangs.SingleOrDefault(v => v.MaKhachHang == taiKhoan.MaKhachHang).TenKhachHang.ToString()));
}
context.Validated(identity);
}
else
{
context.SetError("invalid_grant", "Provided username and password is incorrect");
return;
}
}
}
public IHttpActionResult GetSumLuaChonByMaHoaDon(int maHoaDon)
{
using (var db = new QuanLyTraSuaEntities())
{
var maLuaChon = db.HoaDonChiTiets.SingleOrDefault(v => v.MaHoaDon == maHoaDon).MaLuaChon;
var maTopping = db.LuaChons.Where(v => v.MaLuaChon == maLuaChon).ToList();
var result = new List <ToppingViewModel>();
maTopping.ForEach(v =>
{
var temp = db.Toppings.Single(n => n.MaTopping == v.MaTopping);
var resultItem = new ToppingViewModel()
{
MaTopping = temp.MaTopping,
TenTopping = temp.TenTopping,
DonGia = temp.DonGia,
HinhAnh = temp.HinhAnh
};
result.Add(resultItem);
});
return(Ok(result.ToList()));
}
}
public IHttpActionResult GetListSanPhamByMaChuDe(int maChuDe)
{
using (QuanLyTraSuaEntities db = new QuanLyTraSuaEntities())
{
var sanPhamList = db.SanPhams.Where(v => v.MaChuDe == maChuDe).Select(n => new SanPhamViewModel
{
MaSanPham = n.MaSanPham,
TenSanPham = n.TenSanPham,
KichCo = n.KichCo,
DonGia = n.DonGia,
HinhAnh = n.HinhAnh,
MaChuDe = n.MaChuDe
});
if (sanPhamList != null)
{
return(Ok(sanPhamList.ToList()));
}
else
{
return(BadRequest());
}
}
}
