private void btnFinish_Click(object sender, EventArgs e)
{
Boolean isCountable = true;
string info, label;
int setsAmount = 0;
trainingDone newDone = new trainingDone();
List <string> setDetails = new List <string>();
foreach (FlowLayoutPanel flp in panelBig.Controls)
{
info = "";
label = "";
setDetails.Clear();
foreach (Control ctrl in flp.Controls)
{
if (ctrl is TextBox)
{
if (ctrl.Text != "")
{
//info += ctrl.Text + "|";
setDetails.Add(ctrl.Text);
setsAmount++;
}
}
if (ctrl is Label)
{
label = ctrl.Text;
}
}
IQueryable <Exercise> exName =
from ex in FPdatabase.Exercise
where ex.name == label
select ex;
IQueryable <TE> exercise =
from te in FPdatabase.TE
where te.trainingID == training.trainingID && te.exerciseID == exName.FirstOrDefault().exerciseID
select te;
if (setDetails.Count() != 0)
{
for (int i = 0; i < setDetails.Count(); i++)
{
info += setDetails[i] + "|";
}
var exerciseToUpdate = exName.SingleOrDefault();
exerciseToUpdate.lastInfo = info;
FPdatabase.SubmitChanges();
ExerciseInfo exInfo = new ExerciseInfo
{
setsAmount = setsAmount
};
exInfo.trainingDone = newDone;
exInfo.TE = exercise.AsEnumerable().LastOrDefault();
FPdatabase.ExerciseInfo.InsertOnSubmit(exInfo);
FPdatabase.SubmitChanges();
for (int i = 0; i < setDetails.Count(); i++)
{
ExerciseDetail exDetail = new ExerciseDetail
{
setNumber = i + 1,
ExerciseInfo = exInfo,
setInfo = setDetails[i]
};
FPdatabase.ExerciseDetail.InsertOnSubmit(exDetail);
FPdatabase.SubmitChanges();
}
isCountable = true;
}
}
if (isCountable)
{
string comment = textBox1.Text;
newDone.date = DateTime.Today;
newDone.trainingID = training.trainingID;
//newDone.Training = training;
if (comment == "" || comment == "Type here...")
{
newDone.comment = "none";
}
else
{
newDone.comment = comment;
}
FPdatabase.SubmitChanges();
MessageBox.Show("Congratulations! You have succesfully finished training!", "Congrats!", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("You didn't do anything!", "??", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnFinish_Click(object sender, EventArgs e)
{
Boolean isCountable = true;
string info, label;
//int counter;
foreach (FlowLayoutPanel flp in panelBig.Controls)
{
info = "";
label = "";
//counter = 0;
foreach (Control ctrl in flp.Controls)
{
if (ctrl is TextBox)
{
//counter++;
if (ctrl.Text != "")
{
info += ctrl.Text + "|";
}
}
if (ctrl is Label)
{
label = ctrl.Text;
}
}
IQueryable <Exercise> exName =
from ex in FPdatabase.Exercise
where ex.name == label
select ex;
IQueryable <TE> exercise =
from te in FPdatabase.TE
where te.trainingID == training.trainingID && te.exerciseID == exName.FirstOrDefault().exerciseID
select te;
if (info != "")
{
var exerciseToUpdate = exName.SingleOrDefault();
exerciseToUpdate.lastInfo = info;
FPdatabase.SubmitChanges();
ExerciseInfo exInfo = new ExerciseInfo
{
info = info,
randomPK = exercise.AsEnumerable().LastOrDefault().randomPK,
};
var lastDone = (from ld in FPdatabase.trainingDone select ld).AsEnumerable().LastOrDefault();
if (lastDone == null)
{
exInfo.doneID = 1;
}
else
{
exInfo.doneID = lastDone.doneID + 1;
}
FPdatabase.ExerciseInfo.InsertOnSubmit(exInfo);
FPdatabase.SubmitChanges();
isCountable = true;
}
}
if (isCountable)
{
string comment = Microsoft.VisualBasic.Interaction.InputBox("Please add a comment to your training!", "comment", "");
trainingDone newDone = new trainingDone();
FPdatabase.trainingDone.InsertOnSubmit(newDone);
newDone.date = DateTime.Now.Date;
newDone.trainingID = training.trainingID;
if (comment == "")
{
newDone.comment = "none";
}
else
{
newDone.comment = comment;
}
FPdatabase.SubmitChanges();
MessageBox.Show("Congratulations! You have succesfully finished training!", "Congrats!", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("You didn't do anything!", "??", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}