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