//Loading filtered data
private void LoadData(string name)
{
using (var db = new ApirsDatabase())
{
try
{
Drillings = new BindableCollection <tblDrilling>(from drill in db.tblDrillings
where drill.drillName == name
select drill);
if (Drillings.Count == 0)
{
SelectedDrilling = new tblDrilling();
SelectedDrilling.drillName = name;
}
else if (Drillings.Count > 1)
{
SelectedDrilling = Drillings.First();
}
else
{
SelectedDrilling = Drillings.First();
}
}
catch
{
Drillings = new BindableCollection <tblDrilling>();
SelectedDrilling = new tblDrilling();
}
}
}
//Loading filtered data
private void LoadData(string name)
{
using (var db = new ApirsRepository <tblDrilling>())
{
try
{
Drillings = new BindableCollection <tblDrilling>(db.GetModelByExpression(x => x.drillName == name));
if (Drillings.Count == 0)
{
SelectedDrilling = new tblDrilling();
SelectedDrilling.drillName = name;
}
else if (Drillings.Count > 1)
{
SelectedDrilling = Drillings.First();
}
else
{
SelectedDrilling = Drillings.First();
}
}
catch
{
Drillings = new BindableCollection <tblDrilling>();
SelectedDrilling = new tblDrilling();
}
}
}
// Commit changes from the new object form
// or edits made to the existing object form.
public void Update()
{
using (var db = new ApirsDatabase())
{
try
{
if (SelectedDrilling.drillIdPk == 0)
{
try
{
db.tblDrillings.Add(SelectedDrilling);
db.SaveChanges();
TryClose();
}
catch
{
((ShellViewModel)IoC.Get <IShell>()).ShowInformation("Object can't be added. Please check every field again.");
return;
}
}
else
{
tblDrilling result = db.tblDrillings.Where(drill => drill.drillName == SelectedDrilling.drillName).First();
if (result != null)
{
db.Entry <tblDrilling>(result).CurrentValues.SetValues(SelectedDrilling);
db.SaveChanges();
}
}
}
catch (SqlException ex)
{
((ShellViewModel)IoC.Get <IShell>()).ShowInformation("Please provide valid input parameters");
}
catch (Exception e)
{
((ShellViewModel)IoC.Get <IShell>()).ShowInformation("Something went wrong");
}
finally
{
}
}
}