public DataTable getNhaSanXuat()
{
db = new DBLib();
try
{
return db.FillDataTable("sp_SelectNhaSanXuat", CommandType.StoredProcedure);
}
catch (Exception)
{
throw;
}
}
public bool insertNSX(string TenSX)
{
db = new DBLib();
try
{
db.AddParameter("@TenSX", TenSX);
return db.ExecuteNonQuery("sp_InsertNSX", CommandType.StoredProcedure) > 0;
}
catch (Exception)
{
throw;
}
}
public bool deleteNSX(int MaSX)
{
db = new DBLib();
try
{
db.AddParameter("@MaSX", MaSX);
return db.ExecuteNonQuery("sp_DeleteNSX", CommandType.StoredProcedure) > 0;
}
catch (Exception)
{
throw;
}
}
public bool updateNSX(DTO.NhaSanXuat dto)
{
db = new DBLib();
try
{
db.AddParameter("@MaSX", dto.MaSX);
db.AddParameter("@TenSX", dto.TenSX);
return db.ExecuteNonQuery("sp_UpdateNSX", CommandType.StoredProcedure) > 0;
}
catch (Exception)
{
throw;
}
}