protected void Insert(object sender, EventArgs e) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { string sid = Session["PLANWEEKID"].ToString(); Int32 ID = Convert.ToInt32(sid); string dtype = ddldaytype.SelectedItem.Text; PrizeExerciseDayType daytpes = (from c in db.PrizeExerciseDayTypes where c.DayTypeName == dtype select c).FirstOrDefault(); int dId = daytpes.Id; PrizeExercisePlanWeekDay CD = new PrizeExercisePlanWeekDay(); CD.ExercisePlanWeekId = ID; CD.Day = Convert.ToInt32(txtDay.Text); CD.DayTypeId = dId; db.PrizeExercisePlanWeekDays.Add(CD); db.SaveChanges(); } db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e) { int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]); using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); PrizeExercisePlanWeekDay item = (from c in db.PrizeExercisePlanWeekDays where c.Id == Id select c).FirstOrDefault(); IQueryable <PrizeExerciseUnitSetForDay> unitSets = (from c in db.PrizeExerciseUnitSetForDays where c.ExercisePlanWeekId == item.ExercisePlanWeekId && c.ExerciseDay == item.Day select c); foreach (var unitset in unitSets) { db.PrizeExerciseUnitSetForDays.Remove(unitset); } db.PrizeExercisePlanWeekDays.Remove(item); db.SaveChanges(); db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }