public int themLS(LayHang LH)
{
try
{
return(lhDAO.ThemLS(LH));
}
catch (SqlException ex)
{
throw ex;
}
}
public int Xoa(LayHang LH)
{
try
{
return(lhDAO.Xoa(LH));
}
catch (SqlException ex)
{
throw ex;
}
}
public int Xoa(LayHang LH)
{
string delete = "DELETE FROM SanPham WHERE MaSP = '" + LH.MaSP + "';";
try
{
return(myExcuteNoneQuery(delete));
}
catch (SqlException ex)
{
throw ex;
}
}
public int LaySL(LayHang LH, string a)
{
string laysl = "SELECT SoLuong FROM SanPham WHERE MaSP = '" + LH.SoLuong + "';";
try
{
a = myExecuteScalar(laysl).ToString();
return(int.Parse(a));
}
catch (SqlException ex)
{
throw ex;
}
}
public void TestLayHang_ThieuTenSP()
{
LayHangBUS LHBus = new LayHangBUS();
int a;
string make = "K01";
string masp = "95486";
string tensp = "";
string soluong = "1000";
string ngaylay = (DateTime.Now).ToString();
string nguoilay = "hien";
LayHang LH = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay);
a = LHBus.Xoa(LH);
Assert.AreEqual(0, a);
}
public int ThemLS(LayHang LH)
{
string select = "INSERT INTO LSXuatHang (MaKe, MaSP, TenSP, SoLuong, NgayLay, NguoiLay) "
+ "VALUES('" + LH.MaKe + "','" + LH.MaSP + "','" + LH.TenSP + "','"
+ LH.SoLuong + "','" + LH.NgayLay + "','" + LH.NguoiLay + "');";
try
{
return(myExcuteNoneQuery(select));
}
catch (SqlException ex)
{
throw ex;
}
}
public void TestLayHang_ThieuMaKe_MaSP_TenSP_SoLuong_NgayLay_NguoiLay()
{
LayHangBUS LHBus = new LayHangBUS();
int a;
string make = "";
string masp = "";
string tensp = "";
string soluong = "";
string ngaylay = "";
string nguoilay = "";
LayHang LH = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay);
a = LHBus.Xoa(LH);
Assert.AreEqual(0, a);
}
public void TestLayHang_ThieuSoLuong_NgayLay_NguoiLay()
{
LayHangBUS LHBus = new LayHangBUS();
int a;
string make = "K01";
string masp = "95486";
string tensp = "Pin sạc dự phòng";
string soluong = "";
string ngaylay = "";
string nguoilay = "";
LayHang LH = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay);
a = LHBus.Xoa(LH);
Assert.AreEqual(0, a);
}
public void TestLayHang_ThieuMaKe_MaSP_NguoiLay()
{
LayHangBUS LHBus = new LayHangBUS();
int a;
string make = "";
string masp = "";
string tensp = "Pin sạc dự phòng";
string soluong = "1000";
string ngaylay = (DateTime.Now).ToString();
string nguoilay = "";
LayHang LH = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay);
a = LHBus.Xoa(LH);
Assert.AreEqual(0, a);
}
private void btnLayHang_Click(object sender, EventArgs e)
{
sqlcnn.Open();
String a;
String select = "SELECT SoLuong FROM SanPham WHERE MaSP = '" + txtMaSP5.Text + "';";
SqlCommand selectcmd = new SqlCommand(select, sqlcnn);
a = selectcmd.ExecuteScalar().ToString();
sqlcnn.Close();
int total;
this.textBox1.Text = this.txtSL5.Text;
string make = this.txtMaKe5.Text;
string masp = this.txtMaSP5.Text;
string tensp = this.txtTenSP5.Text;
string soluong = this.txtSL5.Text;
string ngaylay = (DateTime.Now).ToString();
string nguoilay = lbgetUser.Text;
LayHang LH = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay);
SanPham SP = new SanPham(masp, tensp, make, soluong);
int SoDong;
int y = int.Parse(a);
int x = int.Parse(textBox1.Text);
if (x < y)
{
total = y - x;
SoDong = new SanPhamDAO().CapNhap(SP, total);
SoDong = new LayHangDAO().ThemLS(LH);
}
else if (x == y)
{
SoDong = new SanPhamDAO().Xoa(SP);
SoDong = new LayHangDAO().ThemLS(LH);
}
else
{
MessageBox.Show("SL lấy ra lớn hơn SL có trong kho");
}
loadData();
}
public List <LayHang> GetLayHangDAO()
{
string select = "SELECT * FROM XuatHang";
string make;
string masp;
string tensp;
string soluong;
string ngaylay;
string nguoilay;
List <LayHang> list = new List <LayHang>();
connect();
try
{
SqlDataReader sda = layDuLieuTuBang(select);
while (sda.Read())
{
make = sda[0].ToString();
masp = sda[1].ToString();
tensp = sda[2].ToString();
soluong = sda[3].ToString();
ngaylay = sda[4].ToString();
nguoilay = sda[5].ToString();
LayHang item = new LayHang(make, masp, tensp, soluong, ngaylay, nguoilay);
list.Add(item);
}
sda.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
disConnect();
}
}
