public static T RetrieveDataObjectByParameter(string connectionName, string query, out string errMsg, bool isUnique = false, params object[] args)
{
T result = default(T);
errMsg = string.Empty;
try
{
using (Database = DatabaseManager.GetDatabaseByName(connectionName, true))
{
var intResult = Database.Fetch <T>(query, args);
if (intResult != null && intResult.Count == 1)
{
result = intResult.FirstOrDefault();
}
else if (intResult.Count > 1 && isUnique == false)
{
throw new Exception("Result not unique");
}
else if (intResult.Count > 1 && isUnique == true)
{
result = intResult.FirstOrDefault();
}
else if (intResult.Count < 0)
{
throw new Exception("Invalid Result");
}
}
}
catch (Exception e)
{
errMsg = e.Message;
}
return(result);
}
public static IList <T> RetrieveAllByParameters(string connectionName, string query, out string errMsg, params object[] args)
{
IList <T> result = null;
errMsg = string.Empty;
try
{
using (Database = DatabaseManager.GetDatabaseByName(connectionName, true))
{
result = Database.Fetch <T>(query, args);
}
}
catch (Exception e)
{
errMsg = e.Message;
}
return(result);
}
