public GetEmployeesQr(string filter, DataResultType dataResultType = DataResultType.Summary)
{
Filter = filter?.Trim();
DataResultType = dataResultType;
FilterField = EmployeeFilterField.FullName;
if (string.IsNullOrEmpty(Filter))
{
FilterField = EmployeeFilterField.None;
}
}
public DataResult(DataResultType type, string friendlyMessage, string internalMessage)
{
Verify.ValidEnumValue(type, nameof(type));
Verify.ValidString(friendlyMessage, nameof(friendlyMessage));
Verify.ValidString(internalMessage, nameof(internalMessage));
Type = type;
FriendlyMessage = friendlyMessage;
InternalMessage = internalMessage;
Validation = new ValidationCollection();
Data = new Dictionary <string, object>();
}
public DataResult(DataResultType resultType)
{
_dataResultType = resultType;
switch (resultType)
{
case DataResultType.DataTableType:
_table = new DataTable();
break;
case DataResultType.ListType:
_list = new List <string[]>();
break;
default:
throw new ArgumentOutOfRangeException("DataResult.DataResultType does not exist");
}
}
protected DataResult <TResult> CreateDataResult <TResult>(string storedProcedureName, int rowCount,
TResult value, DataResultType resultType, string friendlyMessage, string internalMessage,
int?valueId = null, DbException exception = null)
{
if (rowCount > 0)
{
resultType = DataResultType.Success;
friendlyMessage = !string.IsNullOrWhiteSpace(friendlyMessage) ? friendlyMessage : Success;
internalMessage = !string.IsNullOrWhiteSpace(internalMessage)
? internalMessage
: $"Procedure {storedProcedureName} completed successfully.";
}
else if (resultType.Equals(DataResultType.Success) && !storedProcedureName.ToLower().Contains("get") &&
!storedProcedureName.ToLower().Contains("read"))
{
resultType = DataResultType.NotRequired;
friendlyMessage = !string.IsNullOrWhiteSpace(friendlyMessage) && !friendlyMessage.Equals(Success)
? friendlyMessage
: "No actions required";
internalMessage = !string.IsNullOrWhiteSpace(internalMessage)
? internalMessage
: $"Procedure {storedProcedureName} did not require any changes.";
}
else if (resultType.Equals(DataResultType.Success))
{
resultType = DataResultType.NoRecordsFound;
friendlyMessage = "Sorry, no results were returned.";
internalMessage = $"Procedure {storedProcedureName} returned 0 records.";
}
var dataResult = new DataResult <TResult>(value, resultType, friendlyMessage, internalMessage, exception);
dataResult.Data.Add("Command Details", storedProcedureName);
if (valueId.HasValue)
{
dataResult.ValueId = valueId.Value;
}
exception?.Data.Add("ExceptionData.StringValue", storedProcedureName);
UnitOfWork.AddDataResult(dataResult);
return(dataResult);
}
protected static void InitialiseInformativeVariables(string commandText, out string commandType,
out string commandTypePastTense, out DataResultType resultType, out string friendlyMessage, out string internalMessage)
{
commandType = "process";
resultType = DataResultType.UnknownError;
if (commandText.EndsWith("create"))
{
commandType = "create";
resultType = DataResultType.UnableToCreateRecord;
}
else if (commandText.Contains("get"))
{
commandType = "read";
resultType = DataResultType.UnableToReadRecord;
}
else if (commandText.EndsWith("save"))
{
commandType = "save";
resultType = DataResultType.UnableToUpdateRecord;
}
else if (commandText.EndsWith("update"))
{
commandType = "update";
resultType = DataResultType.UnableToUpdateRecord;
}
else if (commandText.EndsWith("delete"))
{
commandType = "delete";
resultType = DataResultType.UnableToDeleteRecord;
}
if (commandType.Equals("process"))
{
commandTypePastTense = $"{commandType}ed";
}
else if (!commandType.Equals("read"))
{
commandTypePastTense = $"{commandType}d";
}
else
{
commandTypePastTense = commandType;
}
friendlyMessage = "Sorry, an unexpected error has occurred.";
internalMessage = $"Unable to {commandType} record. No records affected.";
}
public DataResult(DataResultType type, string friendlyMessage, string internalMessage, Exception exception)
: this(type, friendlyMessage, internalMessage)
{
Exception = exception;
}
public DataResult(DataResultType type, string message, Exception exception)
: this(type, message)
{
Exception = exception;
}
public DataResult(DataResultType type, string message)
: this(type, message, message)
{
}
public DataResult(T value, DataResultType type, string message, Exception exception)
: this(value, type, message, message, exception)
{
}
public DataResult(T value, DataResultType type, string friendlyMessage, string internalMessage, Exception exception)
: base(type, friendlyMessage, internalMessage, exception)
{
Value = value;
}
public DataResult(T value, int valueId, DataResultType type, string message)
: this(value, valueId, type, message, message)
{
}
public DataResult(T value, int valueId, DataResultType type, string friendlyMessage, string internalMessage)
: base(type, friendlyMessage, internalMessage)
{
Value = value;
ValueId = valueId;
}
public DataResult(DataResultType type, string message, Exception exception)
: base(type, message, exception)
{
}
public DataResult(DataResultType type, string message)
: base(type, message)
{
}
public DataResult(DataResultType type, string friendlyMessage, string internalMessage)
: base(type, friendlyMessage, internalMessage)
{
}
public DataResult(DataResultType resultType)
{
_dataResultType = resultType;
switch (resultType)
{
case DataResultType.DataTableType:
_table = new DataTable();
break;
case DataResultType.ListType:
_list = new List<string[]>();
break;
default:
throw new ArgumentOutOfRangeException("DataResult.DataResultType does not exist");
}
}
