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