private void HienThiGiaiDoan()
{
ObservableCollection <GiaiDoan> objGiaiDoan = GiaiDoan.HienThiTatCa();
cmb_GiaiDoan.DataContext = objGiaiDoan;
ObservableCollection <GiaiDoan> obj = GiaiDoan.HienThiGiaiDoan(4);
cmb_GiaiDoan.SelectedValue = obj[0].MaGiaiDoan;
}
private GiaiDoan GiaiDoanIDataReader(IDataReader Reader)
{
GiaiDoan obj = new GiaiDoan();
obj.MaGiaiDoan = (Reader["MaGiaiDoan"] is DBNull) ? int.MinValue : (int)Reader["MaGiaiDoan"];
obj.TenGiaiDoan = (Reader["TenGiaiDoan"] is DBNull) ? string.Empty : (string)Reader["TenGiaiDoan"];
obj.SoHocKy = (Reader["SoHocKy"] is DBNull) ? int.MinValue : (int)Reader["SoHocKy"];
return(obj);
}
public int SuaGiaiDoan(GiaiDoan obj)
{
using (SqlConnection conn = getConnect())
{
try
{
conn.Open();
SqlCommand myCommand = new SqlCommand("Update GiaiDoan set TenGiaiDoan = '" + obj.TenGiaiDoan + "', SoHocKy = '" + obj.SoHocKy + "' where MaGiaiDoan = '" + obj.MaGiaiDoan + "' ", conn);
myCommand.CommandType = CommandType.Text;
myCommand.ExecuteNonQuery();
conn.Close();
return(1);
}
catch
{
return(0);
}
}
}
public int ThemGiaiDoan(GiaiDoan obj)
{
using (SqlConnection conn = getConnect())
{
try
{
conn.Open();
SqlCommand myCommand = new SqlCommand("Insert into GiaiDoan values(N'" + obj.TenGiaiDoan + "','" + obj.SoHocKy + "')", conn);
myCommand.CommandType = CommandType.Text;
myCommand.ExecuteReader();
conn.Close();
return(1);
}
catch
{
return(0);
}
}
}
private void loadGiaiDoan()
{
ObservableCollection <GiaiDoan> obj = GiaiDoan.HienThiTatCa();
cb_MaGiaiDoan.DataContext = obj;
}
