Exemplo n.º 1
0
 internal static IEnumerable <T> GetDataObjects <T>(MySqlConnection ExistingConnection, string QueryString, Dictionary <string, object> Parameters = null, bool ThrowException = true, MySqlTransaction SqlTransaction = null) where T : DALBaseModel
 {
     return(RefinedResultsHelper.GetDataTable(ExistingConnection, QueryString, Parameters: Parameters, ThrowException: ThrowException, SqlTransaction: SqlTransaction)
            .AsEnumerable()
            .Select(x => x == null
                                 ? null
                                 : typeof(T).GetConstructors().Any(y => y.GetParameters().Length > 2)
                                         ? DatabaseCoreUtilities.CreateCreatorExpression <DataRow, string, bool, bool, T>()(x, null, false, false)
                                         : DatabaseCoreUtilities.CreateCreatorExpression <DataRow, string, T>()(x, null)));
 }
Exemplo n.º 2
0
 /// <summary>
 /// Converts an InternalId to an autonumbered row ID.
 /// </summary>
 /// <param name="ConfigConnectionString">The connection type to use.</param>
 /// <param name="Table">Table name to use for the conversion.</param>
 /// <param name="InternalId">The GUID of the InternalId to convert.</param>
 /// <returns>ID of the row matching the InternalId.</returns>
 internal static string GetIdFromInternalId(Enum ConfigConnectionString, string Table, string InternalId)
 {
     return(RefinedResultsHelper.GetScalar <string>(ConfigConnectionString, $"SELECT ID FROM {Table} WHERE InternalId = @InternalId", new Dictionary <string, object> {
         { "@InternalId", InternalId }
     }));
 }
Exemplo n.º 3
0
 /// <summary>
 /// Use the MySql built in function to get the ID of the last row inserted.
 /// </summary>
 /// <param name="ConfigConnectionString">The connection type to use when getting the last ID.</param>
 /// <returns>A string representation of the ID.</returns>
 internal static string GetLastInsertId(Enum ConfigConnectionString)
 {
     return(RefinedResultsHelper.GetScalar <string>(ConfigConnectionString, "SELECT LAST_INSERT_ID();"));
 }
Exemplo n.º 4
0
 internal static IEnumerable <T> GetDataList <T>(MySqlConnection ExistingConnection, string QueryString, Dictionary <string, object> Parameters = null, bool ThrowException = true, MySqlTransaction SqlTransaction = null)      //where T : DALBaseModel
 {
     return(RefinedResultsHelper.GetDataTable(ExistingConnection, QueryString, Parameters: Parameters, ThrowException: ThrowException, SqlTransaction: SqlTransaction)
            .AsEnumerable()
            .Select(x => (T)DatabaseCoreUtilities.ConvertScalar <T>(x[0])));
 }