/// <summary>
/// Adds CPU to database
/// </summary>
/// <param name="_item">Item details of CPU.</param>
/// <param name="_cpu">CPU details.</param>
/// <returns></returns>
public bool AddItem(Item _item, CPU _cpu)
{
try
{
// Using database context
using (var db = new InventorySystemContext())
{
// Add CPU to database if item does not fail.
if (AddItem(_item))
{
// Get item ID
var item = db.Items.First(c => c.Name == _item.Name);
// Add Item to cpu
CPU cpu = _cpu;
cpu.Item = item;
db.CPUs.Add(_cpu);
db.SaveChanges();
}
else
{
// Returns false if name exists.
return(false);
}
}
}
catch (Exception e)
{
// Return false if failed.
return(false);
}
// Return true if successful.
return(true);
}
/// <summary>
/// Prints all Items.
/// </summary>
public void PrintAll()
{
using (var db = new InventorySystemContext())
{
var query = from i in db.Items
orderby i.Price
select i;
Console.WriteLine("____All Items____");
Console.WriteLine();
foreach (var item in query)
{
// Print ID
Console.WriteLine("ID: {0}", item.ID);
// Print Name
Console.WriteLine("Name: {0}", item.Name);
// Print Price
Console.WriteLine("Price: £{0}", item.Price);
// Quantity
Console.WriteLine("Quantity: {0}", item.Quantity);
Console.WriteLine();
Console.WriteLine();
}
}
}
public List <Item> GetItems()
{
using (var db = new InventorySystemContext())
{
return(db.Items.OrderBy(x => x.Name).ToList());
}
}
public bool AddItem(Item _item, Transaction _transaction)
{
try
{
// Using database context
using (var db = new InventorySystemContext())
{
// Get item ID
var item = db.Items.First(c => c.Name == _item.Name);
// Add Item to RAM
_transaction.Item = item;
db.Transactions.Add(_transaction);
db.SaveChanges();
}
}
catch (Exception e)
{
// Return false if failed.
return(false);
}
// Return true if successful.
return(true);
}
/// <summary>
/// Prints CPU Coolers.
/// </summary>
public void PrintMotherboards()
{
using (var db = new InventorySystemContext())
{
var query = from c in db.Motherboards
orderby c.ID
select c;
Console.WriteLine("____Motherboards____");
Console.WriteLine();
foreach (var motherboard in query)
{
Item temp = db.Items.First(i => i.ID == motherboard.ItemID);
// ID
Console.WriteLine("ID: {0}", temp.ID);
// Name
Console.WriteLine("Name: {0}", temp.Name);
// Socket
Console.WriteLine("Socket: {0}", motherboard.Socket);
// Form Factor
Console.WriteLine("Form Factor: {0}", motherboard.FormFactor);
// Socket
Console.WriteLine("Ram Slots: {0}", motherboard.RamSlots);
// Socket
Console.WriteLine("Max Ram: {0}", motherboard.MaxRam);
// Price
Console.WriteLine("Price: £{0}", temp.Price);
// Quantity
Console.WriteLine("Quantity: {0}", temp.Quantity);
Console.WriteLine();
Console.WriteLine();
}
}
}
/// <summary>
/// Prints CPU Coolers.
/// </summary>
public void PrintCPUCoolers()
{
using (var db = new InventorySystemContext())
{
var query = from c in db.CPUCoolers
orderby c.NoiseLevel
select c;
Console.WriteLine("____CPUCoolers____");
Console.WriteLine();
foreach (var cooler in query)
{
Item temp = db.Items.First(i => i.ID == cooler.ItemID);
// ID
Console.WriteLine("ID: {0}", temp.ID);
// Name
Console.WriteLine("Name: {0}", temp.Name);
// Speed
Console.WriteLine("Fan RPM: {0}", cooler.FanRPM);
// Cores
Console.WriteLine("Noise Level: {0}dB", cooler.NoiseLevel);
// Price
Console.WriteLine("Price: £{0}", temp.Price);
// Quantity
Console.WriteLine("Quantity: {0}", temp.Quantity);
Console.WriteLine();
Console.WriteLine();
}
}
}
/// <summary>
/// Prints GPUs.
/// </summary>
public void PrintGPUs()
{
using (var db = new InventorySystemContext())
{
var query = from c in db.GPUs
orderby c.ID
select c;
Console.WriteLine("____GPUs____");
Console.WriteLine();
foreach (var gpu in query)
{
Item temp = db.Items.First(i => i.ID == gpu.ItemID);
// ID
Console.WriteLine("ID: {0}", temp.ID);
// Name
Console.WriteLine("Name: {0}", temp.Name);
// Socket
Console.WriteLine("Series: {0}", gpu.Series);
// Form Factor
Console.WriteLine("Chipset: {0}", gpu.Chipset);
// Socket
Console.WriteLine("Memory: {0}", gpu.Memory);
// Socket
Console.WriteLine("CoreClock: {0} GHz", gpu.CoreClock);
// Price
Console.WriteLine("Price: £{0}", temp.Price);
// Quantity
Console.WriteLine("Quantity: {0}", temp.Quantity);
Console.WriteLine();
Console.WriteLine();
}
}
}
public bool EditItem(Item item, bool UpdateStock = true)
{
using (var db = new InventorySystemContext())
{
int change = 0;
var old = db.Items.First(i => i.ID == item.ID).Quantity;
change = item.Quantity - old;
if (change != 0 && UpdateStock)
{
Transaction transaction = new Transaction()
{
Change = change,
Item = item,
Reason = "Stock Updated",
Time = DateTime.Now
};
AddItem(item, transaction);
}
db.SaveChanges();
}
using (var db = new InventorySystemContext())
{
db.Entry(item).State = System.Data.Entity.EntityState.Modified;
//db.Items.Add(item);
db.SaveChanges();
}
return(true);
}
public void PrintCases()
{
using (var db = new InventorySystemContext())
{
var query = from c in db.Cases
orderby c.ID
select c;
Console.WriteLine("____Cases____");
Console.WriteLine();
foreach (var cases in query)
{
Item temp = db.Items.First(i => i.ID == cases.ItemID);
// ID
Console.WriteLine("ID: {0}", temp.ID);
// Name
Console.WriteLine("Name: {0}", temp.Name);
// Type
Console.WriteLine("Type: {0}", cases.Type);
// External 5" bays
Console.WriteLine("Ext. 5\" bays: {0}", cases.ExtFiveBays);
// Internal 5" bays
Console.WriteLine("Int. 3\" bays: {0}", cases.IntThreeBays);
// Price
Console.WriteLine("Price: £{0}", temp.Price);
// Quantity
Console.WriteLine("Quantity: {0}", temp.Quantity);
Console.WriteLine();
Console.WriteLine();
}
}
}
/// <summary>
/// Prints all CPUs
/// </summary>
public void PrintCPUs()
{
using (var db = new InventorySystemContext())
{
var query = from c in db.CPUs
orderby c.Power
select c;
Console.WriteLine("____CPUs____");
Console.WriteLine();
foreach (var cpu in query)
{
Item temp = db.Items.First(i => i.ID == cpu.ItemID);
// ID
Console.WriteLine("ID: {0}", temp.ID);
// Name
Console.WriteLine("Name: {0}", temp.Name);
// Speed
Console.WriteLine("Speed: {0}", cpu.Speed);
// Cores
Console.WriteLine("Cores: {0}", cpu.Cores);
// Power
Console.WriteLine("Power: {0}", cpu.Power);
// Price
Console.WriteLine("Price: £{0}", temp.Price);
// Quantity
Console.WriteLine("Quantity: {0}", temp.Quantity);
Console.WriteLine();
Console.WriteLine();
}
}
}
public bool ItemExists(string _name)
{
using (var db = new InventorySystemContext())
{
if (db.Items.Any(i => i.Name == _name))
{
return(true);
}
else
{
return(false);
}
}
}
public Item FindItem(int id)
{
using (var db = new InventorySystemContext())
{
try
{
var Item = db.Items.First(i => i.ID == id);
return(Item);
}
catch
{
return(null);
}
}
}
public List <Transaction> GetTransactions()
{
using (var db = new InventorySystemContext())
{
var transactions = db.Transactions.OrderByDescending(x => x.Time).ToList();
var items = GetItems();
foreach (var tran in transactions)
{
if (items.Exists(a => a.ID == tran.ItemID))
{
tran.Item = items.First(a => a.ID == tran.ItemID);
}
}
return(transactions.ToList());
}
}
public void PrintTransactions()
{
using (var db = new InventorySystemContext())
{
var query = from c in db.Transactions
orderby c.ID
select c;
Console.WriteLine("____TRANSACTIONS____");
Console.WriteLine();
foreach (var transaction in query)
{
Item item = db.Items.First(i => i.ID == transaction.ID);
Console.WriteLine("Name:{0}", item.Name);
Console.WriteLine("Change:{0}", transaction.Change);
Console.WriteLine("Time:{0}", transaction.Time.ToLongTimeString());
Console.WriteLine("Reason: {0}\n", transaction.Reason);
}
}
}
/// <summary>
/// Adds Item to database.
/// </summary>
/// <param name="_item">Item to Add.</param>
/// <returns>True if successful.</returns>
public bool AddItem(Item _item)
{
try
{
Item temp = _item;
// Using database context.
using (var db = new InventorySystemContext())
{
// Check if item exists first
if (db.Items.Any(i => i.Name == _item.Name))
{
return(false);
}
temp.ID = db.Items.Count();
// Add Item and save changes.
db.Items.Add(temp);
//db.SaveChanges();
//db.Transactions.Add(transaction);
db.SaveChanges();
}
Transaction transaction = new Transaction
{
Item = temp,
Change = temp.Quantity,
Time = DateTime.Now,
Reason = "Added Entry to Inventory"
};
AddItem(temp, transaction);
}
catch (Exception e)
{
// Return false if failed
return(false);
}
// Return true if successful
return(true);
}
public bool RemoveStock(Dictionary <int, int> keyValuePairs)
{
using (var db = new InventorySystemContext())
{
foreach (var pair in keyValuePairs)
{
Item item = FindItem(pair.Key);
item.Quantity -= pair.Value;
EditItem(item, false);
AddItem(item, new Transaction()
{
Change = -pair.Value,
Item = item,
Reason = "Sold to Customer",
Time = DateTime.Now
});
db.SaveChanges();
}
}
return(true);
}
public void PrintPSUs()
{
using (var db = new InventorySystemContext())
{
var query = from c in db.PSUs
orderby c.ID
select c;
Console.WriteLine("____PSUs____");
Console.WriteLine();
foreach (var psu in query)
{
Item temp = db.Items.First(i => i.ID == psu.ItemID);
// ID
Console.WriteLine("ID: {0}", temp.ID);
// Name
Console.WriteLine("Name: {0}", temp.Name);
// Series
Console.WriteLine("Series: {0}", psu.Series);
// Form
Console.WriteLine("Form: {0}", psu.Form);
// Efficiency
Console.WriteLine("Efficiency: {0}", psu.Efficiency);
// Watts
Console.WriteLine("Watts: {0}w", psu.Watts);
// Modular
Console.WriteLine("Modular: {0}", psu.Modular);
// Price
Console.WriteLine("Price: £{0}", temp.Price);
// Quantity
Console.WriteLine("Quantity: {0}", temp.Quantity);
Console.WriteLine();
Console.WriteLine();
}
}
}
public List <Item> FindItems(string type, string name)
{
using (var db = new InventorySystemContext())
{
List <Item> items = new List <Item>();
if (name != null)
{
items = db.Items.Where(i => i.Name.Contains(name)).ToList();
}
else
{
items = GetItems();
}
// Get component if required
if (type != null && type != "")
{
items = items.Where(i => i.Component.ToString() == type).ToList();
}
return(items.OrderBy(x => x.Name).ToList());
}
}
/// <summary>
/// Prints RAMs.
/// </summary>
public void PrintRAMs()
{
using (var db = new InventorySystemContext())
{
var query = from c in db.RAMs
orderby c.ID
select c;
Console.WriteLine("____RAMs____");
Console.WriteLine();
foreach (var ram in query)
{
Item temp = db.Items.First(i => i.ID == ram.ItemID);
// ID
Console.WriteLine("ID: {0}", temp.ID);
// Name
Console.WriteLine("Name: {0}", temp.Name);
// Speed
Console.WriteLine("Speed: {0}", ram.Speed);
// Type
Console.WriteLine("Type: {0}", ram.Type);
// CAS
Console.WriteLine("CAS: {0}", ram.CAS);
// Modules
Console.WriteLine("Modules: {0}", ram.Modules);
// Size
Console.WriteLine("Size: {0}", ram.Size);
// Price
Console.WriteLine("Price: £{0}", temp.Price);
// Quantity
Console.WriteLine("Quantity: {0}", temp.Quantity);
Console.WriteLine();
Console.WriteLine();
}
}
}
public bool DeleteItem(int _id, bool _record = true)
{
using (var db = new InventorySystemContext())
{
if (db.Items.Any(i => i.ID == _id))
{
Item item = db.Items.First(i => i.ID == _id);
// Check all lists and delete where necessary
switch (item.Component)
{
case (Model.Type.CASE):
db.Cases.Remove(db.Cases.First(c => c.ItemID == _id));
break;
case (Model.Type.CPU):
db.CPUs.Remove(db.CPUs.First(c => c.ItemID == _id));
break;
case (Model.Type.CPUCOOLER):
db.CPUCoolers.Remove(db.CPUCoolers.First(c => c.ItemID == _id));
break;
case (Model.Type.GPU):
db.GPUs.Remove(db.GPUs.First(c => c.ItemID == _id));
break;
case (Model.Type.MOTHERBOARD):
db.Motherboards.Remove(db.Motherboards.First(c => c.ItemID == _id));
break;
case (Model.Type.PSU):
db.PSUs.Remove(db.PSUs.First(c => c.ItemID == _id));
break;
case (Model.Type.RAM):
db.RAMs.Remove(db.RAMs.First(c => c.ItemID == _id));
break;
default:
return(false);
}
if (_record)
{
// Record transaction
Transaction transaction = new Transaction()
{
Item = item,
Change = -item.Quantity,
Time = DateTime.Now,
Reason = "Removed from Database."
};
if (!AddItem(item, transaction))
{
return(false);
}
}
// Remove item from database
db.Items.Remove(item);
// Save changes
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
public Dictionary <string, string> GetObject(int _id)
{
Dictionary <string, string> keyValuePairs = new Dictionary <string, string>();
using (var db = new InventorySystemContext())
{
if (db.Items.Any(i => i.ID == _id))
{
Item item = db.Items.First(i => i.ID == _id);
// Check all lists and delete where necessary
// Case
switch (item.Component)
{
case (Model.Type.CASE):
Case @case = db.Cases.First(c => c.ItemID == _id);
keyValuePairs.Add("Type", @case.Type.ToString());
keyValuePairs.Add("External 5 1/4\" bays", @case.ExtFiveBays.ToString());
keyValuePairs.Add("Internal 3 1/3\" bays", @case.IntThreeBays.ToString());
break;
case (Model.Type.CPU):
CPU cpu = db.CPUs.First(c => c.ItemID == _id);
keyValuePairs.Add("Power", cpu.Power.ToString() + " W");
keyValuePairs.Add("Speed", cpu.Speed.ToString() + " GHz");
break;
case (Model.Type.CPUCOOLER):
CPUCooler cpuCooler = db.CPUCoolers.First(c => c.ItemID == _id);
keyValuePairs.Add("Fan RPM", cpuCooler.FanRPM);
keyValuePairs.Add("Noise Level", cpuCooler.NoiseLevel.ToString() + " dB");
break;
case (Model.Type.GPU):
GPU gpu = db.GPUs.First(c => c.ItemID == _id);
keyValuePairs.Add("Series", gpu.Series);
keyValuePairs.Add("Chipset", gpu.Chipset);
keyValuePairs.Add("Memory", gpu.Memory);
keyValuePairs.Add("Core Clock", gpu.CoreClock.ToString() + " GHz");
break;
case (Model.Type.MOTHERBOARD):
Motherboard motherboard = db.Motherboards.First(c => c.ItemID == _id);
keyValuePairs.Add("Socket", motherboard.Socket);
keyValuePairs.Add("Form Factor", motherboard.FormFactor);
keyValuePairs.Add("RAM Slots", motherboard.RamSlots.ToString());
keyValuePairs.Add("Max RAM", motherboard.MaxRam);
break;
case (Model.Type.PSU):
PSU psu = db.PSUs.First(c => c.ItemID == _id);
keyValuePairs.Add("Series", psu.Series);
keyValuePairs.Add("Form", psu.Form);
keyValuePairs.Add("Efficiency", psu.Efficiency);
keyValuePairs.Add("Watts", psu.Watts.ToString() + " W");
keyValuePairs.Add("Modular", psu.Modular);
break;
case (Model.Type.RAM):
RAM ram = db.RAMs.First(c => c.ItemID == _id);
keyValuePairs.Add("Speed", ram.Speed);
keyValuePairs.Add("Type", ram.Type);
keyValuePairs.Add("CAS", ram.CAS.ToString());
keyValuePairs.Add("Modules", ram.Modules);
keyValuePairs.Add("Size", ram.Size);
break;
default:
return(keyValuePairs);
}
}
return(keyValuePairs);
}
}
