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