private IList <Sale> _FindFilteredCollection(DateTime?start, DateTime?end, Customer customer, Status invoiceStatus)
{
DbCriteria criteria = CreateCriteria();
criteria
.IsGreaterEqual("Sales", "InvoiceDate", start)
.IsLessEqual("Sales", "InvoiceDate", end);
if (customer != null)
{
criteria.IsEqual("Customers", "CardIdentification", customer.CardIdentification);
}
if (invoiceStatus != null)
{
criteria.IsEqual("Sales", "InvoiceStatusID", invoiceStatus.StatusID);
}
Currencies.CurrencyManager cm = RepositoryMgr.CurrencyMgr;
bool support_multi_currency = cm.SupportMultiCurrency;
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectAll()
.From("Sales")
.OrderBy("Sales", "InvoiceDate", "ASC")
.Criteria.And(criteria);
BindingList <Sale> sales = new BindingList <Sale>();
Dictionary <int, int> currencyIds = new Dictionary <int, int>();
DbCommand _cmd = CreateDbCommand(clause);
DbDataReader _reader = _cmd.ExecuteReader();
while (_reader.Read())
{
Sale _obj = CreateDbEntity();
LoadFromReader(_obj, _reader);
sales.Add(_obj);
}
_reader.Close();
_cmd.Dispose();
return(sales);
}
public List <Definitions.Status> ListPurchaseStatus()
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectDistinct()
.SelectColumn("RecurringPurchases", "PurchaseStatusID")
.From("RecurringPurchases");
DbCriteria criteria = DbMgr.CreateCriteria();
DbCommand _cmd = CreateDbCommand(clause);
DbDataReader _reader = _cmd.ExecuteReader();
while (_reader.Read())
{
criteria.IsEqual("Status", "StatusID", GetString(_reader, ("PurchaseStatusID")), DbCriteria.ConcatMode.OR);
}
_reader.Close();
_cmd.Dispose();
return(RepositoryMgr.StatusMgr.List(criteria));
}
private IList <Item> _FindFilteredCollection(bool sold, bool bought, bool inventoried, Dictionary <string, string> keywords)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectAll()
.From("Items");
DbCriteria criteria = clause.Criteria;
if (sold)
{
criteria.IsEqual("Items", "ItemIsSold", "Y");
}
if (bought)
{
criteria.IsEqual("Items", "ItemIsBought", "Y");
}
if (inventoried)
{
criteria.IsEqual("Items", "ItemIsInventoried", "Y");
}
foreach (string key in keywords.Keys)
{
criteria.Like("Items", key, keywords[key]);
}
BindingList <Item> _grp = new BindingList <Item>();
Currencies.CurrencyManager cm = RepositoryMgr.CurrencyMgr;
DbCommand _cmd = CreateDbCommand(clause);
DbDataReader _reader = _cmd.ExecuteReader();
while (_reader.Read())
{
Item _obj = CreateDbEntity();
LoadFromReader(_obj, _reader);
_grp.Add(_obj);
}
_reader.Close();
_cmd.Dispose();
return(_grp);
}
private IList <Purchase> _FindFilteredCollection(DateTime?start, DateTime?end, Supplier supplier, Status purchaseStatus)
{
DbCriteria criteria = CreateCriteria();
criteria
.IsGreaterEqual("Purchases", "PurchaseDate", start)
.IsLessEqual("Purchases", "PurchaseDate", end);
if (supplier != null)
{
criteria.IsEqual("Suppliers", "CardIdentification", supplier.CardIdentification);
}
if (purchaseStatus != null)
{
criteria.IsEqual("Purchases", "PurchaseStatusID", purchaseStatus.StatusID);
}
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectAll()
.From("Purchases")
.OrderBy("Purchases", "PurchaseDate", "ASC")
.Criteria.And(criteria);
BindingList <Purchase> purchases = new BindingList <Purchase>();
DbCommand _cmd = CreateDbCommand(clause);
DbDataReader _reader = _cmd.ExecuteReader();
while (_reader.Read())
{
Purchase _obj = CreateDbEntity();
LoadFromReader(_obj, _reader);
purchases.Add(_obj);
}
_reader.Close();
_cmd.Dispose();
return(purchases);
}
public List <SaleRow> ListLight(DateTime start, DateTime end, Customer customer, Status invoiceStatus, int?startIndex, int?pageSize)
{
DbCriteria criteria = mAccountant.SaleMgr.CreateCriteria();
criteria
.IsGreaterEqual("Sales", "InvoiceDate", start)
.IsLessEqual("Sales", "InvoiceDate", end);
if (customer != null)
{
criteria.IsEqual("Customers", "CardIdentification", customer.CardIdentification);
}
if (invoiceStatus != null)
{
criteria.IsEqual("Sales", "InvoiceStatusID", invoiceStatus.StatusID);
}
return(mAccountant.SaleMgr.ListTableRow(criteria, startIndex, pageSize));
}
public int GetSaleCount(DateTime start, DateTime end, Customer customer, Status invoiceStatus)
{
DbCriteria criteria = mAccountant.SaleMgr.CreateCriteria();
criteria
.IsGreaterEqual("Sales", "InvoiceDate", start)
.IsLessEqual("Sales", "InvoiceDate", end);
if (customer != null)
{
criteria.IsEqual("Customers", "CardIdentification", customer.CardIdentification);
}
if (invoiceStatus != null)
{
criteria.IsEqual("Sales", "InvoiceStatusID", invoiceStatus.StatusID);
}
return(mAccountant.SaleMgr.GetPageCount(criteria));
}
public List <Status> ListPurchaseStatus()
{
DbCriteria criteria = DbMgr.CreateCriteria();
criteria
.IsEqual("Status", "StatusID", "O", DbCriteria.ConcatMode.OR)
.IsEqual("Status", "StatusID", "C", DbCriteria.ConcatMode.OR)
.IsEqual("Status", "StatusID", "OR", DbCriteria.ConcatMode.OR)
.IsEqual("Status", "StatusID", "DR", DbCriteria.ConcatMode.OR)
.IsEqual("Status", "StatusID", "Q", DbCriteria.ConcatMode.OR);
return(List(criteria));
}
protected virtual IList <Status> _FindSaleStatusCollection()
{
DbCriteria criteria = DbMgr.CreateCriteria();
criteria
.IsEqual("Status", "StatusID", "O", DbCriteria.ConcatMode.OR)
.IsEqual("Status", "StatusID", "C", DbCriteria.ConcatMode.OR)
.IsEqual("Status", "StatusID", "OR", DbCriteria.ConcatMode.OR)
.IsEqual("Status", "StatusID", "CR", DbCriteria.ConcatMode.OR)
.IsEqual("Status", "StatusID", "Q", DbCriteria.ConcatMode.OR);
return(List(criteria));
}