public static void AddDB(ProductoModel modelo, TipoPrecioToProduct modeloTipoPrecio)
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
try
{
string codigoDeProducto = ConsecutivoModel.GetConsecutivo("Productos");
//Entidades de la base de datos
Product product = new Product
{
ProductCode = codigoDeProducto,
ProductDescription = modelo.ProductDescription,
FoodOptionCode = modelo.FoodOptionCode,
ProductContent = modelo.ProductContent,
ProductImage = modelo.ProductImage
};
db.Products.Add(product);
db.SaveChanges();
PriceTypeToProduct priceToProduct = new PriceTypeToProduct
{
PriceTypeCode = modeloTipoPrecio.PriceTypeCode,
ProductCode = codigoDeProducto,
Price = modeloTipoPrecio.Price
};
db.PriceTypeToProducts.Add(priceToProduct);
db.SaveChanges();
BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
}
catch (Exception e) { ErrorLogModel.AddError(e); }
}
}
public static void DeletetDB(LineaComidaModel modelo)
{
try
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
var datos = (from valor in db.FoodOptions
where valor.FoodOptionCode == modelo.FoodOptionCode
select valor).SingleOrDefault();
db.FoodOptions.Remove(datos);
db.SaveChanges();
BitacoraModel.AddLogBook("n", "Borrar", Admin.ObtenerIdUsuario());
}
}
catch (Exception x) { ErrorLogModel.AddError(x); }
}
public static void EditDB(TipoPrecioModelo modelo)
{
try
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
var datos = (from valor in db.PriceTypes
where valor.PriceTypeCode == modelo.PriceTypeCode
select valor).SingleOrDefault();
datos.PriceTypeDescription = modelo.PriceTypeDescription;
db.SaveChanges();
BitacoraModel.AddLogBook("e", "Edicion", Admin.ObtenerIdUsuario());
}
}
catch (Exception x) { ErrorLogModel.AddError(x); }
}
public static void AddDB(LineaComidaModel modelo)
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
try
{ //Entidades de la base de datos
FoodOption foodOption = new FoodOption
{
FoodOptionCode = ConsecutivoModel.GetConsecutivo("Líneas de comida"),
FoodOptionDescription = modelo.FoodOptionDescription
};
db.FoodOptions.Add(foodOption);
db.SaveChanges();
BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
}
catch (Exception e) { ErrorLogModel.AddError(e); }
}
}
public static void AddDB(TipoPrecioModelo modelo)
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
try
{ //Entidades de la base de datos
PriceType priceType = new PriceType
{
PriceTypeCode = ConsecutivoModel.GetConsecutivo("Precios"),
PriceTypeDescription = modelo.PriceTypeDescription
};
db.PriceTypes.Add(priceType);
db.SaveChanges();
BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
}
catch (Exception e) { ErrorLogModel.AddError(e); }
}
}
public static void AddDB(TarjetaCreditoDebitoModel modelo)
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
try
{ //Entidades de la base de datos
Card newCard = new Card
{
CardCode = ConsecutivoModel.GetConsecutivo("Tarjetas"),
CardDescription = modelo.CardDescription
};
db.Cards.Add(newCard);
db.SaveChanges();
BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
}
catch (Exception e) { ErrorLogModel.AddError(e); }
}
}
public static void EditDB(TiqueteDescuentoModel modelo)
{
try
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
var datos = (from valor in db.TicketDiscounts
where valor.TicketCode == modelo.TicketCode
select valor).SingleOrDefault();
datos.TicketDescription = modelo.TicketDescription;
datos.TicketDiscountPercentage = modelo.TicketDiscountPercentage;
datos.RemainingTickets = modelo.RemainingTickets;
db.SaveChanges();
BitacoraModel.AddLogBook("e", "Edicion", Admin.ObtenerIdUsuario());
}
}
catch (Exception x) { ErrorLogModel.AddError(x); }
}
public static void AddDB(TipoPrecioToProduct model)
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
try
{ //Entidades de la base de datos
PriceTypeToProduct priceType = new PriceTypeToProduct
{
PriceTypeCode = model.PriceTypeCode,
ProductCode = model.ProductCode,
Price = model.Price
};
db.PriceTypeToProducts.Add(priceType);
db.SaveChanges();
BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
}
catch (Exception e) { ErrorLogModel.AddError(e); }
}
}
public static void EditDB(ProductoModel modelo)
{
try
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
var datos = (from valor in db.Products
where valor.ProductCode == modelo.ProductCode
select valor).SingleOrDefault();
datos.ProductDescription = modelo.ProductDescription;
datos.FoodOptionCode = modelo.FoodOptionCode;
datos.ProductContent = modelo.ProductContent;
//datos.ProductImage = null;
db.SaveChanges();
BitacoraModel.AddLogBook("e", "Edicion", Admin.ObtenerIdUsuario());
}
}
catch (Exception x) { ErrorLogModel.AddError(x); }
}
public static void AddDB(TiqueteDescuentoModel modelo)
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
try
{ //Entidades de la base de datos
TicketDiscount newTicketDiscount = new TicketDiscount
{
TicketCode = ConsecutivoModel.GetConsecutivo("Tiquetes de descuento"),
TicketDescription = modelo.TicketDescription,
TicketDiscountPercentage = modelo.TicketDiscountPercentage,
RemainingTickets = modelo.RemainingTickets
};
db.TicketDiscounts.Add(newTicketDiscount);
db.SaveChanges();
BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
}
catch (Exception e) { ErrorLogModel.AddError(e); }
}
}
public static void EditDB(MediosPagoModel modelo)
{
try
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
var datos = (from valor in db.PaymentProcessors
where valor.PaymentProcessorCode == modelo.PaymentProcessorCode
select valor).SingleOrDefault();
datos.PaymentProcessorName = modelo.PaymentProcessorName;
datos.PaymentProcessorDescription = modelo.PaymentProcessorDescription;
datos.PaymentProcessorType = modelo.PaymentProcessorType;
datos.PaymentProcessorMethod = modelo.PaymentProcessorMethod;
datos.PaymentProcessorStatus = false;
datos.PaymentProcessorVerify = false;
db.SaveChanges();
BitacoraModel.AddLogBook("e", "Edicion", Admin.ObtenerIdUsuario());
}
}
catch (Exception x) { ErrorLogModel.AddError(x); }
}
public static void AddDB(MediosPagoModel modelo)
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
try
{ //Entidades de la base de datos
PaymentProcessor newProcessor = new PaymentProcessor
{
PaymentProcessorCode = ConsecutivoModel.GetConsecutivo("Medios de pago"),
PaymentProcessorName = modelo.PaymentProcessorName,
PaymentProcessorDescription = modelo.PaymentProcessorDescription,
PaymentProcessorType = modelo.PaymentProcessorType,
PaymentProcessorMethod = modelo.PaymentProcessorMethod,
PaymentProcessorStatus = false,
PaymentProcessorVerify = false
};
db.PaymentProcessors.Add(newProcessor);
db.SaveChanges();
BitacoraModel.AddLogBook("a", "Anadir", Admin.ObtenerIdUsuario());
}
catch (Exception e) { ErrorLogModel.AddError(e); }
}
}
public static List <BitacoraModel> FiltrarBitacora(BitacoraModel modelo)
{
try
{
using (efooddatabaseEntities db = new efooddatabaseEntities())
{
var logs = from valor in db.LogBooks
select new BitacoraModel
{
LogID = valor.LogID,
UserID = valor.UserID,
LogDate = valor.LogDate,
RegCode = valor.RegCode,
LogType = valor.LogType,
Description = valor.Description,
RegDetails = valor.RegDetails
};
if (modelo.EndDate != DateTime.Parse("01/01/0001 12:00:00 a. m."))
{
logs = logs.Where(valor => valor.LogDate <= modelo.EndDate);
}
if (modelo.StartDate != DateTime.Parse("01/01/0001 12:00:00 a. m."))
{
logs = logs.Where(valor => valor.LogDate >= modelo.StartDate);
}
if (modelo.UserID != 0)
{
logs = logs.Where(valor => valor.UserID == modelo.UserID);
}
if (modelo.LogType != null)
{
logs = logs.Where(valor => valor.LogType == modelo.LogType);
}
return(logs.ToList());
/*return (from valor in db.LogBooks
* where valor.LogDate >= modelo.StartDate &&
* valor.LogDate <= modelo.EndDate &&
* valor.LogType == modelo.LogType &&
* valor.UserID == modelo.UserID
*
* select new BitacoraModel
* {
* LogID = valor.LogID,
* UserID = valor.UserID,
* LogDate = valor.LogDate,
* RegCode = valor.RegCode,
* LogType = valor.LogType,
* Description = valor.Description,
* RegDetails = valor.RegDetails
*
* }).ToList();*/
}
}
catch (Exception x) {
ErrorLogModel.AddError(x); return(null);
}
}