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