private void add_section_Click(object sender, EventArgs e)
{
SECTION sec = new SECTION();
sec.SECT_PREFDAY = int.Parse(txt_new_pref_hours.Text);
sec.SECT_PREFHOUR = int.Parse(CB_class.SelectedValue.ToString());
sec.SECT_PREFCLASSROOM = int.Parse(CB_class.SelectedValue.ToString());
sec.SECT_PROFESSORID = int.Parse(CB_prof.SelectedValue.ToString());
sec.SECT_COURSEID = int.Parse(CB_sec_crs.SelectedValue.ToString());
sec.SECT_PREFDAY = int.Parse(txt_new_pref_day.Text);
List<String> existing;
existing = Context.SECTION.Where(p => p.SECT_COURSEID == sec.SECT_COURSEID).Select(p => p.SECT_NAME).ToList();
List<int> intlist = new List<int>();
foreach (String item in existing)
{
intlist.Add(int.Parse(item));
}
sec.SECT_NAME = (intlist.Max() + 1).ToString() ;
Context.AddToSECTION(sec);
Context.SaveChanges();
}
/// <summary>
/// Deprecated Method for adding a new object to the SECTION EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToSECTION(SECTION sECTION)
{
base.AddObject("SECTION", sECTION);
}
/// <summary>
/// Create a new SECTION object.
/// </summary>
/// <param name="sECT_ID">Initial value of the SECT_ID property.</param>
/// <param name="sECT_COURSEID">Initial value of the SECT_COURSEID property.</param>
public static SECTION CreateSECTION(global::System.Int32 sECT_ID, global::System.Int32 sECT_COURSEID)
{
SECTION sECTION = new SECTION();
sECTION.SECT_ID = sECT_ID;
sECTION.SECT_COURSEID = sECT_COURSEID;
return sECTION;
}
/// <summary>
/// Create a new SECTION object.
/// </summary>
/// <param name="sECT_ID">Initial value of the SECT_ID property.</param>
/// <param name="sECT_COURSEID">Initial value of the SECT_COURSEID property.</param>
/// <param name="sECT_PROFESSORID">Initial value of the SECT_PROFESSORID property.</param>
/// <param name="sECT_PREFDAY">Initial value of the SECT_PREFDAY property.</param>
/// <param name="sECT_PREFHOUR">Initial value of the SECT_PREFHOUR property.</param>
/// <param name="sECT_PREFCLASSROOM">Initial value of the SECT_PREFCLASSROOM property.</param>
public static SECTION CreateSECTION(global::System.Int32 sECT_ID, global::System.Int32 sECT_COURSEID, global::System.Int32 sECT_PROFESSORID, global::System.Int32 sECT_PREFDAY, global::System.Int32 sECT_PREFHOUR, global::System.Int32 sECT_PREFCLASSROOM)
{
SECTION sECTION = new SECTION();
sECTION.SECT_ID = sECT_ID;
sECTION.SECT_COURSEID = sECT_COURSEID;
sECTION.SECT_PROFESSORID = sECT_PROFESSORID;
sECTION.SECT_PREFDAY = sECT_PREFDAY;
sECTION.SECT_PREFHOUR = sECT_PREFHOUR;
sECTION.SECT_PREFCLASSROOM = sECT_PREFCLASSROOM;
return sECTION;
}
