public List <SearchAndView> GetSearchResult(int companyID, int categoryId)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT Item_t.ItemName, Company_t.CompanyName,Category_t.CategoryName,StockIn_t.AvailableQuantity,Item_t.ReorderLevel FROM ((Item_t INNER JOIN Company_t ON Company_t.CompanyID = Item_t.CompanyID) INNER JOIN Category_t ON Item_t.CategoryID=Category_t.CategoryID INNER JOIN StockIn_t ON Item_t.ItemID=StockIn_t.ItemID) WHERE CompanyID='" + companyID + "' AND CategoryID='" + categoryId + "'";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <SearchAndView> searchList = new List <SearchAndView>();
while (reader.Read())
{
SearchAndView searchAndView = new SearchAndView();
searchAndView.ItemName = reader["ItemName"].ToString();
searchAndView.CompanyName = reader["CompanyName"].ToString();
searchAndView.CategoryName = reader["Categoryname"].ToString();
searchAndView.AvailavleQuntity = reader["AvailableQuantity"].ToString();
searchAndView.ReorderLevel = (int)reader["Reorderlevel"];
searchList.Add(searchAndView);
}
reader.Close();
connection.Close();
return(searchList);
}
public List <SearchAndView> Search(Item item)
{
Query = "SELECT * FROM GetAllInformation WHERE CompanyId='" + item.CompanyId + "' OR CategoryId='" +
item.CategoryId + "'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <SearchAndView> searchAndViews = new List <SearchAndView>();
while (Reader.Read())
{
SearchAndView searchAndView = new SearchAndView();
searchAndView.Item = Reader["Item"].ToString();
searchAndView.Company = Reader["Company"].ToString();
searchAndView.Category = Reader["Category"].ToString();
searchAndView.AvailableQuantity = Convert.ToInt32(Reader["AvailableQuantity"]);
searchAndView.ReorderLevel = Convert.ToInt32(Reader["ReorderLevel"]);
searchAndViews.Add(searchAndView);
}
Reader.Close();
Connection.Close();
return(searchAndViews);
}
