static void Main(string[] args)
{
var config = Factory.GetConnectionString();
ISqlDataAccess dataAccess = Factory.CreateSqlDataAccess(config);
IConnectionStringData connectionStringName = Factory.CreateConnectionStringName();
ISqlCrud sqlCrud = Factory.CreateSqlCrud(dataAccess, connectionStringName);
try
{
//ReadAllContacts(sqlCrud);
//ReadAllGiftsEntered(sqlCrud);
//ReadAllBudgetActuals(sqlCrud);
CreateNewGiftEntry(sqlCrud);
//InsertNewContact(sqlCrud);
//UpdateBudgetAmount(sqlCrud);
//RemoveGiftFromContact(sqlCrud);
}
catch (Exception ex)
{
Console.WriteLine("We had an error");
Console.WriteLine(ex.Message);
}
Console.ReadLine();
}
private static void RemoveGiftFromContact(ISqlCrud sqlCrud)
{
int giftId = 1002;
int contactId = 4;
sqlCrud.DeleteGiftFromContact(giftId, contactId);
Console.WriteLine($"Gift Id {giftId} is removed from contact Id {contactId}.");
}
private static void ReadAllContacts(ISqlCrud sqlCrud)
{
var rows = sqlCrud.GetAllContacts().Result;
foreach (var row in rows)
{
Console.WriteLine($"{row.ContactId}: {row.FirstName} {row.LastName}"
+ Environment.NewLine
+ $"Budget:{string.Format("{0:C}", row.BudgetAmount)}");
Console.WriteLine();
}
}
private static void InsertNewContact(ISqlCrud sqlCrud)
{
ContactModel contact = new ContactModel
{
FirstName = "Brent",
LastName = "Crystal",
BudgetAmount = 20
};
sqlCrud.InsertContact(contact);
Console.WriteLine($"{contact.FirstName} {contact.LastName} added to contact list.");
}
private static void CreateNewGiftEntry(ISqlCrud sqlCrud)
{
GiftModel gift = new GiftModel
{
GiftName = "Barbie Doll",
GiftCost = 15,
ContactId = 4
};
sqlCrud.CreateGiftEntry(gift);
Console.WriteLine($"Gift data entry conmplete.");
}
private static void UpdateBudgetAmount(ISqlCrud sqlCrud)
{
ContactModel contact = new ContactModel
{
ContactId = 11,
FirstName = "Brent",
LastName = "Crystal",
BudgetAmount = 50
};
sqlCrud.UpdateContactBudget(contact);
Console.WriteLine($"Budget for {contact.FirstName} {contact.LastName} is updated.");
}
private static void ReadAllGiftsEntered(ISqlCrud sqlCrud)
{
var rows = sqlCrud.GetAllGiftsEntered().Result;
foreach (var row in rows)
{
Console.WriteLine($"{row.FirstName} {row.LastName}"
+ Environment.NewLine
+ $"Gift: {row.GiftName}"
+ Environment.NewLine
+ $"Cost: {string.Format("{0:C}", row.GiftCost)}");
Console.WriteLine();
}
}
private static void ReadAllBudgetActuals(ISqlCrud sqlCrud)
{
var rows = sqlCrud.GetAllBudgetActuals().Result;
foreach (var row in rows)
{
Console.WriteLine($"{row.FirstName} {row.LastName}"
+ Environment.NewLine
+ $"Budget:{string.Format("{0:C}", row.BudgetAmount)}"
+ Environment.NewLine
+ $"TotalCost: {string.Format("{0:C}", row.TotalCost)}"
+ Environment.NewLine
+ $"Balance: {string.Format("{0:C}", row.BudgetBalance)}");
Console.WriteLine();
}
}
