public static void DeletetDB(MediosPagoModel modelo) { try { using (efooddatabaseEntities db = new efooddatabaseEntities()) { var datos = (from valor in db.PaymentProcessors where valor.PaymentProcessorCode == modelo.PaymentProcessorCode select valor).SingleOrDefault(); db.PaymentProcessors.Remove(datos); db.SaveChanges(); BitacoraModel.AddLogBook("n", "Borrar", Admin.ObtenerIdUsuario()); } } catch (Exception x) { ErrorLogModel.AddError(x); } }
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); } } }