//===================THIS METHOD IS FOR EDIT RECORDS IN STATUS TABLES============== public void EditUniversity(string newName) { if (University.UniversityName == "---") { dialogService.ShowMessage("Нельзя редактировать эту запись"); return; } University.UniversityName = newName; using (StudentuConteiner db = new StudentuConteiner()) { try { var res4 = db.Universities.Find(University.UniversityId); if (res4 != null) { //changing DB University.UniversityName.Trim(); University.City.Trim(); if (University.UniversityName[0] == ' ' || University.City[0] == ' ') { dialogService.ShowMessage("Нельзя добавить пустую строку"); return; } res4.UniversityName = University.UniversityName; res4.City = University.City; db.SaveChanges(); UniversityRecords.Clear(); LoadUniversityData(); } } catch (ArgumentNullException ex) { dialogService.ShowMessage(ex.Message); } catch (OverflowException ex) { dialogService.ShowMessage(ex.Message); } catch (System.Data.SqlClient.SqlException ex) { dialogService.ShowMessage(ex.Message); } catch (System.Data.Entity.Core.EntityCommandExecutionException ex) { dialogService.ShowMessage(ex.Message); } catch (System.Data.Entity.Core.EntityException ex) { dialogService.ShowMessage(ex.Message); } } }
//===================THIS METHOD IS FOR ADD RECORDS IN STATUS TABLES============== public void AddUniversity(string newName) { University.UniversityName = newName; using (StudentuConteiner db = new StudentuConteiner()) { try { bool flag = false; var res4 = db.Universities.ToList(); foreach (var item in res4) { if (item.City == University.City && item.UniversityName == University.UniversityName) { flag = true; break; } } if (!flag) { if (!string.IsNullOrEmpty(University.UniversityName)) { University.UniversityName.Trim(); University.City.Trim(); if (University.UniversityName[0] == ' ' || University.City[0] == ' ') { dialogService.ShowMessage("Нельзя добавить пустую строку"); return; } db.Universities.Add(University); db.SaveChanges(); UniversityRecords.Clear(); LoadUniversityData(); University = new University(); } else { return; } } else { dialogService.ShowMessage("Уже есть такое название в базе данных"); } } catch (ArgumentNullException ex) { dialogService.ShowMessage(ex.Message); } catch (OverflowException ex) { dialogService.ShowMessage(ex.Message); } catch (System.Data.SqlClient.SqlException ex) { dialogService.ShowMessage(ex.Message); } catch (System.Data.Entity.Core.EntityCommandExecutionException ex) { dialogService.ShowMessage(ex.Message); } catch (System.Data.Entity.Core.EntityException ex) { dialogService.ShowMessage(ex.Message); } } }