private void Window_Loaded(object sender, RoutedEventArgs e)
{
timerStart();
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(FindResource("marathonDataSet")));
// Загрузить данные в таблицу Runner. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.RunnerTableAdapter marathonDataSetRunnerTableAdapter = new WpfApp1.marathonDataSetTableAdapters.RunnerTableAdapter();
marathonDataSetRunnerTableAdapter.SerchEmail(marathonDataSet.Runner, Runner.Email);
System.Windows.Data.CollectionViewSource runnerViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("runnerViewSource")));
runnerViewSource.View.MoveCurrentToFirst();
// Загрузить данные в таблицу User. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.UserTableAdapter marathonDataSetUserTableAdapter = new WpfApp1.marathonDataSetTableAdapters.UserTableAdapter();
marathonDataSetUserTableAdapter.SerchEmail(marathonDataSet.User, Runner.Email);
System.Windows.Data.CollectionViewSource userViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("userViewSource")));
userViewSource.View.MoveCurrentToFirst();
// Загрузить данные в таблицу Country. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.CountryTableAdapter marathonDataSetCountryTableAdapter = new WpfApp1.marathonDataSetTableAdapters.CountryTableAdapter();
marathonDataSetCountryTableAdapter.SerchKod(marathonDataSet.Country, Runner.CountryCode);
System.Windows.Data.CollectionViewSource countryViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("countryViewSource")));
countryViewSource.View.MoveCurrentToFirst();
var bitmap = new BitmapImage();
string sq = AppDomain.CurrentDomain.BaseDirectory + photoTextBox.Text;
bitmap.BeginInit();
bitmap.UriSource = new Uri($"{sq}", UriKind.Absolute);
bitmap.EndInit();
bitmap.Freeze();
PhotoUser.Source = bitmap;
// Загрузить данные в таблицу Gender. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.GenderTableAdapter marathonDataSetGenderTableAdapter = new WpfApp1.marathonDataSetTableAdapters.GenderTableAdapter();
marathonDataSetGenderTableAdapter.Fill(marathonDataSet.Gender);
System.Windows.Data.CollectionViewSource genderViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("genderViewSource")));
genderViewSource.View.MoveCurrentToFirst();
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
WpfApp1.marathonDataSetTableAdapters.RunnerTableAdapter runnerTableAdapter = new marathonDataSetTableAdapters.RunnerTableAdapter();
WpfApp1.marathonDataSetTableAdapters.RegistrationTableAdapter registrationTableAdapter = new marathonDataSetTableAdapters.RegistrationTableAdapter();
WpfApp1.marathonDataSetTableAdapters.CharityTableAdapter charityTableAdapter = new marathonDataSetTableAdapters.CharityTableAdapter();
if (!(bool)KM32.IsChecked && !(bool)KM23.IsChecked && !(bool)KM5.IsChecked)
{
MessageBox.Show("Выберите хотя бы 1 дистанцию"); return;
}
if (!(bool)VarA.IsChecked && !(bool)VarB.IsChecked && !(bool)VarC.IsChecked)
{
MessageBox.Show("Выберите комплект"); return;
}
try
{
Convert.ToInt32(PriceTextBox.Text);
}
catch { MessageBox.Show("Сумма взноса должна быть числом"); }
runnerTableAdapter.Runner(marathonDataSet.Runner, Runner.Email, Runner.Gender, Runner.CountryCode, Runner.Photo);
charityTableAdapter.FillBy(marathonDataSet.Charity, charityNameComboBox.Text);
int runnerid = Convert.ToInt32(marathonDataSet.Runner[0][0].ToString());
if (Convert.ToInt32(PriceTextBox.Text) < Convert.ToInt32(priceAll))
{
registrationTableAdapter.InsertReg(runnerid, DateTime.Now, variant, 1, priceAll, Convert.ToInt32(marathonDataSet.Charity[0][0].ToString()), Convert.ToDecimal(Price.Text));
}
registrationTableAdapter.InsertReg(runnerid, DateTime.Now, variant, 2, priceAll, Convert.ToInt32(marathonDataSet.Charity[0][0].ToString()), Convert.ToDecimal(priceAll));
RegistrationConfirmation registrationConfirmation = new RegistrationConfirmation();
registrationConfirmation.Show();
Close();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
Img1.Source = Img2.Source = Img3.Source = Img4.Source = Img5.Source = Img6.Source = new BitmapImage(new Uri(AppDomain.CurrentDomain.BaseDirectory + "cross-icon.png", UriKind.Absolute));
timerStart();
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
marathonDataSetTableAdapters.Registration1TableAdapter registration1TableAdapter = new marathonDataSetTableAdapters.Registration1TableAdapter();
registration1TableAdapter.A(marathonDataSet.Registration1);
TypeA0.Text = TypeA1.Text = TypeA2.Text = marathonDataSet.Registration1[0][1].ToString();
registration1TableAdapter.B(marathonDataSet.Registration1);
TypeB0.Text = TypeB1.Text = TypeB2.Text = TypeB3.Text = TypeB4.Text = marathonDataSet.Registration1[0][1].ToString();
registration1TableAdapter.C(marathonDataSet.Registration1);
TypeC0.Text = TypeC1.Text = TypeC2.Text = TypeC3.Text = TypeC4.Text = TypeC5.Text = TypeC6.Text = marathonDataSet.Registration1[0][1].ToString();
marathonDataSetTableAdapters.InventoryTableAdapter inventoryTableAdapter = new marathonDataSetTableAdapters.InventoryTableAdapter();
inventoryTableAdapter.Fill(marathonDataSet.Inventory);
neob0.Text = Convert.ToString(Convert.ToInt32(TypeA0.Text) + Convert.ToInt32(TypeB0.Text) + Convert.ToInt32(TypeC0.Text));
neob1.Text = Convert.ToString(Convert.ToInt32(TypeA1.Text) + Convert.ToInt32(TypeB1.Text) + Convert.ToInt32(TypeC1.Text));
neob2.Text = Convert.ToString(Convert.ToInt32(TypeA2.Text) + Convert.ToInt32(TypeB2.Text) + Convert.ToInt32(TypeC2.Text));
neob3.Text = Convert.ToString(Convert.ToInt32(TypeB3.Text) + Convert.ToInt32(TypeC3.Text));
neob4.Text = Convert.ToString(Convert.ToInt32(TypeB4.Text) + Convert.ToInt32(TypeC4.Text));
neob5.Text = Convert.ToString(Convert.ToInt32(TypeC5.Text));
neob6.Text = Convert.ToString(Convert.ToInt32(TypeC6.Text));
ost1.Text = marathonDataSet.Inventory[0][2].ToString();
ost2.Text = marathonDataSet.Inventory[1][2].ToString();
ost3.Text = marathonDataSet.Inventory[2][2].ToString();
ost4.Text = marathonDataSet.Inventory[3][2].ToString();
ost5.Text = marathonDataSet.Inventory[4][2].ToString();
ost6.Text = marathonDataSet.Inventory[5][2].ToString();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
//Image logo = new Image();
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
//WpfApp1.marathonDataSetTableAdapters.DataTable2TableAdapter dataTable2TableAdapter = new marathonDataSetTableAdapters.DataTable2TableAdapter();
//WpfApp1.marathonDataSetTableAdapters.DataTable1TableAdapter dataTable1TableAdapter = new marathonDataSetTableAdapters.DataTable1TableAdapter();
//dataTable1TableAdapter.findID(marathonDataSet.DataTable1, Perem.Runner);
//string id = marathonDataSet.DataTable1[0][1].ToString();
WpfApp1.marathonDataSetTableAdapters.CharityTableAdapter charityTableAdapter = new marathonDataSetTableAdapters.CharityTableAdapter();
charityTableAdapter.FillBy(marathonDataSet.Charity, Perem.CharityName);
//dataTable2TableAdapter.FillBy(marathonDataSet.DataTable2, Convert.ToInt32(id));
//Perem.CharityName = marathonDataSet.DataTable2[0][1].ToString();
//Perem.CharityDescription = marathonDataSet.DataTable2[0][2].ToString();
//Perem.LogoName = marathonDataSet.DataTable2[0][3].ToString();
//string sor = $"pack://application:,,,/Images\\diabetes_brazil_logo.png";
BitmapImage logo = new BitmapImage();
string sq = AppDomain.CurrentDomain.BaseDirectory + marathonDataSet.Charity[0][3].ToString();
logo.BeginInit();
logo.UriSource = new Uri($"{sq}", UriKind.Absolute);
logo.EndInit();
CharityName.Content = Perem.CharityName;
CharityDiscription.Text = marathonDataSet.Charity[0][2].ToString();
ImageLogo.Source = logo;
}
private void Button_Click_2(object sender, RoutedEventArgs e)
{
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(FindResource("marathonDataSet")));
WpfApp1.marathonDataSetTableAdapters.RunnerTableAdapter runnerTableAdapter = new marathonDataSetTableAdapters.RunnerTableAdapter();
WpfApp1.marathonDataSetTableAdapters.CountryTableAdapter countryTableAdapter = new marathonDataSetTableAdapters.CountryTableAdapter();
WpfApp1.marathonDataSetTableAdapters.UserTableAdapter userTableAdapter = new marathonDataSetTableAdapters.UserTableAdapter();
if (emailTextBox.Text.Length == 0)
{
MessageBox.Show("Введите маил"); return;
}
try
{
System.Net.Mail.MailAddress mailAddress = new System.Net.Mail.MailAddress(emailTextBox.Text);
}
catch { MessageBox.Show("не верный маил"); return; }
if (firstNameTextBox.Text.Length == 0)
{
MessageBox.Show("Введите имя"); return;
}
if (lastNameTextBox.Text.Length == 0)
{
MessageBox.Show("Введите фамилию"); return;
}
if (photoTextBox.Text.Length == 0)
{
MessageBox.Show("Выберите фото"); return;
}
if (dateOfBirthDatePicker.SelectedDate.Value.Year > DateTime.Now.Year)
{
MessageBox.Show("Год не может быть больше текущего"); return;
}
if ((DateTime.Now.Year - dateOfBirthDatePicker.SelectedDate.Value.Year) < 10)
{
MessageBox.Show("дети младше 10 лет не могут быть бегунами"); return;
}
if (PassTbox.Text.Length == 0 && PassTbox1.Text.Length == 0)
{
userTableAdapter.UpdateUserPass(firstNameTextBox.Text, lastNameTextBox.Text, Runner.Email);
runnerTableAdapter.UpdateRunner(genderComboBox.Text, dateOfBirthDatePicker.SelectedDate, countryCodeTextBox.Text, photoTextBox.Text, Runner.Email);
}
else
{
if (PassTbox.Text != PassTbox1.Text)
{
MessageBox.Show("Пароли не совпадают"); return;
}
Regex reg = new Regex("^(?=.*?[A-Z])(?=.*?[a-z])(?=.*?[0-9])(?=.*?[#?!@$%^&*-]).{6,}$");
string ss = Convert.ToString(reg.Match(PassTbox.Text));
if (ss.Length == 0)
{
MessageBox.Show("Пароль должен отвечать следующим требованиям:\n" +
"•Минимум 6 символов\n•Минимум 1 прописная буква\n•Минимум 1 цифра\n•По крайней мере один из следующих символов: ! @ # $ % ^ "); return;
}
userTableAdapter.UpdateUserAndPass(PassTbox.Text, firstNameTextBox.Text, lastNameTextBox.Text, Runner.Email);
runnerTableAdapter.UpdateRunner(genderComboBox.Text, dateOfBirthDatePicker.SelectedDate, countryCodeTextBox.Text, photoTextBox.Text, Runner.Email);
}
Close();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
timerStart();
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
// Загрузить данные в таблицу Charity1. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.Charity1TableAdapter marathonDataSetCharity1TableAdapter = new WpfApp1.marathonDataSetTableAdapters.Charity1TableAdapter();
marathonDataSetCharity1TableAdapter.Fill(marathonDataSet.Charity1);
System.Windows.Data.CollectionViewSource charity1ViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("charity1ViewSource")));
charity1ViewSource.View.MoveCurrentToFirst();
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
if (TboxMail.Text.Length == 0 || TboxPass.Text.Length == 0)
{
MessageBox.Show("Введите mail и пароль"); return;
}
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
WpfApp1.marathonDataSetTableAdapters.UserTableAdapter userTableAdapter = new marathonDataSetTableAdapters.UserTableAdapter();
WpfApp1.marathonDataSetTableAdapters.RunnerTableAdapter runnerTableAdapter = new marathonDataSetTableAdapters.RunnerTableAdapter();
runnerTableAdapter.SerchEmail(marathonDataSet.Runner, TboxMail.Text);
userTableAdapter.FillBy(marathonDataSet.User, TboxMail.Text, TboxPass.Text);
if (userTableAdapter.FillBy(marathonDataSet.User, TboxMail.Text, TboxPass.Text) == 0)
{
MessageBox.Show("Такой комбинации логина и пароля не существует"); return;
}
string role = marathonDataSet.User[0][4].ToString();
Runner.ID = marathonDataSet.Runner[0][0].ToString();
Runner.Email = TboxMail.Text;
Runner.Password = TboxPass.Text;
Runner.CountryCode = marathonDataSet.Runner[0][4].ToString();
switch (role)
{
case "R": //бегун
{
RunnerMenu runnerMenu = new RunnerMenu();
runnerMenu.Show();
Close();
break;
}
case "A": //Админ
{
AdminMenu adminMenu = new AdminMenu();
adminMenu.Show();
Close();
MessageBox.Show("Default case");
break;
}
case "K": //Координатор
{
CoordinatorMenu coordinatorMenu = new CoordinatorMenu();
coordinatorMenu.Show();
Close();
break;
}
default:
{
break;
}
}
}
private void Label_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
WpfApp1.marathonDataSetTableAdapters.CharityTableAdapter charityTableAdapter = new marathonDataSetTableAdapters.CharityTableAdapter();
charityTableAdapter.FillBy(marathonDataSet.Charity, charityNameComboBox.Text);
Perem.CharityName = marathonDataSet.Charity[0][1].ToString();
CharityView nn = new CharityView();
nn.ShowDialog();
charityTableAdapter.Fill(marathonDataSet.Charity);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
timerStart();
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(FindResource("marathonDataSet")));
// Загрузить данные в таблицу Charity. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.CharityTableAdapter marathonDataSetCharityTableAdapter = new WpfApp1.marathonDataSetTableAdapters.CharityTableAdapter();
marathonDataSetCharityTableAdapter.Fill(marathonDataSet.Charity);
marathonDataSetCharityTableAdapter.SerchID(marathonDataSet.Charity, Perem.CharityID);
System.Windows.Data.CollectionViewSource charityViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("charityViewSource")));
charityViewSource.View.MoveCurrentToFirst();
LogoImg.Source = new BitmapImage(new Uri(AppDomain.CurrentDomain.BaseDirectory + charityLogoTextBox.Text, UriKind.Absolute));
charityLogoTextBox.Text = "";
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
NewInventory newInventory = new NewInventory();
newInventory.ShowDialog();
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(FindResource("marathonDataSet")));
marathonDataSetTableAdapters.InventoryTableAdapter inventoryTableAdapter = new marathonDataSetTableAdapters.InventoryTableAdapter();
inventoryTableAdapter.Fill(marathonDataSet.Inventory);
ost1.Text = marathonDataSet.Inventory[0][2].ToString();
ost2.Text = marathonDataSet.Inventory[1][2].ToString();
ost3.Text = marathonDataSet.Inventory[2][2].ToString();
ost4.Text = marathonDataSet.Inventory[3][2].ToString();
ost5.Text = marathonDataSet.Inventory[4][2].ToString();
ost6.Text = marathonDataSet.Inventory[5][2].ToString();
}
private void expr1ComboBox_DropDownClosed(object sender, EventArgs e)
{
key = 1;
string ss = expr1ComboBox.Text;
Perem.Runner = expr1ComboBox.Text;
Perem.PeopleName = expr1ComboBox.Text;
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
WpfApp1.marathonDataSetTableAdapters.DataTable2TableAdapter dataTable2TableAdapter = new marathonDataSetTableAdapters.DataTable2TableAdapter();
WpfApp1.marathonDataSetTableAdapters.DataTable1TableAdapter dataTable1TableAdapter = new marathonDataSetTableAdapters.DataTable1TableAdapter();
dataTable1TableAdapter.findID(marathonDataSet.DataTable1, expr1ComboBox.Text);
string id = marathonDataSet.DataTable1[0][1].ToString();
dataTable2TableAdapter.FillBy(marathonDataSet.DataTable2, Convert.ToInt32(id));
OrgName.Content = marathonDataSet.DataTable2[0][1].ToString();
dataTable1TableAdapter.FillBy1(marathonDataSet.DataTable1);
expr1ComboBox.Text = ss;
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
marathonDataSetTableAdapters.InventoryTableAdapter inventoryTableAdapter = new marathonDataSetTableAdapters.InventoryTableAdapter();
inventoryTableAdapter.Fill(marathonDataSet.Inventory);
int num = Convert.ToInt32(marathonDataSet.Inventory[0][2].ToString());;
int rfid = Convert.ToInt32(marathonDataSet.Inventory[1][2].ToString());
int beis = Convert.ToInt32(marathonDataSet.Inventory[2][2].ToString());
int water = Convert.ToInt32(marathonDataSet.Inventory[3][2].ToString());
int fytbolka = Convert.ToInt32(marathonDataSet.Inventory[4][2].ToString());
int bykl = Convert.ToInt32(marathonDataSet.Inventory[5][2].ToString());
inventoryTableAdapter.UpdateQuery("Номер", num + Convert.ToInt32(NumerTbox.Text));
inventoryTableAdapter.UpdateQuery("RFID", rfid + Convert.ToInt32((Rfid.Text)));
inventoryTableAdapter.UpdateQuery("Бейсболка", beis + Convert.ToInt32((beisbol.Text)));
inventoryTableAdapter.UpdateQuery("Бутылка воды", water + Convert.ToInt32((WaterTbox.Text)));
inventoryTableAdapter.UpdateQuery("Футболка", fytbolka + Convert.ToInt32((FytbTbox.Text)));
inventoryTableAdapter.UpdateQuery("Сувенирный буклет", bykl + Convert.ToInt32((ByklTbox.Text)));
Close();
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
timerStart();
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
// Загрузить данные в таблицу Gender. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.GenderTableAdapter marathonDataSetGenderTableAdapter = new WpfApp1.marathonDataSetTableAdapters.GenderTableAdapter();
marathonDataSetGenderTableAdapter.Fill(marathonDataSet.Gender);
System.Windows.Data.CollectionViewSource genderViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("genderViewSource")));
genderViewSource.View.MoveCurrentToFirst();
// Загрузить данные в таблицу Event. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.EventTableAdapter marathonDataSetEventTableAdapter = new WpfApp1.marathonDataSetTableAdapters.EventTableAdapter();
marathonDataSetEventTableAdapter.Fill(marathonDataSet.Event);
System.Windows.Data.CollectionViewSource eventViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("eventViewSource")));
eventViewSource.View.MoveCurrentToFirst();
// Загрузить данные в таблицу DataTable3. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.DataTable3TableAdapter marathonDataSetDataTable3TableAdapter = new WpfApp1.marathonDataSetTableAdapters.DataTable3TableAdapter();
marathonDataSetDataTable3TableAdapter.Fill(marathonDataSet.DataTable3, Convert.ToInt32(Runner.ID));
System.Windows.Data.CollectionViewSource dataTable3ViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("dataTable3ViewSource")));
dataTable3ViewSource.View.MoveCurrentToFirst();
}
private void Details_Click(object sender, RoutedEventArgs e)
{
for (var vis = sender as Visual; vis != null; vis = VisualTreeHelper.GetParent(vis) as Visual)
{
if (vis is DataGridRow)
{
Libra.Charity charity = new Libra.Charity();
var Selectedsell = this.charityDataGrid.Columns[0].GetCellContent(this.charityDataGrid.SelectedItem);
string Cell = Selectedsell.Parent.ToString();
string koll = "System.Windows.Controls.DataGridCell: ";
Cell = Cell.Remove(0, koll.Length);
Cell = Cell.Replace(" ", "");
Perem.CharityID = Convert.ToInt32(Cell);
AddOrEditCharity addOrEditCharity = new AddOrEditCharity();
addOrEditCharity.ShowDialog();
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
// Загрузить данные в таблицу Charity. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.CharityTableAdapter marathonDataSetCharityTableAdapter = new WpfApp1.marathonDataSetTableAdapters.CharityTableAdapter();
marathonDataSetCharityTableAdapter.Fill(marathonDataSet.Charity);
}
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
timerStart();
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
// Загрузить данные в таблицу DataTable1. Можно изменить этот код как требуется.
WpfApp1.marathonDataSetTableAdapters.DataTable1TableAdapter marathonDataSetDataTable1TableAdapter = new WpfApp1.marathonDataSetTableAdapters.DataTable1TableAdapter();
marathonDataSetDataTable1TableAdapter.FillBy1(marathonDataSet.DataTable1);
System.Windows.Data.CollectionViewSource dataTable1ViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("dataTable1ViewSource")));
dataTable1ViewSource.View.MoveCurrentToFirst();
string ss = expr1ComboBox.Text;
Perem.PeopleName = expr1ComboBox.Text;
// WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
WpfApp1.marathonDataSetTableAdapters.DataTable2TableAdapter dataTable2TableAdapter = new marathonDataSetTableAdapters.DataTable2TableAdapter();
WpfApp1.marathonDataSetTableAdapters.DataTable1TableAdapter dataTable1TableAdapter = new marathonDataSetTableAdapters.DataTable1TableAdapter();
dataTable1TableAdapter.findID(marathonDataSet.DataTable1, expr1ComboBox.Text);
string id = marathonDataSet.DataTable1[0][1].ToString();
dataTable2TableAdapter.FillBy(marathonDataSet.DataTable2, Convert.ToInt32(id));
OrgName.Content = marathonDataSet.DataTable2[0][1].ToString();
dataTable1TableAdapter.FillBy1(marathonDataSet.DataTable1);
expr1ComboBox.Text = ss;
}
private void Button_Click_3(object sender, RoutedEventArgs e)
{
try
{
Convert.ToInt32(TboxPrice.Text);
}
catch { MessageBox.Show("Сумма пожертвований должна быть числом"); return; }
if (Convert.ToInt32(TboxPrice.Text) == 0 || Convert.ToInt32(TboxPrice.Text) < 0)
{
MessageBox.Show("Сумма не может быть меньше или равна 0");
return;
}
if (TboxName1.Text.Length == 0)
{
MessageBox.Show("Введите имя и фамилию плательщика"); return;
}
if (expr1ComboBox.SelectedIndex == -1)
{
MessageBox.Show("Выберите"); return;
}
if (TboxVladCart.Text.Length == 0)
{
MessageBox.Show("Введите владельца карты"); return;
}
if (TboxNumberCart.Text.Length != 16)
{
MessageBox.Show("Номер карты должен состоять из 16 цифр"); return;
}
int iwwwe;
int iwwwe1;
try
{
iwwwe = Convert.ToInt32(TboxNumberCart.Text.Substring(0, 8));
iwwwe1 = Convert.ToInt32(TboxNumberCart.Text.Substring(8, 8));
}
catch { MessageBox.Show("Номер карты должен состоять только из цифр"); return; }
if (Convert.ToInt32(TboxSrokMunf.Text) > 12)
{
MessageBox.Show("Месяц не может быть больше 12");
}
if (TboxSrokMunf.Text.Length == 0)
{
MessageBox.Show("Введите месяц на карте"); return;
}
if (TboxSrokYear.Text.Length == 0)
{
MessageBox.Show("Введите год карты"); return;
}
if (TboxCVC.Text.Length == 0)
{
MessageBox.Show("Введите CVC"); return;
}
try
{
Convert.ToInt32(TboxSrokMunf.Text);
Convert.ToInt32(TboxSrokYear.Text);
Convert.ToInt32(TboxCVC.Text);
}
catch
{
MessageBox.Show("срок дейсвия и CVC должен быть числом "); return;
}
if (Convert.ToInt32(TboxSrokYear.Text) < DateTime.Now.Year)
{
MessageBox.Show("Ваша карта не действительна"); return;
}
else
{
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
WpfApp1.marathonDataSetTableAdapters.DataTable1TableAdapter dataTable1TableAdapter = new marathonDataSetTableAdapters.DataTable1TableAdapter();
int i = dataTable1TableAdapter.findID(marathonDataSet.DataTable1, expr1ComboBox.Text);
string h = marathonDataSet.DataTable1[0][1].ToString();
WpfApp1.marathonDataSetTableAdapters.SponsorshipTableAdapter sponsorshipTableAdapter = new marathonDataSetTableAdapters.SponsorshipTableAdapter();
sponsorshipTableAdapter.InsertQuery(TboxName1.Text, Convert.ToInt32(h), Convert.ToDecimal(TboxPrice.Text));
//MessageBox.Show("Спасибо за поддержку"); Close();
Perem.Price = Convert.ToInt32(TboxPrice.Text);
Podtw podtw = new Podtw();
podtw.ShowDialog();
Close();
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
WpfApp1.marathonDataSetTableAdapters.StaffTableAdapter staff = new marathonDataSetTableAdapters.StaffTableAdapter();
// staff.Id(marathonDataSet.Staff, 2);
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(FindResource("marathonDataSet")));
marathonDataSetTableAdapters.CountryTableAdapter countryTableAdapter = new marathonDataSetTableAdapters.CountryTableAdapter();
countryTableAdapter.Fill(marathonDataSet.Country);
}
private void Button_Click_2(object sender, RoutedEventArgs e)//Регистрация
{
if (TboxMail.Text.Length == 0)
{
MessageBox.Show("Введите Mail"); return;
}
try
{
System.Net.Mail.MailAddress mailAddress = new System.Net.Mail.MailAddress(TboxMail.Text);
}
catch { MessageBox.Show("не рабочий mail"); return; }
if (TboxPass.Text.Length < 6)
{
MessageBox.Show("Введите пароль, не менее 6 символов"); return;
}
Regex reg = new Regex("^(?=.*?[A-Z])(?=.*?[a-z])(?=.*?[0-9])(?=.*?[#?!@$%^&*-]).{6,}$");
string ss = Convert.ToString(reg.Match(TboxPass.Text));
if (ss.Length == 0)
{
MessageBox.Show("Пароль должен отвечать следующим требованиям:\n" +
"•Минимум 6 символов\n•Минимум 1 прописная буква\n•Минимум 1 цифра\n•По крайней мере один из следующих символов: ! @ # $ % ^ "); return;
}
if (TboxPassPodtv.Text.Length == 0)
{
MessageBox.Show("Введите повтор пароля"); return;
}
if (TboxPass.Text != TboxPassPodtv.Text)
{
MessageBox.Show("Пароль и его подтверждение не совпадают"); return;
}
if (TboxFirstName.Text.Length == 0)
{
MessageBox.Show("Введите Имя"); return;
}
if (TboxSecondName.Text.Length == 0)
{
MessageBox.Show("Введите фамилию"); return;
}
if (countryCodeTextBox.Text.Length == 0)
{
MessageBox.Show("Выберите страну"); return;
}
DateTime n1 = DateOfbirth.DisplayDate;
if ((DateTime.Now.Year - n1.Year) < 10)
{
MessageBox.Show("Бегуны младше 10 лет не принимаются на марафон"); return;
}
if (n1.Year > DateTime.Now.Year)
{
MessageBox.Show("Дата рождения введена не верно"); return;
}
WpfApp1.marathonDataSet marathonDataSet = ((WpfApp1.marathonDataSet)(this.FindResource("marathonDataSet")));
WpfApp1.marathonDataSetTableAdapters.RunnerTableAdapter runnerTableAdapter = new marathonDataSetTableAdapters.RunnerTableAdapter();
WpfApp1.marathonDataSetTableAdapters.UserTableAdapter userTableAdapter = new marathonDataSetTableAdapters.UserTableAdapter();
runnerTableAdapter.SerchEmail(marathonDataSet.Runner, TboxMail.Text);
if (marathonDataSet.Runner.Count != 0)
{
MessageBox.Show("Такой Ьаил уже зарегестрироывн"); return;
}
userTableAdapter.InsertUser(TboxMail.Text, TboxPass.Text, TboxFirstName.Text, TboxSecondName.Text, "R");
runnerTableAdapter.InserеRunner(TboxMail.Text, genderComboBox.Text, DateOfbirth.SelectedDate, countryCodeTextBox.Text, fotoname.Text);
RegisterForAnEvent registerForAnEvent = new RegisterForAnEvent();
Runner.CountryCode = countryCodeTextBox.Text;
Runner.Email = TboxMail.Text;
Runner.Gender = genderComboBox.Text;
Runner.Photo = fotoname.Text;
registerForAnEvent.Show();
Close();
}
