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