protected void SubmitClick(object sender, EventArgs e)
{
UserClass Usr = (UserClass)Session["User"];
int Time = Convert.ToInt32(HourOT.Value);
string Day = DayOfTheWeek.SelectedValue.ToString();
string Name = "TrainingName";
Name = NameOfTraining.Value.ToString();
int WarmingNumberOfSets = Convert.ToInt32(WrNOS.Value);
int WarmingNumverOfExercices = Convert.ToInt32(WrNOE.Value);
int WarmingExerciceId = Convert.ToInt32(WrTypeOfExercices.SelectedValue);
int SkillNumberOfSets = Convert.ToInt32(SkNOS.Value);
int SkillNumberOfExercices = Convert.ToInt32(SkNOE.Value);
int SkillExerciceId = Convert.ToInt32(SkTypeOfExercices.SelectedValue);
int WodNumberOfSets = Convert.ToInt32(WodNOS.Value);
int WodNumberOfExercices = Convert.ToInt32(WodNOE.Value);
int WodExerciceId = Convert.ToInt32(WodTypeOfExercicies.SelectedValue);
TrainingClass NewTraining = new TrainingClass(Usr.GetId(), Name, Day, Time);
if (ConnectionClass.IsFree(NewTraining))
{
ConnectionClass.InsertNewTraining(NewTraining);
int id = ConnectionClass.GetTrainingIdFromDB(NewTraining);
NewTraining.SetId(id);
StagesClass Warming = new StagesClass(WarmingNumberOfSets, WarmingNumverOfExercices, WarmingExerciceId, NewTraining.GetTrainingId(), "Warming");
StagesClass Skill = new StagesClass(SkillNumberOfSets, SkillNumberOfExercices, SkillExerciceId, NewTraining.GetTrainingId(), "Skill");
StagesClass Wod = new StagesClass(WodNumberOfSets, WodNumberOfExercices, WodExerciceId, NewTraining.GetTrainingId(), "Wod");
ConnectionClass.InsertStage(Warming);
ConnectionClass.InsertStage(Skill);
ConnectionClass.InsertStage(Wod);
Response.Redirect("Program.aspx");
}
else
{ VforTime.Visible = true; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["TId"] == null || !int.TryParse(Request.QueryString["TId"], out TrainingId) || !ConnectionClass.TrainingExists(TrainingId))
{
Response.Redirect("Program.aspx");
}
UserC = (UserClass)Session["User"];
Tr = ConnectionClass.GetTrainingById(TrainingId);
Warming = ConnectionClass.GetStageByTrainingIdAndType(Tr.GetTrainingId(), "Warming");
Skill = ConnectionClass.GetStageByTrainingIdAndType(Tr.GetTrainingId(), "Skill");
Wod = ConnectionClass.GetStageByTrainingIdAndType(Tr.GetTrainingId(), "Wod");
if (Tr.GetTrainerId() != UserC.GetId())
{
Response.Redirect("Program.aspx");
}
if (!IsPostBack)
FillPanel();
}
public static void InsertStage(StagesClass St)
{
Conn.Open();
string query = String.Format("Insert into [dbo].[Stages](NumberOfSets,NumberOfExercices,TypeOfExercices,Training_Id,TypeOfStage) values({0},{1},{2},{3},'{4}')",St.GetNumberOfSets(),St.GetNumberOfExercices(),St.GetTypeOfExercice(),St.GetTrainingId(),St.GetTypeOfStage());
command = new SqlCommand(query, Conn);
command.ExecuteNonQuery();
Conn.Close();
}
public static void UpdateStage(StagesClass St)
{
Conn.Open();
string query = String.Format("Update [dbo].[Stages] set NumberOfSets={0}, NumberOfExercices={1},TypeOfExercices={2} where Training_Id={3} and TypeOfStage='{4}'", St.GetNumberOfSets(), St.GetNumberOfExercices(), St.GetTypeOfExercice(), St.GetTrainingId(), St.GetTypeOfStage());
command = new SqlCommand(query, Conn);
command.ExecuteNonQuery();
Conn.Close();
}
public static StagesClass GetStageByTrainingIdAndType(int TrainigId, string StageType)
{
StagesClass St = new StagesClass();
Conn.Open();
string query = String.Format("Select * from [dbo].[Stages] where Training_id={0} and TypeOfStage='{1}'", TrainigId, StageType);
command = new SqlCommand(query, Conn);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
St = new StagesClass(Convert.ToInt32(reader["Id"]), Convert.ToInt32(reader["NumberOfSets"]), Convert.ToInt32(reader["NumberOfExercices"]), Convert.ToInt32(reader["TypeOfExercices"]), Convert.ToInt32(reader["Training_id"]), reader["TypeOfStage"].ToString());
}
Conn.Close();
return St;
}
