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();
PrizeExerciseUnit item = (from c in db.PrizeExerciseUnits
where c.Id == Id
select c).FirstOrDefault();
db.PrizeExerciseUnits.Remove(item);
db.SaveChanges();
db.Database.Connection.Close();
}
GridView1.EditIndex = -1;
this.BindGrid();
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
int Id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
string Exercise = (row.FindControl("ttExercise") as TextBox).Text;
string AlterExercise = (row.FindControl("ttAlterExercise") as TextBox).Text;
string Reps = (row.FindControl("ttReps") as TextBox).Text;
string Rest = (row.FindControl("ttRest") as TextBox).Text;
string Weight = (row.FindControl("ttWeight") as TextBox).Text;
string Comments = (row.FindControl("ttComments") as TextBox).Text;
//string UnitOrder = (row.FindControl("ttUnitOrder") as TextBox).Text;
string Tempo = (row.FindControl("ttTempo") as TextBox).Text;
string Trainning_Set = (row.FindControl("ttTrainning_Set") as TextBox).Text;
string TimeDuration = (row.FindControl("ttTimeDuration") as TextBox).Text;
string Image = (row.FindControl("ttImage") as TextBox).Text;
using (DIYPTEntities db = new DIYPTEntities())
{
db.Database.Connection.Open();
PrizeExerciseUnit item = (from c in db.PrizeExerciseUnits
where c.Id == Id
select c).FirstOrDefault();
item.Exercise = Exercise;
item.AlternateExercise = AlterExercise;
item.Reps = Reps;
item.Rest = Rest;
item.Weight = Weight;
//item.UnitOrder = Convert.ToInt32(UnitOrder);
item.Comments = Comments;
item.Tempo = Tempo;
item.Trainning_Set = Trainning_Set;
item.Comments = Comments;
item.TimeDuration = Convert.ToInt32(TimeDuration);
item.Image = Image;
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();
{
string[] sTemp = txtExercise.Text.Split(new string[] { "or alternatively" }, 2, StringSplitOptions.None);
string sExercise = sTemp[0];
string sAlterExercise = "";
sExercise = sExercise.Trim(new char[] { ' ' });
if (sTemp.Length > 1)
{
sAlterExercise = sTemp[1];
sAlterExercise = Regex.Replace(sAlterExercise, @",", "");
sAlterExercise = sAlterExercise.Trim(new char[] { ' ' });
}
PrizeExerciseUnit addplan = new PrizeExerciseUnit();
addplan.Exercise = sExercise;
addplan.AlternateExercise = sAlterExercise;
addplan.Reps = txtReps.Text;
addplan.Rest = txtRest.Text;
addplan.Weight = txtWeight.Text;
addplan.Comments = txtComments.Text;
addplan.UnitOrder = 0;// Convert.ToInt32(txtUnitOrder.Text);
addplan.Tempo = txtTempo.Text;
addplan.Trainning_Set = txtTrainning_Set.Text;
addplan.TimeDuration = Convert.ToInt32(txtTimeDuration.Text);
addplan.Image = txtImage.Text;
//addplan.Video = txtVideo.Text;
db.PrizeExerciseUnits.Add(addplan);
db.SaveChanges();
this.BindGrid();
}
// transaction.Complete();
db.Database.Connection.Close();
}
}
