public ActionResult Sua(int masp) { ChiTietSanPham sp = new ChiTietSanPham(); sp = db.ChiTietSanPhams.FirstOrDefault(dep => dep.MaSP == masp); return(View(sp)); }
private void btnThem_Click(object sender, EventArgs e) { CHI_TIET_SAN_PHAM ctsp = ChiTietSanPham.LayChiTietSanPham((int)cbbHangSanXuat.SelectedValue, txtDongSanPham.Text, txtSoHieuSanPham.Text, txtTenSanPham.Text); if (ctsp != null) { MessageBox.Show("Thông tin thêm bị trùng!"); return; } ctsp = new CHI_TIET_SAN_PHAM(); ctsp.MA_HANG = (int)cbbHangSanXuat.SelectedValue; ctsp.DONG_SAN_PHAM = txtDongSanPham.Text; ctsp.SO_HIEU_SAN_PHAM = txtSoHieuSanPham.Text; ctsp.TEN_SAN_PHAM = txtTenSanPham.Text; ctsp.THONG_TIN_KY_THUAT = txtThongTinKyThuat.Text; ctsp.THONG_TIN_SAN_PHAM = txtThongTinSanPham.Text; ctsp.THOI_GIAN_BAO_HANH = Convert.ToInt32(nudThoiGianBaoHanh.Value); ctsp.GIA_BAN = Convert.ToInt32(txtGiaBan.Text); if (ChiTietSanPham.ThemChiTietSanPham(ctsp)) { MessageBox.Show("Thêm Thành Công!"); } else { MessageBox.Show("Thêm Thất Bại!"); } }
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; } } }
private void btnDelete_Click(object sender, EventArgs e) { CHI_TIET_SAN_PHAM tmp; try { tmp = (CHI_TIET_SAN_PHAM)dgvChiTietSanPham.SelectedRows[0].DataBoundItem; } catch (Exception) { tmp = null; return; } if (tmp == null) { return; } if (ChiTietSanPham.XoaChiTietSanPham(tmp.MA_CHI_TIET_SAN_PHAM)) { MessageBox.Show("Xóa Thành Công!"); } else { MessageBox.Show("Xóa Thất Bại!"); } FormThayDoiChiTietSanPham_Load(sender, e); }
public ActionResult DatHang(FormCollection collection) { //Them Don hang DonHang ddh = new DonHang(); KhachHang kh = (KhachHang)Session["MaKH"]; //List<GioHang> gh = LayGioHang(); ShoppingCart gh = (ShoppingCart)Session["GioHang"]; ddh.MaKH = kh.MaKH; ddh.NgayDat = DateTime.Now; var ngaygiao = String.Format("{0:MM/dd/yyyy}", collection["Ngaygiao"]); ddh.NgayGiao = DateTime.Parse(ngaygiao); ddh.TinhTrangGH = false; ddh.DaThanhToan = false; db.DonHangs.Add(ddh); db.SaveChanges(); //Them chi tiet don hang foreach (var item in gh.Items) { ChiTietSanPham ctdh = new ChiTietSanPham(); ctdh.MaDonHang = ddh.MaDonHang; ctdh.MaSP = item.MaSP; ctdh.SoLuong = item.SoLuongTon; ctdh.DonGia = (decimal)item.GiaBan; db.ChiTietSanPhams.Add(ctdh); } db.SaveChanges(); Session["GioHang"] = null; return(RedirectToAction("Xacnhandonhang", "Cart")); }
public FormKiemTraHangTon() { InitializeComponent(); cbbChiTietSanPham.DataSource = ChiTietSanPham.LayChiTietSanPham(); cbbChiTietSanPham.DisplayMember = "DINH_DANH"; cbbChiTietSanPham.ValueMember = "MA_CHI_TIET_SAN_PHAM"; }
public int getGia() { if (gia == 0) { gia = ChiTietSanPham.LayChiTietSanPham(sp.MA_CHI_TIET_SAN_PHAM).GIA_BAN; } return(gia); }
public long Update(ChiTietSanPham chitietsp) { var ctsp = db.ChiTietSanPhams.Find(chitietsp.MaCTSP); ctsp.SoLuong = chitietsp.SoLuong; db.SaveChanges(); return(ctsp.MaCTSP); }
public ActionResult DeleteConfirmed(long id) { ChiTietSanPham chiTietSanPham = db.ChiTietSanPhams.Find(id); db.ChiTietSanPhams.Remove(chiTietSanPham); db.SaveChanges(); return(RedirectToAction("Index")); }
void Select(string lsp = "") { dataSP.ItemsSource = null; CTSP.Clear(); if (keywordTextBox.Text == "") { var select = from s in db.SANPHAMs from t in db.LOAISANPHAMs where s.KichHoat == true && t.MaLoaiSP == s.MaLoaiSP && s.MaLoaiSP.ToString().Contains(lsp) select new { s.MaSP, s.TenSP, s.GiaBanRa, s.KhuyenMai, s.SoLuong, s.KichHoat, s.MaLoaiSP, t.TenLoaiSP }; foreach (var data in select) { var ctsp = new ChiTietSanPham() { TenLoaiSP = data.TenLoaiSP, TenSP = data.TenSP, MaLoaiSP = (int)data.MaLoaiSP, MaSP = data.MaSP, GiaBanRa = (decimal)data.GiaBanRa, SoLuong = (int)data.SoLuong, KichHoat = data.KichHoat.Value, KhuyenMai = (int)data.KhuyenMai }; CTSP.Add(ctsp); } } else { var select = from s in db.SANPHAMs from t in db.LOAISANPHAMs where s.KichHoat == true && t.MaLoaiSP == s.MaLoaiSP && s.MaLoaiSP.ToString().Contains(lsp) && s.TenSP.ToLower().Contains(keywordTextBox.Text.ToLower()) select new { s.MaSP, s.TenSP, s.GiaBanRa, s.KhuyenMai, s.SoLuong, s.KichHoat, s.MaLoaiSP, t.TenLoaiSP }; foreach (var data in select) { var ctsp = new ChiTietSanPham() { TenLoaiSP = data.TenLoaiSP, TenSP = data.TenSP, MaLoaiSP = (int)data.MaLoaiSP, MaSP = data.MaSP, GiaBanRa = (decimal)data.GiaBanRa, SoLuong = (int)data.SoLuong, KichHoat = data.KichHoat.Value, KhuyenMai = (int)data.KhuyenMai }; CTSP.Add(ctsp); } } dataSP.ItemsSource = CTSP; }
// khỏi tạo giỏ hàng theo MAsach được truyền vào với sl mặc định là 1 public GioHang(int MaSP) { this.MaSP = MaSP; ChiTietSanPham sp = data.ChiTietSanPhams.Single(n => n.MaSP == this.MaSP); sTenSP = sp.TenSP; sAnhBia = sp.AnhBia; dGiaBan = decimal.Parse(sp.GiaBan.ToString()); iSlMua = 1; }
public ActionResult Edit([Bind(Include = "MaCTSP,MetaTitle,Code,Mau,Size,SoLuong,LinkAnh,TrangThai,MaSanPham")] ChiTietSanPham chiTietSanPham) { if (ModelState.IsValid) { db.Entry(chiTietSanPham).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaSanPham = new SelectList(db.SanPhams, "MaSanPham", "TenSanPham", chiTietSanPham.MaSanPham); return(View(chiTietSanPham)); }
public ActionResult Edit([Bind(Include = "MaSP,MaDonHang,SoLuong,DonGia")] ChiTietSanPham chiTietSanPham) { if (ModelState.IsValid) { db.Entry(chiTietSanPham).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MaDonHang = new SelectList(db.DonHangs, "MaDonHang", "MaDonHang", chiTietSanPham.MaDonHang); ViewBag.MaSP = new SelectList(db.SanPhams, "MaSP", "TenSP", chiTietSanPham.MaSP); return(View(chiTietSanPham)); }
public ActionResult XoaSanPham(int id) { //Lay ra doi tuong sach can xoa theo ma ChiTietSanPham sp = data.ChiTietSanPhams.SingleOrDefault(n => n.MaSP == id); ViewBag.MaSP = sp.MaSP; if (sp == null) { Response.StatusCode = 404; return(null); } return(View(sp)); }
private void cbbChiTietSanPham_SelectedIndexChanged(object sender, EventArgs e) { int maChiTietSanPham = (int)cbbChiTietSanPham.SelectedValue; CHI_TIET_SAN_PHAM ctsp = ChiTietSanPham.LayChiTietSanPham(maChiTietSanPham); int conTon = KhoHang.GetTonKho(maChiTietSanPham); Console.WriteLine(conTon); txtConLai.Text = conTon.ToString(); txtGiaBan.Text = ctsp.GIA_BAN.ToString(); txtThoiGianBaoHanh.Text = ctsp.THOI_GIAN_BAO_HANH.ToString(); txtThongTinKyThuat.Text = ctsp.THONG_TIN_KY_THUAT; txtThongTinSanPham.Text = ctsp.THONG_TIN_SAN_PHAM; }
public ActionResult Xoa(int masp) { ChiTietSanPham sp = new ChiTietSanPham(); sp = db.ChiTietSanPhams.FirstOrDefault(dep => dep.MaSP == masp); if (sp != null) { List <ChiTietDonDatHang> lstDDH = db.ChiTietDonDatHangs.ToList().Where(giay => giay.MaSP == masp).ToList(); db.ChiTietDonDatHangs.DeleteAllOnSubmit(lstDDH); db.ChiTietSanPhams.DeleteOnSubmit(sp); db.SubmitChanges(); } return(RedirectToAction("Qlysanpham", "Qlysanpham")); }
// GET: Admin/ChiTietSanPhams/Details/5 public ActionResult Details(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ChiTietSanPham chiTietSanPham = db.ChiTietSanPhams.Find(id); if (chiTietSanPham == null) { return(HttpNotFound()); } return(View(chiTietSanPham)); }
public ActionResult XacNhanXoa(int id) { //Lay ra doi tuong sach can xoa theo ma ChiTietSanPham sp = data.ChiTietSanPhams.SingleOrDefault(n => n.MaSP == id); ViewBag.MaSP = sp.MaSP; if (sp == null) { Response.StatusCode = 404; return(null); } data.ChiTietSanPhams.DeleteOnSubmit(sp); data.SubmitChanges(); return(RedirectToAction("SanPham")); }
// GET: Admin/ChiTietSanPhams/Edit/5 public ActionResult Edit(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ChiTietSanPham chiTietSanPham = db.ChiTietSanPhams.Find(id); if (chiTietSanPham == null) { return(HttpNotFound()); } ViewBag.MaSanPham = new SelectList(db.SanPhams, "MaSanPham", "TenSanPham", chiTietSanPham.MaSanPham); return(View(chiTietSanPham)); }
public ActionResult SuaSanPham(int id) { //Lay ra doi tuong sach theo ma ChiTietSanPham sp = data.ChiTietSanPhams.SingleOrDefault(n => n.MaSP == id); ViewBag.MaSP = sp.MaSP; if (sp == null) { Response.StatusCode = 404; return(null); } //Dua du lieu vao dropdownList //Lay ds tu tabke chu de, sắp xep tang dan trheo ten chu de, chon lay gia tri Ma CD, hien thi thi Tenchude ViewBag.MaLoai = new SelectList(data.PhanLoaiSanPhams.ToList().OrderBy(n => n.Loai), "MaLoai", "Loai", sp.MaLoai); ViewBag.MaTheLoai = new SelectList(data.TheLoaiSanPhams.ToList().OrderBy(n => n.TenTheLoai), "MaTheLoai", "TenTheLoai", sp.MaTheLoai); return(View(sp)); }
// // GET: /SanPham/Details/5 public ActionResult Details(int id = 0) { ChiTietSanPham ctsp = new ChiTietSanPham(); var q = from s in db.SanPhams.Include("BinhLuans") where s.maSP == id select s; SanPham sanpham = q.FirstOrDefault(); if (sanpham == null) { return(HttpNotFound()); } ctsp.SanPham = sanpham; ctsp.DSBinhLuan = sanpham.BinhLuans.ToList(); return(View(ctsp)); }
private void btnSave_Click(object sender, EventArgs e) { CHI_TIET_SAN_PHAM tmp; try { tmp = (CHI_TIET_SAN_PHAM)dgvChiTietSanPham.SelectedRows[0].DataBoundItem; } catch (Exception) { tmp = null; return; } if (tmp == null) { return; } ChiTietSanPham.XoaChiTietSanPham(tmp.MA_CHI_TIET_SAN_PHAM); CHI_TIET_SAN_PHAM ctsp = ChiTietSanPham.LayChiTietSanPham((int)cbbHangSanXuat.SelectedValue, txtDongSanPham.Text, txtSoHieuSanPham.Text, txtTenSanPham.Text); if (ctsp != null) { MessageBox.Show("Thông tin thay đổi bị trùng!"); return; } ctsp = new CHI_TIET_SAN_PHAM(); ctsp.MA_HANG = (int)cbbHangSanXuat.SelectedValue; ctsp.DONG_SAN_PHAM = txtDongSanPham.Text; ctsp.SO_HIEU_SAN_PHAM = txtSoHieuSanPham.Text; ctsp.TEN_SAN_PHAM = txtTenSanPham.Text; ctsp.THONG_TIN_KY_THUAT = txtThongTinKyThuat.Text; ctsp.THONG_TIN_SAN_PHAM = txtThongTinSanPham.Text; ctsp.THOI_GIAN_BAO_HANH = Convert.ToInt32(nudThoiGianBaoHanh.Value); ctsp.GIA_BAN = Convert.ToInt32(txtGiaBan.Text); if (ChiTietSanPham.ThemChiTietSanPham(ctsp)) { MessageBox.Show("Thay Đổi Thành Công!"); } else { MessageBox.Show("Thay Đổi Thất Bại!"); } FormThayDoiChiTietSanPham_Load(sender, e); }
private void FormNhapHang_Load(object sender, EventArgs e) { cbbDoiTac.DataSource = new BindingList <DOI_TAC_NHAP_HANG>(DoiTacNhapHang.LayDoiTac()); cbbDoiTac.DisplayMember = "THONG_TIN"; cbbDoiTac.ValueMember = "MA_DOI_TAC"; cbbChiTietSanPham.DataSource = new BindingList <CHI_TIET_SAN_PHAM>(ChiTietSanPham.LayChiTietSanPham()); cbbChiTietSanPham.DisplayMember = "DINH_DANH"; cbbChiTietSanPham.ValueMember = "MA_CHI_TIET_SAN_PHAM"; try { int soLuong = Convert.ToInt32(txtSoLuong.Text); int count = flowPanel.Controls.Count; Console.WriteLine(soLuong + " " + count); btnThemSanPham.Enabled = (count < soLuong); } catch (Exception) { } }
public ActionResult Edit(FormCollection col, int masp) { ChiTietSanPham sp = new ChiTietSanPham(); if (sp != null) { sp = db.ChiTietSanPhams.FirstOrDefault(dep => dep.MaSP == masp); sp.TenSP = col["tensp"]; sp.Hinh = col["hinh"]; sp.MoTa = col["mota"]; sp.Size = col["size"]; sp.MaLoai = int.Parse(col["loai"]); sp.Gia = int.Parse(col["dongia"]); sp.MaNhom = int.Parse(col["nhom"]); db.SubmitChanges(); } return(RedirectToAction("Qlysanpham", "Qlysanpham")); }
public ActionResult InsertNew(FormCollection col, HttpPostedFileBase fileUpload) { var fileName = ""; if (fileUpload != null && fileUpload.ContentLength > 0) { fileName = Path.GetFileName(fileUpload.FileName); var path = Path.Combine(Server.MapPath("~/Content/Hinh/"), fileName); fileUpload.SaveAs(path); } ChiTietSanPham sp = new ChiTietSanPham(); sp.TenSP = col["tensp"]; sp.Hinh = fileName; sp.MoTa = col["mota"]; sp.Size = col["size"]; sp.MaLoai = int.Parse(col["loai"]); sp.Gia = int.Parse(col["dongia"]); sp.MaNhom = int.Parse(col["nhom"]); db.ChiTietSanPhams.InsertOnSubmit(sp); db.SubmitChanges(); return(RedirectToAction("Qlysanpham", "Qlysanpham")); }
public ActionResult Chitietsp(string tensp) { ChiTietSanPham chitietsp = db.ChiTietSanPhams.ToList().FirstOrDefault(sp => sp.TenSP.Contains(tensp)); return(View(chitietsp)); }
private void FormThayDoiChiTietSanPham_Load(object sender, EventArgs e) { dgvChiTietSanPham.DataSource = new BindingList <CHI_TIET_SAN_PHAM>(ChiTietSanPham.LayChiTietSanPham()); }
public static ArrayList LayDanhSachChiTietSanPham(string ma) { ArrayList list = new ArrayList(); string query = String.Format("SELECT * FROM ChiTietSanPham WHERE MaSP = '"+ ma +"' and STT = 1"); try { conn.Open(); command.CommandText = query; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string masp = reader.GetString(1); string sku = reader.GetString(2); string model = reader.GetString(3); string manhinh = reader.GetString(4); string trongluong = reader.GetString(5); string mausac = reader.GetString(6); string kichthuocmanhinh = reader.GetString(7); string bonhotrong = reader.GetString(8); string bonnhongoai = reader.GetString(9); string camera = reader.GetString(10); string hedieuhanh = reader.GetString(11); string loaipin = reader.GetString(12); string congketnoi = reader.GetString(13); string baohanh = reader.GetString(14); string cpu = reader.GetString(15); ChiTietSanPham sp = new ChiTietSanPham(masp, sku, model, manhinh, trongluong, mausac, kichthuocmanhinh, bonhotrong,bonnhongoai,camera,hedieuhanh,loaipin,congketnoi,baohanh,cpu); list.Add(sp); } } finally { conn.Close(); } return list; }
//Tram lam public ActionResult ThemMoiSanPham(ChiTietSanPham sp, HttpPostedFileBase fileUpload, HttpPostedFileBase fileUpload_1, HttpPostedFileBase fileUpload_2, HttpPostedFileBase fileUpload_3) { //Dua du lieu vao dropdownload ViewBag.MaLoai = new SelectList(data.PhanLoaiSanPhams.ToList().OrderBy(n => n.Loai), "MaLoai", "Loai"); ViewBag.MaTheLoai = new SelectList(data.TheLoaiSanPhams.ToList().OrderBy(n => n.TenTheLoai), "MaTheLoai", "TenTheLoai"); //Kiem tra duong dan file if (fileUpload == null) { ViewBag.Thongbao = "Vui lòng chọn ảnh bìa"; return(View()); } if (fileUpload_1 == null) { ViewBag.Thongbao = "Vui lòng chọn ảnh 1"; return(View()); } if (fileUpload_2 == null) { ViewBag.Thongbao = "Vui lòng chọn ảnh 2"; return(View()); } if (fileUpload_3 == null) { ViewBag.Thongbao = "Vui lòng chọn ảnh 3"; return(View()); } //Them vao CSDL else { if (ModelState.IsValid) { //Luu ten fie, luu y bo sung thu vien using System.IO; var fileName = Path.GetFileName(fileUpload.FileName); var fileName_1 = Path.GetFileName(fileUpload_1.FileName); var fileName_2 = Path.GetFileName(fileUpload_2.FileName); var fileName_3 = Path.GetFileName(fileUpload_3.FileName); //Luu duong dan cua file var path = Path.Combine(Server.MapPath("~/images"), fileName); var path_1 = Path.Combine(Server.MapPath("~/images"), fileName_1); var path_2 = Path.Combine(Server.MapPath("~/images"), fileName_2); var path_3 = Path.Combine(Server.MapPath("~/images"), fileName_3); //Kiem tra hình anh ton tai chua? if (System.IO.File.Exists(path) || System.IO.File.Exists(path_1) || System.IO.File.Exists(path_2) || System.IO.File.Exists(path_3)) { ViewBag.Thongbao = "Hình ảnh đã tồn tại"; } else { //Luu hinh anh vao duong dan fileUpload.SaveAs(path); fileUpload_1.SaveAs(path_1); fileUpload_2.SaveAs(path_2); fileUpload_3.SaveAs(path_3); } sp.AnhBia = fileName; sp.Anh_1 = fileName_1; sp.Anh_2 = fileName_2; sp.Anh_3 = fileName_3; //Luu vao CSDL data.ChiTietSanPhams.InsertOnSubmit(sp); data.SubmitChanges(); } return(RedirectToAction("SanPham")); } }
public bool themChiTietSanPham(ChiTietSanPham chitiet) { return(dal_chiTietSanPham.themChiTietSanPham(chitiet)); }
// Not Finish public bool ThemChiTietSanPham(CHI_TIET_SAN_PHAM ctsp) { return(ChiTietSanPham.ThemChiTietSanPham(ctsp)); }