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; } }