}//клик на ПОИСК МАРШРУТА
private void SearchStopsMenu()
{
GridColumn1.ItemsSource = null;
GridColumn2.Items.Clear();
GridColumn3.Items.Clear();
KursWorkEntities db = new KursWorkEntities();
string s = Convert.ToString(SeacrhButton.SelectedItem);
//try
//{
IQueryable <Stop> queryableStop = from t in db.Stop
where t.StopName == s
select t;
ObservableCollection <SomeShit> keka = new ObservableCollection <SomeShit>();
foreach (Stop t in queryableStop)
{
ListBoxItem listBoxItem = new ListBoxItem();
listBoxItem.Content = t.StopName;
listBoxItem.Selected += ListBoxItem_Selected;
GridColumn2.Items.Add(listBoxItem);
}
IQueryable <Route> queryableRoute = from t in db.Stop
where t.StopName == s
select t.Route;
foreach (Route t in queryableRoute)
{
SomeShit some = new SomeShit(t.RouteName);
some.isFav = "true";
keka.Add(some);
}
GridColumn1.ItemsSource = keka;
}//клик на ПОИСК
}//Раскрытие списка
private void StopMenu()
{
TitleOfSelected.Text = "Остановки";
//GridColumn1.Items.Clear();
GridColumn1.SelectionChanged -= GridColumn1_SelectionChanged1;
GridColumn1.SelectionChanged -= MetroSelect;
GridColumn1.SelectionChanged -= Stops_Time;
GridColumn1.ItemsSource = null;
GridColumn2.Items.Clear();
KursWorkEntities db = new KursWorkEntities();
IQueryable <Stop> queryable = from t in db.Stop select t;
ObservableCollection <SomeShit> keka = new ObservableCollection <SomeShit>();
foreach (Stop ds in queryable)
{
ListBoxItem item = new ListBoxItem();
SomeShit ss = new SomeShit(ds.Route.RouteType + " " + ds.Route.RouteNumber + ". " + ds.StopName);
ss.isFav = "false";
keka.Add(ss);
}
GridColumn1.ItemsSource = keka;
GridColumn1.SelectionChanged -= GridColumn1_SelectionChanged1;
GridColumn1.SelectionChanged += Stops_Time;
}//Клик на Остановки
}//клик на МЕТРО
private void FavoriteMenu()
{
TitleOfSelected.Text = "Избранное";
GridColumn1.SelectionChanged -= GridColumn1_SelectionChanged1;
GridColumn1.SelectionChanged -= MetroSelect;
GridColumn1.ItemsSource = null;
KursWorkEntities db = new KursWorkEntities();
ObservableCollection <SomeShit> keka = new ObservableCollection <SomeShit>();
var queryableUser = db.Users
.Where(c => c.UserLogin == Users.Login)
.FirstOrDefault();
try
{
SomeShit someShit = new SomeShit(queryableUser.UserFavourite);
someShit.isFav = "true";
keka.Add(someShit);
GridColumn1.ItemsSource = keka;
}
catch (NullReferenceException)
{
MessageBox.Show("Необходимо войти");
}
}//клик на ИЗБРАННОЕ
private void MetroSelect(object sender, SelectionChangedEventArgs e)
{
GridColumn2.Items.Clear();
ListBox listBox = (ListBox)sender;
SomeShit someShit = (SomeShit)listBox.SelectedItems[0];
string TempStr = someShit.text;
KursWorkEntities db = new KursWorkEntities();
IQueryable <int> query = from t in db.Metro
where t.NameBranch == TempStr
select t.ID;
int cifra = query.FirstOrDefault();
IQueryable <Metro_Branch> queryable = from t in db.Metro_Branch
where t.Number == cifra
select t;
foreach (Metro_Branch t in queryable)
{
ListBoxItem listBoxItem = new ListBoxItem();
listBoxItem.Content = t.NameStation;
listBoxItem.Selected += NameMetroStation_Time;
GridColumn2.Items.Add(listBoxItem);
}
}
private void GridColumn1_SelectionChanged1(object sender, SelectionChangedEventArgs e)//Вывод остановок
{
GridColumn2.Items.Clear();
ListBox listBox = (ListBox)sender;
SomeShit someShit = (SomeShit)listBox.SelectedItems[0];
//----------------------------------
someShit.isFav = "true";
//----------------------------------
string TempStr = someShit.text;
string sad = " ";
int index = TempStr.IndexOf(sad) + 3;
string FinalStr = TempStr.Remove(0, index);
KursWorkEntities db = new KursWorkEntities();
IQueryable <int> queryable = from t in db.Route
where t.RouteName == FinalStr
select t.RouteID;
List <int> listT = queryable.ToList();
int Id = Convert.ToInt32(listT[0]);
IQueryable <string> StopQuery = from t in db.Stop
where t.StopNum == Id
select t.StopName;
foreach (string s in StopQuery)
{
ListBoxItem listBoxItem = new ListBoxItem();
listBoxItem.Selected += ListBoxItem_Selected;
listBoxItem.Content = s;
GridColumn2.Items.Add(listBoxItem);
}
}
private void logIn(TextBlock In)
{
KursWorkEntities db = new KursWorkEntities();
string tempLog = RegLogin.Text;
string tempPass = RegPassword.Password;
if (Users.Login != null && Users.Password != null)
{
MessageBox.Show("Необходимо выйти");
return;
}
string validate = "^[a-zA-Z0-9]+$";
Regex regex = new Regex(validate);
if (regex.IsMatch(tempLog))
{
;
}
else
{
MessageBox.Show("Неправильно введён логин");
}
var hasNumber = new Regex(@"[0-9]+");
var hasUpperChar = new Regex(@"[A-Z]+");
var hasMinimum6Chars = new Regex(@".{6,}");
if (hasNumber.IsMatch(RegPassword.Password) && hasUpperChar.IsMatch(RegPassword.Password) && hasMinimum6Chars.IsMatch(RegPassword.Password))
{
;
}
else
{
MessageBox.Show("Неправильно введён пароль: Необходимо присутствие цифры, буквы в верхнем регистре и длина пароля минимум 6 символов");
return;
}
IQueryable <Users> temp = from t in db.Users where t.UserLogin == tempLog && t.UserPassword == tempPass select t;
db.Users.Where(t => t.UserLogin == tempLog && t.UserPassword == tempPass);
foreach (Users usrs in temp)
{
MessageBox.Show("Аутентификация прошла успешно");
Users.Login = RegLogin.Text;
Users.Password = RegLogin.Text;
In.Text = "Выйти";
}
Close();
}
private void ListBoxItem_Selected(object sender, RoutedEventArgs e)//маршруты-остановки-время
{
ListBoxItem temp = (ListBoxItem)sender;
string content = Convert.ToString(temp.Content);
KursWorkEntities db = new KursWorkEntities();
IQueryable <Stop> SomeQuery = from t in db.Stop
where t.StopName == content
select t;
foreach (Stop t in SomeQuery)
{
foreach (Time tt in t.Time)
{
GridColumn3.Items.Add(tt.Hour + " : " + tt.Minute);
}
}
#region oldVers
//GridColumn2.Items.Clear();
//ListBoxItem listBox = (ListBoxItem)sender;
//string temp = Convert.ToString(listBox.Content);
////---------------------------тут всё норм
//string sad = " ";
//int index = temp.IndexOf(sad)+3;
//string FinalStr = temp.Remove(0, index);
//KursWorkEntities db = new KursWorkEntities();
//IQueryable<int> queryable = from t in db.Route
// where t.RouteName == FinalStr
// select t.RouteID;
//List<int> listT = queryable.ToList();
//int Id=Convert.ToInt32(listT[0]);
//IQueryable<string> StopQuery = from t in db.Stop
// where t.StopNum == Id
// select t.StopName;
//foreach(string s in StopQuery)
//{
// ListBoxItem listBoxItem = new ListBoxItem();
// listBoxItem.Selected += List_Selected;
// listBoxItem.Content = s;
// GridColumn2.Items.Add(listBoxItem);
//}
#endregion
}
private void Initialzation()
{
KursWorkEntities db = new KursWorkEntities();
IQueryable <string> queryable = from t in db.Stop
select t.StopName;
foreach (string s in queryable)
{
FromCmb.Items.Add(s);
WhereCmb.Items.Add(s);
}
}
private void InitlzationSearchBut()
{
KursWorkEntities db = new KursWorkEntities();
IQueryable <string> queryable = from t in db.Stop
select t.StopName;
foreach (string s in queryable)
{
SeacrhButton.Items.Add(s);
}
}
private void AutobusMenu()//клик на АВТОБУС
{
GridColumn1.SelectionChanged -= GridColumn1_SelectionChanged1;
GridColumn1.SelectionChanged -= MetroSelect;
GridColumn1.SelectionChanged -= Stops_Time;
GridColumn1.ItemsSource = null;
GridColumn2.Items.Clear();
GridColumn3.Items.Clear();
TitleOfSelected.Text = "Автобус";
KursWorkEntities db = new KursWorkEntities();
IQueryable <Route> Query = from t in db.Route
where t.RouteType == "Автобус"
select t;
UnitOfWork unitOfWork = new UnitOfWork();
//var prot = unitOfWork.route.GetAll();
//var t =from f in prot
// where f.RouteType
ObservableCollection <SomeShit> keka = new ObservableCollection <SomeShit>();
if (GridColumn1.Items.Count == 0)
{
foreach (Route t in Query)
{
keka.Add(new SomeShit(t.RouteNumber + " " + t.RouteName));
}
GridColumn1.ItemsSource = keka;
GridColumn1.SelectionChanged += GridColumn1_SelectionChanged1;
}
else
{
GridColumn1.ItemsSource = null;
foreach (Route t in Query)
{
keka.Add(new SomeShit(t.RouteNumber + " " + t.RouteName));
}
GridColumn1.ItemsSource = keka;
GridColumn1.SelectionChanged += GridColumn1_SelectionChanged1;
}
}
}//Клик на Остановки
private void MetroMenu()
{
GridColumn1.SelectionChanged -= GridColumn1_SelectionChanged1;
GridColumn1.ItemsSource = null;
GridColumn2.Items.Clear();
GridColumn3.Items.Clear();
TitleOfSelected.Text = "Станции метро";
KursWorkEntities dB = new KursWorkEntities();
ObservableCollection <SomeShit> keka = new ObservableCollection <SomeShit>();
IQueryable <Metro> temp2 = from t in dB.Metro
select t;
foreach (Metro t in temp2)
{
SomeShit ss = new SomeShit(t.NameBranch);
ss.isFav = "true";
keka.Add(ss);
}
GridColumn1.SelectionChanged += MetroSelect;
GridColumn1.ItemsSource = keka;
}//клик на МЕТРО
private void TrollebusMenu()
{
TitleOfSelected.Text = "Троллейбус";
GridColumn1.SelectionChanged -= GridColumn1_SelectionChanged1;
GridColumn1.SelectionChanged -= MetroSelect;
GridColumn1.SelectionChanged -= Stops_Time;
GridColumn1.ItemsSource = null;
GridColumn2.Items.Clear();
GridColumn3.Items.Clear();
KursWorkEntities db = new KursWorkEntities();
IQueryable <Route> Query = from t in db.Route
where t.RouteType == "Троллейбус"
select t;
ObservableCollection <SomeShit> keka = new ObservableCollection <SomeShit>();
if (GridColumn1.ItemsSource == null)
{
foreach (Route t in Query)
{
keka.Add(new SomeShit(t.RouteNumber + " " + t.RouteName));
}
GridColumn1.ItemsSource = keka;
GridColumn1.SelectionChanged += GridColumn1_SelectionChanged1;
}
else
{
GridColumn1.ItemsSource = null;
foreach (Route t in Query)
{
keka.Add(new SomeShit(t.RouteNumber + " " + t.RouteName));
}
GridColumn1.ItemsSource = keka;
GridColumn1.SelectionChanged += GridColumn1_SelectionChanged1;
}
}//клик на ТРОЛЛЕЙБУС
private void NameMetroStation_Time(object sender, RoutedEventArgs e)
{
GridColumn3.Items.Clear();
ListBoxItem listBox = (ListBoxItem)sender;
string TempStr = Convert.ToString(listBox.Content);
KursWorkEntities db = new KursWorkEntities();
IQueryable <int> SomeQuery = from t in db.Metro_Branch
where t.NameStation == TempStr
select t.ID;
int chislo = SomeQuery.FirstOrDefault();
IQueryable <Metro_Time> queryable = from t in db.Metro_Time
where t.ID == chislo
select t;
foreach (Metro_Time t in queryable)
{
GridColumn3.Items.Add(t.Hours + " : " + t.Minuts);
}
}
private void Stops_Time(object sender, SelectionChangedEventArgs e)//ОСТАНОВКИ-ВРЕМЯ
{
GridColumn2.Items.Clear();
GridColumn3.Items.Clear();
ListBox listBox = (ListBox)sender;
SomeShit someShit = (SomeShit)listBox.SelectedItems[0];
string TempStr = someShit.text;
string sad = ". ";
int index = TempStr.IndexOf(sad) + 3;
string FinalStr = TempStr.Remove(0, index);
KursWorkEntities db = new KursWorkEntities();
IQueryable <Stop> SomeQuery = from t in db.Stop
where t.StopName == FinalStr
select t;
foreach (Stop t in SomeQuery)
{
foreach (Time tt in t.Time)
{
GridColumn3.Items.Add(tt.Hour + " : " + tt.Minute);
}
}
}
private void FavoriteBtn(object sender, RoutedEventArgs e)
{
if (Users.Login == null && Users.Password == null)
{
MessageBox.Show("Необходимо войти или зарегестрироваться");
return;
}
KursWorkEntities db = new KursWorkEntities();
IQueryable <Users> queryable = from t in db.Users
select t;
Button self = (Button)sender;
string nameOstanovka = (string)self.Tag;
foreach (Users t in queryable)
{
if (t.UserFavourite == nameOstanovka)
{
MessageBox.Show("Пользователь уже содержит этот объект");
return;
}
}
var queryableUser = db.Users
.Where(c => c.UserLogin == Users.Login)
.FirstOrDefault();
queryableUser.UserFavourite = nameOstanovka;
db.SaveChanges();
MessageBox.Show(nameOstanovka);
}
private void Button_Click(object sender, RoutedEventArgs e)//registration
{
if (Users.Login != null && Users.Password != null)
{
MessageBox.Show("Надо выйти");
Close();
return;
}
string validateForLogin = "******";
Regex regex = new Regex(validateForLogin);
if (regex.IsMatch(LoginTB.Text))
{
;
}
else
{
MessageBox.Show("Неправильно введён логин");
return;
}
var hasNumber = new Regex(@"[0-9]+");
var hasUpperChar = new Regex(@"[A-Z]+");
var hasMinimum6Chars = new Regex(@".{6,}");
if (hasNumber.IsMatch(PasswordTB.Password) && hasUpperChar.IsMatch(PasswordTB.Password) && hasMinimum6Chars.IsMatch(PasswordTB.Password))
{
;
}
else
{
MessageBox.Show("Неправильно введён пароль: Необходимо присутствие цифры, буквы в верхнем регистре и длина пароля минимум 6 символов");
return;
}
if (IsValidEmail(EmailTB.Text))
{
;
}
else
{
MessageBox.Show("неправильно введена почта");
return;
}
KursWorkEntities dB = new KursWorkEntities();
Users users = new Users()
{
UserLogin = LoginTB.Text,
UserEmail = EmailTB.Text,
UserPassword = PasswordTB.Password
};
try
{
dB.Users.Add(users);
dB.SaveChanges();
MessageBox.Show("Регистрация прошла успешно");
}
catch (DbEntityValidationException ex)
{
foreach (DbEntityValidationResult validationError in ex.EntityValidationErrors)
{
MessageBox.Show("Object: " + validationError.Entry.Entity.ToString());
MessageBox.Show("");
foreach (DbValidationError err in validationError.ValidationErrors)
{
MessageBox.Show(err.ErrorMessage + "");
}
}
}
Close();
}
public Repozitory_Time(KursWorkEntities context)
{
this.db = context;
}
public RepozitoryStop(KursWorkEntities context)
{
this.db = context;
}
private void Search()
{
#region OLD
//string s1 = Convert.ToString(FromCmb.SelectedItem);
//string s2= Convert.ToString(WhereCmb.SelectedItem);
//List<string> result = new List<string>();
//if (s1 == "" || s2 == "")
//{
// MessageBox.Show("Заполните поля");
// return;
//}
//KursWorkEntities db = new KursWorkEntities();
//var query = db.Stop
// .Where(c => c.StopName == s1)
// .FirstOrDefault();
//var query2 = db.Stop
// .Where(c => c.StopName == s2)
// .FirstOrDefault();
////прушинских - ленина
//// id=2 counter=2
//int ID = query.StopNum;
//int counter = query.StopCounter;
////прушинских - ленина
//// id=1 counter=15
//int ID2 = query2.StopNum;
//int counter2 = query2.StopCounter;
//int check = query.StopID;//28
//int check2=query2.StopID;//24
//if (ID == ID2)
//{
// if (counter < counter2)
// {
// IQueryable<string> FinalQuery3 = from t in db.Stop
// where t.StopNum == ID && t.StopCounter >= counter && t.StopCounter <= counter2
// select t.StopName;
// foreach (string s in FinalQuery3)
// {
// result.Add(s);
// }
// }
// else
// {
// IQueryable<string> FinalQuery3 = from t in db.Stop
// where t.StopNum == ID && t.StopCounter >= counter2 && t.StopCounter <= counter
// select t.StopName;
// foreach (string s in FinalQuery3)
// {
// result.Add(s);
// }
// result.Reverse();
// }
//}
//else if (check < check2)
//{
// IQueryable<string> FinalQuery1 = from t in db.Stop
// where t.StopNum == ID && t.StopCounter >= counter
// select t.StopName;
// foreach (string s in FinalQuery1)
// {
// result.Add(s);
// }
// IQueryable<string> FinalQuery2 = from t in db.Stop
// where t.StopNum == ID2 && t.StopCounter <= counter2
// select t.StopName;
// foreach (string ss in FinalQuery2)
// {
// result.Add(ss);
// }
//}
//else
//{
// query = db.Stop
// .Where(c => c.StopName == s2)
// .FirstOrDefault();
// query2= db.Stop
// .Where(c => c.StopName == s1)
// .FirstOrDefault();
// IQueryable<string> FinalQuery1 = from t in db.Stop
// where t.StopNum == ID && t.StopCounter <= counter
// select t.StopName;
// foreach (string s in FinalQuery1)
// {
// result.Add(s);
// }
// result.Reverse();
// IQueryable<string> FinalQuery2 = from t in db.Stop
// where t.StopNum == ID2 && t.StopCounter >= counter2
// select t.StopName;
// List<string> rez = new List<string>();
// foreach (string ss in FinalQuery2)
// {
// rez.Add(ss);
// }
// rez.Reverse();
// result.AddRange(rez);
//}
// if (result.Count == 0)
// {
// MessageBox.Show("Подбор маршрута невозможен");
// }
// foreach (string s in result)
// {
// MessageBox.Show(s);
// }
#endregion
Information.Children.Clear();
Information.Visibility = Visibility.Visible;
LabelMarsh.Visibility = Visibility.Visible;
string s1 = Convert.ToString(FromCmb.SelectedItem);
string s2 = Convert.ToString(WhereCmb.SelectedItem);
List <string> result = new List <string>();
if (s1 == "" || s2 == "")
{
MessageBox.Show("Заполните поля");
return;
}
KursWorkEntities db = new KursWorkEntities();
var query = db.Stop
.Where(c => c.StopName == s1)
.FirstOrDefault();
var query2 = db.Stop
.Where(c => c.StopName == s2)
.FirstOrDefault();
int check = query.StopNum;
int check2 = query2.StopNum;
int ID = query.StopID; //25 n
int ID2 = query2.StopID; //28 n
if (ID2 > ID)
{
#region
//IQueryable<string> queryable = from t in db.Stop
// where t.StopID <= ID2 && t.StopID >= ID
// select t.StopName;
//foreach (string t in queryable)
//{
// result.Add(t);
// MessageBox.Show(t);
//}
#endregion
if (check != check2)
{
IQueryable <string> FinalQuery3 = from t in db.Stop
where t.StopID <= ID2 && t.StopID >= ID && t.StopNum == check
select t.StopName;
string firstOne = FinalQuery3.ToList().First();
string lastOne = FinalQuery3.ToList().Last();
var queryable = db.Stop
.Where(c => c.StopID <= ID2 && c.StopID >= ID && c.StopNum == check)//для маршрутов с другим id
.FirstOrDefault();
string info = queryable.Route.RouteType + " " + queryable.Route.RouteNumber;
Drow(Information, firstOne, lastOne, info);
//-------------------------------------------------------------------------------------------------------
var queryable2 = db.Stop
.Where(c => c.StopID <= ID2 && c.StopID >= ID && c.StopNum == check2)//для маршрутов с другим id
.FirstOrDefault();
IQueryable <string> FinalQuery3_2 = from t in db.Stop
where t.StopID <= ID2 && t.StopID >= ID && t.StopNum == check2
select t.StopName;
string firstTwo = FinalQuery3_2.ToList().First();
string lastTwo = FinalQuery3_2.ToList().Last();
string info2 = queryable2.Route.RouteType + " " + queryable2.Route.RouteNumber;
Information2.Visibility = Visibility.Visible;
Drow(Information2, firstTwo, lastTwo, info2);
}
else
{
var queryable = db.Stop
.Where(c => c.StopID <= ID2 && c.StopID >= ID)
.FirstOrDefault();
string info = queryable.Route.RouteNumber + " " + queryable.Route.RouteType;
IQueryable <string> queryable22 = from t in db.Stop
where t.StopID <= ID2 && t.StopID >= ID
select t.StopName;
string firstTwo = queryable22.ToList().First();
string lastTwo = queryable22.ToList().Last();
Drow(Information, firstTwo, lastTwo, info);
}
}
else if (ID2 < ID)
{
if (check != check2)
{
var queryable = db.Stop
.Where(c => c.StopID <= ID2 && c.StopID >= ID && c.StopNum == check)//для маршрутов с другим id
.FirstOrDefault();
IQueryable <string> FinalQuery3 = from t in db.Stop
where t.StopID <= ID2 && t.StopID >= ID && t.StopNum == check
select t.StopName;
string firstOne = FinalQuery3.ToList().First();
string lastOne = FinalQuery3.ToList().Last();
string info = queryable.Route.RouteType + " " + queryable.Route.RouteNumber;
Drow(Information, firstOne, lastOne, info);
IQueryable <string> FinalQuery3_2 = from t in db.Stop
where t.StopID <= ID2 && t.StopID >= ID && t.StopNum == check2
select t.StopName;
var queryable2 = db.Stop
.Where(c => c.StopID <= ID2 && c.StopID >= ID && c.StopNum == check)//для маршрутов с другим id
.FirstOrDefault();
string firstTwo = FinalQuery3_2.ToList().First();
string lastTwo = FinalQuery3_2.ToList().Last();
string info2 = queryable2.Route.RouteType + " " + queryable2.Route.RouteNumber;
Information2.Visibility = Visibility.Visible;
Drow(Information2, firstTwo, lastTwo, info2);
}
else
{
IQueryable <string> queryable = from t in db.Stop
where t.StopID <= ID && t.StopID >= ID2
select t.StopName;
var queryableInf = db.Stop
.Where(c => c.StopID <= ID && c.StopID >= ID2)
.FirstOrDefault();
string info = queryableInf.Route.RouteNumber + " " + queryableInf.Route.RouteType;
foreach (string t in queryable)
{
result.Add(t);
}
result.Reverse();
string firstOne = result.First();
string firstTwo = result.Last();
Drow(Information, firstOne, firstTwo, info);
}
}
}
public RepozitoryMetro_Branch(KursWorkEntities context)
{
this.db = context;
}