/// <summary>
/// Edits a retailer from the database and updates the list of retailers
/// </summary>
public void EditRetailer()
{
Handlers.Database db = new Handlers.Database();
db.UpdateRetailer(NewRetailer);
UpdateRetailers();
}
/// <summary>
/// Loads all retailers from the database into the retailer list
/// </summary>
public void LoadRetailers()
{
Handlers.Database db = new Handlers.Database();
Retailers = db.LoadAllRetailers();
SortRetailersByName();
sortedByName = false;
}
/// <summary>
/// Deletes a retailer from the database and updates the list of retailers
/// </summary>
public void DeleteRetailer()
{
// delete retailer from database
Handlers.Database db = new Handlers.Database();
db.DeleteRetailer(Retailer);
UpdateRetailers();
}
/// <summary>
/// Adds a new retailer to the database and updates list of retailers
/// </summary>
public void AddRetailer()
{
// add retailer to database
Handlers.Database db = new Handlers.Database();
//db.WriteRecord<Retailer>(NewRetailer, table, db.BuildFieldObject("nvarchar", fieldname));
db.AddRetailer(NewRetailer);
UpdateRetailers();
ClearNewRetailer();
}
/// <summary>
/// Handles the event that retailer is selected from the list in the settings UI
/// </summary>
/// <param name="sender"> The retailer that was selected in the list</param>
/// <param name="e"></param>
/// <remarks>
/// The NewRetailer is loaded from the database instead of being referenced internally for it's information
/// to avoid referencing the same address as Retailer or a retailer in Retailers.
/// </remarks>
public void RetailerSelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (e.AddedItems.Count > 0)
{
foreach (var item in e.AddedItems)
{
Retailer = (Retailer)item;
}
}
Handlers.Database db = new Handlers.Database();
NewRetailer = db.LoadRetailer(Retailer);
}
/// <summary>
/// Updates <see cref="Retailers"/> after a retailer is added, edited, or deleted from the database
/// </summary>
/// <remarks>
/// LoadRetailers() can't be used in place of UpdateRetailers() because the list in the settings UI is bound to the
/// observable collection Retailers <see cref="Retailers"/>. LoadRetailers() would break the binding and not update
/// in real time if the user were to make a change
/// </remarks>
public void UpdateRetailers()
{
Handlers.Database db = new Handlers.Database();
var retailerList = db.LoadAllRetailers();
Retailers.Clear();
foreach (var retailer in retailerList)
{
Retailers.Add(retailer);
}
sortedByName = false;
SortRetailersByName();
sortedByName = false;
}
/// <summary>
/// Updates RetailButtons list with retailers from the database
/// </summary>
/// <seealso cref="RetailButtons"/>
/// <seealso cref="SortByName(ObservableCollection{Retailer}))"/>
public void UpdateRetailButtons()
{
Handlers.Database db = new Handlers.Database();
var retailerList = db.LoadAllRetailers();
SortByName(retailerList);
int i = 0;
foreach (Retailer item in retailerList)
{
RetailButton newButton = new RetailButton();
newButton.Retailer = item;
newButton.Visibility = true;
RetailButtons.RemoveAt(i);
RetailButtons.Insert(i, newButton);
++i;
}
}
