public void item()
{
List <StockinView> stockinViews = aStockInManager.StockWithCompany();
StockinView defauStockinView = new StockinView();
defauStockinView.ItemId = -1;
defauStockinView.ItemName = "--Select--";
stockinViews.Insert(0, defauStockinView);
itemNameComboBox.DataSource = stockinViews;
itemNameComboBox.DisplayMember = "ItemName";
itemNameComboBox.ValueMember = "ItemId";
}
public List <StockinView> StockWithCompany()
{
Query = "SELECT * FROM StockWithCompany";
Command = new SqlCommand(Query, Connection);
Command.Connection.Open();
Reader = Command.ExecuteReader();
List <StockinView> stockList = new List <StockinView>();
while (Reader.Read())
{
StockinView aStockinView = new StockinView();
aStockinView.CompanyId = (int)Reader["CompanyId"];
aStockinView.ItemId = (int)Reader["ItemId"];
aStockinView.CompanyName = Reader["CompanyName"].ToString();
aStockinView.ItemName = Reader["ItemName"].ToString();
stockList.Add(aStockinView);
}
Reader.Close();
Connection.Close();
return(stockList);
}
