public static void SuaSP(SanPham_DTO sp, string macu)
{
SqlConnection cnn = sqlConnectionData.Ketnoi();
string sql = "update SANPHAM set MaSP=@ma,TenSP=@ten,LoaiSP=@loai,Dongia=@dongia,NhaSX=nhasx,SoLuong=@soluong where MaSP='" + macu + "'";
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@ma", SqlDbType.NVarChar, 10);
cmd.Parameters.Add("@ten", SqlDbType.NVarChar, 50);
cmd.Parameters.Add("@loai", SqlDbType.NVarChar, 10);
cmd.Parameters.Add("@dongia", SqlDbType.Int);
cmd.Parameters.Add("@nhasx", SqlDbType.NVarChar, 10);
cmd.Parameters.Add("@soluong", SqlDbType.Int);
cmd.Parameters["@ma"].Value = sp.masp;
cmd.Parameters["@ten"].Value = sp.tensp;
cmd.Parameters["@loai"].Value = sp.loaisp;
cmd.Parameters["@dongia"].Value = sp.dongia;
cmd.Parameters["@nhasx"].Value = sp.nhasx;
cmd.Parameters["@soluong"].Value = sp.soluong;
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
private void btnInsert_Click(object sender, EventArgs e)
{
viewState.State = true;
mode = CRUD_State.Insert;
ClearForm();
newItem = new SanPham_DTO();
}
private void btnThemSanPham_Click(object sender, EventArgs e)
{
if (txtTenSanPham.Text.Trim() == "" ||
txtLoaiSanPham.Text.Trim() == "" ||
txtDonGia.Text.Trim() == "")
{
MessageBox.Show("Bạn chưa nhập đầy đủ thông tin", "Thông báo");
}
else
{
SanPham_DTO sp = new SanPham_DTO();
sp.TenSP = txtTenSanPham.Text;
sp.LoaiSP = txtLoaiSanPham.Text;
sp.DonGia = decimal.Parse(txtDonGia.Text);
sp.IconUrl = imageName;
sp.NgayTao = dateTimeNgayTapSP.Value;
if (imagePath != "")
{
DirectoryInfo di = Directory.CreateDirectory("data/hinhanh");
string path = System.IO.Path.Combine(di.FullName, imageName);
System.IO.File.Copy(imagePath, path, true);
}
SanPham_BUS dtBus = new SanPham_BUS();
dtBus.ThemSanPham(sp, 1);
MessageBox.Show("Đã Thêm 1 Sản Phẩm mới");
LoadDSSP();
ResetSP();
}
}
public List <SanPham_DTO> LayDanhSachSanPham()
{
List <SanPham_DTO> lsKetQua = new List <SanPham_DTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
string strTruyVan = "Select * From SANPHAM Where TrangThai = 1";
SqlDataReader sdr = DataProvider.TruyVanDuLieu(strTruyVan, conn);
while (sdr.Read())
{
SanPham_DTO sp = new SanPham_DTO();
sp.MaSP = sdr["MaSP"].ToString();
sp.TenSP = sdr["TenSP"].ToString();
sp.LoaiSP = sdr["LoaiSP"].ToString();
sp.NCC = sdr["NCC"].ToString();
sp.GiaBan = int.Parse(sdr["GiaBan"].ToString());
sp.SoLuongTon = int.Parse(sdr["SoLuongTon"].ToString());
sp.HinhAnhSP = sdr["HinhAnhSP"].ToString();
sp.HanSuDung = DateTime.Parse(sdr["HanSuDung"].ToString());
sp.TrangThai = int.Parse(sdr["TrangThai"].ToString());
lsKetQua.Add(sp);
}
sdr.Close();
conn.Close();
return(lsKetQua);
}
public List <SanPham_DTO> Search(SanPham_DTO a, int slmin, int slmax, int dongiamin, int dongiamax, int trongluongmin, int trongluongmax)
{
var pmh = datacontext.SanPham_Search(a.MaSP, a.MaLoaiSP, a.MaKieuSP, slmin, slmax, dongiamin, dongiamax, trongluongmin, trongluongmax);
var MyQuery = (from sp in pmh
join lo in datacontext.LOAISPs
on sp.MaLoaiSP equals lo.MaLoaiSP
join k in datacontext.KIEUSPs
on sp.MaKieuSP equals k.MaKieuSP
join dv in datacontext.DONVITINHs
on lo.MaDonViTinh equals dv.MaDonViTinh
select new SanPham_DTO
{
MaLoaiSP = sp.MaLoaiSP.GetValueOrDefault(),
TenLoaiSP = lo.TenLoaiSP,
MaSP = sp.MaSP,
MaKieuSP = sp.MaKieuSP.GetValueOrDefault(),
TrongLuong = (float)sp.TrongLuong.GetValueOrDefault(),
DonGiaBan = sp.DonGiaBan.GetValueOrDefault(),
SoLuongTon = sp.SoLuongTon.GetValueOrDefault(),
TenKieuSP = k.TenKieuSP,
TenDonViTinh = dv.TenDonViTinh
});
return(MyQuery.ToList());
}
private void toolStripTimkiem_Click(object sender, EventArgs e)
{
int slmin = txtSLTonMin.Text == ""?0:Int16.Parse(txtSLTonMin.Text);
int slmax = txtSLTonMax.Text == ""?0:Int16.Parse(txtSLTonMax.Text);
int dongiamin = txtDonGiaMin.Text == ""?0:Int16.Parse(txtDonGiaMin.Text);
int dongiamax = txtDonGiaBanMax.Text == ""?0:Int16.Parse(txtDonGiaBanMax.Text);
int trongluongmin = txtTrongLuongMin.Text == ""?0:Int16.Parse(txtTrongLuongMin.Text);
int trongluongmax = txtTrongLuongMax.Text == "" ? 0 : Int16.Parse(txtTrongLuongMax.Text);
SanPham_DTO a = new SanPham_DTO();
a.MaSP = txtMaSP.Text == "" ? 0 : Int16.Parse(txtMaSP.Text);
a.MaKieuSP = cbbKieuSP.Text == "" ? 0 : Int16.Parse(cbbKieuSP.SelectedValue.ToString());
a.MaLoaiSP = cbbLoaiSP.Text == "" ? 0 : Int16.Parse(cbbLoaiSP.SelectedValue.ToString());
dataGridView1.DataSource = sp.Search(a, slmin, slmax, dongiamin, dongiamax, trongluongmin, trongluongmax);
dataGridView1.Columns["MaLoaiSP"].Visible = false;
dataGridView1.Columns["MaKieuSP"].Visible = false;
cbbKieuSP.DataSource = k.LayKieuSP();
cbbKieuSP.DisplayMember = "TenKieuSP";
cbbKieuSP.ValueMember = "MaKieuSP";
cbbLoaiSP.DataSource = lo.LayLoaiSP();
cbbLoaiSP.DisplayMember = "TenLoaiSP";
cbbLoaiSP.ValueMember = "MaLoaiSP";
dataGridView1.Columns["TrongLuong"].HeaderText = "Trọng lượng";
dataGridView1.Columns["DonGiaBan"].HeaderText = "Đơn giá bán";
dataGridView1.Columns["SoLuongTon"].HeaderText = "Số lượng tổn";
dataGridView1.Columns["MaSP"].HeaderText = "Mã sản phẩm";
dataGridView1.Columns["TenLoaiSP"].HeaderText = "Loại sản phẩm";
dataGridView1.Columns["TenKieuSP"].HeaderText = "Kiểu sản phẩm";
dataGridView1.Columns["TenDonViTinh"].HeaderText = "Dơn vị tính";
}
private void btnThem_Click(object sender, EventArgs e)
{
ResetColor();
if (!ValidateData())
{
return;
}
SanPham_DTO sanPhamDaCo = lstSanPham.SingleOrDefault(item => item.TenSP == txtTenSP.Text.Trim());
NhapHang_DTO phieuNhap = new NhapHang_DTO();
phieuNhap.TenSanPham = txtTenSP.Text.Trim();
phieuNhap.Ma_SanPham = sanPhamDaCo == null ? 0 : sanPhamDaCo.MaSP;
phieuNhap.Ma_NSX = (int)cboNSX.SelectedValue;
phieuNhap.Ma_NV = (int)cboNhanVien.SelectedValue;
phieuNhap.Ma_LoaiSP = (int)cboLoaiSP.SelectedValue;
phieuNhap.DonGia = int.Parse(txtDonGia.Text);
phieuNhap.SoLuong = (int)numSoLuong.Value;
phieuNhap.TenLoai = cboLoaiSP.Text;
phieuNhap.Ten_NV = cboNhanVien.Text.Split('-')[0];
phieuNhap.Ten_NSX = cboNSX.Text;
lstPhieuNhap.Add(phieuNhap);
dgvPhieuNhap.DataSource = typeof(List <NhapHang_DTO>);
dgvPhieuNhap.DataSource = lstPhieuNhap;
EditDataGridView();
}
public bool UpdateDV(SanPham_DTO sp)
{
try
{
con.Open();
string SQL = string.Format("UPDATE SANPHAM SET TENSP = N'" + sp.TENSP + "' , GIABAN =" + sp.GIABAN
+ ", LOAI = N'" + sp.LOAI + "' WHERE MASP =" + sp.MASP);
SqlCommand cmd = new SqlCommand(SQL, con);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e)
{ }
finally
{
con.Close();
}
return(false);
}
private void btnThem_Click(object sender, EventArgs e)
{
if (txtDonGiaBan.Text == "" || txtTrongLuong.Text == "")
{
MessageBox.Show("Bạn còn dữ liệu chưa nhập");
return;
}
SanPham_DTO a = new SanPham_DTO();
a.MaLoaiSP = Int16.Parse(cbbLoaiSP.SelectedValue.ToString());
a.MaKieuSP = Int16.Parse(cbbKieuSP.SelectedValue.ToString());
if (sp.KiemTraSP(a.MaKieuSP, a.MaLoaiSP) == 1)
{
MessageBox.Show("Không thể thêm một sản phẩm mới có cùng kiểu sản phẩm và loại sản phẩm với sản phẩm có sẵn");
return;
}
a.TrongLuong = (float)Double.Parse(txtTrongLuong.Text);
a.DonGiaBan = Decimal.Parse(txtDonGiaBan.Text);
if (a.TrongLuong == 0)
{
MessageBox.Show("Trọng lượng phải khác 0");
return;
}
if (a.DonGiaBan == 0)
{
MessageBox.Show("Đơn giá bán phải khác 0");
return;
}
sp.ThemSP(a);
this.Close(); //MessageBox.Show("Thêm thành công");
}
public bool Insert(SanPham_DTO sp)
{
try
{
con.Open();
string SQL = string.Format("INSERT INTO SANPHAM VALUES (TENSP =N'" + sp.TENSP + "', SOLUONG = 0, GIANHAP ='" + sp.GIANHAP + "', GIABAN ='" + sp.GIABAN
+ "', DonVi =N'" + sp.DONVI + "', LOAI= N'" + sp.LOAI);
SqlCommand cmd = new SqlCommand(SQL, con);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e)
{ }
finally
{
con.Close();
}
return(false);
}
public bool InsertDV(SanPham_DTO sp)
{
try
{
con.Open();
string SQL = string.Format("INSERT INTO SANPHAM VALUES (N'" + sp.TENSP + "',null, null, " + sp.GIABAN
+ ",null, N'" + sp.LOAI + "')");
SqlCommand cmd = new SqlCommand(SQL, con);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e)
{ }
finally
{
con.Close();
}
return(false);
}
private void cboTenSP_SelectedIndexChanged(object sender, EventArgs e)
{
SanPham_DTO sanPham = cboTenSP.SelectedItem as SanPham_DTO;
txtNSX.Text = sanPham.TenNSX;
txtLoaiSP.Text = sanPham.TenLoaiSP;
}
private bool ValidateData()
{
int err = 0;
int donGia;
if (txtTenKH.Text.Trim() == "")
{
txtTenKH.BackColor = Color.Coral;
err++;
}
if (!int.TryParse(txtDonGia.Text, out donGia))
{
txtDonGia.BackColor = Color.Coral;
err++;
}
SanPham_DTO sanPham = lstSanPham.Single(item => item.MaSP == (int)cboTenSP.SelectedValue);
if (numSoLuong.Value > sanPham.SoLuong)
{
numSoLuong.BackColor = Color.Coral;
err++;
}
if (err > 0)
{
MessageBox.Show("Dữ liệu nhập vào chưa đúng. Xin kiểm tra lại!");
}
return(err == 0);
}
//Kiểm tra trước khi lưu
public bool KiemTraTruocKhiLuu(SanPham_DTO sp)
{
if (sp.TenSP.Equals(""))
{
MessageBox.Show("Tên Sản Phẩm không hợp lệ ! ");
return(false);
}
if (sp.NgayNhapHang.Equals(""))
{
MessageBox.Show("Ngày nhập Sản Phẩm không hợp lệ ! ");
return(false);
}
if (sp.MaNPP.Equals(""))
{
MessageBox.Show("Mã Nhà Phân Phối không hợp lệ ! ");
return(false);
}
if (sp.MaDV.Equals(""))
{
MessageBox.Show("Mã Dịch Vụ không hợp lệ ! ");
return(false);
}
if (sp.MaTL.Equals(""))
{
MessageBox.Show("Mã Thể loại không hợp lệ ! ");
return(false);
}
if (sp.TinhTrang.Equals(""))
{
MessageBox.Show("Tình trạng không hợp lệ ! ");
return(false);
}
return(true);
}
public void SuaThongTinSanPham(SanPham_DTO sp)
{
SqlConnection con = DataProvider.TaoKetNoi();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"UPDATE SanPham SET TenSP = @TenSP, LoaiSP = @LoaiSP, DonGia = @DonGia,IconUrl = @IconUrl, NgayTao = @NgayTao WHERE MaSP = @MaSP";
cmd.Parameters.Add("@TenSP", SqlDbType.NVarChar, 255);
cmd.Parameters.Add("@LoaiSP", SqlDbType.NVarChar, 255);
cmd.Parameters.Add("@DonGia", SqlDbType.NVarChar, 255);
cmd.Parameters.Add("@IconUrl", SqlDbType.NVarChar, 255);
cmd.Parameters.Add("@NgayTao", SqlDbType.NVarChar, 255);
cmd.Parameters["@TenSP"].Value = sp.TenSP;
cmd.Parameters["@LoaiSP"].Value = sp.LoaiSP;
cmd.Parameters["@DonGia"].Value = sp.DonGia;
cmd.Parameters["@IconUrl"].Value = sp.IconUrl;
cmd.Parameters["@NgayTao"].Value = sp.NgayTao.ToString("yyyy/MM/dd");
cmd.Parameters.AddWithValue(@"MaSP", sp.MaSP);
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
}
public bool SuaHangHoa(SanPham_DTO sanpham)
{
try
{
var sp = _models.SanPhams.Where(s => s.ID == sanpham.ID).FirstOrDefault();
if (sp != null)
{
sp.MaSP = sanpham.MaSP;
sp.TenSP = sanpham.TenSP;
sp.DonGia = sanpham.DonGia;
sp.NgayNhap = sanpham.NgayNhap;
sp.SoLuong = sanpham.SoLuong;
sp.MoTa = sanpham.MoTa;
sp.HinhAnh = sanpham.HinhAnh;
sp.IDNhomHangHoa = sanpham.IDNhomHangHoa;
sp.DaDuyet = sanpham.DaDuyet;
_models.SaveChanges();
return(true);
}
else
{
return(false);
}
}
catch (System.Exception)
{
throw;
}
}
public FoodCard(SanPham_DTO sp)
{
InitializeComponent();
this.Tag = sp;
lblDongia.Text = Helper_GUI.ConvertToVNmoney(sp.Giaban) + " VNĐ";
lblTen.Text = sp.Ten;
lblSoluong.Text = sp.Soluong.ToString();
}
private void cbSanPham_SelectedIndexChanged(object sender, EventArgs e)
{
SanPham_DTO sanPham = cbSanPham.SelectedItem as SanPham_DTO;
if (cbSanPham.SelectedItem != null)
{
nmDonGia.Value = sanPham.DonGia;
}
}
public IActionResult SuaHangHoa(dynamic request)
{
SanPham_DTO sanpham = JsonConvert.DeserializeObject <SanPham_DTO>(request.ToString());
using (QuanLyKhoBS ql = new QuanLyKhoBS()){
var result = ql.SuaHangHoa(sanpham);
return(Ok(result));
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
viewState.State = false;
mode = CRUD_State.View;
ClearForm();
if (newItem != null)
{
newItem = null;
}
}
private void dgvSP_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
if (senderGrid.Columns[e.ColumnIndex].Name == "btnUpdate" && e.RowIndex >= 0)
{
viewState.State = true;
mode = CRUD_State.Update;
newItem = dgvSP.CurrentRow.DataBoundItem as SanPham_DTO;
}
}
void pnAnh_MouseMove(object sender, MouseEventArgs e)
{
Control ct = (sender as Control).Parent;
ct.BackColor = Color.DarkOrchid;
SanPham_DTO sp = ct.Controls["pnAnhSanPham"].Tag as SanPham_DTO;
if (ctrTrangThaiHover != null)
{
ctrTrangThaiHover.Text = sp.TenSP;
}
}
public void ThemSP(SanPham_DTO a)
{
SANPHAM b = new SANPHAM();
b.MaLoaiSP = a.MaLoaiSP;
b.MaKieuSP = a.MaKieuSP;
b.TrongLuong = a.TrongLuong;
b.DonGiaBan = a.DonGiaBan;
b.SoLuongTon = 0;
datacontext.SANPHAMs.InsertOnSubmit(b);
datacontext.SubmitChanges();
}
public List <SanPham_DTO> LaySanPhamTheoHD(int IDHD)
{
DataTable data = DataProvider.Instance.ExecuteQuery("SPTheoHD @IDHD", new object[] { IDHD });
List <SanPham_DTO> SPTheoHD = new List <SanPham_DTO>();
foreach (DataRow item in data.Rows)
{
SanPham_DTO sp = new SanPham_DTO(item);
SPTheoHD.Add(sp);
}
return(SPTheoHD);
}
public List <SanPham_DTO> LayTatCaSanPhamTheoNSX(int MaNSX)
{
List <SanPham_DTO> DanhSachSP = new List <SanPham_DTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("SPTheoNSX @MaNSX", new object[] { MaNSX });
foreach (DataRow item in data.Rows)
{
SanPham_DTO SanPham = new SanPham_DTO(item);
DanhSachSP.Add(SanPham);
}
return(DanhSachSP);
}
public List <SanPham_DTO> LayTatCaSanPham()
{
List <SanPham_DTO> DanhSachSP = new List <SanPham_DTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("LayTatCaSanPham");
foreach (DataRow item in data.Rows)
{
SanPham_DTO SanPham = new SanPham_DTO(item);
DanhSachSP.Add(SanPham);
}
return(DanhSachSP);
}
public void CapNhapSP(SanPham_DTO a)
{
var b = datacontext.SANPHAMs.Single(x => x.MaSP == a.MaSP);
//b.TenKieuSP = a.TenKieuSP;
b.MaLoaiSP = a.MaLoaiSP;
b.MaKieuSP = a.MaKieuSP;
b.TrongLuong = a.TrongLuong;
b.DonGiaBan = a.DonGiaBan;
//b.SoLuongTon = a.SoLuongTon;
datacontext.SubmitChanges();
}
private void dgvSP_SelectionChanged(object sender, EventArgs e)
{
if (dgvSP.SelectedRows.Count > 0)
{
SPChon = (SanPham_DTO)dgvSP.SelectedRows[0].DataBoundItem;
}
else
{
SPChon = null;
}
BindingChiTiet();
}
public void ThemSanPham(SanPham_DTO sp, int TrangThai)
{
SqlConnection con = DataProvider.TaoKetNoi();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = string.Format("INSERT INTO SanPham (TenSP, LoaiSP, DonGia, IconUrl, NgayTao, TrangThai) VALUES(N'{0}' ,N'{1}',{2},'{3}',N'{4}',{5})"
, sp.TenSP, sp.LoaiSP, sp.DonGia, sp.IconUrl, sp.NgayTao.ToString("yyyy/MM/dd"), TrangThai);
cmd.Connection = con;
cmd.ExecuteNonQuery();
DataProvider.NgatKetNoi(con);
}
public void XoaSanPham(SanPham_DTO sp)
{
SqlConnection con = DataProvider.TaoKetNoi();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"UPDATE SanPham SET TrangThai = 0 WHERE MaSP = @MaSP";
cmd.Parameters.AddWithValue(@"MaSP", sp.MaSP);
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
}
