public static DataTable Search(Data data, int auditId)
{
var sql = String.Empty;
try
{
// formulate SQL
sql = "EXEC dbo.UserPreferenceSearch " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + data.ToSQLParameter(DataColumns.UserPreferenceId) +
", " + data.ToSQLParameter(DataColumns.UserPreferenceKeyId) +
", " + data.ToSQLParameter(DataColumns.UserPreferenceKey) +
", " + data.ToSQLParameter(DataColumns.UserPreferenceCategoryId) +
", " + data.ToSQLParameter(DataColumns.DataTypeId) +
", " + data.ToSQLParameter(DataColumns.Value) +
", " + data.ToSQLParameter(DataColumns.ApplicationUserId);
var oDT = new DataAccess.DBDataTable("UserPreference.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
catch (Exception ex)
{
Log4Net.LogError(sql, MethodBase.GetCurrentMethod().DeclaringType.ToString(), ApplicationId, ex);
throw ex;
}
}
public static DataTable GetTopNUserPreferences(Data data, int topN, int auditId)
{
var sql = String.Empty;
try
{
// formulate SQL
sql = "EXEC dbo.UserPreferenceTopNPreference " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + data.ToSQLParameter(DataColumns.Value) +
", " + data.ToSQLParameter(DataColumns.UserPreferenceKeyId) +
", @TopN = " + Convert.ToString(topN);
var oDT = new DataAccess.DBDataTable("EXEC dbo.UserPreferenceTopNPreference", sql, DataStoreKey);
if (oDT.DBTable != null && oDT.DBTable.Rows.Count > topN) // check if the total no. of records are greater then TopN
{
if (Convert.ToString(oDT.DBTable.Rows[topN + 1]["Value"]) == data.Value) // check the last row's Value. IF it matches the current value passed then remove the 2nd last row.
{
oDT.DBTable.Rows.RemoveAt(topN);
}
else
{
oDT.DBTable.Rows.RemoveAt(topN + 1); //if not then remove the last row.
}
}
return(oDT.DBTable);
}
catch (Exception ex)
{
Log4Net.LogError(sql, MethodBase.GetCurrentMethod().DeclaringType.ToString(), ApplicationId, ex);
throw ex;
}
}
public static int?DoesExist(DomainModel.UserPreferenceCategory data, int auditId)
{
var key = auditId + ", " + data.ToURLQuery();
if (UserPreferenceCategoryCache.ContainsKey(key))
{
return(UserPreferenceCategoryCache[key]);
}
var sql = "EXEC dbo.UserPreferenceCategoryDoesExist " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.Name) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId);
var oDT = new DataAccess.DBDataTable("UserPreferenceCategory.DoesExist", sql, DataStoreKey);
var dt = oDT.DBTable;
if (dt != null && dt.Rows.Count > 0)
{
var id = (int)dt.Rows[0][DomainModel.UserPreferenceCategory.DataColumns.UserPreferenceCategoryId];
UserPreferenceCategoryCache.Add(key, id);
return(id);
}
return(null);
}
public static DataTable SearchRecordsWithMissingHistory(int systemEntityTypeId, RequestProfile requestProfile)
{
var SQL = string.Format("EXEC dbo.FindRecordsWithNoAuditHistory @SystemEntityTypeId = {0}, @auditId = {1}", systemEntityTypeId, requestProfile.AuditId);
var oDT = new DataAccess.DBDataTable("AuditHistory.RecordsWithNoHistory", SQL, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetEntityTestData(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile)
{
var SQL = string.Format("EXEC dbo.GetTestDataCount");
var oDT = new DataAccess.DBDataTable("EXEC GetTestDataCount", SQL, "TaskTimeTracker");
return(oDT.DBTable);
}
public static DataTable GetTestAndAuditDataIds(string Entity, string typeofdata)
{
var SQL = string.Format("EXEC dbo.GetTestAndAuditDataIds @SystemEntityType={0}, @TypeOfData={1}", Entity, typeofdata);
var oDT = new DataAccess.DBDataTable("EXEC GetTestAndAuditDataIds", SQL, "TaskTimeTracker");
return(oDT.DBTable);
}
public static DataTable GetTopNList(int count)
{
var sql = "Select TOP " + count + "* FROM AuditHistory";
var oDT = new DataAccess.DBDataTable("AuditHistory.TopNList", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByApplicationOperation(int applicationOperationId, RequestProfile requestProfile)
{
var sql = "EXEC ApplicationOperationXApplicationRoleDetails " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", @ApplicationOperationId ="+ applicationOperationId;
var oDT = new DataAccess.DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetList(RequestProfile requestProfile)
{
var sql = "EXEC dbo.ApplicationMonitoredEventSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
var oDT = new DataAccess.DBDataTable("ApplicationMonitoredEvent.List", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetDetails(Data data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationDisplayNameDetails " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + data.ToSQLParameter(DataColumns.FieldConfigurationDisplayNameId);
var oDT = new DataAccess.DBDataTable("FieldConfigurationDisplayName.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetList(int auditId)
{
var sql = "EXEC dbo.UserPreferenceKeyList" +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId);
var oDT = new DataAccess.DBDataTable("UserPreferenceKey.List", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetEntityTestDetailData(int systemEntityTypeId, RequestProfile requestProfile)
{
var systemEntityId = Convert.ToString(systemEntityTypeId);
var SQL = string.Format("EXEC AuditTestDataDetails @SystemEntityTypeId = {0}, @AuditId = {1}", systemEntityId, requestProfile.AuditId);
var oDT = new DataAccess.DBDataTable("EXEC GetEntityTestDetailData", SQL, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetDetails(DomainModel.DateRangeTitle data, int auditId)
{
var sql = "EXEC dbo.DateRangeTitleDetails " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.DateRangeTitle.DataColumns.DateRangeTitleId);
var oDT = new DataAccess.DBDataTable("DateRangeTitle.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetDetails(DomainModel.FieldConfigurationModeCategory data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationModeCategoryDetails " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeCategory.DataColumns.FieldConfigurationModeCategoryId);
var oDT = new DataAccess.DBDataTable("FieldConfigurationModeCategory.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetList(int auditId)
{
var sql = "EXEC dbo.FieldConfigurationModeCategoryList" +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId);
var oDT = new DataAccess.DBDataTable("FieldConfigurationModeCategory.List", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetDetails(DomainModel.UserPreferenceKey data, int auditId)
{
var sql = "EXEC dbo.UserPreferenceKeyDetails " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.UserPreferenceKey.DataColumns.UserPreferenceKeyId);
var oDT = new DataAccess.DBDataTable("UserPreferenceKey.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable SearchBrokenHistoryRecords(DataModel.Framework.Audit.AuditHistory data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.FindBrokenHistoryRecords " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.TypeOfIssue) +
", " + ToSQLParameter(data, DataModel.Framework.Audit.AuditHistory.DataColumns.SystemEntityId);
var oDT = new DataAccess.DBDataTable("AuditHistory.FindBrokenHistoryRecords", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable DoesExist(DomainModel.FieldConfigurationModeAccessMode data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationModeAccessModeDoesExist " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + ToSQLParameter(data, StandardModel.StandardDataColumns.Name);
var oDT = new DataAccess.DBDataTable("FieldConfigurationModeAccessMode.DoesExist", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetList(string prefixText, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ApplicationUserSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", @Name='" + prefixText + "'";
var oDT = new DataAccess.DBDataTable("ApplicationUser.List", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetDetails(BatchFileDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.BatchFileSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo, BaseDataManager.ReturnAuditInfoOnDetails) +
", " + ToSQLParameter(data, BatchFileDataModel.DataColumns.BatchFileId);
var oDT = new DataAccess.DBDataTable("BatchFile.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static bool DoesExist(ApplicationMonitoredEventEmailDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ApplicationMonitoredEventEmailSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, ApplicationMonitoredEventEmailDataModel.DataColumns.ApplicationMonitoredEventEmailId);
var oDT = new DataAccess.DBDataTable("ApplicationMonitoredEventEmail.DoesExist", sql, DataStoreKey);
return(oDT.DBTable.Rows.Count > 0);
}
public static DataTable DoesExist(Data data, int auditId)
{
var sql = "EXEC dbo.UserPreferenceDataTypeDoesExist " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + data.ToSQLParameter(DataColumns.UserPreferenceDataTypeId);
var oDT = new DataAccess.DBDataTable("UserPreferenceDataType.DoesExist", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable EventTypeList(NotificationEventTypeDataModel data, RequestProfile requestProfile)
{
// formulate SQL
var sql = "EXEC dbo.NotificationEventTypeSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(data, NotificationEventTypeDataModel.DataColumns.ApplicationId);
var oDT = new DataAccess.DBDataTable("EventType.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetDetailsViewColumns(DomainModel.FieldConfiguration data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationGetDetailsViewColumns " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + ToSQLParameter(data, DomainModel.FieldConfiguration.DataColumns.SystemEntityTypeId);
var oDT = new DataAccess.DBDataTable("FieldConfiguration.GetDetailsViewColumns", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByFieldConfigurationMode(int fieldConfigurationModeId, int auditId)
{
var sql = "EXEC ApplicationModeXFieldConfigurationModeSearch" +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", @FieldConfigurationModeId ="+ fieldConfigurationModeId;
DataStoreKey = SetupConfiguration.GetDataStoreKey("ApplicationModeXFieldConfigurationMode");
var oDT = new DataAccess.DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetDetails(ApplicationUserProfileImageMasterDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.ApplicationUserProfileImageMasterSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
//", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo,BaseDataManager.ReturnAduitInfoOnDetails) +
", " + ToSQLParameter(data, ApplicationUserProfileImageMasterDataModel.DataColumns.ApplicationUserProfileImageMasterId);
var oDT = new DataAccess.DBDataTable("ApplicationUserProfileImageMaster.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetList(int auditId)
{
DataStoreKey = SetupConfiguration.GetDataStoreKey("FieldConfigurationDisplayName");
var sql = "EXEC dbo.FieldConfigurationDisplayNameList" +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId);
var oDT = new DataAccess.DBDataTable("FieldConfigurationDisplayName.List", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable DoesExist(Data data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationDisplayNameDoesExist " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + data.ToSQLParameter(DataColumns.LanguageId) +
", " + data.ToSQLParameter(DataColumns.FieldConfigurationId);
var oDT = new DataAccess.DBDataTable("FieldConfigurationDisplayName.DoesExist", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable CheckDefaultView(FieldConfigurationDataModel data, RequestProfile requestProfile)
{
var sql = "EXEC dbo.CheckDefaultViewList" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, data.ApplicationId) +
", " + ToSQLParameter(data, FieldConfigurationDataModel.DataColumns.FieldConfigurationModeId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DataAccess.DBDataTable("CheckDefaultView", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable Search(DomainModel.DateRangeTitle data, int auditId)
{
// formulate SQL
var sql = "EXEC dbo.DateRangeTitleSearch " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + ToSQLParameter(data, DomainModel.DateRangeTitle.DataColumns.DateRangeTitleId) +
", " + ToSQLParameter(data, StandardModel.StandardDataColumns.Name);
var oDT = new DataAccess.DBDataTable("DateRangeTitle.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
