private void ParseAndAddItemsToList(List <XElement> items, Store store)
{
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
foreach (XElement xmlItem in items)
{
try
{
Item item = new Item(xmlItem.Element("ItemName").Value.ToString());
item.Price = xmlItem.Element("ItemPrice").Value.ToString();
item.Code = xmlItem.Element("ItemCode").Value.ToString();
item.Type = xmlItem.Element("ItemType").Value.ToString();
item.Quantity = xmlItem.Element("Quantity").Value.ToString();
item.UnitOfMeasure = xmlItem.Element("UnitOfMeasure").Value.ToString();
item.StoreId = store.Id;
item.StoreId = dataAccess.GetStoreId(store);
itemsDB.Add(item);
}
catch (FormatException)
{
}
catch (OverflowException)
{
}
}
}
public void Parse()
{
itemsDB = new List<Item>();
foreach (string currentDirectory in Directory.GetDirectories(path))
{
StoresDocument storesDocument = GetDataStoresFile(currentDirectory);
foreach (string currentFile in Directory.GetFiles(currentDirectory))
{
if (!currentFile.Contains(@"\Stores"))
{
XDocument xmlDoc = XDocument.Load(currentFile);
Store store = AddStoreToDB(xmlDoc, storesDocument);
if (store != null)
{
var items = xmlDoc.Descendants("item").ToList();
if (items.Count == 0)
{
items = xmlDoc.Descendants("Item").ToList();
}
if (items != null)
{
ParseAndAddItemsToList(items, store);
}
}
}
}
}
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
dataAccess.AddItems(itemsDB);
}
public void Parse()
{
itemsDB = new List <Item>();
foreach (string currentDirectory in Directory.GetDirectories(path))
{
StoresDocument storesDocument = GetDataStoresFile(currentDirectory);
foreach (string currentFile in Directory.GetFiles(currentDirectory))
{
if (!currentFile.Contains(@"\Stores"))
{
XDocument xmlDoc = XDocument.Load(currentFile);
Store store = AddStoreToDB(xmlDoc, storesDocument);
if (store != null)
{
var items = xmlDoc.Descendants("item").ToList();
if (items.Count == 0)
{
items = xmlDoc.Descendants("Item").ToList();
}
if (items != null)
{
ParseAndAddItemsToList(items, store);
}
}
}
}
}
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
dataAccess.AddItems(itemsDB);
}
public User Login(string name, string password)
{
if (((!String.IsNullOrEmpty(name)) && (!String.IsNullOrEmpty(password))))
{
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
List <User> users = dataAccess.GetAllUsers().Where(user => user.Name.Equals(name) && user.Password.Equals(password)).ToList();
if (users.Count == 1)
{
return(users.First());
}
}
return(null);
}
public User AddUser(string name, string password)
{
if (((!String.IsNullOrEmpty(name)) && (!String.IsNullOrEmpty(password))))
{
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
List <User> users = dataAccess.GetAllUsers().Where(user => user.Name.Equals(name)).ToList();
if (users.Count == 0)
{
User newUser = new User(name, password);
dataAccess.AddUser(newUser);
return(newUser);
}
}
return(null);
}
public User AddUser(string name, string password)
{
if (((!String.IsNullOrEmpty(name)) && (!String.IsNullOrEmpty(password))))
{
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
List<User> users = dataAccess.GetAllUsers().Where(user => user.Name.Equals(name)).ToList();
if (users.Count == 0)
{
User newUser = new User(name, password);
dataAccess.AddUser(newUser);
return newUser;
}
}
return null;
}
private Store AddStoreToDB(XDocument xmlDoc, StoresDocument storesDocument)
{
Store store = null;
if(storesDocument != null)
{
string storeId = xmlDoc.Element("Root").Element("StoreId").Value.ToString();
string name = storesDocument.Stores[storeId];
if (name != null)
{
store = new Store(name);
store.ChainStoreName = storesDocument.ChainStoresName;
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
dataAccess.AddStore(store);
}
}
return store;
}
private Store AddStoreToDB(XDocument xmlDoc, StoresDocument storesDocument)
{
Store store = null;
if (storesDocument != null)
{
string storeId = xmlDoc.Element("Root").Element("StoreId").Value.ToString();
string name = storesDocument.Stores[storeId];
if (name != null)
{
store = new Store(name);
store.ChainStoreName = storesDocument.ChainStoresName;
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
dataAccess.AddStore(store);
}
}
return(store);
}
private void ParseAndAddItemsToList(List<XElement> items, Store store)
{
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
foreach (XElement xmlItem in items)
{
try
{
Item item = new Item(xmlItem.Element("ItemName").Value.ToString());
item.Price = xmlItem.Element("ItemPrice").Value.ToString();
item.Code = xmlItem.Element("ItemCode").Value.ToString();
item.Type = xmlItem.Element("ItemType").Value.ToString();
item.Quantity = xmlItem.Element("Quantity").Value.ToString();
item.UnitOfMeasure = xmlItem.Element("UnitOfMeasure").Value.ToString();
item.StoreId = store.Id;
item.StoreId = dataAccess.GetStoreId(store);
itemsDB.Add(item);
}
catch(FormatException)
{
}
catch(OverflowException)
{
}
}
}
public List <Item> GetItemsByStoreId(long storeId)
{
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
return(dataAccess.GetItemsByStoreId(storeId));
}
public List <Store> GetAllStores()
{
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
return(dataAccess.GetAllStores());
}
public User Login(string name, string password)
{
if(((!String.IsNullOrEmpty(name)) && (!String.IsNullOrEmpty(password))))
{
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
List<User> users = dataAccess.GetAllUsers().Where(user => user.Name.Equals(name) && user.Password.Equals(password)).ToList();
if (users.Count == 1)
{
return users.First();
}
}
return null;
}
public List<Item> GetItemsByStoreId(long storeId)
{
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
return dataAccess.GetItemsByStoreId(storeId);
}
public List<Store> GetAllStores()
{
PriceCompareDataAccess dataAccess = new PriceCompareDataAccess();
return dataAccess.GetAllStores();
}
