private void AllDirections_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
DBOrders NewOrder = new DBOrders(Convert.ToInt32(DirectionsTable.Rows[AllDirections.SelectedIndex][1]), CurrentUser);
SendedObject Send = new SendedObject(CurrentUser, NewOrder as object);
Switcher.Switch(new MakeOrder(), Send);
}
public void UtilizeState(object state)
{
SendedObject InData = state as SendedObject;
CurrentUser = InData.SendedUser;
HowToSort.Items.Add("Времени в пути");
HowToSort.Items.Add("Цене за 1 кг");
Order.Items.Add("По возрастанию");
Order.Items.Add("По убыванию");
}
public void UtilizeState(object state)
{
SendedObject InData = state as SendedObject;
CurrentUser = InData.SendedUser;
ShowStatus.Text += " " + CurrentUser.UserStatusV;
ShowRegistrationDate.Text += " " + CurrentUser.RegistrarionDateV.ToShortDateString();
UsernameOut.Text = " " + CurrentUser.UsernameV;
OrdersAmount();
LoadOrders();
}
public void UtilizeState(object state)
{
SendedObject InData = state as SendedObject;
CurrentUser = InData.SendedUser;
NewOrder = InData.Data as DBOrders;
getOrderInfo();
Direction.Text = Direction.Text + " " + OrderInfo.Rows[0][0] + " - " + OrderInfo.Rows[0][1];
DepartureDate.Text = DepartureDate.Text + " " + Convert.ToDateTime(OrderInfo.Rows[0][2]).ToLongDateString();
DepartureTime.Text = DepartureTime.Text + " " + OrderInfo.Rows[0][3];
ArrivalTime.Text = ArrivalTime.Text + " " + OrderInfo.Rows[0][4];
NewOrder.OrderV = Convert.ToInt32(OrderInfo.Rows[0][5]) + 1;
}
private void Enter(object sender, RoutedEventArgs e)
{
if (UsernameEntered.Text.Length == 0)
{
UsernameEntered.BorderBrush = Brushes.Red;
UsernameError.Text = "Заполните это поле";
}
if (PasswordEntered.Password.Length == 0)
{
PasswordEntered.BorderBrush = Brushes.Red;
passwordError.Text = "Заполните это поле";
}
if (UsernameError.Text == "" && passwordError.Text == "")
{
string sqlCommand = "select UserPassword from Users where Username = '******'";
SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlCommand);
DataTable ThisUser = new DataTable();
DataTable ThisUserFound = new DataTable();
try
{
adapter.Fill(ThisUser);
}
catch (Exception ex)
{
Switcher.Switch(new pages.FirstPage());
}
if (ThisUser.Rows.Count == 0)
{
UsernameEntered.BorderBrush = Brushes.Red;
UsernameError.Text = "Пользователь не найден, проверьте введённые данные";
}
else
{
if (Convert.ToString(ThisUser.Rows[0][0]) != PasswordEntered.Password)
{
PasswordEntered.BorderBrush = Brushes.Red;
passwordError.Text = "Неверный пароль";
}
else
{
sqlCommand = "select * from Users where Username = '******'";
adapter = ConnectionToDatabase.GetRequestResult(sqlCommand);
adapter.Fill(ThisUserFound);
DBUsers EnteredUser = new DBUsers((string)ThisUserFound.Rows[0][0], (string)ThisUserFound.Rows[0][1], (long)ThisUserFound.Rows[0][3], (string)ThisUserFound.Rows[0][2], (DateTime)ThisUserFound.Rows[0][4], (int)ThisUserFound.Rows[0][5]);
SendedObject Send = new SendedObject(EnteredUser);
Switcher.Switch(new UserMainPage(), Send);
}
}
}
}
public void UtilizeState(object state)
{
SendedObject IncomeObject = state as SendedObject;
CurrentUser = IncomeObject.SendedUser;
GreetingsText.Text = GreetingsText.Text + " " + CurrentUser.UsernameV;
if (CurrentUser.UserStatusV == "Admin" || CurrentUser.UserStatusV == "Carrier")
{
DirectionsControl.Visibility = Visibility.Visible;
}
if (CurrentUser.UserStatusV == "Admin")
{
AccountControl.Visibility = Visibility.Visible;
}
}
private void Register(object sender, RoutedEventArgs e)
{
string sqlRequest = "select Username from Users where Username = '******'";
DataTable Usernames = new DataTable();
try
{
if (UsernameEntered.Text.Length == 0)
{
usernameError.Text = "Заполните это поле";
UsernameEntered.BorderBrush = Brushes.Red;
}
else
{
if (Regex.IsMatch(UsernameEntered.Text, @"\W"))
{
usernameError.Text = "Имя пользователя должно состоять из чисел и букв";
UsernameEntered.BorderBrush = Brushes.Red;
}
else
{
SqlDataAdapter adapter = ConnectionToDatabase.GetRequestResult(sqlRequest);
adapter.Fill(Usernames);
if (Usernames.Rows.Count != 0)
{
usernameError.Text = "Имя пользователя занято";
UsernameEntered.BorderBrush = Brushes.Red;
}
}
}
if (PasswordEntered1.Password.Length == 0)
{
password1Error.Text = "Заполните это поле";
PasswordEntered1.BorderBrush = Brushes.Red;
}
else
{
if (PasswordEntered1.Password.Length < 4)
{
password1Error.Text = "Пароль слишком короткий (минимум 4 символа)";
PasswordEntered1.BorderBrush = Brushes.Red;
}
}
if (PasswordEntered2.Password.Length == 0)
{
password2Error.Text = "Заполните это поле";
PasswordEntered2.BorderBrush = Brushes.Red;
}
else
{
if (PasswordEntered1.Password != PasswordEntered2.Password)
{
password2Error.Text = "Пароли не совпадают";
PasswordEntered1.BorderBrush = Brushes.Red;
PasswordEntered2.BorderBrush = Brushes.Red;
}
}
if (PhoneNumber.Text.Length == 0)
{
phoneError.Text = "Заполните это поле";
PhoneNumber.BorderBrush = Brushes.Red;
}
else
{
if (PhoneNumber.Text.Length < 12 || Regex.IsMatch(PhoneNumber.Text, @"\D"))
{
phoneError.Text = "Введите корректный номер мобильного телефона, начиная с цифры";
PhoneNumber.BorderBrush = Brushes.Red;
}
}
if (usernameError.Text == "" && password1Error.Text == "" && password2Error.Text == "" && phoneError.Text == "")
{
DBUsers CurrentUser = new DBUsers(UsernameEntered.Text, PasswordEntered1.Password, Convert.ToInt64(PhoneNumber.Text));
sqlRequest = "insert into " +
"USERS (Username, UserPassword, PhoneNumber, RegistrationDate, Ranking) " +
"values ('" + CurrentUser.UsernameV + "', '" + CurrentUser.UserPasswordV + "', '" + CurrentUser.PhoneNumberV + "', '" + CurrentUser.RegistrarionDateV.Year + "-" + CurrentUser.RegistrarionDateV.Month + "-" + CurrentUser.RegistrarionDateV.Day + "', '" + CurrentUser.RankingV + "')";
int i = ConnectionToDatabase.insertData(sqlRequest);
if (i == 0)
{
SendedObject send = new SendedObject(CurrentUser);
Switcher.Switch(new UserMainPage(), send);
}
}
}
catch
{
Switcher.Switch(new FirstPage());
}
}
private void ToUserCabinet(object sender, RoutedEventArgs e)
{
SendedObject Send = new SendedObject(CurrentUser);
Switcher.Switch(new UserCabinet(), Send);
}
public void UtilizeState(object state)
{
SendedObject InData = state as SendedObject;
CurrentUser = InData.SendedUser;
}
private void ToMessages(object sender, RoutedEventArgs e)
{
Send = new SendedObject(CurrentUser);
Switcher.Switch(new Messages(), Send);
}
private void ToRunsControl(object sender, RoutedEventArgs e)
{
Send = new SendedObject(CurrentUser);
Switcher.Switch(new RunsControl2(), Send);
}
private void ToFindDirection()
{
Send = new SendedObject(CurrentUser);
Switcher.Switch(new FindDirection(), Send);
}
private void ToUserMainPage(object sender, RoutedEventArgs e)
{
SendedObject send = new SendedObject(CurrentUser);
Switcher.Switch(new UserMainPage(), send);
}
