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); } }