//Loading filtered data
private void LoadData(string name)
{
using (var db = new ApirsRepository <tblPlug>())
{
try
{
Plugs = new BindableCollection <tblPlug>(db.GetModelByExpression(plug => plug.plugLabel == name));
if (Plugs.Count == 0)
{
SelectedPlug = new tblPlug();
SelectedPlug.plugLabel = name;
}
else if (Plugs.Count > 1)
{
SelectedPlug = Plugs.First();
}
else
{
SelectedPlug = Plugs.First();
}
}
catch
{
Plugs = new BindableCollection <tblPlug>();
SelectedPlug = new tblPlug();
}
}
}
public void Update()
{
using (var db = new ApirsRepository <tblPlug>())
{
try
{
if (SelectedPlug.plugIdPk == 0)
{
try
{
db.InsertModel(SelectedPlug);
db.Save();
TryClose();
}
catch
{
((ShellViewModel)IoC.Get <IShell>()).ShowInformation("Plug can't be added. Please check every field again.");
return;
}
}
else
{
tblPlug result = db.GetModelById(SelectedPlug.plugIdPk);
if (result != null)
{
db.UpdateModel(SelectedPlug, SelectedPlug.plugIdPk);
db.Save();
}
}
}
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
{
}
}
}
