public void populateDataGrid(DataGrid grid)
{
using (var db = new PlanningContext())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(rss_configuration.rss_configuration_id))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "description",
Binding = new Binding(nameof(rss_configuration.description))
});
foreach (var data in db.rss_configuration)
{
grid.Items.Add(data);
// Cache some of the data we need
if (data.device != null)
{
data.device.ToString();
}
if (data.update_period != null)
{
data.update_period.ToString();
}
}
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
bbc_rss_visibility data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.bbc_rss_visibility_id.Text);
data = db.bbc_rss_visibility.Where(d => d.bbc_rss_visibility_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.bbc_rss_visibility_id.Text}' does not exist.";
return;
}
}
else
{
data = new bbc_rss_visibility();
}
data.bbc_rss_visibility_id = Convert.ToInt32(this.bbc_rss_visibility_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_visibility.Add(data);
}
db.SaveChanges();
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
backup_log data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.backup_log_id.Text);
data = db.backup_log.Where(d => d.backup_log_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.backup_log_id.Text}' does not exist.";
return;
}
}
else
{
data = new backup_log();
}
data.backup_log_id = Convert.ToInt32(this.backup_log_id.Text);
data.filename = /**/ (this.filename.Text);
data.datetime = (DateTime)this.datetime.SelectedDate;
data.comment = /**/ (this.comment.Text);
data.is_active = (bool)this.is_active.IsChecked;
if (this._isCreateMode)
{
db.backup_log.Add(data);
}
db.SaveChanges();
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new PlanningContext())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(message_type.message_type_id))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "description",
Binding = new Binding(nameof(message_type.description))
});
foreach (var data in db.message_type)
{
grid.Items.Add(data);
// Cache some of the data we need
foreach (var val0 in data.application_log)
{
if (val0.application != null)
{
val0.application.ToString();
}
if (val0.message_type != null)
{
val0.message_type.ToString();
}
}
}
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new PlanningContext())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(unit.unit_id))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "description",
Binding = new Binding(nameof(unit.description))
});
foreach (var data in db.units)
{
grid.Items.Add(data);
// Cache some of the data we need
foreach (var val0 in data.device_type)
{
if (val0.unit != null)
{
val0.unit.ToString();
}
foreach (var val1 in val0.devices)
{
}
}
}
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new PlanningContext())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(device_address_type.device_address_type_id))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "description",
Binding = new Binding(nameof(device_address_type.description))
});
foreach (var data in db.device_address_type)
{
grid.Items.Add(data);
// Cache some of the data we need
foreach(var val0 in data.device_address){
if(val0.device != null) val0.device.ToString();
if(val0.device_address_type != null) val0.device_address_type.ToString();
}
}
}
}
public static bbc_rss_visibility GetVisibility(string visiblity, bool createIfMissing = true)
{
visiblity = visiblity.ToUpper().Trim();
using (var db = new PlanningContext())
{
var query = from db_visiblity in db.bbc_rss_visibility
where db_visiblity.description.ToUpper() == visiblity
select db_visiblity;
var result = query.FirstOrDefault();
if (result == null && createIfMissing)
{
var toAdd = new bbc_rss_visibility
{
description = visiblity,
version = 1,
is_active = true,
comment = visiblity
};
db.bbc_rss_visibility.Add(toAdd);
db.SaveChanges();
result = toAdd;
}
return(result);
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new PlanningContext())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(contact_history.contact_history_id))
});
foreach (var data in db.contact_history)
{
grid.Items.Add(data);
// Cache some of the data we need
if (data.contact != null)
{
data.contact.ToString();
}
if (data.history_event != null)
{
data.history_event.ToString();
}
}
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new PlanningContext())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(device_history.device_history_id))
});
foreach (var data in db.device_history)
{
grid.Items.Add(data);
// Cache some of the data we need
if (data.device != null)
{
data.device.ToString();
}
if (data.device_history_action != null)
{
data.device_history_action.ToString();
}
if (data.supplier != null)
{
data.supplier.ToString();
}
}
}
}
public static bbc_rss_cloud_coverage GetCloudCoverage(string coverage, bool createIfMissing = true)
{
coverage = coverage.ToUpper().Trim();
using (var db = new PlanningContext())
{
var query = from db_coverage in db.bbc_rss_cloud_coverage
where db_coverage.description == coverage
select db_coverage;
var result = query.FirstOrDefault();
if (result == null && createIfMissing)
{
var toAdd = new bbc_rss_cloud_coverage
{
description = coverage,
version = 1,
is_active = true,
comment = coverage
};
db.bbc_rss_cloud_coverage.Add(toAdd);
db.SaveChanges();
result = toAdd;
}
return(result);
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
application data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.application_id.Text);
data = db.applications.Where(d => d.application_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.application_id.Text}' does not exist.";
return;
}
}
else
{
data = new application();
}
data.application_id = Convert.ToInt32(this.application_id.Text);
data.name = /**/ (this.name.Text);
data.description = /**/ (this.description.Text);
data.application_version = Convert.ToInt32(this.application_version.Text);
data.is_active = (bool)this.is_active.IsChecked;
if (this._isCreateMode)
{
db.applications.Add(data);
}
db.SaveChanges();
}
}
public static void createEntry()
{
var databaseIP = ConfigurationManager.AppSettings["databaseIP"];
if (databaseIP == null)
{
throw new Exception("No key called 'databaseIP' in App.config *(make sure it's in the right one)*");
}
if (!RSSHelper.isConnectedToTheInternet())
{
}
var ping = new Ping().Send("However we get this");
if (ping.Status != IPStatus.Success)
{
}
using (var context = new PlanningContext())
{
if (!context.Database.Exists())
{
}
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
database_config data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.database_config_id.Text);
data = db.database_config.Where(d => d.database_config_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.database_config_id.Text}' does not exist.";
return;
}
}
else
{
data = new database_config();
}
data.database_config_id = Convert.ToInt32(this.database_config_id.Text);
data.database_backup_directory = /**/ (this.database_backup_directory.Text);
data.is_active = (bool)this.is_active.IsChecked;
if (this._isCreateMode)
{
db.database_config.Add(data);
}
db.SaveChanges();
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new PlanningContext())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(alarm.alarm_id))
});
foreach (var data in db.alarms)
{
grid.Items.Add(data);
// Cache some of the data we need
if (data.alarm_type != null)
{
data.alarm_type.ToString();
}
if (data.device != null)
{
data.device.ToString();
}
if (data.group_type != null)
{
data.group_type.ToString();
}
}
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
supplier data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.supplier_id.Text);
data = db.suppliers.Where(d => d.supplier_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.supplier_id.Text}' does not exist.";
return;
}
}
else
{
data = new supplier();
}
data.supplier_id = Convert.ToInt32(this.supplier_id.Text);
data.name = /**/ (this.name.Text);
data.is_active = (bool)this.is_active.IsChecked;
data.comment = /**/ (this.comment.Text);
if (this._isCreateMode)
{
db.suppliers.Add(data);
}
db.SaveChanges();
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new PlanningContext())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(history_event.history_event_id))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "description",
Binding = new Binding(nameof(history_event.description))
});
foreach (var data in db.history_event)
{
grid.Items.Add(data);
// Cache some of the data we need
foreach (var val0 in data.contact_history)
{
if (val0.contact != null)
{
val0.contact.ToString();
}
if (val0.history_event != null)
{
val0.history_event.ToString();
}
}
}
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
device data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.device_id.Text);
data = db.devices.Where(d => d.device_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.device_id.Text}' does not exist.";
return;
}
}
else
{
data = new device();
}
data.device_id = Convert.ToInt32(this.device_id.Text);
data.name = /**/ (this.name.Text);
data.description = /**/ (this.description.Text);
data.location = /**/ (this.location.Text);
data.min_value = Convert.ToDouble(this.min_value.Text);
data.max_value = Convert.ToDouble(this.max_value.Text);
data.accuracy = Convert.ToDouble(this.accuracy.Text);
data.serial_number = /**/ (this.serial_number.Text);
data.cost = Convert.ToDecimal(this.cost.Text);
data.reliability = Convert.ToInt32(this.reliability.Text);
data.strikes = Convert.ToInt32(this.strikes.Text);
data.is_active = (bool)this.is_active.IsChecked;
data.comment = /**/ (this.comment.Text);
data.is_allowed_for_use = (bool)this.is_allowed_for_use.IsChecked;
data.device2 = new Func <device>(() => { foreach (var v in db.devices)
{
if (v.device_id == (this.device2.item as device).device_id)
{
return(v);
}
}
return(null); })();
data.device_type = new Func <device_type>(() => { foreach (var v in db.device_type)
{
if (v.device_type_id == (this.device_type.item as device_type).device_type_id)
{
return(v);
}
}
return(null); })();
if (this._isCreateMode)
{
db.devices.Add(data);
}
db.SaveChanges();
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
alarm data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.alarm_id.Text);
data = db.alarms.Where(d => d.alarm_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.alarm_id.Text}' does not exist.";
return;
}
}
else
{
data = new alarm();
}
data.alarm_id = Convert.ToInt32(this.alarm_id.Text);
data.value = Convert.ToDouble(this.value.Text);
data.comment = /**/ (this.comment.Text);
data.is_active = (bool)this.is_active.IsChecked;
data.alarm_type = new Func <alarm_type>(() => { foreach (var v in db.alarm_type)
{
if (v.alarm_type_id == (this.alarm_type.item as alarm_type).alarm_type_id)
{
return(v);
}
}
return(null); })();
data.device = new Func <device>(() => { foreach (var v in db.devices)
{
if (v.device_id == (this.device.item as device).device_id)
{
return(v);
}
}
return(null); })();
data.group_type = new Func <group_type>(() => { foreach (var v in db.group_type)
{
if (v.group_type_id == (this.group_type.item as group_type).group_type_id)
{
return(v);
}
}
return(null); })();
if (this._isCreateMode)
{
db.alarms.Add(data);
}
db.SaveChanges();
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
device_history data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.device_history_id.Text);
data = db.device_history.Where(d => d.device_history_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.device_history_id.Text}' does not exist.";
return;
}
}
else
{
data = new device_history();
}
data.device_history_id = Convert.ToInt32(this.device_history_id.Text);
data.datetime = (DateTime)this.datetime.SelectedDate;
data.is_active = (bool)this.is_active.IsChecked;
data.comment = /**/ (this.comment.Text);
data.device = new Func <device>(() => { foreach (var v in db.devices)
{
if (v.device_id == (this.device.item as device).device_id)
{
return(v);
}
}
return(null); })();
data.device_history_action = new Func <device_history_action>(() => { foreach (var v in db.device_history_action)
{
if (v.device_history_action1 == (this.device_history_action.item as device_history_action).device_history_action1)
{
return(v);
}
}
return(null); })();
data.supplier = new Func <supplier>(() => { foreach (var v in db.suppliers)
{
if (v.supplier_id == (this.supplier.item as supplier).supplier_id)
{
return(v);
}
}
return(null); })();
if (this._isCreateMode)
{
db.device_history.Add(data);
}
db.SaveChanges();
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
contact data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.contact_id.Text);
data = db.contacts.Where(d => d.contact_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.contact_id.Text}' does not exist.";
return;
}
}
else
{
data = new contact();
}
data.contact_id = Convert.ToInt32(this.contact_id.Text);
data.is_active = (bool)this.is_active.IsChecked;
data.comment = /**/ (this.comment.Text);
data.contact_type = new Func <contact_type>(() => { foreach (var v in db.contact_type)
{
if (v.contact_type_id == (this.contact_type.item as contact_type).contact_type_id)
{
return(v);
}
}
return(null); })();
data.supplier = new Func <supplier>(() => { foreach (var v in db.suppliers)
{
if (v.supplier_id == (this.supplier.item as supplier).supplier_id)
{
return(v);
}
}
return(null); })();
data.user = new Func <user>(() => { foreach (var v in db.users)
{
if (v.user_id == (this.user.item as user).user_id)
{
return(v);
}
}
return(null); })();
if (this._isCreateMode)
{
db.contacts.Add(data);
}
db.SaveChanges();
}
}
/// <summary>
/// The contructor requires an open DataContext to work with
/// </summary>
/// <param name="context">An open DataContext</param>
public RepositoryPlanning(PlanningContext context)
{
this.Context = context;
try
{
this.Entities = context.Set <TEntity>();
}
catch
{
this.Queries = context.Query <TEntity>();
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
rss_configuration data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.rss_configuration_id.Text);
data = db.rss_configuration.Where(d => d.rss_configuration_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.rss_configuration_id.Text}' does not exist.";
return;
}
}
else
{
data = new rss_configuration();
}
data.rss_configuration_id = Convert.ToInt32(this.rss_configuration_id.Text);
data.description = /**/ (this.description.Text);
data.is_active = (bool)this.is_active.IsChecked;
data.last_update = (DateTime)this.last_update.SelectedDate;
data.update_frequency = Convert.ToDouble(this.update_frequency.Text);
data.rss_url = /**/ (this.rss_url.Text);
data.device = new Func <device>(() => { foreach (var v in db.devices)
{
if (v.device_id == (this.device.item as device).device_id)
{
return(v);
}
}
return(null); })();
data.update_period = new Func <update_period>(() => { foreach (var v in db.update_period)
{
if (v.update_period_id == (this.update_period.item as update_period).update_period_id)
{
return(v);
}
}
return(null); })();
if (this._isCreateMode)
{
db.rss_configuration.Add(data);
}
db.SaveChanges();
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
device_address data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.device_address_id.Text);
data = db.device_address.Where(d => d.device_address_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.device_address_id.Text}' does not exist.";
return;
}
}
else
{
data = new device_address();
}
data.device_address_id = Convert.ToInt32(this.device_address_id.Text);
data.pin_number = Convert.ToInt32(this.pin_number.Text);
data.ip_address = /**/ (this.ip_address.Text);
data.comment = /**/ (this.comment.Text);
data.is_active = (bool)this.is_active.IsChecked;
data.device = new Func <device>(() => { foreach (var v in db.devices)
{
if (v.device_id == (this.device.item as device).device_id)
{
return(v);
}
}
return(null); })();
data.device_address_type = new Func <device_address_type>(() => { foreach (var v in db.device_address_type)
{
if (v.device_address_type_id == (this.device_address_type.item as device_address_type).device_address_type_id)
{
return(v);
}
}
return(null); })();
if (this._isCreateMode)
{
db.device_address.Add(data);
}
db.SaveChanges();
}
}
public void populateDataGrid(DataGrid grid)
{
using (var db = new PlanningContext())
{
grid.Columns.Add(new DataGridTextColumn()
{
Header = "ID",
Binding = new Binding(nameof(contact_type.contact_type_id))
});
grid.Columns.Add(new DataGridTextColumn()
{
Header = "description",
Binding = new Binding(nameof(contact_type.description))
});
foreach (var data in db.contact_type)
{
grid.Items.Add(data);
// Cache some of the data we need
foreach (var val0 in data.contacts)
{
if (val0.contact_type != null)
{
val0.contact_type.ToString();
}
if (val0.supplier != null)
{
val0.supplier.ToString();
}
if (val0.user != null)
{
val0.user.ToString();
}
foreach (var val1 in val0.contact_email)
{
}
foreach (var val1 in val0.contact_history)
{
}
foreach (var val1 in val0.contact_telephone)
{
}
foreach (var val1 in val0.group_member)
{
}
}
}
}
}
static void Main(string[] args)
{
using (var db = new PlanningContext())
{
var query = from device in db.devices select device;
foreach (var device in query)
{
Console.WriteLine(device.device_type.description);
}
Console.ReadKey();
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
application_log data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.application_log_id.Text);
data = db.application_log.Where(d => d.application_log_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.application_log_id.Text}' does not exist.";
return;
}
}
else
{
data = new application_log();
}
data.application_log_id = Convert.ToInt32(this.application_log_id.Text);
data.message = /**/ (this.message.Text);
data.datetime = (DateTime)this.datetime.SelectedDate;
data.is_active = (bool)this.is_active.IsChecked;
data.application = new Func <application>(() => { foreach (var v in db.applications)
{
if (v.application_id == (this.application.item as application).application_id)
{
return(v);
}
}
return(null); })();
data.message_type = new Func <message_type>(() => { foreach (var v in db.message_type)
{
if (v.message_type_id == (this.message_type.item as message_type).message_type_id)
{
return(v);
}
}
return(null); })();
if (this._isCreateMode)
{
db.application_log.Add(data);
}
db.SaveChanges();
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
contact_history data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.contact_history_id.Text);
data = db.contact_history.Where(d => d.contact_history_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.contact_history_id.Text}' does not exist.";
return;
}
}
else
{
data = new contact_history();
}
data.contact_history_id = Convert.ToInt32(this.contact_history_id.Text);
data.date_and_time = (DateTime)this.date_and_time.SelectedDate;
data.is_active = (bool)this.is_active.IsChecked;
data.comment = /**/ (this.comment.Text);
data.contact = new Func <contact>(() => { foreach (var v in db.contacts)
{
if (v.contact_id == (this.contact.item as contact).contact_id)
{
return(v);
}
}
return(null); })();
data.history_event = new Func <history_event>(() => { foreach (var v in db.history_event)
{
if (v.history_event_id == (this.history_event.item as history_event).history_event_id)
{
return(v);
}
}
return(null); })();
if (this._isCreateMode)
{
db.contact_history.Add(data);
}
db.SaveChanges();
}
}
public void deleteItem(object item)
{
if(item == null)
return;
device_address_type data = item as device_address_type;
if(data == null)
return;
using (var db = new PlanningContext())
{
db.device_address_type.Remove(db.device_address_type.Where(d => d.device_address_type_id == data.device_address_type_id).First());
db.SaveChanges();
}
}
public void saveChanges()
{
using (var db = new PlanningContext())
{
device_value data = null;
if (!this._isCreateMode)
{
var id = Convert.ToInt32(this.device_value_id.Text);
data = db.device_value.Where(d => d.device_value_id == id).FirstOrDefault();
if (data == null)
{
this._mainInterface.statusText = $"ERROR: ID '{this.device_value_id.Text}' does not exist.";
return;
}
}
else
{
data = new device_value();
}
data.device_value_id = Convert.ToInt32(this.device_value_id.Text);
data.value = Convert.ToDouble(this.value.Text);
data.datetime = (DateTime)this.datetime.SelectedDate;
data.response_recieved = (bool)this.response_recieved.IsChecked;
data.is_active = (bool)this.is_active.IsChecked;
data.comment = /**/ (this.comment.Text);
data.extra_data = /**/ (this.extra_data.Text);
data.device = new Func <device>(() => { foreach (var v in db.devices)
{
if (v.device_id == (this.device.item as device).device_id)
{
return(v);
}
}
return(null); })();
if (this._isCreateMode)
{
db.device_value.Add(data);
}
db.SaveChanges();
}
}
private static device GetDevice(string name)
{
using (var db = new PlanningContext())
{
var query = from db_device in db.devices
where db_device.name == name
select db_device;
var result = query.FirstOrDefault();
if (result == null)
{
throw new Exception($"Unable to find RSS device, name '{RSSObservationDeviceName}'");
}
return(result);
}
}
