public List <PurchaseShow> ShowPurchaseProduct(string purchaseCode)
{
List <PurchaseShow> purchaseProductShows = new List <PurchaseShow>();
Connect();
query = "SELECT ProductsView.Code, Product, Quantity, UnitPrice, MRP, TotalPrice FROM PurchaseView, ProductsView WHERE PurchaseView.Product = ProductsView.Name AND PurchaseView.Code = '" + purchaseCode + "'";
_sqlCommand = new SqlCommand {
CommandText = query, Connection = DatabaseConnection.sqlConnection
};
_sqlDataReader = _sqlCommand.ExecuteReader();
while (_sqlDataReader.Read())
{
PurchaseShow aPurchaseShow = new PurchaseShow
{
ProductCode = _sqlDataReader["Code"].ToString(),
Product = _sqlDataReader["Product"].ToString(),
Quantity = Convert.ToInt32(_sqlDataReader["Quantity"]),
UnitPrice = Convert.ToDouble(_sqlDataReader["UnitPrice"]),
MRP = Convert.ToDouble(_sqlDataReader["MRP"]),
TotalPrice = Convert.ToDouble(_sqlDataReader["TotalPrice"])
};
purchaseProductShows.Add(aPurchaseShow);
}
DatabaseConnection.sqlConnection.Close();
return(purchaseProductShows);
}
public List <PurchaseShow> SearchPurchase(string searchItem)
{
List <PurchaseShow> purchaseShows = new List <PurchaseShow>();
Connect();
query = "SELECT Distinct(Code), Date, Supplier, BillNo FROM PurchaseView WHERE Code LIKE '%" + searchItem + "%' OR Date LIKE '%" + searchItem + "%' ";
_sqlCommand = new SqlCommand {
CommandText = query, Connection = DatabaseConnection.sqlConnection
};
_sqlDataReader = _sqlCommand.ExecuteReader();
while (_sqlDataReader.Read())
{
PurchaseShow aPurchaseShow = new PurchaseShow
{
Date = Convert.ToDateTime(_sqlDataReader["Date"]),
PurchaseCode = _sqlDataReader["Code"].ToString(),
Supplier = _sqlDataReader["Supplier"].ToString(),
Invoice = _sqlDataReader["BillNo"].ToString(),
};
purchaseShows.Add(aPurchaseShow);
}
DatabaseConnection.sqlConnection.Close();
return(purchaseShows);
}
