public void saveChanges()
{
using (var db = new PlanningContext())
{
bbc_rss_barometric_change data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.bbc_rss_barometric_change_id.Text);
data = db.bbc_rss_barometric_change.Where(d => d.bbc_rss_barometric_change_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.bbc_rss_barometric_change_id.Text}' does not exist.";
return;
}
}
else
{
data = new bbc_rss_barometric_change();
}
data.bbc_rss_barometric_change_id = Convert.ToInt32(this.bbc_rss_barometric_change_id.Text);
data.description = /**/ (this.description.Text);
data.comment = /**/ (this.comment.Text);
data.is_active = (bool)this.is_active.IsChecked;
if (this._isCreateMode)
{
db.bbc_rss_barometric_change.Add(data);
}
db.SaveChanges();
}
}
public static bbc_rss_barometric_change GetBarometricChange(string change, bool createIfMissing = true)
{
change = change.ToUpper().Trim();
using (var db = new PlanningContext())
{
var query = from db_change in db.bbc_rss_barometric_change
where db_change.description == change
select db_change;
var result = query.FirstOrDefault();
if (result == null && createIfMissing)
{
var toAdd = new bbc_rss_barometric_change
{
description = change,
version = 1,
is_active = true,
comment = change
};
db.bbc_rss_barometric_change.Add(toAdd);
db.SaveChanges();
result = toAdd;
}
return(result);
}
}
public void deleteItem(object item)
{
if (item == null)
{
return;
}
bbc_rss_barometric_change data = item as bbc_rss_barometric_change;
if (data == null)
{
return;
}
using (var db = new PlanningContext())
{
db.bbc_rss_barometric_change.Remove(db.bbc_rss_barometric_change.Where(d => d.bbc_rss_barometric_change_id == data.bbc_rss_barometric_change_id).First());
db.SaveChanges();
}
}
