public List <InventoryData> GetProductsByInventoryForm(ProductSearchParamemters param) { List <InventoryData> result = new List <InventoryData>(); Vendor vendor = GetVendorByName(param.VendorName); string cmdText = "SELECT * FROM [OrderManager].[dbo].[InventoryMatrix] where Manufacturer = '" + vendor.InventoryFrom + "'"; string _connectionString = ConfigurationManager.ConnectionStrings["OrderManager"].ConnectionString; using (var connection = new SqlConnection(_connectionString)) { connection.Open(); using (var command = new SqlCommand(cmdText, connection)) { command.CommandType = CommandType.Text; using (var reader = command.ExecuteReader()) { while (reader.Read()) { // Vendor exists in Vendor table var inventoryData = new InventoryData(); inventoryData.ItemID = reader["ItemID"].ToString(); inventoryData.ItemCode = reader["ItemCode"].ToString().Replace("\"", ""); inventoryData.itemDescription = reader["itemDescription"].ToString(); try { inventoryData.Quantity = int.Parse(reader["Quantity"].ToString()); } catch (Exception e) { } inventoryData.Manufacturer = reader["Manufacturer"].ToString(); inventoryData.AlternateItemCode = reader["AlternateItemCode"].ToString(); inventoryData.UPC = reader["UPC"].ToString(); inventoryData.ShippingWeight = reader["ShippingWeight"].ToString(); inventoryData.ItemLocation = reader["ItemLocation"].ToString(); inventoryData.BoxSize = reader["BoxSize"].ToString(); inventoryData.OpenOrders = int.Parse(reader["OpenOrders"].ToString()); inventoryData.DontFollow = reader["DontFollow"].ToString(); inventoryData.FollowAsIs = reader["FollowAsIs"].ToString(); inventoryData.DSFee = decimal.Parse((string)reader["DSFee"].ToString()); inventoryData.CasePack = reader["CasePack"].ToString(); inventoryData.ActualWeight = reader["ActualWeight"].ToString(); inventoryData.Map = reader["Map"].ToString(); inventoryData.brand = reader["brand"].ToString(); result.Add(inventoryData); } } } connection.Close(); } return(result); }//*/
public List <Product> SearchProduct(ProductSearchParamemters param) { List <Product> result = new List <Product>(); using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); using (var command = new SqlCommand()) { command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = "usp_search_product"; if (!string.IsNullOrEmpty(param.VendorName)) { command.Parameters.AddWithValue("@VendorName", param.VendorName); } if (param.LimitRecords.HasValue) { command.Parameters.AddWithValue("@LimitRecords", param.LimitRecords.Value); } if (!string.IsNullOrEmpty(param.Description)) { command.Parameters.AddWithValue("@Description", param.Description); } if (param.MinProfit.HasValue) { command.Parameters.AddWithValue("@MinProfit", param.MinProfit.Value); } if (param.MinProfitPecent.HasValue) { command.Parameters.AddWithValue("@MinProfitPercent", param.MinProfitPecent.Value); } if (param.Discount.HasValue) { command.Parameters.AddWithValue("@Discount", param.Discount.Value); } if (param.QuantityInStock.HasValue) { command.Parameters.AddWithValue("@QuanityInStock", param.QuantityInStock.Value); } if (param.CostToBringOver.HasValue) { command.Parameters.AddWithValue("@CostToBring", param.CostToBringOver.Value); } if (!string.IsNullOrEmpty(param.Sku)) { command.Parameters.AddWithValue("@Sku", param.Sku); } command.Parameters.AddWithValue("@IsWatchList", param.IsWatchList); var reader = command.ExecuteReader(); while (reader.Read()) { var product = new Product(); product.Asin = (string)reader["Asin"]; product.Sku = (string)reader["SKU"]; product.SalesValue = Convert.ToDecimal(reader["SalesValue"]); product.Profit = Convert.ToDecimal(reader["Profit"]); product.Seller = (string)reader["Seller"]; product.Manufacturer = (string)reader["Manufacturer"]; if (!reader.IsDBNull(reader.GetOrdinal("QuantityInStock"))) { product.QuantityInStock = Convert.ToInt32(reader["QuantityInStock"]); } if (!reader.IsDBNull(reader.GetOrdinal("CasePack"))) { product.CasePack = Convert.ToInt32(reader["CasePack"]); } if (!reader.IsDBNull(reader.GetOrdinal("FirstCategory"))) { product.FirstCategory = (string)reader["FirstCategory"]; } if (!reader.IsDBNull(reader.GetOrdinal("FirstCategoryRank"))) { product.FirstCategoryRank = Convert.ToInt32(reader["FirstCategoryRank"]); } if (!reader.IsDBNull(reader.GetOrdinal("Cost"))) { product.Cost = Convert.ToDecimal(reader["Cost"]); } if (!reader.IsDBNull(reader.GetOrdinal("BB-Price"))) { product.BBPrice = Convert.ToDecimal(reader["BB-Price"]); } if (!reader.IsDBNull(reader.GetOrdinal("BB-Shipping"))) { product.BBShipping = Convert.ToDecimal(reader["BB-Shipping"]); } if (!reader.IsDBNull(reader.GetOrdinal("BB-Delivered"))) { product.BBDelivered = Convert.ToDecimal(reader["BB-Delivered"]); } if (!reader.IsDBNull(reader.GetOrdinal("Name"))) { product.Name = (string)reader["Name"]; } if (!reader.IsDBNull(reader.GetOrdinal("AmazonShippingWeight"))) { product.AmazonShippingWeight = (string)reader["AmazonShippingWeight"]; } if (!reader.IsDBNull(reader.GetOrdinal("ShippingWeight"))) { product.ShippingWeight = (string)reader["ShippingWeight"]; } if (!reader.IsDBNull(reader.GetOrdinal("AVGRanking"))) { product.AverageRanking = Convert.ToInt32(reader["AVGRanking"]); } if (!reader.IsDBNull(reader.GetOrdinal("Likes"))) { product.Likes = Convert.ToInt32(reader["Likes"]); } result.Add(product); } } connection.Close(); } return(result); }
public JsonResult Search(ProductSearchParamemters param) { var products = PricingBusiness.SearchProduct(param); return(Json(products, JsonRequestBehavior.AllowGet)); }