public List <StockOutViewModel> GetAllItemByCompany(StockOutViewModel stockOutViewModel) { stockOutViewModel.Type = "Buy"; string query = "GETALLITEMBYCOMPANY"; command = new SqlCommand(query, connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@company", stockOutViewModel.CompanySl); connection.Open(); reader = command.ExecuteReader(); List <StockOutViewModel> stockOutModelList = new List <StockOutViewModel>(); while (reader.Read()) { stockOutViewModel = new StockOutViewModel(); stockOutViewModel.ItemSl = Convert.ToInt32(reader["ItemSl"]); stockOutViewModel.ItemName = reader["ItemName"].ToString(); stockOutModelList.Add(stockOutViewModel); } reader.Close(); connection.Close(); return(stockOutModelList); }
public IActionResult StockOut() { StockOutViewModel model = new StockOutViewModel(); model.detailProductList = products; model.outList = outList; return(View(model)); }
private void ItemListByCompany(StockOutViewModel stockOutViewModel) { itemDropDownList.DataSource = stockOutManager.GetAllItemByCompany(stockOutViewModel); itemDropDownList.DataTextField = "ItemName"; itemDropDownList.DataValueField = "ItemSl"; itemDropDownList.DataBind(); itemDropDownList.Items.Insert(0, new ListItem("Select a Item")); }
private void CompanyList(StockOutViewModel stockOutViewModel) { companyDropDownList.DataSource = stockOutManager.GetAllCompanyFromStock(stockOutViewModel); companyDropDownList.DataTextField = "CompanyName"; companyDropDownList.DataValueField = "CompanySl"; companyDropDownList.DataBind(); companyDropDownList.Items.Insert(0, new ListItem("Select a Company")); }
private void GetQuantityByItem(StockOutViewModel stockOutViewModel) { stockOutViewModel = stockOutManager.GetQuantityByItem(stockOutViewModel); if (stockOutViewModel == null) { availabelQuantityTextBox.Text = "0"; } else { availabelQuantityTextBox.Text = stockOutViewModel.Quantity.ToString(); } }
private void GetReorderByItem(StockOutViewModel stockOutViewModel) { stockOutViewModel = stockOutManager.GetReorderByItem(stockOutViewModel); //availableQuantityTextBox.Text = stockInModel.AvailableQuantity.ToString(); if (stockOutViewModel == null) { reorderLevelTextBox.Text = "0"; } else { reorderLevelTextBox.Text = stockOutViewModel.ReorderLevel.ToString(); } }
public List <StockOutViewModel> GetAllCompanyFromStock(StockOutViewModel stockOutViewModel) { string query = "CompanyByIdProcedure"; command = new SqlCommand(query, connection); connection.Open(); reader = command.ExecuteReader(); List <StockOutViewModel> itemModelCompanyViewList = new List <StockOutViewModel>(); while (reader.Read()) { stockOutViewModel = new StockOutViewModel(); stockOutViewModel.CompanySl = Convert.ToInt32(reader["CompanyId"]); stockOutViewModel.CompanyName = reader["CompanyName"].ToString(); itemModelCompanyViewList.Add(stockOutViewModel); } reader.Close(); connection.Close(); return(itemModelCompanyViewList); }
public StockOutViewModel GetQuantityByItem(StockOutViewModel stockOutViewModel) { string query = "TotalStock"; command = new SqlCommand(query, connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@item", stockOutViewModel.ItemName); connection.Open(); reader = command.ExecuteReader(); reader.Read(); stockOutViewModel = null; if (reader.HasRows) { stockOutViewModel = new StockOutViewModel(); stockOutViewModel.Quantity = Convert.ToInt32(reader["Quantity"]); } reader.Close(); connection.Close(); return(stockOutViewModel); }
public StockOutViewModel GetReorderByItem(StockOutViewModel stockOutViewModel) { string query = "GETREORDERBYITEMCOMPANY"; command = new SqlCommand(query, connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@item", stockOutViewModel.ItemSl); command.Parameters.AddWithValue("@company", stockOutViewModel.CompanySl); connection.Open(); reader = command.ExecuteReader(); reader.Read(); stockOutViewModel = null; if (reader.HasRows) { stockOutViewModel = new StockOutViewModel(); stockOutViewModel.ReorderLevel = Convert.ToInt32(reader["ReorderLevel"]); } reader.Close(); connection.Close(); return(stockOutViewModel); }
public List <StockOutViewModel> SearchByDate(string fromdate, string todate, string actionType) { SetConnection(); string query = "SELECT * FROM StockOutView WHERE Date BETWEEN @fromDate " + "AND @todate AND Action = @action"; command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@fromDate", fromdate); command.Parameters.AddWithValue("@todate", todate); command.Parameters.AddWithValue("@action", actionType); connection.Open(); List <StockOutViewModel> AllCompanyItem = new List <StockOutViewModel>(); reader = command.ExecuteReader(); while (reader.Read()) { StockOutViewModel stockOut = new StockOutViewModel(); stockOut.ItemId = Convert.ToInt32(reader["ItemId"]); stockOut.ItemName = reader["ItemName"].ToString(); stockOut.AvailableQuantity = Convert.ToInt32(reader["AvailableQuantity"]); stockOut.CompanyId = Convert.ToInt32(reader["CompanyId"]); stockOut.CompanyName = reader["CompanyName"].ToString(); stockOut.StockOutId = Convert.ToInt32(reader["StockOutId"]); stockOut.Action = reader["Action"].ToString(); stockOut.Quantity = Convert.ToInt32(reader["Quantity"]); stockOut.Date = reader["Date"].ToString(); AllCompanyItem.Add(stockOut); } reader.Close(); connection.Close(); return(AllCompanyItem); }
//StockOutViewModel vmodel = new StockOutViewModel(); private void addStockOutButton_Click(object sender, EventArgs e) { try { int flag = 0; StockOutViewModel vmodel = new StockOutViewModel(); string categryName = categoryStockOutComboBox.Text; string companyName = companyStockOutComboBox.Text; string itemName = itemStockOutComboBox.Text; string quantityStockOut = quantityStockOutTextBox.Text; if (String.IsNullOrEmpty(categryName) || String.IsNullOrEmpty(companyName) || String.IsNullOrEmpty(itemName) || String.IsNullOrEmpty(quantityStockOut) || Convert.ToInt32(quantityStockOutTextBox.Text) == 0) { messageLabel.Text = (" Fill Up The Required Information"); messageLabel.ForeColor = Color.Red; } else { int availableQuantity = Convert.ToInt32(availableViewTextBox.Text); int stockOutQuantity = Convert.ToInt32(quantityStockOutTextBox.Text); if (stockOutQuantity > availableQuantity) { messageLabel.Text = " Requested Quantity Is Not Available"; messageLabel.ForeColor = Color.Red; } else { vmodel.Item = itemStockOutComboBox.Text; vmodel.Company = companyStockOutComboBox.Text; vmodel.Quantity = Convert.ToInt32(quantityStockOutTextBox.Text); foreach (var viewm in viewModel) { if (viewm.Item == itemStockOutComboBox.Text) { flag = 1; viewm.Quantity += Convert.ToInt32(quantityStockOutTextBox.Text); break; } } if (flag == 0) { viewModel.Add(vmodel); } if (viewModel.Count == 0) { viewModel.Add(vmodel); } ProductListDataGridView.DataSource = null; ProductListDataGridView.DataSource = viewModel; ProductListDataGridView.AutoGenerateColumns = false; itemStockOutComboBox.Text = ""; clearReoderQuantityAvilable(); } } } catch (Exception exception) { MessageBox.Show(exception.Message); } }
public StockOutViewModel GetQuantityByItem(StockOutViewModel stockOutModel) { return(stockOutGateway.GetQuantityByItem(stockOutModel)); }
public StockOutViewModel GetReorderByItem(StockOutViewModel stockOutModel) { return(stockOutGateway.GetReorderByItem(stockOutModel)); }
public List <StockOutViewModel> GetAllItemByCompany(StockOutViewModel stockOutModel) { return(stockOutGateway.GetAllItemByCompany(stockOutModel)); }
public List <StockOutViewModel> GetAllCompanyFromStock(StockOutViewModel stockOutModel) { return(stockOutGateway.GetAllCompanyFromStock(stockOutModel)); }