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); }