public string Post([FromBody] CobroModelView value)
{
DateTime Hoy = DateTime.Today;
string fecha_actual = Hoy.ToString("dd/MM/yyyy");
value.Fecha = fecha_actual;
return(gestorCobro.IngresarCobro(value));
}
public static string IngresarCobro(CobroModelView cobro)
{
string rpt = "ok";
SqlConnection cn = new SqlConnection(Conexion.cn);
cn.Open();
SqlTransaction tran = cn.BeginTransaction(IsolationLevel.Serializable);
try
{
DynamicParameters dypa = new DynamicParameters();
dypa.Add("@Fecha", cobro.Fecha);
dypa.Add("@MontoML", cobro.MontoML);
dypa.Add("@MontoME", cobro.MontoME);
dypa.Add("@Dni", cobro.DNI);
dypa.Add("@IdTipoCobro", cobro.IdTipoCobro);
dypa.Add("@TipoDoc", cobro.TipoDoc);
dypa.Add("@SerieDoc", cobro.SerieDoc);
dypa.Add("@NumeroDoc", cobro.NumeroDoc);
dypa.Add("@Moneda", cobro.Moneda);
dypa.Add("@MontoCobrado", cobro.MontoCobrado);
dypa.Add("@TipoDocCobro", cobro.TipoDocCobro);
dypa.Add("@NumOperacion", cobro.NumOperacion);
dypa.Add("@Observacion", cobro.Observacion);
cn.Execute("itData.SP_I_CABCOBRO_DETCOBRO", dypa, tran, commandType: CommandType.StoredProcedure);
rpt = "ok";
tran.Commit();
}
catch (Exception e)
{
tran.Rollback();
rpt = "Excepción ocurrida: " + e.Message;
}
finally
{
tran.Dispose();
cn.Close();
cn.Dispose();
}
return(rpt);
}
public static CobroModelView BuscarCobro(int id)
{
CobroModelView lis = new CobroModelView();
SqlConnection cn = new SqlConnection(Conexion.cn);
try
{
DynamicParameters dypa = new DynamicParameters();
dypa.Add("@IdCobro", id);
lis = cn.Query <CobroModelView>("itData.SP_S_ID_Cobro", dypa, commandType: CommandType.StoredProcedure).First();
}
catch (Exception e)
{
var rpt = "Excepción ocurrida: " + e.Message;
lis = null;
}
finally
{
cn.Close();
cn.Dispose();
}
return(lis);
}
public string Put([FromBody] CobroModelView value)
{
return(gestorCobro.ActualizarCobro(value));
}
public string ActualizarCobro(CobroModelView cobro)
{
return(CobroDAO.ActualizarCobro(cobro));
}
public string IngresarCobro(CobroModelView cobro)
{
return(CobroDAO.IngresarCobro(cobro));
}
