private void buttonAddStatisticUser_Click(object sender, EventArgs e)
{
string[,] sqlSelect = workWithDataBase.SelectFromDataBase("select dateOfBirth from Users where idUsers=" + SelectUserWindow.idSelectedUser, 1);
int age = Convert.ToInt32(DateTime.Now.Year - Convert.ToDateTime(sqlSelect[0, 0]).Year);
double CPwC = calculation.CalculationPowerCondition(int.Parse(textBoxPushUps.Text),
int.Parse(textBoxPullUps.Text),
int.Parse(textBoxSquts.Text),
int.Parse(textBoxPress.Text),
Convert.ToDouble(textBoxRun100.Text));
double CPhC = calculation.CalculationPhysicalCondition(int.Parse(textBoxPressureUp.Text),
int.Parse(textBoxPressureDown.Text),
age,
int.Parse(textBoxGrowth.Text),
int.Parse(textBoxWeight.Text),
int.Parse(textBoxPuls.Text));
workWithUsers.InsertStatisticsUser(SelectUserWindow.idSelectedUser,
int.Parse(textBoxPuls.Text),
int.Parse(textBoxPressureUp.Text),
int.Parse(textBoxPressureDown.Text),
int.Parse(textBoxGrowth.Text),
int.Parse(textBoxWeight.Text),
age,
int.Parse(textBoxPullUps.Text),
int.Parse(textBoxPushUps.Text),
(float)Convert.ToDouble(textBoxRun100.Text),
int.Parse(textBoxSquts.Text),
int.Parse(textBoxPullUps.Text),
(float)CPhC,
(float)CPwC);
addTpForUser.FillListViewStatisticUser(listViewStatisticUser);
addTpForUser.PicterBoxLoad(mainWindow.pictureBoxStatistic, mainWindow.nameColumnFromCoboBox[mainWindow.comboBoxSelectStatistic.SelectedIndex]);
mainWindow.FillUserBar();
}
private void buttonNext_Click(object sender, EventArgs e)
{
if (currentPageAddUserWindow == CurrentPageAddUserWindow.pageAddUser)
{
PageAddUser(false);
PagePulsPressure(true);
}
else if (currentPageAddUserWindow == CurrentPageAddUserWindow.pagePulsPressure)
{
PageGrowthWeight(true);
}
else if (currentPageAddUserWindow == CurrentPageAddUserWindow.pageGrowthWeight)
{
PagePullupPushUp(true);
}
else if (currentPageAddUserWindow == CurrentPageAddUserWindow.pagePullupPushUp)
{
PageSquatsRun100(true);
}
else if (currentPageAddUserWindow == CurrentPageAddUserWindow.pageSquatsRun100)
{
PagePress(true);
buttonNext.Text = "Добавить пользователя";
}
else if (currentPageAddUserWindow == CurrentPageAddUserWindow.pagePress)
{
workWithUsers.InsertUser(textBoxName.Text,
textBoxSecondName.Text,
comboBoxGender.Text,
dateTimePicker.Value.Date);
string[,] sqtResult = workWithDataBase.SelectFromDataBase("select * from Users where firstName = '" + textBoxName.Text + "' and lastName = '" + textBoxSecondName.Text + "' and gender = '" + comboBoxGender.Text + "' and dateOfBirth='" + dateTimePicker.Value.Date + "'", 1);
//idSelectedUser = Convert.ToInt32(sqtResult[0, 0]);
SelectUserWindow.idSelectedUser = Convert.ToInt32(sqtResult[0, 0]);
double CPwC = calculation.CalculationPowerCondition(int.Parse(textBoxPushUps.Text),
int.Parse(textBoxPullUps.Text),
int.Parse(textBoxSquts.Text),
int.Parse(textBoxPress.Text),
Convert.ToDouble(textBoxRun100.Text));
int age = Convert.ToInt32(DateTime.Now.Year - dateTimePicker.Value.Date.Year);
double CPhC = calculation.CalculationPhysicalCondition(int.Parse(textBoxPressureUp.Text),
int.Parse(textBoxPressureDown.Text),
age,
int.Parse(textBoxGrowth.Text),
int.Parse(textBoxWeight.Text),
int.Parse(textBoxPuls.Text));
workWithUsers.InsertStatisticsUser(SelectUserWindow.idSelectedUser,
int.Parse(textBoxPuls.Text),
int.Parse(textBoxPressureUp.Text),
int.Parse(textBoxPressureDown.Text),
int.Parse(textBoxGrowth.Text),
int.Parse(textBoxWeight.Text),
age,
int.Parse(textBoxPullUps.Text),
int.Parse(textBoxPushUps.Text),
(float)Convert.ToDouble(textBoxRun100.Text),
int.Parse(textBoxSquts.Text),
int.Parse(textBoxPullUps.Text),
(float)CPhC,
(float)CPwC);
isSelected = true;
this.Close();
mainWindow.FillUserBar();
}
}
