// Hàm xóa nhà cung cấp
public bool deleteManhacungcap(string MAcc)
{
SqlCommand command = new SqlCommand("exec NHACUNGCAP_Xoa @mact", dt.getConnection);
command.Parameters.Add("@mact", SqlDbType.VarChar).Value = MAcc;
dt.openConnection();
if ((command.ExecuteNonQuery() == 1))
{
dt.closeConnection(); return(true);
}
else
{
dt.closeConnection(); return(false);
}
}
// Hàm này để xóa cửa hàng
public bool deleteMaCuaHang(string MACH)
{
SqlCommand command = new SqlCommand("exec CUAHANG_Xoa @mach", dt.getConnection);
command.Parameters.Add("@mach", SqlDbType.VarChar).Value = MACH;
dt.openConnection();
if (command.ExecuteNonQuery() == 1)
{
dt.closeConnection();
return(true);
}
else
{
dt.closeConnection();
return(false);
}
}
//XUAT KHO
public bool insertXuatKho(string ma, string ten, DateTime ngay, int soluong, string dongia, string phieu, MemoryStream picture)
{
SqlCommand command = new SqlCommand
("exec proc_insXuatKho @ma, @ten, @ngay, @soluong, @dongia, @phieu,@picture", mydb.getConnection);
command.Parameters.Add("@ma", SqlDbType.VarChar).Value = ma;
command.Parameters.Add("@ten", SqlDbType.VarChar).Value = ten;
command.Parameters.Add("@ngay", SqlDbType.DateTime).Value = ngay;
command.Parameters.Add("@soluong", SqlDbType.Int).Value = soluong;
command.Parameters.Add("@dongia", SqlDbType.VarChar).Value = dongia;
command.Parameters.Add("@phieu", SqlDbType.VarChar).Value = phieu;
command.Parameters.Add("@picture", SqlDbType.Image).Value = picture.ToArray();
mydb.openConnection();
//if (command.ExecuteNonQuery() == 1)
if (command.ExecuteNonQuery() >= 1) //Do ket qua excute co so dong(row) >= 1
{
mydb.closeConnection();
return(true);
}
else
{
mydb.closeConnection();
return(false);
}
}
