public static List <DatabaseChangeLogDataModel> GetEntityDetails(DatabaseChangeLogDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = ReturnAuditInfoOnDetails) { const string sql = @"dbo.DatabaseChangeLogSearch "; var parameters = new { AuditId = requestProfile.AuditId , Id = dataQuery.Id , DataBaseName = dataQuery.DataBaseName , ObjectName = dataQuery.ObjectName , ObjectType = dataQuery.ObjectType , CurrentUser = dataQuery.CurrentUser , HostName = dataQuery.HostName , FromSearchDate = dataQuery.FromSearchDate , ToSearchDate = dataQuery.ToSearchDate , ReturnAuditInfo = returnAuditInfo }; List <DatabaseChangeLogDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <DatabaseChangeLogDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static DataTable Search(DatabaseChangeLogDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
public static string ToSQLParameter(DatabaseChangeLogDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case DatabaseChangeLogDataModel.DataColumns.Id: if (data.Id != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DatabaseChangeLogDataModel.DataColumns.Id, data.Id); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DatabaseChangeLogDataModel.DataColumns.Id); } break; case DatabaseChangeLogDataModel.DataColumns.CurrentUser: if (!string.IsNullOrEmpty(data.CurrentUser)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DatabaseChangeLogDataModel.DataColumns.CurrentUser, data.CurrentUser.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DatabaseChangeLogDataModel.DataColumns.CurrentUser); } break; case DatabaseChangeLogDataModel.DataColumns.FromSearchDate: if (data.FromSearchDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DatabaseChangeLogDataModel.DataColumns.FromSearchDate, data.FromSearchDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DatabaseChangeLogDataModel.DataColumns.FromSearchDate); } break; case DatabaseChangeLogDataModel.DataColumns.ToSearchDate: if (data.ToSearchDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DatabaseChangeLogDataModel.DataColumns.ToSearchDate, data.ToSearchDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DatabaseChangeLogDataModel.DataColumns.ToSearchDate); } break; case DatabaseChangeLogDataModel.DataColumns.DataBaseName: if (!string.IsNullOrEmpty(data.DataBaseName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DatabaseChangeLogDataModel.DataColumns.DataBaseName, data.DataBaseName.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DatabaseChangeLogDataModel.DataColumns.DataBaseName); } break; case DatabaseChangeLogDataModel.DataColumns.ObjectName: if (!string.IsNullOrEmpty(data.ObjectName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DatabaseChangeLogDataModel.DataColumns.ObjectName, data.ObjectName.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DatabaseChangeLogDataModel.DataColumns.ObjectName); } break; case DatabaseChangeLogDataModel.DataColumns.ObjectType: if (!string.IsNullOrEmpty(data.ObjectType)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DatabaseChangeLogDataModel.DataColumns.ObjectType, data.ObjectType.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DatabaseChangeLogDataModel.DataColumns.ObjectType); } break; case DatabaseChangeLogDataModel.DataColumns.HostName: if (!string.IsNullOrEmpty(data.HostName)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DatabaseChangeLogDataModel.DataColumns.HostName, data.HostName.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DatabaseChangeLogDataModel.DataColumns.HostName); } break; case DatabaseChangeLogDataModel.DataColumns.RecordDate: if (data.RecordDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DatabaseChangeLogDataModel.DataColumns.RecordDate, data.RecordDate.ToString()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DatabaseChangeLogDataModel.DataColumns.RecordDate); } break; } return(returnValue); }
public static DatabaseChangeLogDataModel GetDetails(DatabaseChangeLogDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }