public Boolean ThemGioHang(SanPhamHoaDon sphd)
{
try
{
return(sphdd.ThemGioHang(sphd));
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(false);
}
private void button2_Click(object sender, EventArgs e)
{
string masanpham = spDuocChon.MaSanPham;
if (masanpham == null)
{
MessageBox.Show("Xin mời lựa chọn sản phẩm");
return;
}
int sl;
try
{
sl = Int32.Parse(txtSoLuongMua.Text);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
txtSoLuongMua.Text = "";
return;
}
if (sl > spDuocChon.SoLuong)
{
MessageBox.Show("Số lượng trong kho không đủ");
txtSoLuongMua.Text = "";
return;
}
if (spb.CapNhatSoLuong(masanpham, sl))
{
soHangTrongGio++;
lblGioHang.Text = Convert.ToString(soHangTrongGio);
lblSLCon.Text = (spDuocChon.SoLuong - sl).ToString();
SanPhamHoaDon sphd = new SanPhamHoaDon();
sphd.TenSanPham = spDuocChon.TenSanPham;
sphd.DungTich = spDuocChon.DungTich;
sphd.NongDo = spDuocChon.NongDo;
sphd.SoLuongMua = Int32.Parse(txtSoLuongMua.Text);
sphd.DonGia = spDuocChon.DonGia;
sphdBUL.ThemGioHang(sphd);
}
//dgvListSanPham.DataSource = spb.LaySanPham();
txtSoLuongMua.Text = "";
}
public Boolean ThemGioHang(SanPhamHoaDon sphd)
{
OpenConn();
string sql = "insert into SanPhamHoaDon values(@tensanpham,@dungtich,@nongdo,@soluongmua,@dongia)";
SqlCommand sqlComm = new SqlCommand(sql, conn);
sqlComm.Parameters.Add(new SqlParameter("@tensanpham", SqlDbType.NVarChar)).Value = sphd.TenSanPham;
sqlComm.Parameters.Add(new SqlParameter("@dungtich", SqlDbType.Int)).Value = sphd.DungTich;
sqlComm.Parameters.Add(new SqlParameter("@nongdo", SqlDbType.Int)).Value = sphd.NongDo;
sqlComm.Parameters.Add(new SqlParameter("@soluongmua", SqlDbType.Int)).Value = sphd.SoLuongMua;
sqlComm.Parameters.Add(new SqlParameter("@dongia", SqlDbType.Int)).Value = sphd.DonGia;
int kq = sqlComm.ExecuteNonQuery();
CloseConn();
if (kq != 0)
{
return(true);
}
return(false);
}
public List <SanPhamHoaDon> LayGioHang()
{
List <SanPhamHoaDon> list = new List <SanPhamHoaDon>();
OpenConn();
string sql = "select * from SanPhamHoaDon";
SqlCommand sqlComm = new SqlCommand(sql, conn);
SqlDataReader sqlDr = sqlComm.ExecuteReader();
while (sqlDr.Read())
{
SanPhamHoaDon sphd = new SanPhamHoaDon();
sphd.TenSanPham = sqlDr.GetString(0);
sphd.DungTich = sqlDr.GetInt32(1);
sphd.NongDo = sqlDr.GetInt32(2);
sphd.SoLuongMua = sqlDr.GetInt32(3);
sphd.DonGia = sqlDr.GetInt32(4);
list.Add(sphd);
}
sqlDr.Close();
CloseConn();
return(list);
}
