public static List <SearchKeyDetailItemDataModel> GetEntityDetails(SearchKeyDetailItemDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.SearchKeyDetailItemSearch "; var parameters = new { AuditId = requestProfile.AuditId , SearchKeyDetailItemId = dataQuery.SearchKeyDetailItemId , SearchKeyDetailId = dataQuery.SearchKeyDetailId , ApplicationMode = requestProfile.ApplicationModeId , Name = dataQuery.Value , ApplicationId = dataQuery.ApplicationId , ReturnAuditInfo = returnAuditInfo }; List <SearchKeyDetailItemDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <SearchKeyDetailItemDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
private static string CreateOrUpdate(SearchKeyDetailItemDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.SearchKeyDetailItemInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.SearchKeyDetailItemUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, SearchKeyDetailItemDataModel.DataColumns.SearchKeyDetailItemId) + ", " + ToSQLParameter(data, SearchKeyDetailItemDataModel.DataColumns.SearchKeyDetailId) + ", " + ToSQLParameter(data, SearchKeyDetailItemDataModel.DataColumns.Value) + ", " + ToSQLParameter(data, SearchKeyDetailItemDataModel.DataColumns.SortOrder); return(sql); }
public static DataTable DoesExist(SearchKeyDetailItemDataModel data, RequestProfile requestProfile) { var doesExistRequest = new SearchKeyDetailItemDataModel(); doesExistRequest.SearchKeyDetailItemId = data.SearchKeyDetailItemId; return(Search(doesExistRequest, requestProfile)); }
public static DataTable Search(SearchKeyDetailItemDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
public static string ToSQLParameter(SearchKeyDetailItemDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case SearchKeyDetailItemDataModel.DataColumns.SearchKeyDetailItemId: if (data.SearchKeyDetailItemId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SearchKeyDetailItemDataModel.DataColumns.SearchKeyDetailItemId, data.SearchKeyDetailItemId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDetailItemDataModel.DataColumns.SearchKeyDetailItemId); } break; case SearchKeyDetailItemDataModel.DataColumns.SearchKeyDetailId: if (data.SearchKeyDetailId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SearchKeyDetailItemDataModel.DataColumns.SearchKeyDetailId, data.SearchKeyDetailId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDetailItemDataModel.DataColumns.SearchKeyDetailId); } break; case SearchKeyDetailItemDataModel.DataColumns.Value: returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, SearchKeyDetailItemDataModel.DataColumns.Value, data.Value.Trim()); //if (!string.IsNullOrEmpty(data.Value)) //{ //} //else //{ // returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDetailItemDataModel.DataColumns.Value); //} break; case SearchKeyDetailItemDataModel.DataColumns.SortOrder: if (data.SortOrder != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, SearchKeyDetailItemDataModel.DataColumns.SortOrder, data.SortOrder); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, SearchKeyDetailItemDataModel.DataColumns.SortOrder); } break; default: returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static bool DoesExist(SearchKeyDetailItemDataModel data, RequestProfile requestProfile) { var doesExistRequest = new SearchKeyDetailItemDataModel(); doesExistRequest.SearchKeyDetailItemId = data.SearchKeyDetailItemId; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
private int GetSearchKey() { var searchKeyId = 0; var data = new SearchKeyDataModel(); data.Name = DateTime.Now.ToLongTimeString(); data.View = "ScheduleDetail"; data.SortOrder = 1; data.Description = "ScheduleDetail"; searchKeyId = SearchKeyDataManager.Create(data, SessionVariables.RequestProfile); var listKeys = new List <string>(); listKeys.Add(ScheduleDetailDataModel.DataColumns.PersonId); listKeys.Add(ScheduleDetailDataModel.DataColumns.ScheduleDetailActivityCategoryId); listKeys.Add(ScheduleDetailDataModel.DataColumns.Message); listKeys.Add(ScheduleDetailDataModel.DataColumns.WorkDate); listKeys.Add(ApplicationCommon.XAxisKey); listKeys.Add(ApplicationCommon.YAxisKey); listKeys.Add(ApplicationCommon.ZAxisKey); listKeys.Add(ApplicationCommon.AggeregateFunctionKey); listKeys.Add(ApplicationCommon.ShowAggeregateKey); foreach (var key in listKeys) { //try //{ var columnName = key; var columnValue = PerferenceUtility.GetUserPreferenceByKey(key, SettingCategory); var dataDetail = new SearchKeyDetailDataModel(); dataDetail.SearchKeyId = searchKeyId; //ApplicationCommon.UpdateUserPreference(SettingCategory, columnName, columnValue); dataDetail.SearchParameter = columnName; dataDetail.SortOrder = 1; var detailId = SearchKeyDetailDataManager.Create(dataDetail, SessionVariables.RequestProfile); var dataDetailItem = new SearchKeyDetailItemDataModel(); dataDetailItem.SearchKeyDetailId = detailId; dataDetailItem.SortOrder = 1; dataDetailItem.Value = columnValue; SearchKeyDetailItemDataManager.Create(dataDetailItem, SessionVariables.RequestProfile); } return(searchKeyId); }
public static void Delete(SearchKeyDetailItemDataModel dataQuery, RequestProfile requestProfile) { const string sql = @"dbo.SearchKeyDetailItemDelete "; var parameters = new { AuditId = requestProfile.AuditId , SearchKeyDetailItemId = dataQuery.SearchKeyDetailItemId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
private int SaveSearchKey() { var searchKeyId = 0; if (SearchColumns != null) { var data = new SearchKeyDataModel(); data.Name = DateTime.Now.ToLongTimeString(); data.View = "FunctionalityXFunctionalityImage"; data.SortOrder = 1; data.Description = "FunctionalityXFunctionalityImage"; searchKeyId = Framework.Components.Core.SearchKeyDataManager.Create(data, SessionVariables.RequestProfile); foreach (DataRow dr in SearchColumns.Rows) { try { var columnName = Convert.ToString(dr["Name"]); var columnValue = CheckAndGetFieldValue(columnName, false).ToString(); var dataDetail = new SearchKeyDetailDataModel(); dataDetail.SearchKeyId = searchKeyId; //ApplicationCommon.UpdateUserPreference(SettingCategory, columnName, columnValue); dataDetail.SearchParameter = columnName; dataDetail.SortOrder = 1; var detailId = Framework.Components.Core.SearchKeyDetailDataManager.Create(dataDetail, SessionVariables.RequestProfile); var dataDetailItem = new SearchKeyDetailItemDataModel(); dataDetailItem.SearchKeyDetailId = detailId; dataDetailItem.SortOrder = 1; dataDetailItem.Value = columnValue; Framework.Components.Core.SearchKeyDetailItemDataManager.Create(dataDetailItem, SessionVariables.RequestProfile); } catch { } } } return(searchKeyId); }
public static void Update(SearchKeyDetailItemDataModel data, RequestProfile requestProfile) { var sql = CreateOrUpdate(data, requestProfile, "Update"); DBDML.RunSQL("SearchKeyDetailItem.Update", sql, DataStoreKey); }
public static SearchKeyDetailItemDataModel GetDetails(SearchKeyDetailItemDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }