public static Result <T> GetSelectValue <T>(string connectionString, string query, List <MySqlParameter> parameters = null)
{
var valor = default(T);
using (var exe = new DataBaseExecuteReader(connectionString, query, parameters))
{
if (exe.DataReader.Read())
{
if (typeof(T) == typeof(int))
{
valor = (T)(object)exe.DataReader.GetInt(0);
}
else if (typeof(T) == typeof(double))
{
valor = (T)(object)exe.DataReader.GetDecimal(0);
}
else
{
valor = (T)(object)exe.DataReader.GetString(0);
}
}
else
{
return(Result.Failure <T>("Record not found"));
}
}
return(valor);
}
public static ulong GetLastInsertId(string connectionString)
{
var query = "SELECT LAST_INSERT_ID()";
using (var exe = new DataBaseExecuteReader(connectionString, query))
{
if (exe.DataReader.Read())
{
return(exe.DataReader.GetULong(0));
}
}
return(0);
}
