public void SaveDetailQ(Token Token, int IdQ, RequestProducts Product) { using (SqlConnection con = new SqlConnection(this.ConnectionStrings)) { using (SqlCommand cmd = new SqlCommand("GuardarCotizacionDetalle", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@IdPlanta", SqlDbType.Int); cmd.Parameters["@IdPlanta"].Value = Token.IdPlant; cmd.Parameters.Add("@IdCotizacion", SqlDbType.Int); cmd.Parameters["@IdCotizacion"].Value = IdQ; cmd.Parameters.Add("@IdProducto", SqlDbType.Int); cmd.Parameters["@IdProducto"].Value = Product.Id; cmd.Parameters.Add("@idMedida", SqlDbType.Int); cmd.Parameters["@idMedida"].Value = Product.IdMeasure; cmd.Parameters.Add("@Cantidad", SqlDbType.Decimal); cmd.Parameters["@Cantidad"].Value = Product.Amount; con.Open(); cmd.ExecuteNonQuery(); } } }
public virtual async Task <ListResult <ProductModel> > ListFiltered(RequestProducts request) { try { return(await Task.Run(() => _repository.ListFiltered(request))); } catch (Exception ex) { Log.Error(ex); return(new ListResult <ProductModel> { Status = "error", Message = ex.Message }); } }
public virtual ListResult <ProductModel> ListFiltered(RequestProducts request) { try { IQueryable <Product> query = from p in Context.Set <Product>() select p; query = query.OrderBy(string.IsNullOrEmpty(request.Sort) ? "Name" : request.Sort); if (request.SubcategoryID != null) { query = query.Where(x => x.ProductSubcategoryID == request.SubcategoryID); } var page = query .Skip(request.Skip ?? 0) .Take(request.Take ?? 24) .ToList(); var pageViewModel = page.Select(x => Mapper.Map <Product, ProductModel>(x)).ToList(); ListResult <ProductModel> result = new ListResult <ProductModel> { Status = "success", TotalCount = query.Count(), Records = pageViewModel }; return(result); } catch (Exception ex) { Log.Error(ex); return(new ListResult <ProductModel> { Status = "error", Message = ex.Message }); } }