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