public static DataTable GetTopNUserPreferences(UserPreferenceDataModel data, int topN, RequestProfile requestProfile)
{
var sql = String.Empty;
try
{
// formulate SQL
sql = "EXEC dbo.UserPreferenceTopNPreference " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) +
", " + ToSQLParameter(data, UserPreferenceDataModel.DataColumns.Value) +
", " + ToSQLParameter(data, UserPreferenceDataModel.DataColumns.UserPreferenceKeyId) +
", @TopN = " + Convert.ToString(topN);
var oDT = new 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(), requestProfile.ApplicationId, ex);
throw ex;
}
}
public static void Sync(int newApplicationId, int oldApplicationId, RequestProfile requestProfile)
{
// get all records for old Application Id
var sql = "EXEC dbo.LanguageSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, oldApplicationId);
var oDT = new DBDataTable("Language.Search", sql, DataStoreKey);
// formaulate a new request Profile which will have new Applicationid
var newRequestProfile = new RequestProfile();
newRequestProfile.ApplicationId = newApplicationId;
newRequestProfile.AuditId = requestProfile.AuditId;
foreach (DataRow dr in oDT.DBTable.Rows)
{
var data = new LanguageDataModel();
data.ApplicationId = newApplicationId;
data.Name = dr[StandardDataModel.StandardDataColumns.Name].ToString();
// check for existing record in new Application Id
var dt = DoesExist(data, newRequestProfile);
if (dt == null || dt.Rows.Count == 0)
{
data.Description = dr[StandardDataModel.StandardDataColumns.Description].ToString();
data.SortOrder = Convert.ToInt32(dr[StandardDataModel.StandardDataColumns.SortOrder]);
//create in new application id
Create(data, newRequestProfile);
}
}
}
public static DataTable GetByParentReleaseLogDetail(int parentReleaseLogDetailId, RequestProfile requestProfile)
{
var sql = "EXEC ReleaseLogDetailMappingSearchByPublishItem @ParentReleaseLogDetailId ="+ parentReleaseLogDetailId + ", " +
"@AuditId =" + requestProfile.AuditId;
var oDt = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDt.DBTable);
}
public static DataTable GetScheduleDetailDistinctList()
{
var sql = "EXEC dbo.ScheduleDetailDistinctSearch ";
var oDT = new DBDataTable("Get List", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByTask(int TaskId, int auditId)
{
var sql = "EXEC TaskXDeliverableArtifactSearch @TaskId=" + TaskId + ", " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, auditId);
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByProductivityArea(int productivityAreaId, int auditId)
{
var sql = "EXEC ProductivityAreaXProductivityAreaFeatureSearch @ProductivityAreaId ="+ productivityAreaId + ", " +
"@AuditId ="+ auditId;
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByApplicationUser(int applicationUserId, int auditId)
{
var sql = "EXEC ProductivityAreaFeatureXApplicationUserSearch @ApplicationUserId ="+ applicationUserId + ", " +
"@AuditId ="+ auditId;
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByTask(int taskId, RequestProfile requestProfile)
{
var sql = "EXEC TaskXApplicationUserDetails @TaskId ="+ taskId + ", " +
"@AuditId ="+ requestProfile.AuditId;
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByDevelopment(int developmentId, RequestProfile requestProfile)
{
var sql = "EXEC ReleaseLogDetailMappingSearchByDevelopmentItem @DevelopmentId=" + developmentId + ", " +
"@AuditId =" + requestProfile.AuditId;
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByFeature(int FeatureId, RequestProfile requestProfile)
{
var sql = "EXEC FeatureGroupXFeatureSearch @FeatureId =" + FeatureId + ", " +
"@AuditId=" + requestProfile.AuditId;
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
//public static List<ScheduleDataModel> GetEntityDetails(ScheduleDataModel data, int auditId)
//{
// var sql = "EXEC dbo.ScheduleSearch " +
// " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, auditId) +
// ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ReturnAuditInfo, BaseDataManager.ReturnAuditInfoOnDetails) +
// ", " + ToSQLParameter(data, ScheduleDataModel.DataColumns.ScheduleId);
// var result = new List<ScheduleDataModel>();
// using (var reader = new DBDataReader("Get Details", sql, DataStoreKey))
// {
// var dbReader = reader.DBReader;
// while (dbReader.Read())
// {
// var dataItem = new ScheduleDataModel();
// dataItem.ScheduleId = (int?)dbReader[ScheduleDataModel.DataColumns.ScheduleId];
// dataItem.Person = (string)dbReader[ScheduleDataModel.DataColumns.Person];
// dataItem.PersonId = (int?)dbReader[ScheduleDataModel.DataColumns.PersonId];
// dataItem.ScheduleStateId = (int?)dbReader[ScheduleDataModel.DataColumns.ScheduleStateId];
// dataItem.WorkDate = (DateTime?)dbReader[ScheduleDataModel.DataColumns.WorkDate];
// dataItem.StartTime = (DateTime?)dbReader[ScheduleDataModel.DataColumns.StartTime];
// dataItem.EndTime = (DateTime?)dbReader[ScheduleDataModel.DataColumns.EndTime];
// dataItem.NextWorkDate = (DateTime?)dbReader[ScheduleDataModel.DataColumns.NextWorkDate];
// dataItem.NextWorkTime = (DateTime?)dbReader[ScheduleDataModel.DataColumns.NextWorkTime];
// dataItem.TotalHoursWorked = (decimal?)dbReader[ScheduleDataModel.DataColumns.TotalHoursWorked];
// if (dbReader[ScheduleDataModel.DataColumns.ComputedHours] != DBNull.Value)
// {
// dataItem.ComputedHours = Convert.ToDecimal(dbReader[ScheduleDataModel.DataColumns.ComputedHours]);
// }
// dataItem.ScheduleStateName = (string)dbReader[ScheduleDataModel.DataColumns.ScheduleStateName];
// dataItem.CreatedDate = (DateTime)dbReader[BaseDataModel.BaseDataColumns.CreatedDate];
// dataItem.ModifiedDate = (DateTime)dbReader[BaseDataModel.BaseDataColumns.ModifiedDate];
// dataItem.CreatedByAuditId = (int?)dbReader[BaseDataModel.BaseDataColumns.CreatedByAuditId];
// dataItem.ModifiedByAuditId = (int?)dbReader[BaseDataModel.BaseDataColumns.ModifiedByAuditId];
// //dataItem.CreatedDate = (DateTime)dbReader[ScheduleDataModel.DataColumns.CreatedDate];
// //dataItem.ModifiedDate = (DateTime)dbReader[ScheduleDataModel.DataColumns.ModifiedDate];
// //dataItem.CreatedByAuditId = (int?)dbReader[ScheduleDataModel.DataColumns.CreatedByAuditId];
// //dataItem.ModifiedByAuditId = (int?)dbReader[ScheduleDataModel.DataColumns.ModifiedByAuditId];
// SetBaseInfo(dataItem, dbReader);
// result.Add(dataItem);
// }
// }
// return result;
//}
#endregion
#region GroupByPerson
public static DataTable GroupByPerson(ScheduleDataModel data)
{
var sql = "EXEC dbo.ScheduleGroupByPerson " + ToSQLParameter(data, ScheduleDataModel.DataColumns.PersonId);
var oDt = new DBDataTable("Schedule.GroupByPerson", sql, DataStoreKey);
return(oDt.DBTable);
}
public static DataTable GetBySystemEntity(int SystemEntityId, RequestProfile requestProfile)
{
var sql = "EXEC SystemEntityXSystemEntityCategorySearch @SystemEntityId =" + SystemEntityId + ", " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetSampleSearch()
{
var sql = "EXEC dbo.ScheduleSampleSearch ";
var oDt = new DBDataTable("Schedule.Search", sql, DataStoreKey);
return(oDt.DBTable);
}
public static DataTable GetByTask(int TaskId, int auditId)
{
var sql = "EXEC FeatureXTaskSearch @TaskId ="+ TaskId + ", " +
"@AuditId ="+ auditId;
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByApplicationUser(int applicationUserId, RequestProfile requestProfile)
{
var sql = "EXEC TaskPackageXOwnerXTaskDetails @ApplicationUserId ="+ applicationUserId + ", " +
"@AuditId ="+ requestProfile.AuditId;
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByTestSuite(int testSuiteId, RequestProfile requestProfile)
{
var sql = "EXEC TestSuiteXTestCaseSearch @TestSuiteId =" + testSuiteId + ", " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByApplicationUser(int applicationUserId, RequestProfile requestProfile)
{
var sql = "EXEC FieldConfigurationModeXApplicationUserSearch @ApplicationUserId =" + applicationUserId + ", " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GroupByKey(CustomTimeLogDataModel data)
{
var sql = "EXEC dbo.CustomTimeLogGroupByKey " + ToSQLParameter(data, CustomTimeLogDataModel.DataColumns.CustomTimeLogId);
var oDt = new DBDataTable("CustomTimeLog.GroupByKey", sql, DataStoreKey);
return(oDt.DBTable);
}
public static DataTable GetList(RequestProfile requestProfile)
{
var sql = "EXEC dbo.ScheduleSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDt = new DBDataTable("Schedule.List", sql, DataStoreKey);
return(oDt.DBTable);
}
public static DataTable GetList(RequestProfile requestProfile)
{
var sql = "EXEC dbo.ReleaseNoteBusinessValueSearch" +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
var oDT = new DBDataTable("Get List", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetList(RequestProfile requestProfile)
{
var sql = "EXEC dbo.ReportXReportCategorySearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DBDataTable("ReportXReportCategory.List", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetList(RequestProfile requestProfile)
{
var sql = "EXEC dbo.ConnectionStringSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DBDataTable("ConnectionString.List", sql, DataStoreKey);
return(oDT.DBTable);
}
//#region GetList
//public static DataTable GetList(int applicationId, int auditId)
//{
// var sql = "EXEC dbo.NotificationSubscriberList "
// + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, applicationId)
// + "," + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, auditId);
// var oDT = new Framework.Components.DataAccess.DBDataTable("Get List", sql, DataStoreKey);
// return oDT.DBTable;
//}
//#endregion GetList
public static DataTable GetList(RequestProfile requestProfile)
{
var sql = "EXEC dbo.NotificationSubscriberSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId)
+ ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
var oDT = new DBDataTable("NotificationSubscriber.GetList", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetList(RequestProfile requestProfile)
{
var sql = "EXEC dbo.TaskXActivityInstanceSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId)
+ ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId);
var oDT = new DBDataTable("TaskXActivityInstance.GetList", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByFunctionality(int functionalityId, RequestProfile requestProfile)
{
var sql = "EXEC FunctionalityXFunctionalityActiveStatusSearch @FunctionalityId =" + functionalityId + ", " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByNeed(int needId, RequestProfile requestProfile)
{
var sql = "EXEC ProjectXNeedSearch @NeedId =" + needId + ", " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByProject(int projectId, int auditId)
{
var sql = "EXEC ProjectXNeedSearch @ProjectId =" + projectId + ", " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, auditId);
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetBySchedule(int scheduleId, RequestProfile requestProfile)
{
var sql = "EXEC ScheduleQuestionSearch @ScheduleId =" + scheduleId + ", " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByEntity(int EntityId, RequestProfile requestProfile)
{
var sql = "EXEC EntityXWorkTicketSearch @EntityId =" + EntityId + ", " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId);
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
public static DataTable GetByApplication(int applicationId, RequestProfile requestProfile)
{
var sql = "EXEC ConnectionStringXApplicationSearch " +
" " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) +
", @ApplicationId ="+ applicationId;
var oDT = new DBDataTable("GetDetails", sql, DataStoreKey);
return(oDT.DBTable);
}
