public ActionResponse Update(int id, SMTPSettingsModel model)
{
using (var unitWork = new UnitOfWork(context))
{
IMessageHelper mHelper;
ActionResponse response = new ActionResponse();
var settingsObj = unitWork.SMTPSettingsRepository.GetByID(id);
if (settingsObj == null)
{
mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetNotFound("SMTPSettings");
return(response);
}
settingsObj.Host = model.Host;
settingsObj.Port = model.Port;
settingsObj.Username = model.Username;
settingsObj.SenderName = model.SenderName;
settingsObj.AdminEmail = model.AdminEmail;
if (!string.IsNullOrEmpty(model.Password))
{
settingsObj.Password = model.Password;
}
unitWork.SMTPSettingsRepository.Update(settingsObj);
unitWork.Save();
response.Message = true.ToString();
return(response);
}
}
public ActionResponse SendNotificationsForNewOrganizations(int newOrganizations, int organizationsWithoutType)
{
var unitWork = new UnitOfWork(context);
ActionResponse response = new ActionResponse();
var messages = unitWork.EmailMessagesRepository.GetAll();
if (newOrganizations > 0)
{
string subject = "", message = "", footerMessage = "";
var emailMessage = (from m in messages
where m.MessageType == EmailMessageType.NewIATIOrganization
select m).FirstOrDefault();
if (emailMessage != null)
{
subject = emailMessage.Subject;
message = emailMessage.Message;
footerMessage = emailMessage.FooterMessage;
}
ISMTPSettingsService smtpService = new SMTPSettingsService(context);
var smtpSettings = smtpService.GetPrivate();
SMTPSettingsModel smtpSettingsModel = new SMTPSettingsModel();
if (smtpSettings != null)
{
smtpSettingsModel.Host = smtpSettings.Host;
smtpSettingsModel.Port = smtpSettings.Port;
smtpSettingsModel.Username = smtpSettings.Username;
smtpSettingsModel.Password = smtpSettings.Password;
smtpSettingsModel.AdminEmail = smtpSettings.AdminEmail;
smtpSettingsModel.SenderName = smtpSettings.SenderName;
}
IEmailHelper emailHelper = new EmailHelper(smtpSettings.AdminEmail, smtpSettings.SenderName, smtpSettingsModel);
var users = unitWork.UserRepository.GetManyQueryable(u => u.UserType == UserTypes.Manager);
var emails = (from u in users
select u.Email);
List <EmailAddress> emailAddresses = new List <EmailAddress>();
foreach (var email in emails)
{
emailAddresses.Add(new EmailAddress()
{
Email = email
});
}
IMessageHelper mHelper = new MessageHelper();
message += mHelper.NewIATIOrganizationsMessage(newOrganizations, organizationsWithoutType);
if (emailAddresses.Count > 0)
{
emailHelper.SendEmailToUsers(emailAddresses, subject, "", message, footerMessage);
}
}
return(response);
}
private SmtpClient GetSMTPClient(SMTPSettingsModel settings)
{
return(new SmtpClient()
{
Host = settings.Host,
Port = settings.Port,
Credentials = new NetworkCredential(
settings.Username,
settings.Password
),
EnableSsl = true
});
}
public IActionResult Post([FromBody] SMTPSettingsModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var response = smtpSettingsService.Add(model);
if (!response.Success)
{
return(BadRequest(response.Message));
}
return(Ok(response.ReturnedId));
}
public ActionResponse Add(SMTPSettingsModel model)
{
using (var unitWork = new UnitOfWork(context))
{
ActionResponse response = new ActionResponse();
try
{
var smtpSettings = unitWork.SMTPSettingsRepository.GetOne(s => s.Id != 0);
if (smtpSettings != null)
{
smtpSettings.Host = model.Host;
smtpSettings.Port = model.Port;
smtpSettings.Username = model.Username;
smtpSettings.AdminEmail = model.AdminEmail;
smtpSettings.SenderName = model.SenderName;
if (!string.IsNullOrEmpty(model.Password))
{
smtpSettings.Password = model.Password;
}
unitWork.SMTPSettingsRepository.Update(smtpSettings);
unitWork.Save();
response.ReturnedId = smtpSettings.Id;
}
else
{
var newSMTPSettings = unitWork.SMTPSettingsRepository.Insert(new EFSMTPSettings()
{
Host = model.Host,
Port = model.Port,
Username = model.Username,
Password = model.Password,
AdminEmail = model.AdminEmail,
SenderName = model.SenderName
});
response.ReturnedId = newSMTPSettings.Id;
unitWork.Save();
}
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
return(response);
}
}
public SMTPSettingsModel GetPrivate()
{
var unitWork = new UnitOfWork(context);
var settings = unitWork.SMTPSettingsRepository.GetOne(s => s.Id != 0);
SMTPSettingsModel view = new SMTPSettingsModel();
if (settings != null)
{
view.AdminEmail = settings.AdminEmail;
view.Host = settings.Host;
view.Port = settings.Port;
view.Username = settings.Username;
view.Password = settings.Password;
view.SenderName = settings.SenderName;
}
return(view);
}
//----------------------END OF REGION----------------------------//
#endregion
#region PRIVATE_FUNCTIONS
//----------------------REGION------------------------------------//
private static Boolean SendVerificationLinkEmail(String emailAddress, Int32 portalAccountID, String paymentCode, String verificationCode, String Url, String password)
{
var verifyUrl = Url + "?pa=" + portalAccountID.ToString() + "&pc=" + paymentCode + "&vc=" + verificationCode;
//'-------------------------------------------------------------------------------------'
SMTPSettingsModel smtpSettings = DatabaseHelper.GetSMTPSettings();
System.Net.Mail.SmtpClient smtpClient = new System.Net.Mail.SmtpClient(smtpSettings.Host);
smtpClient.Port = smtpSettings.Port;
smtpClient.EnableSsl = smtpSettings.SSLRequired;
smtpClient.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
smtpClient.UseDefaultCredentials = false;
if (smtpSettings.RequiresAuthentication == true)
{
smtpClient.Credentials = new NetworkCredential(smtpSettings.UserName, smtpSettings.Password);
}
System.Net.Mail.MailMessage mailMessage = new System.Net.Mail.MailMessage();
mailMessage.IsBodyHtml = true;
mailMessage.From = new System.Net.Mail.MailAddress(smtpSettings.EmailFrom, "Patient Bill Support");
mailMessage.To.Add(new System.Net.Mail.MailAddress(emailAddress));
mailMessage.Bcc.Add(new System.Net.Mail.MailAddress(smtpSettings.EmailFrom, "Patient Bill Support"));
mailMessage.Subject = "Your PRC account activation link";
mailMessage.Body = "<br/><br/>Thank you for registering.<br/><br/>Your account has been successfully created for the Patient Billing Portal. Please verify and login using the verification link and password provided below: " +
" <br/><br/> <a href='" + verifyUrl + "'>Verification Link</a>" + "<br/><br/> Your password : "******"<br/><br/><br/><b>Note: </b>The Verification link will expire in 24 hours. " + "<br/><br/><br/><br/> Thank You.<br/>Patient Billing Portal Team";
bool sentSuccessfully = false;
//--- Try to send the email and handle any errors on send ----//
try
{
smtpClient.Send(mailMessage);
sentSuccessfully = true;
}
catch (Exception ex)
{
DatabaseHelper.LogErrorToDatabase(ex, "", "Account/SendVerificationLinkEmail");
sentSuccessfully = false;
}
//' ------------------------------------------------------------------------------------'
return(sentSuccessfully);
}
public IActionResult Put(int id, [FromBody] SMTPSettingsModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id <= 0)
{
return(BadRequest("Invalid id provided"));
}
var response = smtpSettingsService.Update(id, model);
if (!response.Success)
{
return(BadRequest(response.Message));
}
return(Ok(response.ReturnedId));
}
private static Boolean SendEmail(string emailAddress, string Password)
{
//---Forgot Password function ----///
//'-------------------------------------------------------------------------------------'
SMTPSettingsModel smtpSettings = DatabaseHelper.GetSMTPSettings();
System.Net.Mail.SmtpClient smtpClient = new System.Net.Mail.SmtpClient(smtpSettings.Host);
smtpClient.Port = smtpSettings.Port;
smtpClient.EnableSsl = smtpSettings.SSLRequired;
smtpClient.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network;
smtpClient.UseDefaultCredentials = false;
if (smtpSettings.RequiresAuthentication == true)
{
smtpClient.Credentials = new NetworkCredential(smtpSettings.UserName, smtpSettings.Password);
}
System.Net.Mail.MailMessage mailMessage = new System.Net.Mail.MailMessage();
mailMessage.IsBodyHtml = true;
mailMessage.From = new System.Net.Mail.MailAddress(smtpSettings.EmailFrom, "Patient Bill Support");
mailMessage.To.Add(new System.Net.Mail.MailAddress(emailAddress));
// mailMessage.Bcc.Add(""); ------ NOTE: DO NOT BCC WHEN SENDING PASSWORD OUT. THIS IS HIPAA DATA-------
mailMessage.Subject = "Your PatientBillHelp password has been reset";
mailMessage.Body = "Hi there,<br/><br/>You are receiving this email because we reset your password. <br/><br/>Use the below password to login." + "<br/><br/> New Password : "******"<br/><br/><br/><br/><br/><br/> Best Regards,<br/><br/>PRC";
bool sentSuccessfully = false;
//--- Try to send the email and handle any errors on send ----//
try
{
smtpClient.Send(mailMessage);
sentSuccessfully = true;
}
catch (Exception ex)
{
DatabaseHelper.LogErrorToDatabase(ex, "", "Account/SendEmail");
sentSuccessfully = false;
}
//' ------------------------------------------------------------------------------------'
return(sentSuccessfully);
}
public EmailService(AIMSDbContext cntxt)
{
context = cntxt;
ISMTPSettingsService smtpService = new SMTPSettingsService(context);
var smtpSettings = smtpService.GetPrivate();
SMTPSettingsModel smtpSettingsModel = new SMTPSettingsModel();
if (smtpSettings != null)
{
smtpSettingsModel.Host = smtpSettings.Host;
smtpSettingsModel.Port = smtpSettings.Port;
smtpSettingsModel.Username = smtpSettings.Username;
smtpSettingsModel.Password = smtpSettings.Password;
smtpSettingsModel.AdminEmail = smtpSettings.AdminEmail;
smtpSettings.SenderName = smtpSettings.SenderName;
emailHelper = new EmailHelper(smtpSettings.AdminEmail, smtpSettings.SenderName, smtpSettings);
}
else
{
emailHelper = new EmailHelper(null, null, null);
}
}
public async Task <ActionResponse> ApproveMembershipRequestAsync(int userId, int projectId, int funderId, int ownerId, MembershipTypes membershipType)
{
using (var unitWork = new UnitOfWork(context))
{
ActionResponse response = new ActionResponse();
IMessageHelper mHelper;
UserTypes userType = UserTypes.Standard;
var user = unitWork.UserRepository.GetOne(u => u.Id == userId);
if (user == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetNotFound("User");
response.Success = false;
return(response);
}
var actionUser = unitWork.UserRepository.GetOne(u => u.Id == ownerId);
if (actionUser != null)
{
userType = actionUser.UserType;
}
if (userType != UserTypes.Manager && userType != UserTypes.SuperAdmin)
{
var isUserOwner = unitWork.ProjectRepository.GetOne(p => (p.Id == projectId && p.CreatedById == ownerId));
if (isUserOwner == null)
{
var isFunderOwner = unitWork.ProjectFundersRepository.GetOne(f => f.FunderId == funderId && f.ProjectId == projectId);
var isImplementerOwner = unitWork.ProjectImplementersRepository.GetOne(i => i.ImplementerId == funderId && i.ProjectId == projectId);
if (isFunderOwner == null && isImplementerOwner == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetInvalidFunderApprovalMessage();
response.Success = false;
return(response);
}
}
}
var project = unitWork.ProjectRepository.GetOne(p => p.Id == projectId);
if (user == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetNotFound("Project");
response.Success = false;
return(response);
}
var userOrganization = unitWork.OrganizationRepository.GetOne(o => o.Id == user.OrganizationId);
if (userOrganization == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetNotFound("User Organization");
response.Success = false;
return(response);
}
IQueryable <EFProjectMembershipRequests> requests = null;
if (userType == UserTypes.Manager || userType == UserTypes.SuperAdmin)
{
requests = unitWork.ProjectMembershipRepository.GetManyQueryable(r => r.ProjectId == projectId && r.MembershipType == membershipType);
}
else
{
requests = unitWork.ProjectMembershipRepository.GetManyQueryable(r => r.ProjectId == projectId && r.OrganizationId == user.OrganizationId && r.MembershipType == membershipType);
if (requests.Count() == 0)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetNotFound("Membership Request");
response.Success = false;
return(response);
}
}
var strategy = context.Database.CreateExecutionStrategy();
await strategy.ExecuteAsync(async() =>
{
using (var transaction = context.Database.BeginTransaction())
{
var approvalRequest = (from r in requests
select r).FirstOrDefault();
foreach (var request in requests)
{
request.IsApproved = true;
unitWork.ProjectMembershipRepository.Update(request);
}
await unitWork.SaveAsync();
if (approvalRequest.MembershipType == MembershipTypes.Funder)
{
var projectFunder = unitWork.ProjectFundersRepository.GetOne(f => f.ProjectId == projectId && f.FunderId == user.OrganizationId);
if (projectFunder == null)
{
unitWork.ProjectFundersRepository.Insert(new EFProjectFunders()
{
ProjectId = projectId,
FunderId = user.OrganizationId
});
await unitWork.SaveAsync();
}
}
else if (approvalRequest.MembershipType == MembershipTypes.Implementer)
{
var projectImplementer = unitWork.ProjectImplementersRepository.GetOne(i => i.ProjectId == projectId && i.ImplementerId == user.OrganizationId);
if (projectImplementer == null)
{
unitWork.ProjectImplementersRepository.Insert(new EFProjectImplementers()
{
ProjectId = projectId,
ImplementerId = user.OrganizationId
});
await unitWork.SaveAsync();
}
}
transaction.Commit();
}
});
//Send status email
string requestedProject = project.Title;
List <EmailAddress> usersEmailList = new List <EmailAddress>();
usersEmailList.Add(new EmailAddress()
{
Email = user.Email,
});
if (usersEmailList.Count > 0)
{
//Send emails
ISMTPSettingsService smtpService = new SMTPSettingsService(context);
var smtpSettings = smtpService.GetPrivate();
SMTPSettingsModel smtpSettingsModel = new SMTPSettingsModel();
if (smtpSettings != null)
{
smtpSettingsModel.Host = smtpSettings.Host;
smtpSettingsModel.Port = smtpSettings.Port;
smtpSettingsModel.Username = smtpSettings.Username;
smtpSettingsModel.Password = smtpSettings.Password;
smtpSettingsModel.AdminEmail = smtpSettings.AdminEmail;
smtpSettingsModel.SenderName = smtpSettings.SenderName;
}
string message = "", subject = "", footerMessage = "";
var emailMessage = unitWork.EmailMessagesRepository.GetOne(m => m.MessageType == EmailMessageType.ProjectPermissionGranted);
if (emailMessage != null)
{
subject = emailMessage.Subject;
message = emailMessage.Message;
footerMessage = emailMessage.FooterMessage;
}
mHelper = new MessageHelper();
message += mHelper.ProjectPermissionGranted(requestedProject);
IEmailHelper emailHelper = new EmailHelper(smtpSettingsModel.AdminEmail, smtpSettings.SenderName, smtpSettingsModel);
emailHelper.SendEmailToUsers(usersEmailList, subject, "", message, footerMessage);
}
return(response);
}
}
public EmailHelper(string adminEmail, string adminName, SMTPSettingsModel smtpSettings)
{
client = this.GetSMTPClient(smtpSettings);
senderName = adminName;
emailFrom = adminEmail;
}
public ActionResponse SendPendingDeletionRequestsToManagement()
{
ActionResponse response = new ActionResponse();
var unitWork = new UnitOfWork(context);
var pendingDeletionRequests = unitWork.ProjectDeletionRepository.GetWithInclude(d => d.Status == ProjectDeletionStatus.Requested &&
d.RequestedOn <= DateTime.Now.AddDays(-7) && !d.IsNotifiedToManager, new string[] { "Project", "RequestedBy" });
var users = unitWork.UserRepository.GetWithInclude(u => u.UserType == UserTypes.Manager, new string[] { "Organization" });
var adminEmails = (from u in users
select u.Email);
List <EmailAddress> usersEmailList = new List <EmailAddress>();
foreach (var email in adminEmails)
{
usersEmailList.Add(new EmailAddress()
{
Email = email
});
}
if (usersEmailList.Count > 0)
{
ISMTPSettingsService smtpService = new SMTPSettingsService(context);
var smtpSettings = smtpService.GetPrivate();
SMTPSettingsModel smtpSettingsModel = new SMTPSettingsModel();
if (smtpSettings != null)
{
smtpSettingsModel.Host = smtpSettings.Host;
smtpSettingsModel.Port = smtpSettings.Port;
smtpSettingsModel.Username = smtpSettings.Username;
smtpSettingsModel.Password = smtpSettings.Password;
smtpSettingsModel.AdminEmail = smtpSettings.AdminEmail;
smtpSettingsModel.SenderName = smtpSettings.SenderName;
}
var projectIds = (from p in pendingDeletionRequests
select p.ProjectId).ToList <int>();
foreach (var request in pendingDeletionRequests)
{
var receiversEmails = (from e in usersEmailList
where e.Email != request.RequestedBy.Email
select e).ToList();
string message = "", subject = "", footerMessage = "";
string projectTitle = "<h5>Project title: " + request.Project.Title + "</h5>";
string requestedBy = "<h5>Requested by: " + request.RequestedBy.Email + "</h5>";
var emailMessage = unitWork.EmailMessagesRepository.GetOne(m => m.MessageType == EmailMessageType.ProjectDeletionRequest);
if (emailMessage != null)
{
subject = emailMessage.Subject;
message = projectTitle + requestedBy + emailMessage.Message;
footerMessage = emailMessage.FooterMessage;
}
IEmailHelper emailHelper = new EmailHelper(smtpSettingsModel.AdminEmail, smtpSettings.SenderName, smtpSettingsModel);
emailHelper.SendEmailToUsers(receiversEmails, subject, "", message, footerMessage);
request.IsNotifiedToManager = true;
unitWork.ProjectDeletionRepository.Update(request);
}
if (pendingDeletionRequests.Any())
{
unitWork.Save();
}
}
return(response);
}
public ActionResponse DeleteProject(int projectId, int userId)
{
using (var unitWork = new UnitOfWork(context))
{
IMessageHelper mHelper;
ActionResponse response = new ActionResponse();
var user = unitWork.UserRepository.GetOne(u => (u.UserType == UserTypes.Manager || u.UserType == UserTypes.SuperAdmin) && u.Id == userId);
if (user == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetInvalidAccountForProject();
response.Success = false;
return(response);
}
var project = unitWork.ProjectRepository.GetByID(projectId);
if (project == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetNotFound("Project");
response.Success = false;
return(response);
}
unitWork.ProjectRepository.Delete(project);
unitWork.Save();
int userOrganizationId = 0;
var deletionRequest = unitWork.ProjectDeletionRepository.GetWithInclude(p => p.ProjectId == projectId, new string[] { "RequestedBy" }).FirstOrDefault();
if (deletionRequest != null)
{
userOrganizationId = deletionRequest.RequestedBy.OrganizationId;
}
var projectFunderIds = unitWork.ProjectFundersRepository.GetProjection(f => f.ProjectId == project.Id, f => f.FunderId);
var projectImplementerIds = unitWork.ProjectImplementersRepository.GetProjection(i => i.ProjectId == project.Id, i => i.ImplementerId);
var orgIds = projectFunderIds.Union(projectImplementerIds).ToList();
if (!orgIds.Contains(userOrganizationId) && userOrganizationId != 0)
{
orgIds.Add(userOrganizationId);
}
var userEmails = unitWork.UserRepository.GetProjection(u => u.UserType == UserTypes.Standard && orgIds.Contains(u.OrganizationId), u => u.Email);
var adminEmails = unitWork.UserRepository.GetProjection(u => u.UserType == UserTypes.Manager, u => u.Email);
var allEmails = userEmails.Union(adminEmails);
List <EmailAddress> usersEmailList = new List <EmailAddress>();
foreach (var email in allEmails)
{
usersEmailList.Add(new EmailAddress()
{
Email = email
});
}
if (usersEmailList.Count > 0)
{
ISMTPSettingsService smtpService = new SMTPSettingsService(context);
var smtpSettings = smtpService.GetPrivate();
SMTPSettingsModel smtpSettingsModel = new SMTPSettingsModel();
if (smtpSettings != null)
{
smtpSettingsModel.Host = smtpSettings.Host;
smtpSettingsModel.Port = smtpSettings.Port;
smtpSettingsModel.Username = smtpSettings.Username;
smtpSettingsModel.Password = smtpSettings.Password;
smtpSettingsModel.AdminEmail = smtpSettings.AdminEmail;
smtpSettingsModel.SenderName = smtpSettings.SenderName;
}
string message = "", subject = "", footerMessage = "";
var emailMessage = unitWork.EmailMessagesRepository.GetOne(m => m.MessageType == EmailMessageType.ProjectDeleted);
if (emailMessage != null)
{
subject = emailMessage.Subject;
message = emailMessage.Message;
footerMessage = emailMessage.FooterMessage;
}
mHelper = new MessageHelper();
message += mHelper.ProjectDeletionMessage(project.Title);
IEmailHelper emailHelper = new EmailHelper(smtpSettingsModel.AdminEmail, smtpSettings.SenderName, smtpSettingsModel);
emailHelper.SendEmailToUsers(usersEmailList, subject, "", message, footerMessage);
}
return(response);
}
}
public ActionResponse CancelRequest(int projectId, int userId)
{
using (var unitWork = new UnitOfWork(context))
{
IMessageHelper mHelper;
ActionResponse response = new ActionResponse();
var project = unitWork.ProjectRepository.GetByID(projectId);
if (project == null)
{
mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetNotFound("Project");
return(response);
}
var userOrganizationsList = unitWork.UserRepository.GetProjection(u => u.Id == userId, u => u.OrganizationId);
var userOrganizationId = (from orgId in userOrganizationsList
select orgId).FirstOrDefault();
int projectOrganizationId = 0;
EFProjectDeletionRequests deletionRequest = null;
var deletionRequestArr = unitWork.ProjectDeletionRepository.GetWithInclude(d => d.ProjectId == projectId, new string[] { "RequestedBy" });
foreach (var delRequest in deletionRequestArr)
{
projectOrganizationId = delRequest.RequestedBy.OrganizationId;
deletionRequest = delRequest;
}
bool canEditProject = false;
if (projectOrganizationId == userOrganizationId)
{
canEditProject = true;
}
else
{
var funderProjectsIds = unitWork.ProjectFundersRepository.GetProjection(f => f.FunderId == userOrganizationId, f => f.ProjectId).ToList();
var implementerProjectIds = unitWork.ProjectImplementersRepository.GetProjection(i => i.ImplementerId == userOrganizationId, i => i.ProjectId).ToList();
var membershipProjectIds = unitWork.ProjectMembershipRepository.GetProjection(m => (m.UserId == userId && m.IsApproved == true), m => m.ProjectId);
var combinedProjectIds = funderProjectsIds.Union(implementerProjectIds);
combinedProjectIds = combinedProjectIds.Union(membershipProjectIds);
if (!combinedProjectIds.Contains(projectId))
{
mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetInvalidProjectEdit();
return(response);
}
canEditProject = true;
}
if (canEditProject)
{
unitWork.ProjectDeletionRepository.Delete(deletionRequest);
unitWork.Save();
var projectFunderIds = unitWork.ProjectFundersRepository.GetProjection(f => f.ProjectId == project.Id, f => f.FunderId);
var projectImplementerIds = unitWork.ProjectImplementersRepository.GetProjection(i => i.ProjectId == project.Id, i => i.ImplementerId);
var orgIds = projectFunderIds.Union(projectImplementerIds).ToList();
if (!orgIds.Contains(userOrganizationId))
{
orgIds.Add(userOrganizationId);
}
var userEmails = unitWork.UserRepository.GetProjection(u => u.UserType == UserTypes.Standard && orgIds.Contains(u.OrganizationId), u => u.Email);
var adminEmails = unitWork.UserRepository.GetProjection(u => u.UserType == UserTypes.Manager, u => u.Email);
var allEmails = userEmails.Union(adminEmails);
List <EmailAddress> usersEmailList = new List <EmailAddress>();
foreach (var email in allEmails)
{
usersEmailList.Add(new EmailAddress()
{
Email = email
});
}
if (usersEmailList.Count > 0)
{
ISMTPSettingsService smtpService = new SMTPSettingsService(context);
var smtpSettings = smtpService.GetPrivate();
SMTPSettingsModel smtpSettingsModel = new SMTPSettingsModel();
if (smtpSettings != null)
{
smtpSettingsModel.Host = smtpSettings.Host;
smtpSettingsModel.Port = smtpSettings.Port;
smtpSettingsModel.Username = smtpSettings.Username;
smtpSettingsModel.Password = smtpSettings.Password;
smtpSettingsModel.AdminEmail = smtpSettings.AdminEmail;
smtpSettingsModel.SenderName = smtpSettings.SenderName;
}
string message = "", subject = "", footerMessage = "";
string projectTitle = "<h5>Project title: " + project.Title + "</h5>";
var emailMessage = unitWork.EmailMessagesRepository.GetOne(m => m.MessageType == EmailMessageType.ProjectDeletionCancelled);
if (emailMessage != null)
{
subject = emailMessage.Subject;
message = projectTitle + emailMessage.Message;
footerMessage = emailMessage.FooterMessage;
}
IEmailHelper emailHelper = new EmailHelper(smtpSettingsModel.AdminEmail, smtpSettings.SenderName, smtpSettingsModel);
emailHelper.SendEmailToUsers(usersEmailList, subject, "", message, footerMessage);
}
}
return(response);
}
}
public ActionResponse AddRequest(ProjectDeletionRequestModel model)
{
using (var unitWork = new UnitOfWork(context))
{
ActionResponse response = new ActionResponse();
IMessageHelper mHelper;
var project = unitWork.ProjectRepository.GetByID(model.ProjectId);
if (project == null)
{
mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetNotFound("Project");
return(response);
}
var user = unitWork.UserRepository.GetWithInclude(u => u.Id == model.UserId, new string[] { "Organization" }).FirstOrDefault();
if (user == null)
{
mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetNotFound("User");
return(response);
}
var isRequestExists = unitWork.ProjectDeletionRepository.GetOne(p => p.ProjectId == project.Id);
if (isRequestExists != null && isRequestExists.Status == ProjectDeletionStatus.Requested)
{
mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetProjectDeletionExistsMessage();
return(response);
}
if (isRequestExists != null && isRequestExists.Status == ProjectDeletionStatus.Approved)
{
mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetProjectDeletionApprovedMessage();
return(response);
}
if (isRequestExists != null && isRequestExists.Status == ProjectDeletionStatus.Cancelled)
{
isRequestExists.Status = ProjectDeletionStatus.Requested;
isRequestExists.RequestedOn = DateTime.Now;
isRequestExists.StatusUpdatedOn = DateTime.Now;
isRequestExists.RequestedBy = user;
unitWork.ProjectDeletionRepository.Update(isRequestExists);
}
else
{
unitWork.ProjectDeletionRepository.Insert(new EFProjectDeletionRequests()
{
Project = project,
RequestedBy = user,
RequestedOn = DateTime.Now,
StatusUpdatedOn = DateTime.Now,
Status = ProjectDeletionStatus.Requested
});
}
unitWork.Save();
var projectFunderIds = unitWork.ProjectFundersRepository.GetProjection(f => f.ProjectId == project.Id, f => f.FunderId);
var projectImplementerIds = unitWork.ProjectImplementersRepository.GetProjection(i => i.ProjectId == project.Id, i => i.ImplementerId);
var orgIds = projectFunderIds.Union(projectImplementerIds).ToList();
if (!orgIds.Contains(user.OrganizationId))
{
orgIds.Add(user.OrganizationId);
}
var userEmails = unitWork.UserRepository.GetProjection(u => u.UserType == UserTypes.Standard && orgIds.Contains(u.OrganizationId) && u.Id != user.Id, u => u.Email);
//var adminEmails = unitWork.UserRepository.GetProjection(u => u.UserType == UserTypes.Manager && u.Id != user.Id, u => u.Email);
//var allEmails = userEmails.Union(adminEmails);
List <EmailAddress> usersEmailList = new List <EmailAddress>();
foreach (var email in userEmails)
{
usersEmailList.Add(new EmailAddress()
{
Email = email
});
}
if (usersEmailList.Count > 0)
{
ISMTPSettingsService smtpService = new SMTPSettingsService(context);
var smtpSettings = smtpService.GetPrivate();
SMTPSettingsModel smtpSettingsModel = new SMTPSettingsModel();
if (smtpSettings != null)
{
smtpSettingsModel.Host = smtpSettings.Host;
smtpSettingsModel.Port = smtpSettings.Port;
smtpSettingsModel.Username = smtpSettings.Username;
smtpSettingsModel.Password = smtpSettings.Password;
smtpSettingsModel.AdminEmail = smtpSettings.AdminEmail;
smtpSettingsModel.SenderName = smtpSettings.SenderName;
}
string message = "", subject = "", footerMessage = "";
string projectTitle = "<h5>Project title: " + project.Title + "</h5>";
string requestedBy = "<h5>Requested by: " + user.Email + " (" + user.Organization.OrganizationName + ")</h5>";
var emailMessage = unitWork.EmailMessagesRepository.GetOne(m => m.MessageType == EmailMessageType.ProjectDeletionRequest);
if (emailMessage != null)
{
subject = emailMessage.Subject;
message = projectTitle + requestedBy + emailMessage.Message;
footerMessage = emailMessage.FooterMessage;
}
IEmailHelper emailHelper = new EmailHelper(smtpSettingsModel.AdminEmail, smtpSettings.SenderName, smtpSettingsModel);
emailHelper.SendEmailToUsers(usersEmailList, subject, "", message, footerMessage);
}
return(response);
}
}
public ActionResponse UnApproveMembershipRequest(int userId, int projectId, int funderId, int ownerId, MembershipTypes membershipType)
{
using (var unitWork = new UnitOfWork(context))
{
ActionResponse response = new ActionResponse();
IMessageHelper mHelper;
UserTypes userType = UserTypes.Standard;
var actionUser = unitWork.UserRepository.GetOne(u => u.Id == ownerId);
if (actionUser != null)
{
userType = actionUser.UserType;
}
if (userType != UserTypes.Manager && userType != UserTypes.SuperAdmin)
{
var isUserOwner = unitWork.ProjectRepository.GetOne(p => (p.Id == projectId && p.CreatedById == ownerId));
if (isUserOwner == null)
{
var isFunderOwner = unitWork.ProjectFundersRepository.GetOne(f => f.FunderId == funderId && f.ProjectId == projectId);
var isImplementerOwner = unitWork.ProjectImplementersRepository.GetOne(i => i.ImplementerId == funderId && i.ProjectId == projectId);
if (isFunderOwner == null && isImplementerOwner == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetInvalidFunderApprovalMessage();
response.Success = false;
return(response);
}
}
}
var user = unitWork.UserRepository.GetOne(u => u.Id == userId);
if (user == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetNotFound("User");
response.Success = false;
return(response);
}
var project = unitWork.ProjectRepository.GetOne(p => p.Id == projectId);
if (project == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetNotFound("Project");
response.Success = false;
return(response);
}
var isRequestExists = unitWork.ProjectMembershipRepository.GetOne(r => r.ProjectId == projectId && r.UserId == user.Id && r.MembershipType == membershipType);
if (isRequestExists == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetNotFound("Membership Request");
response.Success = false;
return(response);
}
unitWork.ProjectMembershipRepository.Delete(isRequestExists);
unitWork.Save();
//Send status email
string requestedProject = project.Title;
List <EmailAddress> usersEmailList = new List <EmailAddress>();
usersEmailList.Add(new EmailAddress()
{
Email = user.Email,
});
if (usersEmailList.Count > 0)
{
//Send emails
ISMTPSettingsService smtpService = new SMTPSettingsService(context);
var smtpSettings = smtpService.GetPrivate();
SMTPSettingsModel smtpSettingsModel = new SMTPSettingsModel();
if (smtpSettings != null)
{
smtpSettingsModel.Host = smtpSettings.Host;
smtpSettingsModel.Port = smtpSettings.Port;
smtpSettingsModel.Username = smtpSettings.Username;
smtpSettingsModel.Password = smtpSettings.Password;
smtpSettingsModel.AdminEmail = smtpSettings.AdminEmail;
smtpSettingsModel.SenderName = smtpSettings.SenderName;
}
string message = "", subject = "", footerMessage = "";
var emailMessage = unitWork.EmailMessagesRepository.GetOne(m => m.MessageType == EmailMessageType.ProjectPermissionDenied);
if (emailMessage != null)
{
subject = emailMessage.Subject;
message = emailMessage.Message;
footerMessage = emailMessage.FooterMessage;
}
mHelper = new MessageHelper();
message += mHelper.ProjectPermissionDenied(requestedProject);
IEmailHelper emailHelper = new EmailHelper(smtpSettingsModel.AdminEmail, smtpSettings.SenderName, smtpSettingsModel);
emailHelper.SendEmailToUsers(usersEmailList, subject, "", message, footerMessage);
}
return(response);
}
}
public AdminSettingsModel()
{
HeaderSettingsModel = new HeaderSettingsModel();
LoginPageSettingsModel = new LoginPageSettingsModel();
SMTPSettingsModel = new SMTPSettingsModel();
}
public ActionResponse AddMembershipRequest(ProjectMembershipRequestModel model)
{
using (var unitWork = new UnitOfWork(context))
{
ActionResponse response = new ActionResponse();
IMessageHelper mHelper;
try
{
var project = unitWork.ProjectRepository.GetByID(model.ProjectId);
if (project == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetNotFound("Project");
response.Success = false;
return(response);
}
var user = unitWork.UserRepository.GetOne(u => u.Email == model.UserEmail);
if (user == null)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetNotFound("User");
response.Success = false;
return(response);
}
int membershipConstant = (int)model.MembershipType;
var requestExists = unitWork.ProjectMembershipRepository.GetOne(r => (r.ProjectId == model.ProjectId && r.UserId == user.Id && r.MembershipType == (MembershipTypes)model.MembershipType));
if (requestExists != null)
{
mHelper = new MessageHelper();
requestExists.Dated = DateTime.Now;
unitWork.ProjectMembershipRepository.Update(requestExists);
response.Message = mHelper.AlreadyExists("Membership request");
return(response);
}
else
{
requestExists = unitWork.ProjectMembershipRepository.Insert(new EFProjectMembershipRequests()
{
Project = project,
User = user,
OrganizationId = user.OrganizationId,
Dated = DateTime.Now,
MembershipType = model.MembershipType,
IsApproved = false
});
}
unitWork.Save();
//Send email to all members of the funder
var projectFunderIds = unitWork.ProjectFundersRepository.GetProjection(p => p.ProjectId == model.ProjectId, p => p.FunderId);
var users = unitWork.UserRepository.GetManyQueryable(u => projectFunderIds.Contains(u.OrganizationId));
var requestingUser = unitWork.UserRepository.GetWithInclude(u => u.Id == user.Id, new string[] { "Organization" }).FirstOrDefault();
string requestingOrganization = requestingUser != null ? requestingUser.Organization.OrganizationName : null;
List <EmailAddress> usersEmailList = new List <EmailAddress>();
foreach (var u in users)
{
usersEmailList.Add(new EmailAddress()
{
Email = u.Email,
});
}
if (usersEmailList.Count == 0)
{
var projectOwner = unitWork.UserRepository.GetOne(o => o.Id == project.CreatedById);
if (projectOwner != null)
{
usersEmailList.Add(new EmailAddress()
{
Email = projectOwner.Email
});
}
}
if (usersEmailList.Count > 0)
{
//Send emails
ISMTPSettingsService smtpService = new SMTPSettingsService(context);
var smtpSettings = smtpService.GetPrivate();
SMTPSettingsModel smtpSettingsModel = new SMTPSettingsModel();
if (smtpSettings != null)
{
smtpSettingsModel.Host = smtpSettings.Host;
smtpSettingsModel.Port = smtpSettings.Port;
smtpSettingsModel.Username = smtpSettings.Username;
smtpSettingsModel.Password = smtpSettings.Password;
smtpSettingsModel.AdminEmail = smtpSettings.AdminEmail;
smtpSettingsModel.SenderName = smtpSettings.SenderName;
}
string message = "", subject = "", footerMessage = "";
var emailMessage = unitWork.EmailMessagesRepository.GetOne(m => m.MessageType == EmailMessageType.NewOrgToProject);
if (emailMessage != null)
{
subject = emailMessage.Subject;
message = emailMessage.Message;
footerMessage = emailMessage.FooterMessage;
}
mHelper = new MessageHelper();
string role = model.MembershipType.ToString();
message += mHelper.NewOrganizationForProject(requestingOrganization, project.Title, role);
IEmailHelper emailHelper = new EmailHelper(smtpSettingsModel.AdminEmail, smtpSettings.SenderName, smtpSettingsModel);
emailHelper.SendEmailToUsers(usersEmailList, subject, "", message, footerMessage);
}
}
catch (Exception ex)
{
response.Message = ex.Message;
response.Success = false;
}
return(response);
}
}
public async Task <ActionResponse> DeleteAsync(int id, int newId)
{
ActionResponse response = new ActionResponse();
IMessageHelper mHelper;
using (var unitWork = new UnitOfWork(context))
{
EFSector sector = null;
EFSector newSector = null;
var sectors = await unitWork.SectorRepository.GetWithIncludeAsync(s => (s.Id == id || s.Id == newId), new string[] { "SectorType" });
if (sectors.Count() < 2 && newId != 0)
{
mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetNotFound("Sector");
return(await Task <ActionResponse> .Run(() => response).ConfigureAwait(false));
}
var sectorToDelete = (from s in sectors
where s.Id == id
select s).FirstOrDefault();
if (sectorToDelete.IsUnAttributed)
{
mHelper = new MessageHelper();
response.Message = mHelper.UnattributedCannotBeDeleted("Sector");
response.Success = false;
return(response);
}
if (sectorToDelete != null)
{
if (sectorToDelete.SectorType.IsSourceType)
{
mHelper = new MessageHelper();
response.Message = mHelper.GetCannotBeDeleted("Sector imported from source");
response.Success = false;
return(response);
}
}
var projectSectors = await unitWork.ProjectSectorsRepository.GetManyQueryableAsync(s => (s.SectorId == id || s.SectorId == newId));
var projectIds = (from s in projectSectors
select s.ProjectId).Distinct().ToList <int>();
if (projectIds.Count() > 0 && newId == 0)
{
mHelper = new MessageHelper();
response.Success = false;
response.Message = mHelper.GetDependentProjectsOnSectorMessage();
return(await Task <ActionResponse> .Run(() => response).ConfigureAwait(false));
}
var sectorsInDb = (from s in projectSectors
select new SectorsKeyView()
{
SectorId = s.SectorId,
ProjectId = s.ProjectId
});
projectSectors = (from s in projectSectors
where s.SectorId == id
select s);
sector = (from s in sectors
where s.Id == id
select s).FirstOrDefault();
newSector = (from s in sectors
where s.Id == newId
select s).FirstOrDefault();
var projects = unitWork.ProjectRepository.GetWithInclude(p => projectIds.Contains(p.Id), new string[] { "CreatedBy" });
List <string> projectNames = (from p in projects
select p.Title).ToList <string>();
var emails = (from p in projects
select p.CreatedBy.Email);
try
{
var strategy = context.Database.CreateExecutionStrategy();
await strategy.ExecuteAsync(async() =>
{
using (var transaction = context.Database.BeginTransaction())
{
List <EFProjectSectors> sectorsList = new List <EFProjectSectors>();
foreach (var projectSector in projectSectors)
{
var isExists = (from s in sectorsList
where s.SectorId == newId && s.ProjectId == projectSector.ProjectId
select s).FirstOrDefault();
var isExistsInDb = (from s in sectorsInDb
where s.SectorId == newId && s.ProjectId == projectSector.ProjectId
select s).FirstOrDefault();
if (isExists == null && isExistsInDb == null)
{
sectorsList.Add(new EFProjectSectors()
{
SectorId = newId,
ProjectId = projectSector.ProjectId,
FundsPercentage = projectSector.FundsPercentage
});
}
unitWork.ProjectSectorsRepository.Delete(projectSector);
}
await unitWork.SaveAsync();
unitWork.ProjectSectorsRepository.InsertMultiple(sectorsList);
await unitWork.SaveAsync();
unitWork.SectorRepository.Delete(sector);
await unitWork.SaveAsync();
transaction.Commit();
if (projectNames.Count > 0)
{
var users = unitWork.UserRepository.GetManyQueryable(u => u.UserType == UserTypes.Manager || u.UserType == UserTypes.SuperAdmin);
List <EmailAddress> emailAddresses = new List <EmailAddress>();
foreach (var user in users)
{
emailAddresses.Add(new EmailAddress()
{
Email = user.Email
});
}
foreach (var email in emails)
{
var isEmailExists = (from e in emailAddresses
where e.Email.Equals(email, StringComparison.OrdinalIgnoreCase)
select e).FirstOrDefault();
if (isEmailExists == null)
{
emailAddresses.Add(new EmailAddress()
{
Email = email
});
}
}
if (emailAddresses.Count > 0)
{
ISMTPSettingsService smtpService = new SMTPSettingsService(context);
var smtpSettings = smtpService.GetPrivate();
SMTPSettingsModel smtpSettingsModel = new SMTPSettingsModel();
if (smtpSettings != null)
{
smtpSettingsModel.Host = smtpSettings.Host;
smtpSettingsModel.Port = smtpSettings.Port;
smtpSettingsModel.Username = smtpSettings.Username;
smtpSettingsModel.Password = smtpSettings.Password;
smtpSettingsModel.AdminEmail = smtpSettings.AdminEmail;
smtpSettingsModel.SenderName = smtpSettings.SenderName;
}
string subject = "", message = "", footerMessage = "";
var emailMessage = unitWork.EmailMessagesRepository.GetOne(m => m.MessageType == EmailMessageType.ChangedMappingEffectedProject);
if (emailMessage != null)
{
subject = emailMessage.Subject;
message = emailMessage.Message;
footerMessage = emailMessage.FooterMessage;
}
mHelper = new MessageHelper();
string oldSectorName = sector != null ? sector.SectorName : null;
string newSectorName = newSector != null ? newSector.SectorName : null;
message += mHelper.ChangedMappingAffectedProjectsMessage(projectNames, oldSectorName, newSectorName);
IEmailHelper emailHelper = new EmailHelper(smtpSettingsModel.AdminEmail, smtpSettings.SenderName, smtpSettingsModel);
emailHelper.SendEmailToUsers(emailAddresses, subject, "", message);
}
}
}
});
}
catch (Exception ex)
{
response.Success = false;
response.Message = ex.Message;
}
}
return(await Task <ActionResponse> .Run(() => response).ConfigureAwait(false));
}
