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