public void ThemBC(BangCap bc)
{
DAL_BangCap dal_BangCap = new DAL_BangCap();
dal_BangCap.Open();
string insertString = "insert into PhuCap(MaBC,TenBC) values(" + bc.MaBC + ",'" + bc.TenBC + "')";
SqlCommand cmd = new SqlCommand(insertString, dal_BangCap.conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
dal_BangCap.Close();
}
public void XoaBC(string MaBC)
{
DAL_BangCap dal_BangCap = new DAL_BangCap();
dal_BangCap.Open();
string deleteString = "XOABC";
SqlCommand cmd = new SqlCommand(deleteString, dal_BangCap.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MaBC", SqlDbType.Int).Value = MaBC;
cmd.ExecuteNonQuery();
cmd.Dispose();
dal_BangCap.Close();
}
public void CapNhatBC(BangCap bc)
{
DAL_BangCap dal_BangCap = new DAL_BangCap();
dal_BangCap.Open();
string updateString = "SUABC";
SqlCommand cmd = new SqlCommand(updateString, dal_BangCap.conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@MaBC", SqlDbType.Text).Value = bc.MaBC;
cmd.Parameters.Add("@TenBC", SqlDbType.Text).Value = bc.TenBC;
cmd.ExecuteNonQuery();
cmd.Dispose();
dal_BangCap.Close();
}
public int LayMaBC()
{
DAL_BangCap dal_BangCap = new DAL_BangCap();
dal_BangCap.Open();
string selectString = "select top 1 MaBC from BangCap order by MaBC desc";
SqlCommand cmd = new SqlCommand(selectString, dal_BangCap.conn);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
int Mabc = reader.GetInt32(0);
reader.Dispose();
dal_BangCap.Close();
return(Mabc + 1);
}