public void SendMailToParticipatedUser(DataTable particaipateduserTable)
{
try
{
RegisteredVolunteerRepository registeredVolunteerRepository = new RegisteredVolunteerRepository();
foreach (DataRow row in particaipateduserTable.Rows)
{
string body = "";
string subject = "";
if (!row.IsNull("Employee ID") && !row.IsNull("Event ID"))
{
RegisteredVolunteer registeredVolunteer = registeredVolunteerRepository.GetRegisteredVolunteerByAssociateID(row["Employee ID"].ToString());
Event outreachEvent = eventRepository.FindEvent(row["Event ID"].ToString());
if (registeredVolunteer != null && outreachEvent != null)
{
string Creds = outreachEvent.EventId + "\n" + registeredVolunteer.EmployeeID + "\n" + ConstantValues.Participated;
string encrypt = AESCrypt.EncryptString(Creds);
string url = ConfigurationManager.AppSettings["URL"].ToString() + "Feedback?FeedbackValue=" + encrypt + "";
subject = "Feedback for {0} Dated {1}";
subject = string.Format(subject, outreachEvent.EventName, outreachEvent.EventDate.Value.ToShortDateString());
body = new System.IO.StreamReader(HttpContext.Current.Server.MapPath("~/MailTemplate/Participate_Mail.html")).ReadToEnd();
body = body.Replace("{UserName}", string.IsNullOrEmpty(registeredVolunteer.EmployeeName) ? "-" : registeredVolunteer.EmployeeName)
.Replace("{EventName}", string.IsNullOrEmpty(outreachEvent.EventName) ? "-" : outreachEvent.EventName)
.Replace("{EventDate}", string.IsNullOrEmpty(outreachEvent.EventDate.Value.ToShortDateString()) ? "-" : outreachEvent.EventDate.Value.ToShortDateString())
.Replace("{Url}", string.IsNullOrEmpty(url) ? "-" : url);
SendMail(subject, body, ConfigurationManager.AppSettings["CommonMail"].ToString());
}
}
}
}
catch (Exception ex)
{
ExceptionLogger logger = new ExceptionLogger()
{
ControllerName = "OutreachMail",
ActionrName = "SendMailToParticipatedUser",
ExceptionMessage = ex.Message,
ExceptionStackTrace = ex.StackTrace,
LogDateTime = DateTime.Now
};
ExceptionRepository exceptionRepository = new ExceptionRepository();
exceptionRepository.AddException(logger);
}
}
private void InsertParticipatedUserDetails(DataTable particaipateduserTable)
{
try
{
foreach (DataRow row in particaipateduserTable.Rows)
{
RegisteredVolunteer registeredVolunteer = new RegisteredVolunteer();
registeredVolunteer.EventId = row["Event ID"].ToString();
if (!row.IsNull("Employee ID"))
{
registeredVolunteer.EmployeeID = row["Employee ID"].ToString();
}
if (!row.IsNull("Employee Name"))
{
registeredVolunteer.EmployeeName = row["Employee Name"].ToString();
}
if (!row.IsNull("Business Unit"))
{
registeredVolunteer.BusinessUnit = row["Business Unit"].ToString();
}
if (!row.IsNull("Volunteer Hours"))
{
registeredVolunteer.VolunteerHours = Convert.ToInt32(row["Volunteer Hours"]);
}
if (!row.IsNull("Travel Hours"))
{
registeredVolunteer.TravelHours = Convert.ToInt32(row["Travel Hours"]);
}
RegisteredVolunteerRepository registeredVolunteerRepository = new RegisteredVolunteerRepository();
registeredVolunteerRepository.AddRegisteredVolunteer(registeredVolunteer);
}
outreachMail.SendMailToParticipatedUser(particaipateduserTable);
}
catch (Exception ex)
{
ExceptionLogger logger = new ExceptionLogger()
{
ControllerName = "ExcelToDB",
ActionrName = "InsertParticipatedUserDetails",
ExceptionMessage = ex.Message,
ExceptionStackTrace = ex.StackTrace,
LogDateTime = DateTime.Now
};
ExceptionRepository exceptionRepository = new ExceptionRepository();
exceptionRepository.AddException(logger);
}
}
public void AddRegisteredVolunteer(RegisteredVolunteer volunteer)
{
IRegisteredVolunteerRepository.Insert(volunteer);
IRegisteredVolunteerRepository.Save();
}
public RegisteredVolunteer FindRegisteredVolunteer(RegisteredVolunteer volunteer)
{
return(IRegisteredVolunteerRepository.SelectByID(volunteer));
}
