public int themLS(CatHang CH)
{
try
{
return(chDAO.ThemLS(CH));
}
catch (SqlException ex)
{
throw ex;
}
}
public int Xoa(CatHang CH)
{
string delete = "DELETE FROM NhapHang WHERE MaThung = '" + CH.MaThung + "';";
try
{
return(myExcuteNoneQuery(delete));
}
catch (SqlException ex)
{
throw ex;
}
}
public void TestCatHang_Them_ThieuMSP()
{
CatHangBUS CHBus = new CatHangBUS();
int a;
string mathung = "T01";
string make = "KA01";
string masp = "";
string tensp = "Apple";
string soluong = "1000";
string ngaycat = (DateTime.Now).ToString();
string nguoicat = "admin";
CatHang CH = new CatHang(mathung, make, masp, tensp, soluong, ngaycat, nguoicat);
a = CHBus.them(CH);
Assert.AreEqual(0, a);
}
public void TestCatHang_ThemLS_ThieuNguoiCat()
{
CatHangBUS CHBus = new CatHangBUS();
int a;
string mathung = "T01";
string make = "KA01";
string masp = "123";
string tensp = "Apple";
string soluong = "1000";
string ngaycat = "1/1/2018";
string nguoicat = "";
CatHang CH = new CatHang(mathung, make, masp, tensp, soluong, ngaycat, nguoicat);
a = CHBus.them(CH);
Assert.AreEqual(0, a);
}
public List <CatHang> GetCatHangDAO()
{
string select = "SELECT * FROM CatHang";
string mathung;
string make;
string masp;
string tensp;
string soluong;
string ngaycat;
string nguoicat;
List <CatHang> list = new List <CatHang>();
connect();
try
{
SqlDataReader sda = layDuLieuTuBang(select);
while (sda.Read())
{
mathung = sda[0].ToString();
make = sda[1].ToString();
masp = sda[2].ToString();
tensp = sda[3].ToString();
soluong = sda[4].ToString();
ngaycat = sda[5].ToString();
nguoicat = sda[6].ToString();
CatHang item = new CatHang(mathung, make, masp, tensp, soluong, ngaycat, nguoicat);
list.Add(item);
}
sda.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
disConnect();
}
}
private void btThem2_Click(object sender, EventArgs e)
{
string mathung = this.txtMaThung2.Text;
string make = this.txtMaKe.Text;
string masp = this.txtMaSP2.Text;
string tensp = this.txtTenSP2.Text;
string soluong = this.txtSL2.Text;
string ngaycat = (DateTime.Now).ToString();
string nguoicat = this.lbgetUser.Text;
if (mathung == "" || masp == "" || tensp == "" || soluong == "" || ngaycat == "" || nguoicat == "" || make == "")
{
MessageBox.Show("Vui Lòng Nhập đầy đủ Các Ô");
}
NhapHang NH = new NhapHang(mathung, masp, tensp, soluong, ngaycat, nguoicat);
CatHang CH = new CatHang(mathung, make, masp, tensp, soluong, ngaycat, nguoicat);
SanPham SP = new SanPham(masp, tensp, make, soluong);
int SoDong = new CatHangDAO().Them(CH);
SoDong = new CatHangDAO().ThemLS(CH);
SoDong = new SanPhamDAO().Them(SP);
SoDong = new NhapHangDAO().Xoa(NH);
MessageBox.Show("success");
int rowIndex = -1;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[0].Value.ToString().Trim().Equals(txtMaThung2.Text.Trim()))
{
rowIndex = row.Index;
MessageBox.Show("success");
break;
}
}
dataGridView1.Rows.RemoveAt(rowIndex);
loadData();
this.txtMaThung2.Text = this.txtMaSP2.Text = this.txtTenSP2.Text = this.txtSL2.Text = this.txtNgayCat.Text = this.txtMaKe.Text = "";
this.txtMaThung2.Focus();
loadData();
}
public int ThemLS(CatHang CH)
{
string select = "INSERT INTO LSCatHang (MaThung, MaKe, MaSP, TenSP, SoLuong, NgayCat, NguoiCat) "
+ "VALUES('" + CH.MaThung + "','" + CH.MaKe + "','" + CH.MaSP + "','" + CH.TenSP + "','"
+ CH.SoLuong + "','" + CH.NgayCat + "','" + CH.NgayCat + "');";
if (CH.MaThung == "" || CH.MaKe == "" || CH.MaSP == "" || CH.TenSP == "" || CH.SoLuong == "" ||
CH.NgayCat == "" || CH.NguoiCat == "")
{
return(0);
}
else
{
try
{
return(myExcuteNoneQuery(select));
}
catch (SqlException ex)
{
throw ex;
}
}
}
