private async Task Get_Time() { IEnumerable <ResultParticipant> resultParticipations = await resultParticipationServise.Get(); IEnumerable <Participation> participations = await participationService.Get(); IEnumerable <Distantion> distantions = await distantionsServise.Get(); IEnumerable <Competentions> competentions = await competentionsServise.Get(); IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); var info = from r in resultParticipations join p in participations on r.IdParticipation equals p.IdParticipation join c in competentions on p.IdCompetentions equals c.IdCompetentions join d in distantions on c.IdDistantion equals d.IdDistantion join i in infoUsers on p.IdUser equals i.IdUsers select new { r.ResultTime, r.Mesto, d.NameDistantion, i.Login, r.IdResultParticipation }; var res = info.ToList(); if (counts < res.Count || counts > res.Count) { lstData.ItemsSource = res; counts = res.Count; } }
private async Task Get_Time() { IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); IEnumerable <CategoriYars> categoriYars = await categoriYarsServise.Get(); IEnumerable <Participation> participations = await participationService.Get(); IEnumerable <Distantion> distantions = await distantionsServise.Get(); IEnumerable <Competentions> competentions = await competentionsServise.Get(); var info = from p in participations join k in competentions on p.IdCompetentions equals k.IdCompetentions join d in distantions on k.IdDistantion equals d.IdDistantion join i in infoUsers on p.IdUser equals i.IdUsers select new { p.IdUser, i.Login, k.Date, p.IdStatusVerification, d.NameDistantion, }; var res = info.ToList(); if (counts < res.Count || counts > res.Count) { lstData.ItemsSource = res; counts = res.Count; } }
private async Task Poisk(string filtr) { IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); switch (filtr) { case "PoiskLogin": infoUsers = infoUsers.Where(p => p.Login == PoiskLogin.Text || p.Login.StartsWith(PoiskLogin.Text)); break; case "PoiskName": infoUsers = infoUsers.Where(p => p.Name == PoiskName.Text || p.Name.StartsWith(PoiskName.Text)); break; case "PoiskFam": infoUsers = infoUsers.Where(p => p.Fam == PoiskFam.Text || p.Fam.StartsWith(PoiskFam.Text)); break; } var res = infoUsers.ToList(); if (res.Count != 0) { lstData.ItemsSource = res; YesRecords.Height = new GridLength(1, GridUnitType.Star); NoRecords.Height = 0; } else { lstData.ItemsSource = res; YesRecords.Height = 0; NoRecords.Height = new GridLength(1, GridUnitType.Star); } }
private async Task Poisk(string filtr) { InfoUser loginUsers = await loginUsersService.Get(App.Current.Properties["token"].ToString()); IEnumerable <ResultParticipant> resultParticipations = await resultParticipationServise.Get(); IEnumerable <Participation> participations = await participationService.Get(); IEnumerable <Distantion> distantions = await distantionsServise.Get(); IEnumerable <Competentions> competentions = await competentionsServise.Get(); IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); var info = from r in resultParticipations join p in participations on r.IdParticipation equals p.IdParticipation join c in competentions on p.IdCompetentions equals c.IdCompetentions join d in distantions on c.IdDistantion equals d.IdDistantion join i in infoUsers on p.IdUser equals i.IdUsers select new { r.ResultTime, r.Mesto, d.NameDistantion, c.Date, i.IdUsers, p.IdStatusVerification, r.IdResultParticipation, }; info = info.Where(x => x.IdUsers == loginUsers.IdUsers); switch (filtr) { case "PoiskNameDistans": info = info.Where(p => p.NameDistantion == PoiskNameDistans.Text || p.NameDistantion.StartsWith(PoiskNameDistans.Text)); break; case "PoiskDate": info = info.Where(p => p.Date == ID_Time); break; } var res = info.ToList(); if (res.Count != 0) { lstData.ItemsSource = res; YesRecords.Height = new GridLength(1, GridUnitType.Star); NoRecords.Height = 0; } else { lstData.ItemsSource = res; YesRecords.Height = 0; NoRecords.Height = new GridLength(1, GridUnitType.Star); } }
private async Task GetInfomationAsync() { IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); IEnumerable <CategoriYars> categoriYars = await categoriYarsServise.Get(); IEnumerable <Participation> participations = await participationService.Get(); IEnumerable <Distantion> distantions = await distantionsServise.Get(); IEnumerable <Competentions> competentions = await competentionsServise.Get(); var info = from p in participations join k in competentions on p.IdCompetentions equals k.IdCompetentions join d in distantions on k.IdDistantion equals d.IdDistantion join i in infoUsers on p.IdUser equals i.IdUsers select new { p.IdUser, i.Login, k.Date, p.IdStatusVerification, d.NameDistantion, }; var res = info.ToList(); }
public async Task <string> GetClient(int ID) { RegistrationUsersService registrationUsersService = new RegistrationUsersService(); IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); var user = infoUsers.FirstOrDefault(x => x.IdUsers == ID); return(user.Email); }
private async Task Get() { IEnumerable <ResultParticipant> resultParticipations = await resultParticipationServise.Get(); IEnumerable <Participation> participations = await participationService.Get(); IEnumerable <Distantion> distantions = await distantionsServise.Get(); IEnumerable <Competentions> competentions = await competentionsServise.Get(); IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); var info = from r in resultParticipations join p in participations on r.IdParticipation equals p.IdParticipation join c in competentions on p.IdCompetentions equals c.IdCompetentions join d in distantions on c.IdDistantion equals d.IdDistantion join i in infoUsers on p.IdUser equals i.IdUsers select new { d.NameDistantion, i.Login, r.IdResultParticipation }; var groups = from p in info group p by p.NameDistantion into g select new { g.Key, Count = g.Count() }; List <Entry> entries = new List <Entry>(groups.Count()); int k = 0; string[] color = new string[] { "#dbf720", "#42d62b", "#cf2934", "#f20acb", "#9090e8", "#183bed", "#926eae", "#FF1943", "#ab5b68", "#0af2bc", "#cac4b0", "#fa0f0f", "#18ed54" }; foreach (var item in groups) { if (color.Length == k++) { k = 0; } entries.Add(new Entry(item.Count) { Color = SKColor.Parse(color[k]), Label = item.Key, ValueLabel = item.Count.ToString() }); } Chart2.Chart = new LineChart() { Entries = entries }; // Chart4.Chart = new BarChart() { Entries = entries }; }
public async Task <string> GetClient() { RegistrationUsersService registrationUsersService = new RegistrationUsersService(); IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); var user = infoUsers.FirstOrDefault(x => x.Login == Login_Entry.Text); string ID = user.IdUsers.ToString(); return(ID); }
private async Task Criate_LoginPicer(bool status) { IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); LoginPicer = new Picker { Margin = new Thickness(10, -10, 10, 5) }; if (status) { infoUsers = infoUsers.Where(p => p.Login == PoiskLogin.Text || p.Login.StartsWith(PoiskLogin.Text)); } foreach (var item in infoUsers) { LoginPicer.Items.Add(item.Login); } LoginPicer.SelectedIndexChanged += async(s, e) => { IEnumerable <UserHelth> userHelths = await registrationUsersService.get_hels_status(); var picker_list = infoUsers.FirstOrDefault(x => x.Login == LoginPicer.Items[LoginPicer.SelectedIndex].ToString()); var picker_list_Hels = userHelths.FirstOrDefault(x => x.IdHealth == picker_list.IdHelth); IDUser = picker_list.IdUsers; Info_Editor.Text = ""; Info_Editor.Text = "Login: "******"\r\n"; Info_Editor.Text += "E-mail: " + picker_list.Email + "\r\n"; Info_Editor.Text += "ФИО: " + picker_list.Fam + " " + picker_list.Name + " " + picker_list.Patronimic + "\r\n"; Info_Editor.Text += "Возраст: " + picker_list.Years + "\r\n"; Info_Editor.Text += "Статус здоровья: " + picker_list_Hels.NameHealth + "\r\n"; if (picker_list.Isman == true) { Info_Editor.Text += "Пол: Мужской" + "\r\n"; } else { Info_Editor.Text += "Пол: Женский" + "\r\n"; } }; GridMain.Children.Add(LoginPicer, 1, 2); // LoginPicer.SelectedIndex = 1; }
public async Task Criate() { InfoUser loginUsers = await loginUsersService.Get(App.Current.Properties["token"].ToString()); IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); IEnumerable <Participation> participations = await participationService.Get(); IEnumerable <Distantion> distantions = await distantionsServise.Get(); IEnumerable <Competentions> competentions = await competentionsServise.Get(); var info = from p in participations join k in competentions on p.IdCompetentions equals k.IdCompetentions join d in distantions on k.IdDistantion equals d.IdDistantion join i in infoUsers on p.IdUser equals i.IdUsers select new { p.IdUser, i.Login, k.Date, p.IdStatusVerification, d.NameDistantion, }; DateTime selectd_date = Convert.ToDateTime(SelectDate.Items[SelectDate.SelectedIndex]); var picker_list = info.FirstOrDefault(x => x.IdUser == loginUsers.IdUsers && x.NameDistantion == CompetentionsPicer.Items[CompetentionsPicer.SelectedIndex] && x.Date == selectd_date); if (picker_list == null) { if (await Date_TestAsync()) { if (IDUser != 0 && IDCompitention != 0) { Participation participation = new Participation { IdCompetentions = IDCompitention, IdUser = IDUser, IdStatusVerification = true }; await participationService.Add(participation); await DownloadBage(); await Navigation.PopModalAsync(); } else { if (!await DisplayAlert("Ошибка", "Вы заполнили не все поля", "Заполнить", "Выйти")) { await Navigation.PopModalAsync(); } } } } else { if (!await DisplayAlert("Предупреждение", "Вы уже зарегистрированы на эту дисциплину", "Зарегистрироваться на другую", "Выйти")) { await Navigation.PopModalAsync(); } } }
public AddUsersPage(int id, string status_form) { InitializeComponent(); if (!connectClass.CheckConnection()) { Connect_ErrorAsync(); } //Проверка интернета при загрузке формы CrossConnectivity.Current.ConnectivityChanged += (s, e) => { if (!connectClass.CheckConnection()) { Connect_ErrorAsync(); } }; get_users(id); GetPicerAsync(); if (id == 0 && status_form == "MainPage" || status_form == "Redacting") { Rol_Picker.IsEnabled = false; RolUser = "******"; } Pol_Picer.SelectedIndex = 1; Rol_Picker.SelectedIndex = 1; pol = true; User_Image.Source = ImageSource.FromResource(picture_lincs.LinksResourse() + "nophotouser.png"); image_fon.Source = ImageSource.FromResource(picture_lincs.GetFon()); //Users_Fon_Images.Source = ImageSource.FromResource(picture_lincs.LinksResourse() + "UserFon.png"); password_status_image.Source = ImageSource.FromResource(picture_lincs.LinksResourse() + "anvisible_password.png");//Инициализация статуса пароля password_status_image.Clicked += (s, e) => { Password_IsVisible(); }; Pol_Picer.SelectedIndexChanged += (s, e) => { if (Pol_Picer.Items[Pol_Picer.SelectedIndex].ToString() == "Мужской") { pol = true; } else { pol = false; } }; Rol_Picker.SelectedIndexChanged += (s, e) => { if (Rol_Picker.Items[Rol_Picker.SelectedIndex].ToString() == "Администратор") { RolUser = "******"; } else { RolUser = "******"; } }; Registrations_Button.Clicked += async(s, e) => { if (id == 0) { await reg_userAsync(status_form); } else { await update_userAsync(id); } }; Save_Picture_Button.Clicked += async(s, e) => { if (Device.RuntimePlatform == Device.Android) { await getPhotoingaleriAsync(); } else { if (await DisplayAlert("", "Сделать снимок ?", "Да", "Нет")) { await takePhotoAsync(); } else { await getPhotoingaleriAsync(); } } }; Back_Button.Clicked += async(s, e) => { //animations.Animations_Button(Back_Button); //await Task.Delay(1000); await Navigation.PopModalAsync();//Переход назад }; Generate_Password_CheckBox.CheckedChanged += (s, e) => { if (!Generate_Password_CheckBox.IsChecked) { Password_Entry.Text = ""; Password_Replay_Entry.Text = ""; } else { string password = get_Password.GetPassword(); Password_Entry.Text = password; Password_Replay_Entry.Text = password; } }; Login_Entry.TextChanged += async(s, e) => { if (Login_Entry.Text.Length == 17 && id == 0) { IEnumerable <InfoUser> info = await registrationUsersService.Get_user(); var get = info.FirstOrDefault(x => x.Login == Login_Entry.Text); if (get != null) { Error_Login_RowDefinition.Height = 40; Error_Login_Lable.Text = "Пользоватьль с таким логином уже существует"; } else { Error_Login_RowDefinition.Height = 0; Error_Login_Lable.Text = ""; } } }; Fam_Entry.TextChanged += (s, e) => { if (Fam_Entry.Text != null && Fam_Entry.Text.Length == 1) { Fam_Entry.Text = Fam_Entry.Text.Substring(0, 1).ToUpper() + Fam_Entry.Text.Substring(1); } }; Name_Entry.TextChanged += (s, e) => { if (Name_Entry.Text != null && Name_Entry.Text.Length == 1) { Name_Entry.Text = Name_Entry.Text.Substring(0, 1).ToUpper() + Name_Entry.Text.Substring(1); } }; Patronymic_Entry.TextChanged += (s, e) => { if (Patronymic_Entry.Text != null && Patronymic_Entry.Text.Length == 1) { Patronymic_Entry.Text = Patronymic_Entry.Text.Substring(0, 1).ToUpper() + Patronymic_Entry.Text.Substring(1); } }; Yars_Entry.TextChanged += (s, e) => { if (!Int32.TryParse(Yars_Entry.Text, out int num)) { Yars_Entry.Text = ""; } }; Password_Entry.TextChanged += (s, e) => { }; Password_Replay_Entry.TextChanged += (s, e) => { }; }
private async Task Criate_LoginPicer(bool status) { IEnumerable <Participation> participations = await participationService.Get(); IEnumerable <InfoUser> infoUsers = await registrationUsersService.Get_user(); IEnumerable <Competentions> competentions = await competentionsServise.Get(); var info = from p in participations join i in infoUsers on p.IdUser equals i.IdUsers join c in competentions on p.IdCompetentions equals c.IdCompetentions select new { i.Login, i.Name, i.Fam, i.Patronimic, i.Email, i.Years, i.Isman, i.IdHelth, p.IdParticipation, c.Date }; LoginPicer = new Picker { Margin = new Thickness(10, -10, 10, 5) }; if (status) { info = info.Where(p => p.Login == PoiskLogin.Text || p.Login.StartsWith(PoiskLogin.Text)); } foreach (var item in info) { DateTime today = DateTime.Now; DateTime start = item.Date; if (today <= start && today.AddMonths(3) >= start) { LoginPicer.Items.Add(item.Login); } } LoginPicer.SelectedIndexChanged += async(s, e) => { IEnumerable <UserHelth> userHelths = await registrationUsersService.get_hels_status(); var picker_list = info.FirstOrDefault(x => x.Login == LoginPicer.Items[LoginPicer.SelectedIndex].ToString()); var picker_list_Hels = userHelths.FirstOrDefault(x => x.IdHealth == picker_list.IdHelth); Criate_SelectCompitentions(true, true); Info_Editor.Text = ""; Info_Editor.Text = "Login: "******"\r\n"; Info_Editor.Text += "E-mail: " + picker_list.Email + "\r\n"; Info_Editor.Text += "ФИО: " + picker_list.Fam + " " + picker_list.Name + " " + picker_list.Patronimic + "\r\n"; Info_Editor.Text += "Возраст: " + picker_list.Years + "\r\n"; Info_Editor.Text += "Статус здоровья: " + picker_list_Hels.NameHealth + "\r\n"; if (picker_list.Isman == true) { Info_Editor.Text += "Пол: Мужской" + "\r\n"; } else { Info_Editor.Text += "Пол: Женский" + "\r\n"; } }; GridMain.Children.Add(LoginPicer, 1, 2); }