public IEnumerable <Entities.VentasMayor> GetAllVentasMayor(Entities.VentasMayor obj) { using (var connection = Factory.ConnectionFactory()) { connection.Open(); var parm = new DynamicParameters(); parm.Add("@FechaDesde", obj.FechaDesde); parm.Add("@FechaHasta", obj.FechaHasta); var result = connection.Query( sql: "SP_FILTRAR_VENTA_MAYOR", param: parm, commandType: CommandType.StoredProcedure) .Select(m => m as IDictionary <string, object>) .Select(n => new Entities.VentasMayor { Cod_Venta = n.Single(d => d.Key.Equals("Cod_Venta")).Value.Parse <int>(), Producto = new Annies.Entities.Producto { Marca_Prod = n.Single(d => d.Key.Equals("Marca_Prod")).Value.Parse <string>(), }, Precio_Prod = n.Single(d => d.Key.Equals("PrecioProducto")).Value.Parse <int>(), Precio_Venta = n.Single(d => d.Key.Equals("PrecioVenta")).Value.Parse <int>(), Descuento_Venta = n.Single(d => d.Key.Equals("Descuento")).Value.Parse <int>(), Precio_Final = n.Single(d => d.Key.Equals("PrecioTotal")).Value.Parse <int>(), Fecha = n.Single(d => d.Key.Equals("Fecha")).Value.Parse <int>() }); return(result); } }
public Response <IEnumerable <Entities.VentasMayor> > GetAllVentasMayor(Entities.VentasMayor obj) { try { var result = repository.GetAllVentasMayor(obj); return(new Response <IEnumerable <Entities.VentasMayor> >(result)); } catch (Exception ex) { throw new Exception(ex.Message); } }
public Response <int> DeleteVentasMayor(Entities.VentasMayor obj) { try { var result = repository.DeleteVentasMayor(obj); return(new Response <int>(result)); } catch (Exception ex) { return(new Response <int>(ex)); } }
public int DeleteVentasMayor(Entities.VentasMayor obj) { using (var connection = Factory.ConnectionFactory()) { connection.Open(); var parm = new DynamicParameters(); parm.Add("@Cod_Venta", obj.Cod_Venta); parm.Add("@Usuario", obj.Auditoria.UsuarioModificacion); var result = connection.Execute( sql: "SP_ELIMINAR_VENTA_MAYOR", param: parm, commandType: CommandType.StoredProcedure); return(result); } }
public IEnumerable <Entities.VentasMayor> GetVentasMayor(Entities.VentasMayor obj) { using (var connection = Factory.ConnectionFactory()) { connection.Open(); var parm = new DynamicParameters(); parm.Add("@FECHA", obj.Fecha); parm.Add("@NumPagina", obj.Operacion.Inicio); parm.Add("@TamPagina", obj.Operacion.Fin); var result = connection.Query( sql: "SP_BUSCAR_VENTA_MAYOR", param: parm, commandType: CommandType.StoredProcedure) .Select(m => m as IDictionary <string, object>) .Select(n => new Entities.VentasMayor { Cod_Venta = n.Single(d => d.Key.Equals("Cod_Venta")).Value.Parse <int>(), Producto = new Annies.Entities.Producto { Marca_Prod = n.Single(d => d.Key.Equals("Marca_Prod")).Value.Parse <string>(), }, Precio_Prod = n.Single(d => d.Key.Equals("PrecioProducto")).Value.Parse <int>(), Precio_Venta = n.Single(d => d.Key.Equals("PrecioVenta")).Value.Parse <int>(), Descuento_Venta = n.Single(d => d.Key.Equals("Descuento")).Value.Parse <int>(), Precio_Final = n.Single(d => d.Key.Equals("PrecioTotal")).Value.Parse <int>(), Fecha = n.Single(d => d.Key.Equals("Fecha")).Value.Parse <int>(), Auditoria = new Entities.Auditoria { TipoUsuario = obj.Auditoria.TipoUsuario }, Operacion = new Entities.Operacion { TotalRows = n.Single(d => d.Key.Equals("TotalRows")).Value.Parse <int>() } }); return(result); } }
public int InsertUpdateVentas(Entities.VentasMayor obj) { using (var connection = Factory.ConnectionFactory()) { connection.Open(); var parm = new DynamicParameters(); parm.Add("@Cod_Venta", obj.Cod_Venta); parm.Add("@PrecioProducto", obj.Precio_Prod); parm.Add("@PrecioVenta", obj.Precio_Venta); parm.Add("@Descuento", obj.Descuento_Venta); parm.Add("@PrecioTotal", obj.Precio_Final); parm.Add("@Usuario", obj.Auditoria.UsuarioCreacion); parm.Add("@Talla_Ventas", obj.Talla_Ventas); var result = connection.Execute( sql: "SP_INSERTAR_VENTA_MAYOR", param: parm, commandType: CommandType.StoredProcedure); return(result); } }