Пример #1
0
 public IActionResult Index(DateTime fecha1, DateTime fecha2)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_venta_       = new Ecom_venta();
         Ecom_venta_.Incio = fecha1;
         Ecom_venta_.Final = fecha2;
         Ecom_Abono       Ecom_Abono_list       = (Ecom_Abono)EcomData_.GetObject(DataModel.Abono);
         Ecom_Inversiones Ecom_Inversiones_list = (Ecom_Inversiones)EcomData_.GetObject(DataModel.Inversioniones);
         Ecom_venta_.Ecom_Abono_       = Ecom_Abono_list.Get(fecha1, fecha2);
         Ecom_venta_.Ecom_Inversiones_ = Ecom_Inversiones_list.Get(fecha1, fecha2);
         return(View(Ecom_venta_));
     }
     catch (Ecom_Exception ex)
     {
         return(View("../ErrorPages/Error", new { id = ex.Message }));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #2
0
 public ActionResult Create([FromBody] Ecom_Abono Ecom_Abono_)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Abono_ = (Ecom_Abono)EcomData_.SetObjectConnection(Ecom_Abono_, DataModel.Abono);
         if (Ecom_Abono_.Cliente == 0)
         {
             throw new Ecom_Exception("Por favor selecciona Cliente");
         }
         bool result = Ecom_Abono_.Add();
         if (result)
         {
             return(Ok(EcomData_.GetLastMessage()));
         }
         else
         {
             return(BadRequest(EcomData_.GetLastMessage()));
         }
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #3
0
 public ActionResult Delete(int id)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Abono_    = (Ecom_Abono)EcomData_.GetObject(DataModel.Abono);
         Ecom_Abono_.Id = id;
         bool result = Ecom_Abono_.Delete();
         if (result)
         {
             return(Ok(EcomData_.GetLastMessage()));
         }
         else
         {
             return(BadRequest(EcomData_.GetLastMessage()));
         }
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #4
0
 public ActionResult ConcelarVenta([FromBody] Ecom_Producto Ecom_Producto_)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Producto_ = (Ecom_Producto)EcomData_.SetObjectConnection(Ecom_Producto_, DataModel.Producto);
         bool result = Ecom_Producto_.Update(7);
         if (result)
         {
             return(Ok(EcomData_.GetLastMessage()));
         }
         else
         {
             return(BadRequest(EcomData_.GetLastMessage()));
         }
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #5
0
 public ActionResult Recuperar([FromBody] Ecom_Inversiones Ecom_Inversiones_)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Inversiones_ = (Ecom_Inversiones)EcomData_.SetObjectConnection(Ecom_Inversiones_, DataModel.Inversioniones);
         bool result = Ecom_Inversiones_.Update(3);
         if (result)
         {
             return(Ok(EcomData_.GetLastMessage()));
         }
         else
         {
             return(BadRequest(EcomData_.GetLastMessage()));
         }
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #6
0
 public ActionResult Cotizar([FromBody] Ecom_Producto Ecom_Producto_)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Producto_ = (Ecom_Producto)EcomData_.SetObjectConnection(Ecom_Producto_, DataModel.Producto);
         if (Ecom_Producto_.Cliente == 0)
         {
             throw new Ecom_Exception("Por favor selecciona un cliente para la venta");
         }
         bool result = Ecom_Producto_.Update(5);
         if (result)
         {
             return(Ok(EcomData_.GetLastMessage()));
         }
         else
         {
             return(BadRequest(EcomData_.GetLastMessage()));
         }
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #7
0
 public ActionResult Details(int id)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Producto_ = (Ecom_Producto)EcomData_.GetObject(DataModel.Cliente);
         bool result = Ecom_Producto_.Get(id);
         if (result)
         {
             return(Ok(Ecom_Producto_));
         }
         else
         {
             return(BadRequest(Ecom_Producto_));
         }
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #8
0
 // GET: TipoProducto/Details/5
 public ActionResult Details(int id)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Pedido_ = (Ecom_Pedido)EcomData_.GetObject(DataModel.Pedido);
         bool result = Ecom_Pedido_.Get(id);
         if (result)
         {
             return(View(Ecom_Pedido_));
         }
         else
         {
             throw new Ecom_Exception(EcomData_.GetLastMessage());
         }
     }
     catch (Ecom_Exception ex)
     {
         return(View("../ErrorPages/Error", new { id = ex.Message }));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #9
0
 public ActionResult Delete(int id, IFormCollection collection)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Pedido_    = (Ecom_Pedido)EcomData_.GetObject(DataModel.Pedido);
         Ecom_Pedido_.Id = id;
         bool result = Ecom_Pedido_.Delete();
         if (result)
         {
             return(RedirectToAction(nameof(Index)));
         }
         else
         {
             throw new Ecom_Exception(EcomData_.GetLastMessage());
         }
     }
     catch (Ecom_Exception ex)
     {
         return(View("../ErrorPages/Error", new { id = ex.Message }));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #10
0
 public ActionResult Delete(int id, IFormCollection collection)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_PedidoAjuste_    = (Ecom_PedidoAjuste)EcomData_.GetObject(DataModel.PedidoAjuste);
         Ecom_PedidoAjuste_.Id = id;
         bool result2 = Ecom_PedidoAjuste_.Get(id);
         int  perdido = Ecom_PedidoAjuste_.Pedido;
         bool result  = Ecom_PedidoAjuste_.Delete();
         if (result)
         {
             return(RedirectToAction("Details", "Pedido", new { Id = perdido }));
         }
         else
         {
             throw new Ecom_Exception(EcomData_.GetLastMessage());
         }
     }
     catch (Ecom_Exception ex)
     {
         return(View("../ErrorPages/Error", new { id = ex.Message }));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #11
0
 public ActionResult GetRange(DateTime fecha1, DateTime fecha2)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Abono_ = (Ecom_Abono)EcomData_.GetObject(DataModel.Abono);
         List <Ecom_Abono> result = Ecom_Abono_.Get(fecha1, fecha2);
         return(Ok(result));
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #12
0
 public ActionResult GetSinComprar(int id)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Producto_ = (Ecom_Producto)EcomData_.GetObject(DataModel.Producto);
         List <Ecom_Producto> result = Ecom_Producto_.GetByPedido(id);
         return(Ok(result.Where(item => item.Estatus == 1 || item.PrecioCompra == 0).ToList()));
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #13
0
 public ActionResult Index(int id)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Producto_ = (Ecom_Producto)EcomData_.GetObject(DataModel.Producto);
         List <Ecom_Producto> result = Ecom_Producto_.GetByPedido(id);
         return(Ok(result));
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #14
0
 // GET: TipoProducto
 public ActionResult Index()
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Pedido_ = (Ecom_Pedido)EcomData_.GetObject(DataModel.Pedido);
         List <Ecom_Pedido> result = Ecom_Pedido_.Get();
         return(View(result));
     }
     catch (Ecom_Exception ex)
     {
         return(View("../ErrorPages/Error", new { id = ex.Message }));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #15
0
 public ActionResult GetInversionista(int id)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         EcomData_.Connect();
         Ecom_Inversiones_ = (Ecom_Inversiones)EcomData_.GetObject(DataModel.Inversioniones);
         List <Ecom_Inversiones> result = Ecom_Inversiones_.GetByClienteInversionista(id);
         return(Ok(result));
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #16
0
 public ActionResult Create(Ecom_Pedido Ecom_Pedido_)
 {
     //return RedirectToAction(nameof(Index));
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         if (!ModelState.IsValid)
         {
             return(View(Ecom_Pedido_));
         }
         else
         {
             EcomData_.Connect();
             Ecom_Pedido_ = (Ecom_Pedido)EcomData_.SetObjectConnection(Ecom_Pedido_, DataModel.Pedido);
             bool result = Ecom_Pedido_.Add();
             if (result)
             {
                 return(RedirectToAction(nameof(Index)));
             }
             else
             {
                 throw new Ecom_Exception(EcomData_.GetLastMessage());
             }
         }
     }
     catch (Ecom_Exception ex)
     {
         ModelState.AddModelError(string.Empty, string.Format("{0}", ex.Message));
         return(View(Ecom_Pedido_));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #17
0
 public ActionResult Create([FromBody] Ecom_Cliente Ecom_Cliente_)
 {
     //return RedirectToAction(nameof(Index));
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         if (!ModelState.IsValid)
         {
             throw new Ecom_Exception("Campos no validos");
         }
         else
         {
             EcomData_.Connect();
             Ecom_Cliente_ = (Ecom_Cliente)EcomData_.SetObjectConnection(Ecom_Cliente_, DataModel.Cliente);
             bool result = Ecom_Cliente_.Add();
             if (result)
             {
                 return(Ok(EcomData_.GetLastMessage()));
             }
             else
             {
                 throw new Ecom_Exception(EcomData_.GetLastMessage());
             }
         }
     }
     catch (Ecom_Exception ex)
     {
         return(BadRequest(ex.Message));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }
Пример #18
0
 public ActionResult Edit(Ecom_PedidoAjuste Ecom_PedidoAjuste_)
 {
     EcomData_ = new EcomData(StringConnectio);
     try
     {
         if (!ModelState.IsValid)
         {
             return(View(Ecom_PedidoAjuste_));
         }
         else
         {
             EcomData_.Connect();
             Ecom_PedidoAjuste_ = (Ecom_PedidoAjuste)EcomData_.SetObjectConnection(Ecom_PedidoAjuste_, DataModel.PedidoAjuste);
             bool result = Ecom_PedidoAjuste_.Update();
             if (result)
             {
                 return(RedirectToAction("Details", "Pedido", new { Id = Ecom_PedidoAjuste_.Pedido }));
             }
             else
             {
                 throw new Ecom_Exception(EcomData_.GetLastMessage());
             }
         }
     }
     catch (Ecom_Exception ex)
     {
         ModelState.AddModelError(string.Empty, string.Format("{0}", ex.Message));
         return(View(Ecom_PedidoAjuste_));
     }
     finally
     {
         if (EcomData_ != null)
         {
             EcomData_.Disconnect();
         }
     }
 }