public object ExecuteAction(string connectionStringName, string query, object args, out string errMsg)
{
IList <T> result = default(IList <T>);
errMsg = string.Empty;
try
{
result = BusinessObjectDAO <T> .RetrieveAll(connectionStringName, query, out errMsg);
}
catch (Exception e)
{
errMsg = e.Message;
}
return(result);
}
public object ExecuteAction(string connectionStringName, string query, out string errMsg, bool isUnique, bool withPaging = true, params object[] parameters)
{
T result = default(T);
errMsg = string.Empty;
try
{
result = BusinessObjectDAO <T> .RetrieveDataObjectByParameter(connectionStringName, query, out errMsg, isUnique, parameters);
}
catch (Exception e)
{
errMsg = e.Message;
}
return(result);
}
public object ExecuteAction(string connectionStringName, string query, out string errMsg, bool isUnique, bool withPaging = true, params object[] parameters)
{
IList <T> result = default(IList <T>);
errMsg = string.Empty;
try
{
if (withPaging == false)
{
result = BusinessObjectDAO <T> .RetrieveAllByParameters(connectionStringName, query, out errMsg, parameters);
}
else
{
System.Type type = parameters[0].GetType();
//int clientid = (int)type.GetProperty("sort").GetValue(parameters, null);
//string sort, string direction, int page, int pageSize, out int totalItemsCount
string sort = type.GetProperty("sort").GetValue(parameters[0], null).ToString();
string direction = type.GetProperty("direction").GetValue(parameters[0], null).ToString();
int page = int.Parse(type.GetProperty("page").GetValue(parameters[0], null).ToString());
int pageSize = int.Parse(type.GetProperty("pageSize").GetValue(parameters[0], null).ToString());
int ItemsCount = int.Parse(type.GetProperty("itemsCount").GetValue(parameters[0], null).ToString());
//parameters.ToList().Remove(parameters.Where(x=> { return IsSearchParameters(x); }).FirstOrDefault());
var _real_parameters = type.GetProperties().Where(x => { return(!IsSearchParameters(x.Name)); });
//_real_parameters.Remove(parameters.Where(x => { return IsSearchParameters(x); }).FirstOrDefault());
result = BusinessObjectDAO <T> .RetrieveAllWithPaging(connectionStringName, query, sort, Direction.Default, page, pageSize, out ItemsCount, out errMsg, _real_parameters.ToArray());
parameters[parameters.Length - 1] = new KeyValuePair <string, object>("ItemsCount", ItemsCount);
}
}
catch (Exception e)
{
errMsg = e.Message;
}
return(result);
}
