public List <ClientOrder> listOrder()
{
List <ClientOrder> list = new List <ClientOrder>();
using (DB_Project db = new DB_Project())
{
var listDB = (from ClientOrder in db.ClientOrder
where !(ClientOrder.OrderState == "committed" || ClientOrder.OrderState == "canceled")
orderby(ClientOrder.DateHourIn) descending
select ClientOrder).Take(10);
foreach (var item in listDB)
{
list.Add(new ClientOrder()
{
OrderCode = item.OrderCode,
OrderState = item.OrderState,
TotalPrice = item.TotalPrice,
DateHourIn = item.DateHourIn,
DeliveryAddress = item.DeliveryAddress,
ClientEmail = item.ClientEmail
});
}
foreach (ClientOrder item in list)
{
item.listOrders = (from OrderDetail in db.OrderDetail
where OrderDetail.OrderCode == item.OrderCode
select OrderDetail).ToList();
}
}
return(list);
}
public void AddOrderDetail(OrderDetail orderDetail)
{
using (DB_Project db = new DB_Project())
{
db.OrderDetail.Add(orderDetail);
db.SaveChanges();
}
}
public SystemUser ChargeUser(String name)
{
using (DB_Project db = new DB_Project())
{
var user = db.SystemUser.Find(name);
return(user);
}
}
public Dish ChargeDish(int code)
{
using (DB_Project db = new DB_Project())
{
var dish = db.Dish.Find(code);
return(dish);
}
}
public List <Dish> ChargeRelatedDish(string word)
{
using (DB_Project db = new DB_Project())
{
IQueryable <Dish> results = from dish in db.Dish where (dish.DishName == word || dish.DishDescription.Contains(word)) select dish;
List <Dish> list = results.ToList();
return(list);
}
}
public List <Dish> DishesList()
{
List <Dish> listDish = new List <Dish>();
using (DB_Project db = new DB_Project())
{
listDish = db.Dish.ToList();
}
return(listDish);
}
public Client ChargeClient(String email)
{
using (DB_Project db = new DB_Project())
{
var client = db.Client.Find(email);
var Address = db.Address.Find(email);
//client.ClientAddress = Address.PhysicalAddress;
return(client);
}
}
public List <Client> ClientList()
{
List <Client> Clientes = new List <Client>();
using (DB_Project db = new DB_Project())
{
Clientes = db.Client.ToList();
}
return(Clientes);
}
public List <SystemUser> UserList()
{
List <SystemUser> systemUser = new List <SystemUser>();
using (DB_Project db = new DB_Project())
{
systemUser = db.SystemUser.ToList();
}
return(systemUser);
}
public bool checkNameUser(string name)
{
using (DB_Project db = new DB_Project())
{
var user = db.SystemUser.Find(name);
if (user == null)
{
return(true);
}
}
return(false);
}
public void DeleteClient(String email)
{
using (DB_Project db = new DB_Project())
{
var client = db.Client.Find(email);
if (client != null)
{
db.Client.Attach(client);
db.Client.Remove(client);
db.SaveChanges();
}
}
}
public void DeleteUser(String name)
{
using (DB_Project db = new DB_Project())
{
var user = db.SystemUser.Find(name);
if (user != null)
{
db.SystemUser.Attach(user);
db.SystemUser.Remove(user);
db.SaveChanges();
}
}
}
public void DeleteDish(int code)
{
using (DB_Project db = new DB_Project())
{
Dish dish = db.Dish.Find(code);
if (dish != null)
{
db.Dish.Attach(dish);
db.Dish.Remove(dish);
db.SaveChanges();
}
}
}
public void addUser(SystemUser user)
{
try
{
using (DB_Project db = new DB_Project())
{
db.SystemUser.Add(user);
db.SaveChanges();
}
}
catch
{
}
}
public void addDish(Dish dish)
{
try
{
using (DB_Project db = new DB_Project())
{
db.Dish.Add(dish);
db.SaveChanges();
}
}
catch
{
}
}
public void addClient(Client client, Address address)
{
try
{
using (DB_Project db = new DB_Project())
{
db.Client.Add(client);
db.Address.Add(address);
db.SaveChanges();
}
}
catch
{
}
}
public void ChangeStateOrder(int OrderCode, string state)
{
using (DB_Project db = new DB_Project())
{
ClientOrder client = db.ClientOrder.Find(OrderCode);
if (client != null)
{
client.OrderState = state;
if (state == "committed")
{
client.DateHourOut = DateTime.Now;
}
db.SaveChanges();
}
}
}
public int AddOrder(ClientOrder order)
{
int orderCode = 0;
using (DB_Project db = new DB_Project())
{
db.ClientOrder.Add(order);
db.SaveChanges();
ClientOrder orderFound = (from dbOrder in db.ClientOrder
where dbOrder.ClientEmail == order.ClientEmail
orderby dbOrder.OrderCode descending
select dbOrder).First();
orderCode = orderFound.OrderCode;
}
return(orderCode);
}
public void updateStateClient(Client client)
{
try
{
using (DB_Project db = new DB_Project())
{
Client cliente = db.Client.Find(client.ClientEmail);
if (client != null)
{
cliente.ClientAvailable = client.ClientAvailable;
db.SaveChanges();
}
}
}
catch
{
}
}
public void updateUser(SystemUser systemUser)
{
try
{
using (DB_Project db = new DB_Project())
{
SystemUser User = db.SystemUser.Find(systemUser.SystemUserName);
if (User != null)
{
User.SystemUserPassword = systemUser.SystemUserPassword;
User.SystemUserRole = systemUser.SystemUserRole;
db.SaveChanges();
}
}
}
catch
{
}
}
public void updateDish(Dish dish)
{
try
{
using (DB_Project db = new DB_Project())
{
Dish dis = db.Dish.Find(dish.DishCode);
if (dis != null)
{
dis.DishName = dish.DishName;
dis.DishDescription = dish.DishDescription;
dis.DishPrice = dish.DishPrice;
dis.DishAvailable = dish.DishAvailable;
dis.DishPhoto = dish.DishPhoto;
db.SaveChanges();
}
}
}
catch
{
}
}
public Client UserLoginValidation(Client client)
{
using (DB_Project db = new DB_Project())
{
Client clientFound = db.Client.Find(client.ClientEmail);
if (clientFound == null)
{
return(null);
}
else
{
if (clientFound.ClientPassword != client.ClientPassword)
{
return(null);
}
else
{
return(clientFound);
}
}
}
}
public String checkUserCredentials(SystemUser su)
{
String result = "";
SystemUser suFound = null;
using (DB_Project db = new DB_Project())
{
suFound = db.SystemUser.Find(su.SystemUserName);
if (suFound != null)
{
if (suFound.SystemUserPassword.Equals(su.SystemUserPassword))
{
if (suFound.SystemUserRole.Equals(su.SystemUserRole))
{
result = "Correct";
}
else
{
result = "IncorrectRole";
}
}
else
{
result = "IncorrectPassword";
}
}
else
{
result = "IncorrectUserName";
}
}
return(result);
}
