void SaveCompany(Company company, bool isNew) { SystemMessages sm; try { string result = CommonFunctions.SaveCompany(null, company, isNew); sm = new SystemMessages(new Message() { UserMessage = result, SystemMessage = string.Empty, UserMessageType = MessageType.Success }, ButtonType.OkOnly); sm.Owner = Window.GetWindow(this); sm.ShowPopup(); GetCompanies(); //ClearForm(); //make this newly added or updated item as default selected. So user can click initialize right away. ListBoxCompanyList.SelectedItem = ((List<Company>)ListBoxCompanyList.ItemsSource).Find(c => c.Acronym == company.Acronym); } catch (Exception ex) { CommonFunctions.LogException(null, "WPF.SaveCompany", ex); sm = new SystemMessages(new Message() { UserMessage = "Failed to Save Company Information", SystemMessage = ex.Message, UserMessageType = MessageType.Error }, ButtonType.OkOnly); sm.Owner = Window.GetWindow(this); sm.ShowPopup(); } }
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()) { Company company = new Company(); company.Acronym = TextBoxAcronym.Text.CleanText(); company.MapAcronym = TextBoxMapAcronym.Text.CleanText(); company.Name = TextBoxName.Text.CleanText(); company.URL = TextBoxURL.Text.CleanText(); company.LoadOrder = TextBoxLoadOrder.Text.ToInteger(); if (m_inEditMode == true && m_companyID != 0) { company.ID = m_companyID; SaveCompany(company, false); } else SaveCompany(company, true); } }
public static string SaveCompany(DataConnection connection, Company company, 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 Company (Acronym, MapAcronym, Name, URL, LoadOrder, UpdatedBy, UpdatedOn, CreatedBy, CreatedOn) VALUES (@acronym, @mapAcronym, @name, @url, @loadOrder, @updatedBy, @updatedOn, @createdBy, @createdOn)"; else command.CommandText = "UPDATE Company SET Acronym = @acronym, MapAcronym = @mapAcronym, Name = @name, URL = @url, LoadOrder = @loadOrder, UpdatedBy = @updatedBy, UpdatedOn = @updatedOn WHERE ID = @id"; command.Parameters.Add(AddWithValue(command, "@acronym", company.Acronym.Replace(" ", "").ToUpper())); command.Parameters.Add(AddWithValue(command, "@mapAcronym", company.MapAcronym.Replace(" ", "").ToUpper())); command.Parameters.Add(AddWithValue(command, "@name", company.Name)); command.Parameters.Add(AddWithValue(command, "@url", company.URL)); command.Parameters.Add(AddWithValue(command, "@loadOrder", company.LoadOrder)); 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", company.ID)); } command.ExecuteNonQuery(); return "Company Information Saved Successfully"; } finally { if (createdConnection && connection != null) connection.Dispose(); } }