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();
}
}
}
public ActionResult Create([FromBody] Ecom_Inversiones Ecom_Inversiones_)
{
EcomData_ = new EcomData(StringConnectio);
try
{
EcomData_.Connect();
Ecom_Inversiones_ = (Ecom_Inversiones)EcomData_.SetObjectConnection(Ecom_Inversiones_, DataModel.Inversioniones);
if (Ecom_Inversiones_.Inversionista == 0)
{
throw new Ecom_Exception("Por favor selecciona Inversionista");
}
bool result = Ecom_Inversiones_.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();
}
}
}
public ActionResult Delete(int id)
{
EcomData_ = new EcomData(StringConnectio);
try
{
EcomData_.Connect();
Ecom_Inversiones_ = (Ecom_Inversiones)EcomData_.GetObject(DataModel.Inversioniones);
Ecom_Inversiones_.Id = id;
bool result = Ecom_Inversiones_.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();
}
}
}
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();
}
}
}
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();
}
}
}
