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); }