public List <SummaryViewByCategory> GetSummaryByBoth(string company, string category)
{
// SELECT * FROM SummaryViewByCategory WHERE Company = 'Unilever' and Category = 'Electronics'
string query = "SELECT * FROM SummaryViewByCategory WHERE Company = '" + company + "' and Category = '" + category + "'";
Command = new SqlCommand(query, Connection);
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
List <SummaryViewByCategory> bothSummaryList = new List <SummaryViewByCategory>();
while (reader.Read())
{
SummaryViewByCategory bothSummary = new SummaryViewByCategory();
bothSummary.Item = reader["Item"].ToString();
bothSummary.Company = reader["Company"].ToString();
bothSummary.Category = reader["Category"].ToString();
bothSummary.AvailableQuantity = Convert.ToInt32(reader["AvailableQuantity"]);
bothSummary.ReorderLevel = Convert.ToInt32(reader["ReorderLevel"]);
bothSummaryList.Add(bothSummary);
}
Connection.Close();
return(bothSummaryList);
}
public List <SummaryViewByCategory> GetAllSummaryByCategory(string category)
{
string query = "SELECT * FROM SummaryViewByCategory WHERE Category = '" + category + "'";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <SummaryViewByCategory> summaryViewByCategories = new List <SummaryViewByCategory>();
while (Reader.Read())
{
SummaryViewByCategory summaryView = new SummaryViewByCategory();
summaryView.Item = Reader["Item"].ToString();
summaryView.Company = Reader["Company"].ToString();
summaryView.Category = Reader["Category"].ToString();
summaryView.AvailableQuantity = Convert.ToInt32(Reader["AvailableQuantity"]);
summaryView.ReorderLevel = Convert.ToInt32(Reader["ReorderLevel"]);
summaryViewByCategories.Add(summaryView);
}
Connection.Close();
return(summaryViewByCategories);
}
