public ActionResult Index(string tim, string ma = "Tất cả")
{
ViewBag.ma = new SelectList(data.THE_LOAI_SAN_PHAMs.ToList().OrderBy(n => n.TenLoaiSP), "MaLoaiSP", "TenLoaiSP");
var sp = from s in data.SAN_PHAMs select s;
if (!String.IsNullOrEmpty(tim))
{
sp = sp.Where(s => s.TenSP.Contains(tim));
}
if (ma != "")
{
sp = sp.Where(s => s.MaLoaiSP == ma);
}
List <SAN_PHAM> ds = new List <SAN_PHAM>();
foreach (var item in sp)
{
SAN_PHAM t = new SAN_PHAM();
t.MaSP = item.MaSP;
t.TenSP = item.TenSP;
t.HinhAnh = item.HinhAnh;
t.MoTa = item.MoTa;
t.MaTH = item.MaTH;
t.MaLoaiSP = item.MaLoaiSP;
t.GiaBan = item.GiaBan;
ds.Add(t);
}
return(View(ds));
}
public ActionResult SuaSanPham(SAN_PHAM sp, HttpPostedFileBase file)
{
ViewBag.Matheloai = new SelectList(data.THE_LOAI_SAN_PHAMs.ToList().OrderBy(n => n.TenLoaiSP), "MaLoaiSP", "TenLoaiSP");
ViewBag.Mathuonghieu = new SelectList(data.THUONG_HIEUs.ToList().OrderBy(n => n.TenTH), "MaTH", "TenTH");
if (file == null)
{
ViewBag.Thongbao = "Vui lòng chọn ảnh bìa";
return(View());
}
else
{
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/HinhAnh/SanPham"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.Thongbao = "Hình ảnh đã tồn tại";
}
else
{
file.SaveAs(path);
}
sp.HinhAnh = fileName;
UpdateModel(sp);
data.SubmitChanges();
}
return(RedirectToAction("SanPham"));
}
}
public IList <SAN_PHAM> getttsanpham(string masanpham)
{
DataTable dt = new DataTable();
string cmdtext = string.Format(@"Select SP.*,GB.GiaBan,lsp.tenloaisanpham
From dbo.SAN_PHAM SP Inner join dbo.GIA_BAN GB
On SP.MaSanPham = GB.MaSanPham inner join [dbo].[LOAI_SAN_PHAM] lsp on lsp.maLoaiSanPham=sp.maLoaiSanPham and sp.masanpham='{0}' order by masanpham " , masanpham);
dt = DataAccessHelper.log(cmdtext);
List <SAN_PHAM> li = new List <SAN_PHAM>();
foreach (DataRow dr in dt.Rows)
{
SAN_PHAM sp = new SAN_PHAM();
sp.MaLoaiSanPham = dr[0].ToString();
sp.MaSanPham = dr[1].ToString();
sp.SoLuongnhap = int.Parse(dr[3].ToString());
sp.soluongCon = int.Parse(dr[5].ToString());
sp.SoLuongban = int.Parse(dr[4].ToString());
sp.tensanpham = dr[2].ToString();
sp.Hinhanh = dr[6].ToString();
sp.DonViTinh = dr[7].ToString();
sp.Stars = int.Parse(dr[9].ToString());
sp.MoTa = dr[8].ToString();
sp.Giaban = int.Parse(dr[10].ToString());
sp.Tenloaisanpham = dr[11].ToString();
li.Add(sp);
}
return(li);
}
private void btnThemSanPham_Click(object sender, EventArgs e)
{
string imei = txtIMEI.Text;
SAN_PHAM sp = new SAN_PHAM(imei, 0);
if (imei.Length > 0)
{
if (SanPham.LaySanPham(imei) == null)
{
for (int i = 0; i < flowPanel.Controls.Count; i++)
{
PanelSanPham tmp = (PanelSanPham)flowPanel.Controls[i];
if (tmp.getString() == imei)
{
MessageBox.Show("IMEI bị trùng rồi, bạn hãy nhập lại.");
return;
}
}
flowPanel.Controls.Add(new PanelSanPham(sp));
txtIMEI.Text = "";
}
else
{
MessageBox.Show("IMEI bị trùng rồi, bạn hãy nhập lại.");
}
}
else
{
MessageBox.Show("Error!");
}
}
public SAN_PHAM GetDVByTen(string pTen)
{
SAN_PHAM result = new SAN_PHAM();
result = context.SAN_PHAM.FirstOrDefault(m => m.TEN_SP == pTen);
return(result);
}
//Get các sản phẩm bán chạy
public IList <SAN_PHAM> getProductDiscount()
{
DataTable dt = new DataTable();
//lấy về 6 sản phẩm bán chạy nhất
string cmdtext = string.Format(@"
Select Top(6) PP.MaSanPham, PP.TenSanPham, PP.HinhAnh, PP.MoTa, PP.Stars, PP.DonViTinh, PP.GiaBan,PP.GiaBan- PP.GiaBan / 100 * GG.PhanTram as N'Tiền giảm',GG.PhanTram,GG.NgayBatDau,GG.NgayKetThuc
From ProductAndPrice PP Inner Join dbo.Gia_Giam GG
On PP.MaSanPham = GG.MaSanPham
Where GG.NgayBatDau < GETDATE() And GG.NgayKetThuc >GETDATE()" );
dt = DataAccessHelper.log(cmdtext);
List <SAN_PHAM> li = new List <SAN_PHAM>();
foreach (DataRow dr in dt.Rows)
{
int giaBan = int.Parse(dr[6].ToString());
int phanTram = int.Parse(dr[8].ToString());
SAN_PHAM sp = new SAN_PHAM();
sp.MaSanPham = dr[0].ToString();
sp.tensanpham = dr[1].ToString();
sp.Hinhanh = dr[2].ToString();
sp.MoTa = dr[3].ToString();
sp.Stars = int.Parse(dr[4].ToString());
sp.DonViTinh = dr[5].ToString();
sp.Giaban = int.Parse(dr[6].ToString());
sp.Giamoi = giaBan - giaBan * phanTram / 100;
li.Add(sp);
}
return(li);
}
protected void btn_Save_Click(object sender, EventArgs e)
{
sanPhamDAL spDAL = new sanPhamDAL();
SAN_PHAM sp = new SAN_PHAM();
lb_messenger.Visible = true;
var idSP = Request.QueryString["MaSP"];
if (!String.IsNullOrEmpty(txt_tenSP.Text) && !String.IsNullOrEmpty(txt_moTa.Text) &&
!String.IsNullOrEmpty(txt_anh.Text) && !String.IsNullOrEmpty(txt_gia.Text))
{
sp.MA_SP = Convert.ToInt32(idSP);
sp.TEN_SP = txt_tenSP.Text;
sp.MO_TA = txt_moTa.Text;
sp.ANH = txt_gia.Text;
sp.GIA = Convert.ToDouble(txt_gia.Text);
int result = spDAL.Update(sp);
if (result == 1)
{
lb_messenger.Text = "Thành Công";
lb_messenger.CssClass = "text-success";
}
else
{
lb_messenger.Text = "Thất Bại";
}
}
else
{
lb_messenger.Text = "Phải Nhập Đủ Các Trường";
}
}
//get sản phẩm by loai
public IList <SAN_PHAM> getbyloai(string loai, string page)
{
DataTable dt = new DataTable();
string cmdtext = string.Format(@"Select SP.*,GB.GiaBan
From dbo.SAN_PHAM SP Inner join dbo.GIA_BAN GB
On SP.MaSanPham = GB.MaSanPham and sp.maLoaiSanPham='{1}' order by masanpham desc Offset 1 Rows Fetch next {0} rows only" , page, loai);
dt = DataAccessHelper.log(cmdtext);
List <SAN_PHAM> li = new List <SAN_PHAM>();
foreach (DataRow dr in dt.Rows)
{
SAN_PHAM sp = new SAN_PHAM();
sp.MaLoaiSanPham = dr[0].ToString();
sp.MaSanPham = dr[1].ToString();
sp.tensanpham = dr[2].ToString();
sp.SoLuongnhap = int.Parse(dr[3].ToString());
sp.SoLuongban = int.Parse(dr[4].ToString());
sp.soluongCon = int.Parse(dr[5].ToString());
sp.Hinhanh = dr[6].ToString();
sp.DonViTinh = dr[7].ToString();
sp.Stars = int.Parse(dr[9].ToString());
sp.MoTa = dr[8].ToString();
sp.Giaban = int.Parse(dr[10].ToString());
li.Add(sp);
}
return(li);
}
{ //get về 6 sản phẩm ngẫu nhiên đẻ đưa ra trang chủ
public IList <SAN_PHAM> getallsp()
{
DataTable dt = new DataTable();
string cmdtext = string.Format(@"
Select TOP(6) SP.MaSanPham,SP.TenSanPham,SP.HinhAnh,SP.MoTa,SP.Stars,SP.DonViTinh,GB.GiaBan
From dbo.SAN_PHAM SP Inner join dbo.GIA_BAN GB
On SP.MaSanPham = GB.MaSanPham Where GB.NgayKetThuc is Null
Order By NEWID()");//lấy về 6 sản phẩm ngẫu nhiên để tạo
dt = DataAccessHelper.log(cmdtext);
List <SAN_PHAM> li = new List <SAN_PHAM>();
foreach (DataRow dr in dt.Rows)
{
SAN_PHAM sp = new SAN_PHAM();
sp.MaSanPham = dr[0].ToString();
sp.tensanpham = dr[1].ToString();
sp.Hinhanh = dr[2].ToString();
sp.MoTa = dr[3].ToString();
sp.Stars = int.Parse(dr[4].ToString());
sp.DonViTinh = dr[5].ToString();
sp.Giaban = int.Parse(dr[6].ToString());
li.Add(sp);
}
return(li);
}
public IList <SAN_PHAM> searchName(string name, int page, int pagesize)
{
DataTable dt = new DataTable();
//lấy về các sản phẩm theo pagesize
string cmdtext = string.Format(@"Select SP.*,GB.GiaBan,LSP.TenLoaiSanPham
From dbo.SAN_PHAM SP Inner Join dbo.GIA_BAN GB
On SP.MaSanPham = GB.MaSanPham Inner join dbo.LOAI_SAN_PHAM LSP
On SP.MaLoaiSanPham = LSP.MaLoaiSanPham and sp.tensanpham like'%{2}%'
order by masanpham desc Offset {0}*({1}-1) Rows Fetch next {0} rows only", pagesize, page, name);
dt = DataAccessHelper.log(cmdtext);
List <SAN_PHAM> li = new List <SAN_PHAM>();
foreach (DataRow dr in dt.Rows)
{
SAN_PHAM sp = new SAN_PHAM();
sp.MaLoaiSanPham = dr[0].ToString();
sp.MaSanPham = dr[1].ToString();
sp.tensanpham = dr[2].ToString();
sp.SoLuongnhap = int.Parse(dr[3].ToString());
sp.SoLuongban = int.Parse(dr[4].ToString());
sp.soluongCon = int.Parse(dr[5].ToString());
sp.Hinhanh = dr[6].ToString();
sp.DonViTinh = dr[7].ToString();
sp.MoTa = dr[8].ToString();
sp.Stars = int.Parse(dr[9].ToString());
sp.Giaban = int.Parse(dr[10].ToString());
sp.Tenloaisanpham = dr[11].ToString();
li.Add(sp);
}
return(li);
}
public static bool ThemSanPham(SAN_PHAM sp, string ghiChu)
{
LICH_SU_SAN_PHAM lssp = new LICH_SU_SAN_PHAM(sp, Init.nhanVien.MSNV, 0, "Add Product " + ghiChu);
LICH_SU_SAN_PHAM.insert(lssp);
return(true);
}
public static bool NhanBaoHanh(SAN_PHAM sp)
{
LICH_SU_SAN_PHAM lssp = new LICH_SU_SAN_PHAM(sp, Init.nhanVien.MSNV, 5, sp.TRANG_THAI + " -> 1");
LICH_SU_SAN_PHAM.insert(lssp);
return(true);
}
private void btnTimKiem_Click(object sender, EventArgs e)
{
string s = txtIMEI.Text;
SAN_PHAM sp = SanPham.TimSanPham(s);
if (sp == null)
{
//InitializeComponent();
lbThongBao.Text = "!!!Không Tìm Thấy!!!";
txtMaKho.Text = "";
txtChiTietSanPham.Text = "";
dtpNgayBatDauBaoHanh.Value = DateTime.Now;
dtpNgayKetThucBaoHanh.Value = DateTime.Now;
txtGiaBan.Text = "0";
txtGiaMua.Text = "0";
btnNhanBaoHanh.Enabled = false;
return;
}
else
{
lbThongBao.Text = "!!!Đã Tìm Thấy!!!";
txtMaKho.Text = sp.MA_KHO.ToString();
txtChiTietSanPham.Text = ChiTietSanPham.LayChiTietSanPham(sp.MA_CHI_TIET_SAN_PHAM).DINH_DANH;
dtpNgayBatDauBaoHanh.Value = Convert.ToDateTime(sp.NGAY_BAT_DAU_BAO_HANH);
dtpNgayKetThucBaoHanh.Value = Convert.ToDateTime(sp.NGAY_KET_THUC_BAO_HANH);
txtGiaBan.Text = sp.GIA_BAN.ToString();
txtGiaMua.Text = sp.GIA_MUA.ToString();
cbbTrangThai.SelectedValue = sp.TRANG_THAI;
if ((int)cbbTrangThai.SelectedValue == 1)
{
btnNhanBaoHanh.Enabled = true;
}
}
}
public int InsertProduct(SAN_PHAM sp)
{
sp.NGAY_NHAP = DateTime.Today;
db.SAN_PHAM.Add(sp);
db.SaveChanges();
return(sp.MA_SP);
}
public SAN_PHAM GetDVByMa(int pMa)
{
SAN_PHAM result = new SAN_PHAM();
result = context.SAN_PHAM.FirstOrDefault(m => m.MA_SP == pMa);
return(result);
}
//lấy về sản phẩm sale trong ngày
public IList <SAN_PHAM> getDaylydeal()
{
DataTable dt = new DataTable();
string cmdtext = string.Format(@"
Select PAAPT.*,PAAPDT.GiaBan - PAAPDT.GiaBan * PAAPDT.PhanTram / 100 N'Giá Khuyến Mại',PAAPDT.PhanTram From ProductAndAllPriceTest PAAPT Left Join ProductAndAllPriceDiscountTest PAAPDT
On PAAPT.MaSanPham = PAAPDT.MaSanPham where GETDATE() BETWEEN NgayBatDau and NgayKetThuc" );
dt = DataAccessHelper.log(cmdtext);
List <SAN_PHAM> li = new List <SAN_PHAM>();
foreach (DataRow dr in dt.Rows)
{
SAN_PHAM sp = new SAN_PHAM();
sp.MaSanPham = dr[1].ToString();
sp.tensanpham = dr[2].ToString();
sp.Hinhanh = dr[6].ToString();
sp.MoTa = dr[8].ToString();
sp.Stars = int.Parse(dr[9].ToString());
sp.Giaban = int.Parse(dr[10].ToString());
sp.Giamoi = int.Parse(dr[12].ToString());
sp.PhanTram = int.Parse(dr[13].ToString());
li.Add(sp);
}
return(li);
}
//lấy về bán chạy nhất
public IList <SAN_PHAM> getBestSell()
{
DataTable dt = new DataTable();
//lấy về 6 sản phẩm bán chạy nhất
string cmdtext = string.Format(@"
Select SP.MaSanPham,SP.TenSanPham,SP.HinhAnh,SP.MoTa,SP.Stars,SP.DonViTinh,GB.GiaBan
From dbo.SAN_PHAM SP Inner join dbo.GIA_BAN GB On SP.MaSanPham = GB.MaSanPham
Where SP.MaSanPham
in (Select Top(6) CTDH.MaSanPham From dbo.CHI_TIET_DON_HANG CTDH
Group By CTDH.MaSanPham
Order by sum(CTDH.SoLuong) Desc)" );
dt = DataAccessHelper.log(cmdtext);
List <SAN_PHAM> li = new List <SAN_PHAM>();
foreach (DataRow dr in dt.Rows)
{
SAN_PHAM sp = new SAN_PHAM();
sp.MaSanPham = dr[0].ToString();
sp.tensanpham = dr[1].ToString();
sp.Hinhanh = dr[2].ToString();
sp.MoTa = dr[3].ToString();
sp.Stars = int.Parse(dr[4].ToString());
sp.DonViTinh = dr[5].ToString();
sp.Giaban = int.Parse(dr[6].ToString());
li.Add(sp);
}
return(li);
}
public float ThanhTien(int sl, string ma)
{
SAN_PHAM a = qlkho.SAN_PHAMs.Where(t => t.MASP == ma).FirstOrDefault();
//var dg = from a in qlkho.SAN_PHAMs where a.MASP == ma select a.GIANHAP;
float tt = float.Parse(a.GIANHAP.ToString()) * sl;
return(tt);
}
public int Add(SAN_PHAM p)
{
int result = 0;
context.SAN_PHAM.Add(p);
result = context.SaveChanges();
return(result);
}
public ActionResult DeleteConfirmed(int id)
{
SAN_PHAM sAN_PHAM = db.SAN_PHAM.Find(id);
db.SAN_PHAM.Remove(sAN_PHAM);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int Delete(int pMa)
{
int result = 0;
SAN_PHAM k = context.SAN_PHAM.FirstOrDefault(m => m.MA_SP == pMa);
context.SAN_PHAM.Remove(k);
result = context.SaveChanges();
return(result);
}
public static SAN_PHAM XuatKho(SAN_PHAM imei) // Return Gia Mua Vao
{
KHO_HANG kh = KhoHang.LayKhoHang(imei.MA_KHO);
kh.CON_LAI--;
KHO_HANG.update(kh);
imei.GIA_MUA = kh.GIA_MUA;
return(SanPham.ThanhToan(imei));
}
public static bool NhanBaoHanh(string imei)
{
SAN_PHAM sp = LaySanPham(imei);
sp.TRANG_THAI = 1;
LichSuSanPham.NhanBaoHanh(sp);
SAN_PHAM.update(sp);
return(true);
}
public GioHang(int ma)
{
this.ma = ma;
SAN_PHAM s = data.SAN_PHAMs.Single(n => n.MaSP == ma);
ten = s.TenSP;
anh = s.HinhAnh;
donGia = double.Parse(s.GiaBan.ToString());
sl = 1;
}
public static bool XuatHang(int maHoaDon, SAN_PHAM sp)
{
CHI_TIET_HOA_DON tmp = new CHI_TIET_HOA_DON();
tmp.GIA = sp.GIA_BAN;
tmp.MA_HOA_DON = maHoaDon;
tmp.IMEI = sp.IMEI;
CHI_TIET_HOA_DON.insert(tmp);
return(true);
}
public bool ThemSanPham(SAN_PHAM a)
{
try
{
sp.SAN_PHAMs.InsertOnSubmit(a);
sp.SubmitChanges();
return(true);
}
catch { return(false); }
}
public static int LayTongCong(List <SAN_PHAM> imei)
{
int tongCong = 0;
for (int i = 0; i < imei.Count; i++)
{
SAN_PHAM tmp = imei[i];
tongCong += ChiTietSanPham.LayChiTietSanPham(tmp.MA_CHI_TIET_SAN_PHAM).GIA_BAN;
}
return(tongCong);
}
public static SAN_PHAM LaySanPham(string imei)
{
try
{
return(SAN_PHAM.select(" where IMEI = " + imei)[0]);
}
catch (Exception)
{
return(null);
}
}
public static SAN_PHAM ThanhToan(SAN_PHAM sp)
{
CHI_TIET_SAN_PHAM ctsp = ChiTietSanPham.LayChiTietSanPham(sp.MA_CHI_TIET_SAN_PHAM);
sp.GIA_BAN = ctsp.GIA_BAN;
sp.NGAY_BAT_DAU_BAO_HANH = DateTime.Now;
sp.NGAY_KET_THUC_BAO_HANH = DateTime.Now.AddMonths(Convert.ToInt32(ctsp.THOI_GIAN_BAO_HANH));
sp.TRANG_THAI = 1;
SAN_PHAM.update(sp);
return(sp);
}
public bool SuaTTSanPham(SAN_PHAM p)
{
try
{
SAN_PHAM k = sp.SAN_PHAMs.Where(t => t.MASP == p.MASP).FirstOrDefault();
k = p;
sp.SubmitChanges();
return(true);
}
catch { return(false); }
}
