public async Task SendMail(MailSenderDTOs mailInfo)
{
string query = "sp_send_approve_mail";
var param = new DynamicParameters();
param.Add("pv_approver", dbType: DbType.String, value: mailInfo.approver);
param.Add("pv_requester", dbType: DbType.String, value: mailInfo.requester);
param.Add("pv_status", dbType: DbType.String, value: mailInfo.status);
param.Add("pv_folder", dbType: DbType.String, value: mailInfo.folder);
param.Add("pv_docname", dbType: DbType.String, value: mailInfo.docname);
param.Add("pv_docdate", dbType: DbType.Date, value: mailInfo.docdate);
param.Add("pv_note", dbType: DbType.String, value: mailInfo.note);
param.Add("pv_link", dbType: DbType.String, value: mailInfo.link);
param.Add("pv_toemail", dbType: DbType.String, value: mailInfo.approverMail);
param.Add("pv_sendermail", dbType: DbType.String, value: mailInfo.sendermail);
param.Add("SESSIONINFO_USERNAME", dbType: DbType.String, value: "anhpt");
using (OracleConnection conn = new OracleConnection(_connectionString))
{
conn.Open();
var result = await conn.ExecuteAsync(query, param, commandType : CommandType.StoredProcedure);
}
}
public async Task SaveDocument(apec_khktdocs_document document)
{
try
{
if (document.id != 0)
{
var entity = await _documentRepository.GetByIdAsync(document.id).ConfigureAwait(false);
entity.document_name = document.document_name;
entity.stage = document.stage;
entity.document_description = document.document_description;
entity.created_user = document.created_user;
entity.status = document.status;
entity.approve_date = document.approve_date;
entity.document_extension = document.document_extension;
entity.document_folder_id = document.document_folder_id;
entity.modified_date = document.modified_date;
entity.document_receiver = document.document_receiver;
entity.document_agency = document.document_agency;
await _documentRepository.UpdateAsync(entity).ConfigureAwait(false);
return;
}
var username = await _userRepository.GetUsersByUserName(document.approver).ConfigureAwait(false);
var sender = await _userRepository.GetUsersByUserName(document.created_user).ConfigureAwait(false);
var folder = await _doctypeRepository.GetByIdAsync(document.document_folder_id).ConfigureAwait(false);
MailSenderDTOs mail = new MailSenderDTOs
{
approver = username.display_name,
requester = document.created_user,
folder = folder.text,
docname = document.document_name,
docdate = document.created_date,
note = document.document_description,
link = "http://docs.apecgroup.net/Home/Index?folderid=" + document.document_folder_id,
approverMail = username.email,
sendermail = sender.email,
status = GetDocDesEnum(document.status)
};
await _documentRepository.SaveDocument(document).ConfigureAwait(false);
await _documentRepository.SendMail(mail).ConfigureAwait(false);
}
catch (Exception e)
{
throw e;
}
}
public async Task SendMail(MailSenderDTOs mailInfo)
{
try
{
await _documentRepository.SendMail(mailInfo);
}
catch (Exception e)
{
throw;
}
}
