public List <ItemSummaryViewModel> GetDetailsByCompanyAndCategory(ItemSummaryViewModel itemSummaryViewModel) { string query = "VIEWBYCOMPANYANDCATEGORY"; command = new SqlCommand(query, connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@category", itemSummaryViewModel.CategoryId); command.Parameters.AddWithValue("@company", itemSummaryViewModel.CompanyId); connection.Open(); reader = command.ExecuteReader(); List <ItemSummaryViewModel> itemSummaryModelViewList = new List <ItemSummaryViewModel>(); while (reader.Read()) { itemSummaryViewModel = new ItemSummaryViewModel(); itemSummaryViewModel.CompanyId = Convert.ToInt32(reader["CompanyId"]); itemSummaryViewModel.CategoryId = Convert.ToInt32(reader["CategoryId"]); itemSummaryViewModel.CompanyName = reader["CompanyName"].ToString(); itemSummaryViewModel.ItemName = reader["ItemName"].ToString(); itemSummaryViewModel.ReorderLevel = Convert.ToInt32(reader["ReorderLevel"]); itemSummaryViewModel.Quantity = Convert.ToInt32(reader["Quantity"].ToString()); itemSummaryModelViewList.Add(itemSummaryViewModel); } reader.Close(); connection.Close(); return(itemSummaryModelViewList); }
public List <ItemSummaryViewModel> GetDetailsByForAll(ItemSummaryViewModel itemSummaryViewModel) { string query = "VIEWANDSEARCHITEMFORALL"; command = new SqlCommand(query, connection); command.CommandType = CommandType.StoredProcedure; connection.Open(); reader = command.ExecuteReader(); List <ItemSummaryViewModel> itemSummaryModelViewList = new List <ItemSummaryViewModel>(); while (reader.Read()) { itemSummaryViewModel = new ItemSummaryViewModel(); itemSummaryViewModel.CompanyId = Convert.ToInt32(reader["CompanyId"]); itemSummaryViewModel.CompanyName = reader["CompanyName"].ToString(); itemSummaryViewModel.CategoryId = Convert.ToInt32(reader["CategoryId"]); itemSummaryViewModel.CategoryName = reader["CategoryName"].ToString(); itemSummaryViewModel.ItemName = reader["ItemName"].ToString(); itemSummaryViewModel.ReorderLevel = Convert.ToInt32(reader["ReorderLevel"]); itemSummaryViewModel.Quantity = Convert.ToInt32(reader["Quantity"].ToString()); itemSummaryModelViewList.Add(itemSummaryViewModel); } reader.Close(); connection.Close(); return(itemSummaryModelViewList); }
public List <ItemSummaryViewModel> GetItemSummaryByCompanyIdAndCategoryId(int companyId, int categoryId) { string query = "SELECT * FROM ItemSummaryView WHERE CompanyId = @companyId AND CategoryId = @categoryId ORDER BY ItemName"; command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@companyId", companyId); command.Parameters.AddWithValue("@categoryId", categoryId); connection.Open(); reader = command.ExecuteReader(); List <ItemSummaryViewModel> showItemSummaryList = new List <ItemSummaryViewModel>(); while (reader.Read()) { ItemSummaryViewModel itemSummary = new ItemSummaryViewModel(); itemSummary.ItemId = (int)reader["ItemId"]; itemSummary.ItemName = reader["ItemName"] as string; itemSummary.CompanyId = (int)reader["CompanyId"]; itemSummary.CompanyName = reader["CompanyName"] as string; itemSummary.CategoryId = (int)reader["CategoryId"]; itemSummary.CategoryName = reader["CategoryName"] as string; itemSummary.Quantity = (int)reader["AvailableQuantity"]; itemSummary.ReorderLevel = (int)reader["ReorderLevel"]; showItemSummaryList.Add(itemSummary); } connection.Close(); return(showItemSummaryList); }
public List <ItemSummaryViewModel> GetAllItemSummary() { string query = "SELECT * FROM ItemSummaryView ORDER BY ItemName"; command = new SqlCommand(query, connection); connection.Open(); reader = command.ExecuteReader(); List <ItemSummaryViewModel> showItemSummaryList = new List <ItemSummaryViewModel>(); while (reader.Read()) { ItemSummaryViewModel itemSummary = new ItemSummaryViewModel(); itemSummary.ItemId = (int)reader["ItemId"]; itemSummary.ItemName = reader["ItemName"] as string; itemSummary.CompanyId = (int)reader["CompanyId"]; itemSummary.CompanyName = reader["CompanyName"] as string; itemSummary.CategoryId = (int)reader["CategoryId"]; itemSummary.CategoryName = reader["CategoryName"] as string; itemSummary.Quantity = (int)reader["AvailableQuantity"]; itemSummary.ReorderLevel = (int)reader["ReorderLevel"]; showItemSummaryList.Add(itemSummary); } connection.Close(); return(showItemSummaryList); }
private void GetAllCategory(ItemSummaryViewModel itemSummaryViewModel) { categoryDropDownList.DataSource = itemSummaryManager.GetAllCategory(itemSummaryViewModel); categoryDropDownList.DataValueField = "CategoryId"; categoryDropDownList.DataTextField = "CategoryName"; categoryDropDownList.DataBind(); categoryDropDownList.Items.Insert(0, new ListItem("Select a Category")); }
private void GetAllCompany(ItemSummaryViewModel itemSummaryViewModel) { CompanyDropDownList.DataSource = itemSummaryManager.GetAllCompanyFromStock(itemSummaryViewModel); CompanyDropDownList.DataValueField = "CompanyId"; CompanyDropDownList.DataTextField = "CompanyName"; CompanyDropDownList.DataBind(); CompanyDropDownList.Items.Insert(0, new ListItem("Select a Company")); }
public List<ItemSummaryViewModel> GetItems() { var result = new List<ItemSummaryViewModel>(); for (var i = 1; i < 6; i++) { var item = new ItemSummaryViewModel { FamilyName = "Joel's Family", Name = "Type " + i, HasTypeCatalog = i % 2 == 0, FeaturedAttributes = new Dictionary<string, string> { { "rating", "cool" }, { "level", i.ToString() } } }; result.Add(item); } return result; }
public List <ItemSummaryViewModel> GetAllCategory(ItemSummaryViewModel itemSummaryViewModel) { string query = "VIEWALLCATEGORY"; command = new SqlCommand(query, connection); connection.Open(); reader = command.ExecuteReader(); List <ItemSummaryViewModel> itemModelCompanyViewList = new List <ItemSummaryViewModel>(); while (reader.Read()) { itemSummaryViewModel = new ItemSummaryViewModel(); itemSummaryViewModel.CategoryId = Convert.ToInt32(reader["CategoryId"]); itemSummaryViewModel.CategoryName = reader["CategoryName"].ToString(); itemModelCompanyViewList.Add(itemSummaryViewModel); } reader.Close(); connection.Close(); return(itemModelCompanyViewList); }
public async Task <ActionResult> GetPublic(int skip, int take) { Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Cache.SetNoStore(); var user = await User.GetCurrentAsync(); var items = (await _itemRepository.GetPublicAsync(User.Identity.GetUserId(), skip, take)).Select(x => ItemSummaryViewModel.Create(x, user)); return(PartialView("_ItemSummariesPartial", items)); }
public List <ItemSummaryViewModel> GetDetailsByCompanyAndCategory(ItemSummaryViewModel itemSummaryModel) { return(itemSummaryGateway.GetDetailsByCompanyAndCategory(itemSummaryModel)); }
public List <ItemSummaryViewModel> GetAllCategory(ItemSummaryViewModel itemSummaryModel) { return(itemSummaryGateway.GetAllCategory(itemSummaryModel)); }
public List <ItemSummaryViewModel> GetAllCompanyFromStock(ItemSummaryViewModel itemSummaryModel) { return(itemSummaryGateway.GetAllCompanyFromStock(itemSummaryModel)); }
public List <ItemSummaryViewModel> GetDetailsByForAll(ItemSummaryViewModel itemSummaryModel) { return(itemSummaryGateway.GetDetailsByForAll(itemSummaryModel)); }