void SaveVendor(Vendor vendor, bool isNew) { SystemMessages sm; try { string result = CommonFunctions.SaveVendor(null, vendor, isNew); sm = new SystemMessages(new Message() { UserMessage = result, SystemMessage = string.Empty, UserMessageType = MessageType.Success }, ButtonType.OkOnly); sm.Owner = Window.GetWindow(this); sm.ShowPopup(); GetVendors(); //ClearForm(); //make this newly added or updated item as default selected. So user can click initialize right away. ListBoxVendorList.SelectedItem = ((List<Vendor>)ListBoxVendorList.ItemsSource).Find(c => c.Acronym == vendor.Acronym); } catch (Exception ex) { CommonFunctions.LogException(null, "WPF.SaveVendor", ex); sm = new SystemMessages(new Message() { UserMessage = "Failed to Save Vendor 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()) { Vendor vendor = new Vendor(); vendor.Acronym = TextBoxAcronym.Text.CleanText(); vendor.Name = TextBoxName.Text.CleanText(); vendor.PhoneNumber = TextBoxPhoneNumber.Text.CleanText(); vendor.ContactEmail = TextBoxContactEmail.Text.CleanText(); vendor.URL = TextBoxUrl.Text.CleanText(); if (m_vendorID != 0 && m_inEditMode == true) //i.e. It is an update to existing item. { vendor.ID = m_vendorID; SaveVendor(vendor, false); } else //i.e. It is a new item SaveVendor(vendor, true); } }
public static string SaveVendor(DataConnection connection, Vendor vendor, 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 Vendor (Acronym, Name, PhoneNumber, ContactEmail, URL, UpdatedBy, UpdatedOn, CreatedBy, CreatedOn) Values (@acronym, @name, @phoneNumber, @contactEmail, @url, @updatedBy, @updatedOn, @createdBy, @createdOn)"; else command.CommandText = "Update Vendor Set Acronym = @acronym, Name = @name, PhoneNumber = @phoneNumber, ContactEmail = @contactEmail, URL = @url, UpdatedBy = @updatedBy, UpdatedOn = @updatedOn Where ID = @id"; command.Parameters.Add(AddWithValue(command, "@acronym", vendor.Acronym.Replace(" ", "").ToUpper())); command.Parameters.Add(AddWithValue(command, "@name", vendor.Name)); command.Parameters.Add(AddWithValue(command, "@phoneNumber", vendor.PhoneNumber)); command.Parameters.Add(AddWithValue(command, "@contactEmail", vendor.ContactEmail)); command.Parameters.Add(AddWithValue(command, "@url", vendor.URL)); 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", vendor.ID)); command.ExecuteNonQuery(); return "Vendor Information Saved Successfully"; } finally { if (createdConnection && connection != null) connection.Dispose(); } }