// luu màu sắc cho sản phẩm public ActionResult LuuMau(CHI_TIET_SAN_PHAM ctsp, int masanpham, int mactsp) { var check = db.CHI_TIET_SAN_PHAM.FirstOrDefault(n => n.MaCTSP == mactsp); if (check != null) { check.MaSanPham = masanpham; check.Mau = ctsp.Mau; check.Gia = ctsp.Gia; check.Isdeleted = false; } else { CHI_TIET_SAN_PHAM model = new CHI_TIET_SAN_PHAM(); model.MaSanPham = masanpham; model.Mau = ctsp.Mau; model.Gia = ctsp.Gia; model.Isdeleted = false; db.CHI_TIET_SAN_PHAM.Add(model); } db.SaveChanges(); ViewBag.lstMausac = db.CHI_TIET_SAN_PHAM.Where(n => n.MaSanPham == masanpham && n.Isdeleted == false).ToList(); return(View("MausacTable")); }
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!"); } }
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 static CHI_TIET_SAN_PHAM LayChiTietSanPham(int maChiTietSanPham) { try { return(CHI_TIET_SAN_PHAM.select(" where MA_CHI_TIET_SAN_PHAM = " + maChiTietSanPham + " ")[0]); } catch (Exception) { return(null); } }
public static CHI_TIET_SAN_PHAM LayChiTietSanPham(int maHang, string dongSanPham, string soHieu, string tenSanPham) { try { return(CHI_TIET_SAN_PHAM.select(" where MA_HANG = " + maHang + " and DONG_SAN_PHAM = '" + dongSanPham + "' and SO_HIEU_SAN_PHAM = '" + soHieu + "' and TEN_SAN_PHAM = '" + tenSanPham + "' ")[0]); } catch (Exception) { return(null); } }
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; }
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); }
public static bool XoaChiTietSanPham(int ma) { CHI_TIET_SAN_PHAM.delete(ma); return(true); }
public static List <CHI_TIET_SAN_PHAM> LayChiTietSanPham() { return(CHI_TIET_SAN_PHAM.select(" ")); }
public static bool SuaChiTietSanPham(CHI_TIET_SAN_PHAM ctsp) { CHI_TIET_SAN_PHAM.update(ctsp); return(true); }
public static bool ThemChiTietSanPham(CHI_TIET_SAN_PHAM ctsp) { CHI_TIET_SAN_PHAM.insert(ctsp); return(true); }
// Not Finish public bool ThemChiTietSanPham(CHI_TIET_SAN_PHAM ctsp) { return(ChiTietSanPham.ThemChiTietSanPham(ctsp)); }