void ButtonSave_Click(object sender, RoutedEventArgs e) { #if SILVERLIGHT Storyboard sb = new Storyboard(); sb = Application.Current.Resources["ButtonPressAnimation"] as Storyboard; sb.Completed += new EventHandler(delegate(object obj, EventArgs es) { sb.Stop(); }); Storyboard.SetTarget(sb, ButtonSaveTransform); sb.Begin(); #endif if (IsValid()) { OtherDevice otherDevice = new OtherDevice(); otherDevice.Acronym = TextBoxAcronym.Text.CleanText(); otherDevice.Name = TextBoxName.Text.CleanText(); otherDevice.IsConcentrator = (bool)CheckboxConcentrator.IsChecked; otherDevice.CompanyID = ((KeyValuePair<int, string>)ComboboxCompany.SelectedItem).Key == 0 ? (int?)null : ((KeyValuePair<int, string>)ComboboxCompany.SelectedItem).Key; otherDevice.VendorDeviceID = ((KeyValuePair<int, string>)ComboboxVendorDevice.SelectedItem).Key == 0 ? (int?)null : ((KeyValuePair<int, string>)ComboboxVendorDevice.SelectedItem).Key; otherDevice.Longitude = TextBoxLongitude.Text.ToNullableDecimal(); otherDevice.Latitude = TextBoxLatitude.Text.ToNullableDecimal(); otherDevice.InterconnectionID = ((KeyValuePair<int, string>)ComboboxInterconnection.SelectedItem).Key == 0 ? (int?)null : ((KeyValuePair<int, string>)ComboboxInterconnection.SelectedItem).Key; otherDevice.Planned = (bool)CheckboxPlanned.IsChecked; otherDevice.Desired = (bool)CheckboxDesired.IsChecked; otherDevice.InProgress = (bool)CheckboxInProgress.IsChecked; if (m_inEditMode == false && m_deviceID == 0) SaveOtherDevice(otherDevice, true); else { otherDevice.ID = m_deviceID; SaveOtherDevice(otherDevice, false); } } }
public void GetOtherDeviceByDeviceID(int deviceID) { try { OtherDevice deviceToEdit = new OtherDevice(); deviceToEdit = CommonFunctions.GetOtherDeviceByDeviceID(null, deviceID); GridOtherDeviceDetail.DataContext = deviceToEdit; if (deviceToEdit.CompanyID.HasValue) ComboboxCompany.SelectedItem = new KeyValuePair<int, string>((int)deviceToEdit.CompanyID, deviceToEdit.CompanyName); else ComboboxCompany.SelectedIndex = 0; if (deviceToEdit.InterconnectionID.HasValue) ComboboxInterconnection.SelectedItem = new KeyValuePair<int, string>((int)deviceToEdit.InterconnectionID, deviceToEdit.InterconnectionName); else ComboboxInterconnection.SelectedIndex = 0; if (deviceToEdit.VendorDeviceID.HasValue) ComboboxVendorDevice.SelectedItem = new KeyValuePair<int, string>((int)deviceToEdit.VendorDeviceID, deviceToEdit.VendorDeviceName); else ComboboxVendorDevice.SelectedIndex = 0; } catch (Exception ex) { CommonFunctions.LogException(null, "WPF.GetOtherDeviceByDeviceID", ex); SystemMessages sm = new SystemMessages(new Message() { UserMessage = "Failed to Retrieve Other Device Information by ID", SystemMessage = ex.Message, UserMessageType = MessageType.Error }, ButtonType.OkOnly); sm.Owner = Window.GetWindow(this); sm.WindowStartupLocation = WindowStartupLocation.CenterOwner; sm.ShowPopup(); } }
public void SaveOtherDevice(OtherDevice otherDevice, bool isNew) { SystemMessages sm; try { string result = CommonFunctions.SaveOtherDevice(null, otherDevice, isNew); ClearForm(); sm = new SystemMessages(new Message() { UserMessage = result, SystemMessage = string.Empty, UserMessageType = MessageType.Success }, ButtonType.OkOnly); sm.Owner = Window.GetWindow(this); sm.WindowStartupLocation = WindowStartupLocation.CenterOwner; sm.ShowPopup(); OtherDevicesUserControl otherDevicesUserControl = new OtherDevicesUserControl(); ((MasterLayoutWindow)Window.GetWindow(this)).ContentFrame.Navigate(otherDevicesUserControl); } catch (Exception ex) { CommonFunctions.LogException(null, "WPF.SaveOtherDevice", ex); sm = new SystemMessages(new Message() { UserMessage = "Failed to Save Other Device Information", SystemMessage = ex.Message, UserMessageType = MessageType.Error }, ButtonType.OkOnly); sm.Owner = Window.GetWindow(this); sm.WindowStartupLocation = WindowStartupLocation.CenterOwner; sm.ShowPopup(); } }
public static string SaveOtherDevice(DataConnection connection, OtherDevice otherDevice, bool isNew) { bool createdConnection = false; try { if (connection == null) { connection = new DataConnection(); createdConnection = true; } IDbCommand command = connection.Connection.CreateCommand(); command.CommandType = CommandType.Text; if (isNew) command.CommandText = "Insert Into OtherDevice (Acronym, Name, IsConcentrator, CompanyID, VendorDeviceID, Longitude, Latitude, InterconnectionID, Planned, Desired, InProgress, UpdatedBy, UpdatedOn, CreatedBy, CreatedOn) Values " + "(@acronym, @name, @isConcentrator, @companyID, @vendorDeviceID, @longitude, @latitude, @interconnectionID, @planned, @desired, @inProgress, @updatedBy, @updatedOn, @createdBy, @createdOn)"; else command.CommandText = "Update OtherDevice Set Acronym = @acronym, Name = @name, IsConcentrator = @isConcentrator, CompanyID = @companyID, VendorDeviceID = @vendorDeviceID, Longitude = @longitude, " + "Latitude = @latitude, InterconnectionID = @interconnectionID, Planned = @planned, Desired = @desired, InProgress = @inProgress, UpdatedBy = @updatedBy, UpdatedOn = @updatedOn Where ID = @id"; command.Parameters.Add(AddWithValue(command, "@acronym", otherDevice.Acronym.Replace(" ", "").ToUpper())); command.Parameters.Add(AddWithValue(command, "@name", otherDevice.Name)); command.Parameters.Add(AddWithValue(command, "@isConcentrator", otherDevice.IsConcentrator)); command.Parameters.Add(AddWithValue(command, "@companyID", otherDevice.CompanyID ?? (object)DBNull.Value)); command.Parameters.Add(AddWithValue(command, "@vendorDeviceID", otherDevice.VendorDeviceID ?? (object)DBNull.Value)); command.Parameters.Add(AddWithValue(command, "@longitude", otherDevice.Longitude ?? (object)DBNull.Value)); command.Parameters.Add(AddWithValue(command, "@latitude", otherDevice.Latitude ?? (object)DBNull.Value)); command.Parameters.Add(AddWithValue(command, "@interconnectionID", otherDevice.InterconnectionID ?? (object)DBNull.Value)); command.Parameters.Add(AddWithValue(command, "@planned", otherDevice.Planned)); command.Parameters.Add(AddWithValue(command, "@desired", otherDevice.Desired)); command.Parameters.Add(AddWithValue(command, "@inProgress", otherDevice.InProgress)); command.Parameters.Add(AddWithValue(command, "@updatedBy", s_currentUser)); command.Parameters.Add(AddWithValue(command, "@updatedOn", command.Connection.ConnectionString.Contains("Microsoft.Jet.OLEDB") ? DateTime.UtcNow.Date : DateTime.UtcNow)); if (isNew) { command.Parameters.Add(AddWithValue(command, "@createdBy", s_currentUser)); command.Parameters.Add(AddWithValue(command, "@createdOn", command.Connection.ConnectionString.Contains("Microsoft.Jet.OLEDB") ? DateTime.UtcNow.Date : DateTime.UtcNow)); } else command.Parameters.Add(AddWithValue(command, "@id", otherDevice.ID)); command.ExecuteScalar(); return "Other Device Information Saved Successfully"; } finally { if (createdConnection && connection != null) connection.Dispose(); } }