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