public void BindToSaleNo()
{
SaleController saleController = new SaleController();
SaleCollection saleCollection = saleController.SelectList();
SaleInfo saleInfo = new SaleInfo();
saleInfo.SaleNo = "-Select One";
saleInfo.SaleID = null;
saleCollection.Insert(0, saleInfo);
this.cboToSaleInvoiceNo.DisplayMember = "SaleNo";
this.cboToSaleInvoiceNo.ValueMember = "SaleID";
this.cboToSaleInvoiceNo.DataSource = saleCollection;
this.cboToSaleInvoiceNo.SelectedIndex = 0;
}
private void BindToSaleNo()
{
SaleController saleController = new SaleController();
SaleCollection saleCollection = saleController.SelectList();
SaleInfo info = new SaleInfo();
info.SaleNo = " - Select One - ";
info.SaleID = null;
saleCollection.Insert(0, info);
cboToSaleNo.DisplayMember = "SaleNo";
cboToSaleNo.ValueMember = "SaleID";
cboToSaleNo.DataSource = saleCollection;
cboToSaleNo.SelectedIndex = 0;
}
public SaleCollection SelectList()
{
SaleCollection collection = new SaleCollection();
IDataReader Reader = SaleDataAccess.SelectList();
while (Reader.Read())
{
SaleInfo saleInfo = new SaleInfo();
saleInfo.SaleID = Convert.ToString(Reader["SaleID"]);
saleInfo.SaleNo = Convert.ToString(Reader["SaleNo"]);
saleInfo.SaleDate = Convert.ToDateTime(Reader["SaleDate"]);
saleInfo.Quantity = Convert.ToInt32(Reader["Quantity"]);
saleInfo.CustomerID = Convert.ToString(Reader["CustomerID"]);
collection.Add(saleInfo);
}
Reader.Close();
return(collection);
}
