public Billings RetrieveClientBills(string id)
{
Billings billings = new Billings();
try
{
string query = string.Format("select * from dsto_billing where clientId='{0}' and and Deleted=0", id);
var table = DbInfo.ExecuteSelectQuery(query);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Billing billing = billings.Add();
SetBilling(billing, row);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(billings);
}
public Billings RetrieveBills()
{
Billings billings = new Billings();
try
{
string query = "select * from dsto_billing where Deleted=0";
var table = DbInfo.ExecuteSelectQuery(query);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Billing billing = billings.Add();
SetBilling(billing, row);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(billings);
}