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) { 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(); }
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 }; }
private async void lstData_ItemSelected(object sender, SelectedItemChangedEventArgs e) { if (e.SelectedItem != null) { Distantion obj = (Distantion)e.SelectedItem; string res = await DisplayActionSheet("Выберите операцию", "Отмена", null, "Обновить данные", "Удалить данные"); switch (res) { case "Обновить данные": await Navigation.PushModalAsync(new AddDistantionsPage(obj.IdDistantion), animate); break; case "Удалить данные": bool result = await DisplayAlert("Подтвердить действие", "Вы хотите удалить элемент?", "Да", "Нет"); if (result == true) { Distantion Del_Distantion = await distantionsServise.Delete(obj.IdDistantion); IEnumerable <Competentions> competentions = await competentionsServise.Get(); var selectad_del_compitentions = competentions.FirstOrDefault(p => p.IdDistantion == obj.IdDistantion); if (selectad_del_compitentions != null) { Competentions Del_compitentions = await competentionsServise.Delete(selectad_del_compitentions.IdCompetentions); IEnumerable <Participation> participations = await participationService.Get(); var selectad = participations.FirstOrDefault(p => p.IdCompetentions == selectad_del_compitentions.IdCompetentions); if (selectad != null) { int id_part = selectad.IdParticipation; IEnumerable <ResultParticipant> res_participations = await resultParticipationServise.Get(); Participation Del_Participation = await participationService.Delete(id_part); var res_selectad = res_participations.FirstOrDefault(p => p.IdParticipation == id_part); if (res_selectad != null) { int id_res_part = res_selectad.IdResultParticipation; ResultParticipant Del_ResultPartisipation = await resultParticipationServise.Delete(id_res_part); } } } await showEmployeeAsync(); await DisplayAlert("Уведомление", "Дистанция успешно удалена", "Ok"); } break; } lstData.SelectedItem = null; } }
private async void lstData_ItemSelected(object sender, SelectedItemChangedEventArgs e) { if (e.SelectedItem != null) { string obj = e.SelectedItem.ToString(); obj = obj.Substring(obj.LastIndexOf(',') + 1).Replace("IdCompetentions = ", string.Empty).Replace("}", string.Empty); string res = await DisplayActionSheet("Выберите операцию", "Отмена", null, "Обновить данные", "Удалить данные"); switch (res) { case "Обновить данные": await Navigation.PushModalAsync(new AddCompitentionsPage(Convert.ToInt32(obj)), animate); break; case "Удалить данные": bool result = await DisplayAlert("Подтвердить действие", "Вы хотите удалить элемент?", "Да", "Нет"); if (result == true) { IEnumerable <Participation> participations = await participationService.Get(); Competentions Del_compitentions = await competentionsServise.Delete(Convert.ToInt32(obj)); var selectad = participations.FirstOrDefault(p => p.IdCompetentions == Convert.ToInt32(obj)); if (selectad != null) { int id_part = selectad.IdParticipation; IEnumerable <ResultParticipant> res_participations = await resultParticipationServise.Get(); Participation Del_Participation = await participationService.Delete(id_part); var res_selectad = res_participations.FirstOrDefault(p => p.IdParticipation == id_part); if (res_selectad != null) { int id_res_part = res_selectad.IdResultParticipation; ResultParticipant Del_ResultPartisipation = await resultParticipationServise.Delete(id_res_part); } } await showEmployeeAsync(false); await DisplayAlert("Уведомление", "Компетенция успешно удалена", "Ok"); } break; } lstData.SelectedItem = null; } }
private async Task Date_TestAsync() { 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 select new { d.NameDistantion, k.Date, }; var picker_list = info.FirstOrDefault(x => x.NameDistantion == CompetentionsPicer.Items[CompetentionsPicer.SelectedIndex].ToString()); if (picker_list.Date >= DateTime.Today.AddDays(2)) { await DisplayAlert("Ошибка", "На эту дату запись уже недоступна", "Ок"); } }
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(); } } }
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); }