public bool CanDeleteByRoleID(int?RoleID)
{
if (RoleID == null)
{
return(false);
}
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("AuthRoleRole")
.Criteria
.IsEqual("AuthRoleRole", "ChildRoleID", RoleID.Value);
if (ExecuteScalarInt(clause) != 0)
{
return(false);
}
clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("AuthUser")
.Criteria
.IsEqual("AuthUser", "RoleID", RoleID.Value);
if (ExecuteScalarInt(clause) != 0)
{
return(false);
}
return(true);
}
public bool CanDelete(int?ItemID)
{
if (ItemID == null)
{
return(false);
}
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("AuthRoleItem")
.Criteria
.IsEqual("AuthRoleItem", "ItemID", ItemID.Value);
if (ExecuteScalarInt(clause) != 0)
{
return(false);
}
clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("AuthItem")
.Criteria
.IsEqual("AuthItem", "ParentItemID", ItemID.Value);
if (ExecuteScalarInt(clause) != 0)
{
return(false);
}
return(true);
}
public bool HasUser(string username)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount().From("AuthUser").Criteria.IsEqual("AuthUser", "AuthUsername", username);
return(ExecuteScalarInt(clause) != 0);
}
private DbSelectStatement GetQuery_SelectCountByCompanyName(string companyName)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount().From("DataFileInformation").Criteria.IsEqual("DataFileInformation", "CompanyName", companyName);
return(clause);
}
public DbSelectStatement GetQuery_SelectCount()
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("Currency");
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByRecurringGeneralJournalLineID(int RecurringGeneralJournalLineID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount()
.From("RecurringGeneralJournalLines")
.Criteria.IsEqual("RecurringGeneralJournalLines", "RecurringGeneralJournalLineID", RecurringGeneralJournalLineID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByCardTypeID(string CardTypeID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("CardTypes")
.Criteria.IsEqual("CardTypes", "CardTypeID", CardTypeID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByItemID(int ItemID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount()
.From("Items")
.Criteria.IsEqual("Items", "ItemID", ItemID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByItemNumber(string ItemNumber)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount()
.From("Items")
.Criteria.IsEqual("Items", "ItemNumber", ItemNumber);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByBillingRateUsedID(string BillingRateUsedID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount()
.From("BillingRateUsed")
.Criteria.IsEqual("BillingRateUsed", "BillingRateUsedID", BillingRateUsedID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByRecurringMoneySpentID(int RecurringMoneySpentID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount()
.From("RecurringMoneySpent")
.Criteria
.IsEqual("RecurringMoneySpent", "RecurringMoneySpentID", RecurringMoneySpentID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByGeneralJournalNumber(string GeneralJournalNumber)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("GeneralJournals")
.Criteria.IsEqual("GeneralJournals", "GeneralJournalNumber", GeneralJournalNumber);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByCustomListID(int CustomListID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("CustomLists")
.Criteria.IsEqual("CustomLists", "CustomListID", CustomListID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByStatusID(string StatusID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount()
.From("Status")
.Criteria.IsEqual("Status", "StatusID", StatusID);
return(clause);
}
protected DbSelectStatement GetQuery_SelectCountBySubAccountTypeID(string SubAccountTypeID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount()
.From("SubAccountTypes")
.Criteria.IsEqual("SubAccountTypes", "SubAccountTypeID", SubAccountTypeID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByMoneyReceivedID(int MoneyReceivedID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount()
.From("MoneyReceived")
.Criteria
.IsEqual("MoneyReceived", "MoneyReceivedID", MoneyReceivedID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByJobBudgetID(int JobBudgetID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount()
.From("JobBudgets")
.Criteria
.IsEqual("JobBudgets", "JobBudgetID", JobBudgetID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByDebitRefundID(int DebitRefundID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("DebitRefunds")
.Criteria
.IsEqual("DebitRefunds", "DebitRefundID", DebitRefundID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountBySupplierPaymentLineID(int SupplierPaymentLineID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("SupplierPaymentLines")
.Criteria
.IsEqual("SupplierPaymentLines", "SupplierPaymentLineID", SupplierPaymentLineID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByRecordID(int CardRecordID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("Cards")
.Criteria.IsEqual("Cards", "CardRecordID", CardRecordID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByActivityID(int ActivityID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("Activities")
.Criteria.IsEqual("Activities", "ActivityID", ActivityID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountBySalesHistoryID(int SalesHistoryID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("SalesHistory")
.Criteria
.IsEqual("SalesHistory", "SalesHistoryID", SalesHistoryID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByEmployeeID(int EmployeeID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("Employees")
.Criteria.IsEqual("Employees", "EmployeeID", EmployeeID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByCardIdentification(string CardIdentification)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("Employees")
.Criteria.IsEqual("Employees", "CardIdentification", CardIdentification);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByReportingMethodID(string ReportingMethodID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount()
.From("ReportingMethod")
.Criteria
.IsEqual("ReportingMethod", "ReportingMethodID", ReportingMethodID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountByCurrencyCode(string CurrencyCode)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("Currency")
.Criteria.IsEqual("Currency", "CurrencyCode", CurrencyCode);
return(clause);
}
protected DbSelectStatement GetQuery_SelectCountByAccountBudgetID(int AccountBudgetID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("AccountBudgets")
.Criteria.IsEqual("AccountBudgets", "AccountBudgetID", AccountBudgetID);
return(clause);
}
public bool HasAuthUsers()
{
if (!DbMgr.TableExists("AuthUser"))
{
return(false);
}
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause.SelectCount().From("AuthUser");
return(ExecuteScalarInt(clause) != 0);
}
private DbSelectStatement GetQuery_SelectCountbyInvoiceDeliverID(string InvoiceDeliveryID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("InvoiceDelivery")
.Criteria.IsEqual("InvoiceDelivery", "InvoiceDeliveryID", InvoiceDeliveryID);
return(clause);
}
private DbSelectStatement GetQuery_SelectCountBySettledCreditID(int SettledCreditID)
{
DbSelectStatement clause = DbMgr.CreateSelectClause();
clause
.SelectCount()
.From("SettledCredits")
.Criteria
.IsEqual("SettledCredits", "SettledCreditID", SettledCreditID);
return(clause);
}
