public void DeleteSubj()
{
using (StudentuConteiner db = new StudentuConteiner())
{
try
{
var res = db.Orderlines;
if (Subj.SubjectId != 1 && !CheckRecordBeforDelete(Subj))
{
if (dialogService.YesNoDialog("Точно нужно удалить эту запись?") == true)
{
//changing DB
//we find all the records in which we have the desired Id and make a replacement
foreach (OrderLine order in res)
{
if (order.Subject.SubjectId == Subj.SubjectId)
{
order.Subject = db.Subjects.Find(new Subject()
{
SubjectId = 1
}.SubjectId);
}
}
db.Subjects.Remove(db.Subjects.Find(Subj.SubjectId));
db.SaveChanges();
//changing collection
AuthorSubjects.Remove(Subj);
SubjRecords.Remove(Subj);
Subj = SubjRecords[0];
SelectedSubj2 = Subj;
}
}
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);
}
}
}
//===================THIS METHOD IS FOR ADD RECORDS SUBJECTS TABLE==============
public void AddSubj(string newSubName)
{
Subj.SubName = newSubName;
using (StudentuConteiner db = new StudentuConteiner())
{
try
{
var res2 = db.Subjects.Any(o => o.SubName == Subj.SubName);
if (!res2)
{
if (!string.IsNullOrEmpty(Subj.SubName) || Subj.SubName != "---")
{
Subj.SubName.Trim();
if (Subj.SubName[0] == ' ')
{
dialogService.ShowMessage("Нельзя добавить пустую строку");
return;
}
db.Subjects.Add(Subj);
db.SaveChanges();
SubjRecords.Clear();
LoadSubjectsData();
Subj = new Subject();
SelectedSubj2 = Subj;
}
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);
}
}
}
//===================THIS METHOD IS FOR EDIT RECORDS IN SUBJECTS TABLE==============
public void EditSubj(string newSubName)
{
if (Subj.SubName == "---")
{
dialogService.ShowMessage("Нельзя редактировать эту запись");
return;
}
Subj.SubName = newSubName;
using (StudentuConteiner db = new StudentuConteiner())
{
try
{
var res2 = db.Subjects.Find(Subj.SubjectId);
if (res2 != null)
{
//changing DB
res2.SubName = Subj.SubName;
db.SaveChanges();
SubjRecords.Clear();
LoadSubjectsData();
}
}
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);
}
}
}
//load data array from "Subjects" table
private void LoadSubjectsData()
{
using (StudentuConteiner db = new StudentuConteiner())
{
try
{
var list = db.Subjects.ToList <Subject>();
foreach (var item in list)
{
SubjRecords.Add(
new Subject
{
SubjectId = item.SubjectId,
SubName = item.SubName
});
}
Subj = SubjRecords[0];
SelectedSubj2 = Subj;
}
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);
}
}
}
