public List <ViewItemsModel> GetCompanyById(int id)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT Company.Company_Name,Category.Category_Name,Item.Item_Name,Item.Item_Quantity,Item.Item_Reorder_level " +
"FROM Item LEFT JOIN Category on Item.Category_Id=Category.Category_Id " +
"LEFT JOIN Company on Company.Company_Id=Item.Company_Id " +
"WHERE Item.Company_Id=" + id;
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <ViewItemsModel> viewItem = new List <ViewItemsModel>();
while (reader.Read())
{
ViewItemsModel viewItems = new ViewItemsModel();
viewItems.Category_Name = reader["Category_Name"].ToString();
viewItems.Company_Name = reader["Company_Name"].ToString();
viewItems.Item_Name = reader["Item_Name"].ToString();
viewItems.Item_Quantity = Convert.ToInt32(reader["Item_Quantity"]);
viewItems.Item_Reorder_level = Convert.ToInt32(reader["Item_Reorder_level"]);
viewItem.Add(viewItems);
}
connection.Close();
return(viewItem);
}
public List <ViewItemsModel> GetViewItemsList()
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "SELECT * FROM GetViewItemsList";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <ViewItemsModel> viewItemLists = new List <ViewItemsModel>();
while (reader.Read())
{
ViewItemsModel viewItems = new ViewItemsModel();
viewItems.Item_Id = Convert.ToInt32(reader["Item_Id"]);
viewItems.Item_Name = (reader["Item"].ToString());
viewItems.Company_Name = (reader["CompanyName"].ToString());
viewItems.Item_Quantity = Convert.ToInt32(reader["Quantity"]);
viewItems.Item_Reorder_level = Convert.ToInt32(reader["Reorder_level"]);
viewItemLists.Add(viewItems);
}
connection.Close();
return(viewItemLists);
}
