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 Insert(object sender, EventArgs e) { using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); { PrizeExerciseDayType dayType = new PrizeExerciseDayType(); dayType.DayTypeName = txtDayTypeName.Text; db.PrizeExerciseDayTypes.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 DayTypeName = (row.FindControl("ttDayTypeName") as TextBox).Text; using (DIYPTEntities db = new DIYPTEntities()) { db.Database.Connection.Open(); PrizeExerciseDayType item = (from c in db.PrizeExerciseDayTypes where c.Id == Id select c).FirstOrDefault(); item.DayTypeName = DayTypeName; db.SaveChanges(); db.Database.Connection.Close(); } GridView1.EditIndex = -1; this.BindGrid(); }