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