public string Insertar(Recipe recipe)
{
int result;
try
{
using (var context = new ProyectoMaestriaEntities())
{
var repetido = context.Recipe.SingleOrDefault(x => x.Code == recipe.Code);
if (repetido == null)
{
var std = new Recipe()
{
// ID = comedor.ID,
Code = recipe.Code,
Name = recipe.Name
};
context.Recipe.Add(std);
result = context.SaveChanges();
if (result == 0)
{
return("no se ha podido ingresar el registro");
}
else
{
return(std.ID.ToString());
}
}
else
{
return("el registro ya se encuentra en la base de datos");
}
}
}
catch (Exception e)
{
return(e.Message);
}
}
public List <Recipe> GetRecomendedRecipes(int countChildren)
{
List <Recipe> recipes = new List <Recipe>();
using (var context = new ProyectoMaestriaEntities())
{
var result = (
from R in context.Recipe
join I in context.Ingredient on R.ID equals I.IDRecipe
join D in context.Disponibility on I.IDProduct equals D.IDProduct
where D.Quantity >= countChildren
group R by new { R.Code, R.ID, R.Name } into g
select new
{
ID = g.Key.ID,
Code = g.Key.Code,
Name = g.Key.Name,
}).ToList();
if (result != null)
{
foreach (var temp in result)
{
Recipe recipe = new Recipe();
recipe.ID = temp.ID;
recipe.Code = temp.Code;
recipe.Name = temp.Name;
recipes.Add(recipe);
}
return(recipes);
}
else
{
return(recipes);
}
}
}
public Transport Extract(string code)
{
using (var context = new ProyectoMaestriaEntities())
{
// Query for all blogs with names starting with B
//var ComedorExtracted = from b in context.Comedor
// where b.ID.Equals(id)
// select b;
var transport = context.Transport.SingleOrDefault(x => x.Code == code);
if (transport != null)
{
return(new Transport
{
ID = transport.ID,
Code = transport.Code,
CarPlate = transport.CarPlate,
Brand = transport.Brand,
Year = transport.Year,
PersonInCharge = transport.PersonInCharge,
PhonePersonInCharge = transport.PhonePersonInCharge,
MailPersonInCharge = transport.MailPersonInCharge,
PaymentUnity = transport.PaymentUnity,
PaymentMeasurement = transport.PaymentMeasurement,
PaymentValue = transport.PaymentValue,
Availability = transport.Availability,
TransportType = transport.TransportType,
IDProvider = transport.IDProvider
});
}
else
{
return(null);
}
//// Query for the Blog named ADO.NET Blog
//var blog = context.Blogs
// .Where(b => b.Name == "ADO.NET Blog")
// .FirstOrDefault();
}
}
public string Update(Recipe producto)
{
int modify = 0;
try
{
using (var context = new ProyectoMaestriaEntities())
{
var result = context.Recipe.SingleOrDefault(b => b.ID == producto.ID);
if (result != null)
{
result.Code = producto.Code;
result.Name = producto.Name;
// result.Disponibility = producto.Disponibility;
modify = context.SaveChanges();
if (modify == 0)
{
return("no se ha podido modificar el registro");
}
else
{
return("se ha modificado el registro satisfactoriamente");
}
}
else
{
return("no se ha encontrado coincidencia en la base de datos");
}
}
}
catch (Exception e)
{
return(e.Message);
}
}
public List <Provider> ExtractAllProviders()
{
List <Provider> Providers = new List <Provider>();
using (var context = new ProyectoMaestriaEntities())
{
var result = context.Provider.ToList();
if (result != null)
{
foreach (var temp in result)
{
Provider provider = new Provider();
provider.ID = temp.ID;
provider.Code = temp.Code;
provider.Name = temp.Name;
provider.Address = temp.Address;
provider.Neiborhood = temp.Neiborhood;
provider.City = temp.City;
provider.Phone = temp.Phone;
provider.Contact = temp.Contact;
provider.ContactMail = temp.ContactMail;
provider.ContactPhone = temp.ContactPhone;
provider.EnterpriseMail = temp.EnterpriseMail;
provider.NIT = temp.NIT;
provider.Type = temp.Type;
Providers.Add(provider);
}
return(Providers);
}
else
{
return(Providers);
}
}
}
public Provider ExtractById(long?code)
{
using (var context = new ProyectoMaestriaEntities())
{
// Query for all blogs with names starting with B
//var ComedorExtracted = from b in context.Comedor
// where b.ID.Equals(id)
// select b;
var proveedor = context.Provider.SingleOrDefault(x => x.ID == code);
if (proveedor != null)
{
return(new Provider
{
// public long ID { get; set; }
ID = proveedor.ID,
Code = proveedor.Code,
Name = proveedor.Name,
Address = proveedor.Address,
Neiborhood = proveedor.Neiborhood,
City = proveedor.City,
Phone = proveedor.Phone,
Contact = proveedor.Contact,
ContactPhone = proveedor.ContactPhone,
ContactMail = proveedor.ContactMail,
EnterpriseMail = proveedor.EnterpriseMail,
NIT = proveedor.NIT,
Type = proveedor.Type
});
}
else
{
return(null);
}
//// Query for the Blog named ADO.NET Blog
//var blog = context.Blogs
// .Where(b => b.Name == "ADO.NET Blog")
// .FirstOrDefault();
}
}
public List <Transport> ExtractAll()
{
List <Transport> transports = new List <Transport>();
using (var context = new ProyectoMaestriaEntities())
{
var result = context.Transport.ToList();
if (result != null)
{
foreach (var temp in result)
{
Transport transport = new Transport();
transport.ID = temp.ID;
transport.Code = temp.Code;
transport.CarPlate = temp.CarPlate;
transport.Brand = temp.Brand;
transport.Year = temp.Year;
transport.PersonInCharge = temp.PersonInCharge;
transport.PhonePersonInCharge = temp.PhonePersonInCharge;
transport.MailPersonInCharge = temp.MailPersonInCharge;
transport.PaymentUnity = temp.PaymentUnity;
transport.PaymentMeasurement = temp.PaymentMeasurement;
transport.PaymentValue = temp.PaymentValue;
transport.Availability = temp.Availability;
transport.TransportType = temp.TransportType;
transport.IDProvider = temp.IDProvider;
transports.Add(transport);
}
return(transports);
}
else
{
return(transports);
}
}
}
public string Update(Disponibility disponibility)
{
int modify = 0;
try
{
using (var context = new ProyectoMaestriaEntities())
{
var result = context.Disponibility.SingleOrDefault(b => b.ID == disponibility.ID);
if (result != null)
{
result.IDProvider = disponibility.IDProvider;
result.Quantity = disponibility.Quantity;
result.UnitValue = disponibility.UnitValue;
result.IDProduct = disponibility.IDProduct;
result.ExpirationDate = disponibility.ExpirationDate;
modify = context.SaveChanges();
if (modify == 0)
{
return("no se ha podido modificar el registro");
}
else
{
return("se ha modificado el registro satisfactoriamente");
}
}
else
{
return("no se ha encontrado coincidencia en la base de datos");
}
}
}
catch (Exception e)
{
return(e.Message);
}
}
public DiningRoom GetComedorByID(long id)
{
using (var context = new ProyectoMaestriaEntities())
{
// Query for all blogs with names starting with B
//var ComedorExtracted = from b in context.Comedor
// where b.ID.Equals(id)
// select b;
var comedor = context.DiningRoom.SingleOrDefault(x => x.ID == id);
if (comedor != null)
{
return(new DiningRoom
{
ID = comedor.ID,
Code = comedor.Code,
Name = comedor.Name,
Address = comedor.Address,
Phone = comedor.Phone,
Email = comedor.Email,
Neiborhood = comedor.Neiborhood,
City = comedor.City,
Contact = comedor.Contact,
ContactEmail = comedor.ContactEmail,
ContactPhone = comedor.ContactPhone,
ChildNumber = comedor.ChildNumber,
ScheduleReception = comedor.ScheduleReception
});
}
else
{
return(null);
}
//// Query for the Blog named ADO.NET Blog
//var blog = context.Blogs
// .Where(b => b.Name == "ADO.NET Blog")
// .FirstOrDefault();
}
}
public List <DiningRoom> GettAllDinners()
{
List <DiningRoom> diningRooms = new List <DiningRoom>();
using (var context = new ProyectoMaestriaEntities())
{
var result = context.DiningRoom.ToList();
if (result != null)
{
foreach (var temp in result)
{
DiningRoom diningRoom = new DiningRoom();
diningRoom.ID = temp.ID;
diningRoom.Code = temp.Code;
diningRoom.Name = temp.Name;
diningRoom.Address = temp.Address;
diningRoom.Phone = temp.Phone;
diningRoom.Email = temp.Email;
diningRoom.Neiborhood = temp.Neiborhood;
diningRoom.City = temp.City;
diningRoom.Contact = temp.Contact;
diningRoom.ContactEmail = temp.ContactEmail;
diningRoom.ContactPhone = temp.ContactPhone;
diningRoom.ChildNumber = temp.ChildNumber;
diningRoom.ScheduleReception = temp.ScheduleReception;
diningRooms.Add(diningRoom);
}
return(diningRooms);
}
else
{
return(diningRooms);
}
}
}
public List <SystemUser> GetAll()
{
List <SystemUser> transports = new List <SystemUser>();
using (var context = new ProyectoMaestriaEntities())
{
var result = context.SystemUser.ToList();
if (result != null)
{
foreach (var temp in result)
{
//result.Password = systemuser.Password;
//result.Name = systemuser.Name;
//result.LastName = systemuser.LastName;
//result.UserType = systemuser.UserType;
//result.ProviderID = systemuser.ProviderID;
SystemUser systemuser = new SystemUser();
systemuser.ID = temp.ID;
systemuser.Username = temp.Username;
systemuser.Name = temp.Name;
systemuser.LastName = temp.LastName;
systemuser.UserType = temp.UserType;
systemuser.ProviderID = temp.ProviderID;
transports.Add(systemuser);
}
return(transports);
}
else
{
return(transports);
}
}
}
public string InsertList(List <PreOrderItem> items)
{
int result = 0;
try
{
using (var context = new ProyectoMaestriaEntities())
{
foreach (PreOrderItem poi in items)
{
var std = new PreOrderItem
{
// ID=poi.ID,
IDProduct = poi.IDProduct,
IDPreOrder = poi.IDPreOrder,
Quantity = poi.Quantity
};
context.PreOrderItem.Add(std);
result = context.SaveChanges();
if (result == 0)
{
return("no se ha podido ingresar el registro");
}
else
{
result = int.Parse(std.ID.ToString());
}
}
return(result.ToString());
}
}
catch (Exception e)
{
return(e.Message);
}
}
public string InsertarPreorder(PreOrder preorder)
{
int result;
try
{
using (var context = new ProyectoMaestriaEntities())
{
if (preorder.PreOrderDate == null)
{
preorder.PreOrderDate = DateTime.Now;
}
var std = new PreOrder()
{
IDDiningRoom = preorder.IDDiningRoom,
IDRecipe = preorder.IDRecipe,
PreOrderDate = preorder.PreOrderDate,
Accepted = preorder.Accepted
};
context.PreOrder.Add(std);
result = context.SaveChanges();
if (result == 0)
{
return("no se ha podido ingresar el registro");
}
else
{
return(std.ID.ToString());
}
}
}
catch (Exception e)
{
return(e.Message);
}
}
public Product Get(string code)
{
using (var context = new ProyectoMaestriaEntities())
{
var product = context.Product.SingleOrDefault(x => x.Code == code);
if (product != null)
{
return(new Product
{
ID = product.ID,
Code = product.Code,
Name = product.Name,
Description = product.Description,
Preservation = product.Preservation,
ProductType = product.ProductType
});
}
else
{
return(null);
}
}
}
public string UpdatePreorder(PreOrder preorder)
{
int modify = 0;
try
{
using (var context = new ProyectoMaestriaEntities())
{
var result = context.PreOrder.SingleOrDefault(b => b.ID == preorder.ID);
if (result != null)
{
result.IDDiningRoom = preorder.IDDiningRoom;
result.IDRecipe = preorder.IDRecipe;
result.PreOrderDate = preorder.PreOrderDate;
result.Accepted = preorder.Accepted;
modify = context.SaveChanges();
if (modify == 0)
{
return("no se ha podido modificar el registro");
}
else
{
return("se ha modificado el registro satisfactoriamente");
}
}
else
{
return("no se ha encontrado coincidencia en la base de datos");
}
}
}
catch (Exception e)
{
return(e.Message);
}
}
public List <Ingredient> GettAll()
{
List <Ingredient> ingredients = new List <Ingredient>();
using (var context = new ProyectoMaestriaEntities())
{
var result = context.Ingredient.ToList();
if (result != null)
{
foreach (var temp in result)
{
//result.Password = systemuser.Password;
//result.Name = systemuser.Name;
//result.LastName = systemuser.LastName;
//result.UserType = systemuser.UserType;
//result.ProviderID = systemuser.ProviderID;
Ingredient ingredient = new Ingredient();
ingredient.Id = temp.Id;
ingredient.IDProduct = temp.IDProduct;
ingredient.IDRecipe = temp.IDRecipe;
ingredient.Quantity = temp.Quantity;
ingredients.Add(ingredient);
}
return(ingredients);
}
else
{
return(ingredients);
}
}
}
public bool InsertarComedor(Comedor comedor)
{
int result;
using (var context = new ProyectoMaestriaEntities())
{
var std = new Comedor()
{
Codigo = comedor.Codigo,
Nombre = comedor.Nombre,
Direccion = comedor.Direccion,
Telefono = comedor.Telefono,
Email = comedor.Email,
Pais = comedor.Pais,
Departamento = comedor.Departamento,
Ciudad = comedor.Ciudad,
Contacto = comedor.Contacto,
Email_Contacto = comedor.Email_Contacto,
Telefono_Contacto = comedor.Telefono_Contacto,
Numero_Niños = comedor.Numero_Niños,
ZonaHorarioRecepción = comedor.ZonaHorarioRecepción
};
context.Comedor.Add(std);
result = context.SaveChanges();
if (result == 0)
{
return(false);
}
else
{
return(true);
}
}
}
public List <PreOrderItem> GetByOrder(long Preorder)
{
List <PreOrderItem> ingredients = new List <PreOrderItem>();
using (var context = new ProyectoMaestriaEntities())
{
// Query for all blogs with names starting with B
//var ComedorExtracted = from b in context.Comedor
// where b.ID.Equals(id)
// select b;
var repetido = context.PreOrderItem.Where(x => x.IDPreOrder == Preorder);
foreach (PreOrderItem ing in repetido)
{
PreOrderItem ingr = new PreOrderItem();
ingr.ID = ing.ID;
ingr.IDPreOrder = ing.IDPreOrder;
ingr.IDProduct = ing.IDProduct;
ingr.Quantity = ing.Quantity;
ingredients.Add(ingr);
}
return(ingredients);
}
}