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));
}
