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