public async Task <IActionResult> PutCompetentions(int id, Competentions competentions)
{
if (id != competentions.IdCompetentions)
{
return(BadRequest());
}
_context.Entry(competentions).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CompetentionsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <Competentions> > PostCompetentions(Competentions competentions)
{
_context.Competentions.Add(competentions);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCompetentions", new { id = competentions.IdCompetentions }, competentions));
}
public async Task Criate()
{
if (Time != null && id_Distantion != 0)
{
Competentions competentions = new Competentions
{
Date = Time,
IdDistantion = id_Distantion
};
await competentionsServise.Add(competentions);
if (!await DisplayAlert("", "Добавить еще одну дистанцию", "Да", "Нет"))
{
await Navigation.PopModalAsync();
}
else
{
}
}
else
{
if (!await DisplayAlert("Ошибка", "Вы заполнили не все поля", "Заполнить", "Выйти"))
{
await Navigation.PopModalAsync();
}
}
}
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 Task get_infa(int id)
{
Competentions competentions = await competentionsServise.Get_ID(id);
IEnumerable <Distantion> distantions = await distantionsServise.Get();
var info = distantions.FirstOrDefault(p => p.IdDistantion == competentions.IdDistantion);
if (id != 0)
{
}
}
// добавляем информацию
public async Task <Competentions> Add(Competentions сompetentions)
{
HttpClient client = getClientServise.GetClient();
var response = await client.PostAsync("http://90.189.158.10/api/Competentions/",
new StringContent(JsonConvert.SerializeObject(сompetentions), Encoding.UTF8, "application/json"));
if (response.StatusCode != HttpStatusCode.OK)
{
return(null);
}
return(JsonConvert.DeserializeObject <Competentions>(await response.Content.ReadAsStringAsync()));
}
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;
}
}
public async Task Update(int id)
{
if (Time != null && id_Distantion != 0)
{
Competentions competentions = new Competentions
{
IdCompetentions = id,
Date = Time,
IdDistantion = id_Distantion
};
await competentionsServise.Update(competentions);
await Navigation.PopModalAsync();
}
else
{
if (!await DisplayAlert("Ошибка", "Вы заполнили не все поля", "Заполнить", "Выйти"))
{
await Navigation.PopModalAsync();
}
}
}
private async Task get_infa(int id)
{
Competentions competentions = await competentionsServise.Get_ID(id);
IEnumerable <Distantion> distantions = await distantionsServise.Get();
var info = distantions.FirstOrDefault(p => p.IdDistantion == competentions.IdDistantion);
if (id != 0)
{
Time_Picrt.Text = competentions.Date.ToShortDateString();
for (int i = 0; i < picker.Items.Count; i++)
{
if (info.Discriptions == picker.Items[picker.SelectedIndex])
{
picker.SelectedIndex = picker.SelectedIndex;
}
break;
}
Head_Lable.Text = "Редактирование компетенции";
}
}
public WSRContext()
{
//if (!(Database.GetService<IDatabaseCreator>() as RelationalDatabaseCreator).Exists())
Database.EnsureDeleted();
Database.EnsureCreated();
if (!Participants.Any())
{
string DPath = Path.GetFullPath(Path.Combine(Directory.GetCurrentDirectory(), @"..\..\"));
DPath += "\\CSV\\";
Database.OpenConnection();
using (var reader = new StreamReader(DPath + "Participants.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Participants.AddRange(csv.GetRecords <Participant>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Participants ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Participants OFF;");
using (var reader = new StreamReader(DPath + "Experts.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Experts.AddRange(csv.GetRecords <Expert>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Experts ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Experts OFF;");
using (var reader = new StreamReader(DPath + "Admins.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Administrators.AddRange(csv.GetRecords <Administrator>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Administrators ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Administrators OFF;");
using (var reader = new StreamReader(DPath + "Coordinators.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Coordinators.AddRange(csv.GetRecords <Coordinator>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Coordinators ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Coordinators OFF;");
List <Competention> temp = new List <Competention>();
using (var reader = new StreamReader(DPath + "Competentions.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
temp.AddRange(csv.GetRecords <Competention>());
}
using (var reader = new StreamReader(DPath + "CompetentionDesc.txt", Encoding.Default))
{
Competention CurrC;
for (int Counter = 1; Counter <= temp.Count; Counter++)//relies on competencies being consequentioal from 1
{
CurrC = temp.FirstOrDefault(c => c.Id == Counter);
CurrC.Description = reader.ReadLine();
}
}
Competentions.AddRange(temp);
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Competentions ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Competentions OFF;");
using (var reader = new StreamReader(DPath + "Championships.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Championships.AddRange(csv.GetRecords <Championship>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Championships ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Championships OFF;");
using (var reader = new StreamReader(DPath + "Infrastructures.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Infrastructures.AddRange(csv.GetRecords <Infrastructure>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Infrastructures ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Infrastructures OFF;");
using (var reader = new StreamReader(DPath + "SMPs.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
SMPs.AddRange(csv.GetRecords <SMP>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.SMPs ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.SMPs OFF;");
using (var reader = new StreamReader(DPath + "Results.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Results.AddRange(csv.GetRecords <Result>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Results ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Results OFF;");
using (var reader = new StreamReader(DPath + "Sponsors.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Sponsors.AddRange(csv.GetRecords <Sponsor>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Sponsors ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Sponsors OFF;");
using (var reader = new StreamReader(DPath + "Volunteers.csv"))
using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture))
{
Volunteers.AddRange(csv.GetRecords <Volunteer>());
}
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Volunteers ON;");
SaveChanges();
Database.ExecuteSqlRaw("SET IDENTITY_INSERT dbo.Volunteers OFF;");
Database.CloseConnection();
}
}
