protected NextStatusResponse ActionGetNextStatus(IDbConnection connection, NextStatusRequest request)
{
NextStatusResponse response = new NextStatusResponse();
var data = connection.Query <NextStatusResponse>
(
"SP_GetNextTransactionStatusCode",
param: new { transactionId = request.TransactionId, documentCode = request.DocumentCode, nextStatus = request.NextStatusCode },
commandType: System.Data.CommandType.StoredProcedure
);
if (data != null)
{
response = (NextStatusResponse)data.FirstOrDefault();
}
return(response);
}
protected string GetSendEmailCc(NextStatusRequest request)
{
string result = "";
var requestMyRow = (CommonRequestObj)request.Entity;
using (var newConnUser = SqlConnections.NewFor <Administration.Entities.UserRow>())
{
if (request.CcCreator)
{
var emailCreator = newConnUser.TrySingle <Administration.Entities.UserRow>(q => q.Select(Administration.Entities.UserRow.Fields.Email).Where(new Criteria(Administration.Entities.UserRow.Fields.UserId) == requestMyRow.InsertUserId.ToString()));
result = result + emailCreator.Email.ToString() + ";";
}
if (request.CcRequestor)
{
var emailRequestor = newConnUser.TrySingle <Administration.Entities.UserRow>(q => q.Select(Administration.Entities.UserRow.Fields.Email).Where(new Criteria(Administration.Entities.UserRow.Fields.UserId) == requestMyRow.Requestor.ToString()));
result = result + emailRequestor.Email.ToString() + ";";
}
}
return(result);
}
protected void ActionSendEmail(string subjectHeader, string content, NextStatusRequest request, string displayName = "")
{
EmailHelper.Send(subjectHeader, content, request.SendEmailTo, request.SendEmailCc, request.Attachments, displayName);
}
