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