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