protected void Insert(object sender, EventArgs e) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { int weekid = Convert.ToInt32(Session["PWID"]); int day = Convert.ToInt32(Session["DAY"]); string dgroup = ddldaygroup.SelectedItem.Text; PrizeExerciseDayGroupName daygroups = (from c in db.PrizeExerciseDayGroupNames where c.DayGroupName == dgroup select c).FirstOrDefault(); int dId = daygroups.Id; PrizeExerciseUnitSetForDay CD = new PrizeExerciseUnitSetForDay(); CD.ExercisePlanWeekId = weekid; CD.ExerciseDay = day; CD.DayGroupNameId = dId; CD.ExerciseUnitSetId = 0; db.PrizeExerciseUnitSetForDays.Add(CD); db.SaveChanges(); } db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }
protected void Insert(object sender, EventArgs e) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { PrizeExerciseDayGroupName dayType = new PrizeExerciseDayGroupName(); dayType.DayGroupName = txtDayGroupName.Text; db.PrizeExerciseDayGroupNames.Add(dayType); db.SaveChanges(); this.BindGrid(); } db.Database.Connection.Close(); } }
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e) { GridViewRow row = GridView1.Rows[e.RowIndex]; int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); string DayGroupName = (row.FindControl("ttDayGroupName") as TextBox).Text; using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); PrizeExerciseDayGroupName item = (from c in db.PrizeExerciseDayGroupNames where c.Id == Id select c).FirstOrDefault(); item.DayGroupName = DayGroupName; db.SaveChanges(); db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }