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 virtual void Nhap()
{
Console.Write("Ho Ten: ");
HoTen = Console.ReadLine();
//check valid
Console.Write("Nam Sinh: ");
NamSinh = DateTime.Parse(Console.ReadLine());
Console.Write("Bang cap: 1. Ky Su; 2. Thac Si; 3. Tien Si; 4. Giao Su ");
BangCap = (BangCap)int.Parse(Console.ReadLine());
}
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 BangCapEditViewModel(BangCap entity) : base(entity)
{
}
