public List<Product> getAll()
{
try
{
var db = new DatabaseContext();
List<Product> products = db.Products.Select(item => new Product()
{
itemnumber = item.Id,
name = item.Name,
description = item.Description,
price = item.Price,
volum = item.Volum,
producer = item.Producers.Name,
country = item.Countries.Name,
}).ToList();
return products;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public List<Category> getAll(int? id)
{
try
{
var db = new DatabaseContext();
List<Category> category;
if (id == null)
{
category = db.Categories.Select(item => new Category()
{
ID = item.Id,
name = item.Name
}).ToList();
}
else
{
category = db.Categories.Select(item => new Category()
{
ID = item.Id,
name = item.Name
}).Where(item => item.ID == id).ToList();
}
return category;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public List<SubCategory> getAllSub(int? id)
{
try
{
var db = new DatabaseContext();
List<SubCategories> subcat;
if (id != null)
{
subcat = db.SubCategories.Include("Categories").Where(p => p.Id == id).ToList();
}
else
subcat = db.SubCategories.Include("Categories").ToList();
var list = new List<SubCategory>();
foreach (var item in subcat)
{
list.Add(new SubCategory()
{
ID = item.Id,
name = item.Name,
catName = item.Categories.Name
});
}
return list;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public List<Customer> getAll()
{
try
{
var db = new DatabaseContext();
List<Customer> customers = db.Customers.Select(item => new Customer()
{
id = item.Id,
firstname = item.Firstname,
lastname = item.Lastname,
address = item.Address,
email = item.Email,
postalcode = item.PostalareasId.ToString(),
postalarea = item.Postalareas.Postalarea,
phonenumber = item.Phonenumber,
admin = item.Admin
}).ToList();
foreach (var i in customers)
{
i.postalcode = normalizePostalcode(int.Parse(i.postalcode));
}
return customers;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public List<Customer> getResult(string searchString)
{
try
{
var db = new DatabaseContext();
List<Customer> users = db.Customers.Select(p => new Customer()
{
id = p.Id,
firstname = p.Firstname,
lastname = p.Lastname,
address = p.Address,
email = p.Email,
postalcode = p.PostalareasId.ToString(),
postalarea = p.Postalareas.Postalarea,
phonenumber = p.Phonenumber
}).Where(p => p.firstname.ToUpper().Contains(searchString.ToUpper())
|| p.lastname.ToUpper().Contains(searchString.ToUpper())).ToList();
foreach (var u in users)
{
u.postalcode = normalizePostalcode(int.Parse(u.postalcode));
}
return users;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public List<Order> getAllOrders(int? id)
{
try
{
var db = new DatabaseContext();
List<Order> lines;
if (id != null)
lines = db.Orders.Select(item => new Order()
{
id = item.Id,
orderdate = item.OrderDate,
customerid = item.CustomersId
}).Where(item => item.id == id).ToList();
else
lines = db.Orders.Select(item => new Order()
{
id = item.Id,
orderdate = item.OrderDate,
customerid = item.CustomersId
}).ToList();
return lines;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public Customer getCustomer(int id)
{
try
{
var db = new DatabaseContext();
Customers cust = (Customers)db.Customers.FirstOrDefault(c => c.Id == id);
Customer customer = new Customer();
customer.id = cust.Id;
customer.firstname = cust.Firstname;
customer.lastname = cust.Lastname;
customer.phonenumber = cust.Phonenumber;
customer.email = cust.Email;
customer.address = cust.Address;
customer.hashpassword = cust.Password;
customer.admin = cust.Admin;
customer.postalarea = getPostalarea(cust.PostalareasId);
customer.postalcode = normalizePostalcode(cust.PostalareasId);
return customer;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public List<Category> getAllCategories()
{
try
{
var db = new DatabaseContext();
List<Category> categories = db.Categories.Select(item => new Category()
{
ID = item.Id,
name = item.Name
}).ToList();
return categories;
}
catch (Exception e)
{
writeToFile(e);
return null;
}
}
public List<Producer> getAllProducers(int? id)
{
try
{
var db = new DatabaseContext();
List<Producer> producers = db.Producers.Select(item => new Producer()
{
id = item.Id,
name = item.Name
}).ToList();
return producers;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public List<SubCategory> getAllSubCategories()
{
try
{
var db = new DatabaseContext();
List<SubCategory> subCategories = db.SubCategories.Select(item => new SubCategory()
{
ID = item.Id,
name = item.Name,
catName = item.Categories.Name,
catId = item.CategoriesId
}).ToList();
return subCategories;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public List<OrderLine> getAllOrderLinesOfOrder(int id)
{
try
{
var db = new DatabaseContext();
List<OrderLine> lines = db.OrderLines.Select(item => new OrderLine()
{
id = item.Id,
orderid = item.OrdersId,
productid = item.ProductsId,
quantity = item.Quantity,
}).Where(item => item.orderid == id).ToList();
return lines;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public bool deleteProduct(int id, int adminid)
{
var db = new DatabaseContext();
Products c = db.Products.FirstOrDefault(ca => ca.Id == id);
db.Products.Remove(c);
try
{
db.SaveChanges(adminid);
}
catch (DbUpdateException ue)
{
writeToFile(ue);
return false;
}
catch (Exception e)
{
writeToFile(e);
return false;
}
return true;
}
public bool validate(String email, byte[] hashedPassword)
{
try
{
var db = new DatabaseContext();
Customers userFound = db.Customers.FirstOrDefault(u => u.Email == email);
if (userFound != null)
{
if (email.Equals(userFound.Email) && Enumerable.SequenceEqual(hashedPassword, userFound.Password))
{
if (userFound.Admin == true)
{
return true;
}
}
}
}
catch(Exception e)
{
writeToFile(e);
}
return false;
}
public String getPostalarea(int id)
{
try
{
var db = new DatabaseContext();
var postalarea = (Postalareas)db.Postalareas.FirstOrDefault(p => p.PostalareasId == id);
return postalarea.Postalarea;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public Customer findUser(String email)
{
try
{
var db = new DatabaseContext();
Customers userFound = db.Customers.FirstOrDefault(u => u.Email == email);
Customer c = new Customer();
c.id = userFound.Id;
c.firstname = userFound.Firstname;
c.lastname = userFound.Lastname;
c.email = userFound.Email;
c.phonenumber = userFound.Phonenumber;
c.postalcode = normalizePostalcode(userFound.PostalareasId);
c.postalarea = db.Postalareas.Find(userFound.PostalareasId).Postalarea;
c.address = userFound.Address;
c.hashpassword = userFound.Password;
c.admin = true;
return c;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public SubCategory SubCatDetails(int id)
{
try
{
var db = new DatabaseContext();
SubCategories subcat = (SubCategories)db.SubCategories.FirstOrDefault(c => c.Id == id);
SubCategory subcategory = new SubCategory()
{
ID = subcat.Id,
name = subcat.Name,
catId = subcat.CategoriesId
};
return subcategory;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public bool Add(Category category, int adminId)
{
var newCategory = new Categories()
{
Name = category.name
};
try
{
var db = new DatabaseContext();
db.Categories.Add(newCategory);
db.SaveChanges(adminId);
return true;
}
catch (Exception failed)
{
writeToFile(failed);
return false;
}
}
public bool updateProducer(int id, Producer p, int adminid)
{
var db = new DatabaseContext();
try
{
Producers prod = db.Producers.FirstOrDefault(pr => pr.Id == id);
prod.Id = id;
prod.Name = p.name;
db.SaveChanges(adminid);
return true;
}
catch (Exception e)
{
writeToFile(e);
return false;
}
}
public List<Producer> getProducers()
{
try
{
var db = new DatabaseContext();
List<Producer> list = db.Producers.Select(p => new Producer()
{
id = p.Id,
name = p.Name
}).ToList();
return list;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public List<SubCategory> deleteCategory(int id, int adminid)
{
var db = new DatabaseContext();
Categories c = db.Categories.FirstOrDefault(ca => ca.Id == id);
db.Categories.Remove(c);
try
{
db.SaveChanges(adminid);
}
catch (DbUpdateException ue)
{
writeToFile(ue);
try
{
return db.SubCategories.Where(sc => sc.CategoriesId == id).Select(p => new SubCategory()
{
name = p.Name
}).ToList();
}
catch(Exception e)
{
writeToFile(e);
}
}
catch( Exception e)
{
writeToFile(e);
}
return null;
}
public List<Product> deleteProducer(int id, int adminid)
{
var db = new DatabaseContext();
Producers c = db.Producers.FirstOrDefault(ca => ca.Id == id);
db.Producers.Remove(c);
try
{
db.SaveChanges(adminid);
}
catch (DbUpdateException ue)
{
writeToFile(ue);
try
{
return db.Products.Where(sc => sc.ProducersId == id).Select(p => new Product()
{
name = p.Name
}).ToList();
}
catch (Exception e)
{
writeToFile(e);
}
}
catch (Exception e)
{
writeToFile(e);
}
return null;
}
public List<Country> getCountries()
{
try
{
var db = new DatabaseContext();
List<Country> list = db.Countries.Select(item => new Country()
{
id = item.Id,
name = item.Name
}).ToList();
return list;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}
public bool update(int id, SubCategory sc)
{
var db = new DatabaseContext();
SubCategories existing = db.SubCategories.FirstOrDefault(u => u.Id == sc.ID);
try
{
existing.Name = sc.name;
existing.CategoriesId = sc.catId;
db.SaveChanges(id);
}
catch (Exception e)
{
writeToFile(e);
return false;
}
return true;
}
public Producer producerDetails(int id)
{
try
{
var db = new DatabaseContext();
Producers produser = (Producers)db.Producers.FirstOrDefault(c => c.Id == id);
Producer prod = new Producer()
{
id = produser.Id,
name = produser.Name
};
return prod;
}
catch (Exception e)
{
writeToFile(e);
return null;
}
}
public bool delete(int id, int adminid)
{
var db = new DatabaseContext();
try
{
Customers cust = db.Customers.FirstOrDefault(u => u.Id == id);
db.Customers.Remove(cust);
db.SaveChanges(adminid);
return true;
}
catch (Exception e)
{
writeToFile(e);
return false;
}
}
public bool AddProducer(Producer producer, int id)
{
var newProducer = new Producers()
{
Name = producer.name
};
try
{
var db = new DatabaseContext();
db.Producers.Add(newProducer);
db.SaveChanges(id);
return true;
}
catch (Exception fail)
{
writeToFile(fail);
return false;
}
}
public bool update(int id, Customer updateUser, int adminid)
{
var db = new DatabaseContext();
try
{
Customers cust = db.Customers.FirstOrDefault(u => u.Id == id);
cust.Firstname = updateUser.firstname;
cust.Lastname = updateUser.lastname;
cust.Email = updateUser.email;
cust.Phonenumber = updateUser.phonenumber;
cust.Address = updateUser.address;
cust.PostalareasId = Convert.ToInt16(updateUser.postalcode);
var existPostalcode = db.Postalareas.Find(Convert.ToInt16(updateUser.postalcode));
if (existPostalcode == null)
{
var newPostalarea = new Postalareas()
{
PostalareasId = Convert.ToInt16(updateUser.postalcode),
Postalarea = updateUser.postalarea
};
cust.Postalareas = newPostalarea;
}
db.SaveChanges(adminid);
return true;
}
catch (Exception e)
{
writeToFile(e);
return false;
}
}
public bool AddSub(int adminId, SubCategory sc)
{
var db = new DatabaseContext();
db.SubCategories.Add(new SubCategories()
{
Name = sc.name,
CategoriesId = sc.catId
});
try
{
db.SaveChanges(adminId);
}
catch(Exception e)
{
writeToFile(e);
return false;
}
return true;
}
public bool updateCategory(int id, Category c, int adminid)
{
var db = new DatabaseContext();
try
{
Categories cat = db.Categories.FirstOrDefault(ca => ca.Id == id);
cat.Name = c.name;
db.SaveChanges(adminid);
return true;
}
catch(Exception e)
{
writeToFile(e);
return false;
}
}
public List<Product> getResult(string searchString)
{
try
{
var db = new DatabaseContext();
List<Product> products = db.Products.Select(p => new Product()
{
itemnumber = p.Id,
name = p.Name,
description = p.Description,
price = p.Price,
volum = p.Volum,
producer = p.Producers.Name,
category = p.SubCategories.Categories.Name,
categoryid = p.SubCategories.Categories.Id,
subCategory = p.SubCategories.Name,
subCategoryid = p.SubCategories.Id,
country = p.Countries.Name
}).Where(p => p.name.ToUpper().Contains(searchString.ToUpper())
|| p.description.ToUpper().Contains(searchString.ToUpper())).ToList();
return products;
}
catch(Exception e)
{
writeToFile(e);
return null;
}
}