1023 lines
51 KiB
C#
1023 lines
51 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using HRM.BO;
|
|||
|
|
using HRM.DA;
|
|||
|
|
using HRM.Report;
|
|||
|
|
using HRM.BO.Configuration;
|
|||
|
|
using System.Data;
|
|||
|
|
using System.IO;
|
|||
|
|
using System.Threading;
|
|||
|
|
using NPOI.SS.Formula.Functions;
|
|||
|
|
using System.Windows.Forms;
|
|||
|
|
using System.Linq;
|
|||
|
|
using Microsoft.Extensions.Configuration;
|
|||
|
|
|
|||
|
|
namespace HRM.MailNotificationProcess
|
|||
|
|
{
|
|||
|
|
public class SchedularSetupProcess
|
|||
|
|
{
|
|||
|
|
#region Global Properties
|
|||
|
|
|
|||
|
|
private EmailSettings emailSettings;
|
|||
|
|
private MailNotificationProcessConfiguration mailNotificationProcessConfiguration;
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region Constractors
|
|||
|
|
public SchedularSetupProcess()
|
|||
|
|
{
|
|||
|
|
this.emailSettings = null;
|
|||
|
|
this.mailNotificationProcessConfiguration = null;
|
|||
|
|
}
|
|||
|
|
public SchedularSetupProcess(EmailSettings pEmailSettings, MailNotificationProcessConfiguration oMailNotificationProcessConfiguration)
|
|||
|
|
{
|
|||
|
|
this.emailSettings = pEmailSettings;
|
|||
|
|
this.mailNotificationProcessConfiguration = oMailNotificationProcessConfiguration;
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region wait the thread
|
|||
|
|
|
|||
|
|
public bool waitTheThread(DateTime startAt)
|
|||
|
|
{
|
|||
|
|
if (!mailNotificationProcessConfiguration.IsTest)
|
|||
|
|
{
|
|||
|
|
double timeLeft = startAt.Subtract(DateTime.Now).TotalMilliseconds;
|
|||
|
|
if (timeLeft < 0)
|
|||
|
|
{
|
|||
|
|
return false;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
// Thread.Sleep(Convert.ToInt32(timeLeft));
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
return true;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region CreateAndSendMail
|
|||
|
|
|
|||
|
|
private void CreateAndSendMail(SchedularSetup pSchedularSetup, string toEmail, string pdfFileLocation = "")
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
MailSender mailSender = new MailSender();
|
|||
|
|
mailSender.AddTo(toEmail);
|
|||
|
|
mailSender.Subject = pSchedularSetup.MailSubject;
|
|||
|
|
mailSender.Body = pSchedularSetup.MailBody.Replace("<<EmployeeName>>", "Sir/Madam");
|
|||
|
|
|
|||
|
|
if(pSchedularSetup.Type == EnumSchedularType.Yesterday_Absent_Notification_Self)
|
|||
|
|
{
|
|||
|
|
mailSender.Body = mailSender.Body.Replace("<<Date>>", DateTime.Today.AddDays(-1).ToLongDateString());
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (pdfFileLocation != "")
|
|||
|
|
{
|
|||
|
|
mailSender.AddAttachment(pdfFileLocation);
|
|||
|
|
}
|
|||
|
|
mailSender.SendMail(emailSettings);
|
|||
|
|
}
|
|||
|
|
catch (Exception)
|
|||
|
|
{
|
|||
|
|
throw;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private void CreateAndSendMailForMonthlyAttendanceSummary(SchedularSetup pSchedularSetup, DateTime date, string toEmail, string pdfFileLocation = "")
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
MailSender mailSender = new MailSender();
|
|||
|
|
mailSender.AddTo(toEmail);
|
|||
|
|
mailSender.Subject = pSchedularSetup.MailSubject;
|
|||
|
|
mailSender.Body = pSchedularSetup.MailBody.Replace("<<EmployeeName>>", "Sir/Madam").Replace("<<Date>>", date.ToString("MMMM yyyy"));
|
|||
|
|
|
|||
|
|
|
|||
|
|
if (pdfFileLocation != "")
|
|||
|
|
{
|
|||
|
|
mailSender.AddAttachment(pdfFileLocation);
|
|||
|
|
}
|
|||
|
|
mailSender.SendMail(emailSettings);
|
|||
|
|
}
|
|||
|
|
catch (Exception)
|
|||
|
|
{
|
|||
|
|
throw;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private void CreateAndSendMail(SchedularSetup pSchedularSetup,
|
|||
|
|
string toEmail,List<string> cc, string pdfFileLocation = "")
|
|||
|
|
{
|
|||
|
|
MailSender mailSender = new MailSender();
|
|||
|
|
mailSender.AddTo(toEmail);
|
|||
|
|
cc.ForEach(x =>
|
|||
|
|
{
|
|||
|
|
mailSender.AddCC(x);
|
|||
|
|
});
|
|||
|
|
mailSender.Subject = pSchedularSetup.MailSubject;
|
|||
|
|
mailSender.Body = pSchedularSetup.MailBody.Replace("<<EmployeeName>>", "Sir/Madam");
|
|||
|
|
|
|||
|
|
if (pSchedularSetup.Type == EnumSchedularType.Yesterday_Absent_Notification_Self)
|
|||
|
|
{
|
|||
|
|
mailSender.Body = mailSender.Body.Replace("<<Date>>", DateTime.Today.AddDays(-1).ToLongDateString());
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (pdfFileLocation != "")
|
|||
|
|
{
|
|||
|
|
mailSender.AddAttachment(pdfFileLocation);
|
|||
|
|
}
|
|||
|
|
mailSender.SendMail(emailSettings);
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private void CreateAndSendMailSelfOnError(SchedularSetup pSchedularSetup, string ErrorMsg, List<string> cc, string pdfFileLocation = "")
|
|||
|
|
{
|
|||
|
|
MailSender mailSender = new MailSender();
|
|||
|
|
|
|||
|
|
if (pSchedularSetup.OnErrorMail != null)
|
|||
|
|
{
|
|||
|
|
pSchedularSetup.OnErrorMail.ForEach(x =>
|
|||
|
|
{
|
|||
|
|
mailSender.AddTo(x);
|
|||
|
|
});
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (cc != null)
|
|||
|
|
{
|
|||
|
|
cc.ForEach(x =>
|
|||
|
|
{
|
|||
|
|
mailSender.AddCC(x);
|
|||
|
|
});
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
mailSender.Subject = "Error - " + pSchedularSetup.MailSubject;
|
|||
|
|
mailSender.Body = "Looks like an error occured. Details: " + ErrorMsg;
|
|||
|
|
|
|||
|
|
if (pSchedularSetup.Type == EnumSchedularType.Yesterday_Absent_Notification_Self)
|
|||
|
|
{
|
|||
|
|
mailSender.Body = mailSender.Body.Replace("<<Date>>", DateTime.Today.AddDays(-1).ToLongDateString());
|
|||
|
|
mailSender.Subject = mailSender.Subject.Replace("<<Date>>", DateTime.Today.AddDays(-1).ToLongDateString());
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (pdfFileLocation != "")
|
|||
|
|
{
|
|||
|
|
mailSender.AddAttachment(pdfFileLocation);
|
|||
|
|
}
|
|||
|
|
mailSender.SendMail(emailSettings);
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
private void CreateAndSendMailSelf(SchedularSetup pSchedularSetup,
|
|||
|
|
Employee emp, List<string> cc, string pdfFileLocation = "")
|
|||
|
|
{
|
|||
|
|
MailSender mailSender = new MailSender();
|
|||
|
|
mailSender.AddTo(emp.EmailAddress);
|
|||
|
|
cc.ForEach(x =>
|
|||
|
|
{
|
|||
|
|
mailSender.AddCC(x);
|
|||
|
|
});
|
|||
|
|
mailSender.Subject = pSchedularSetup.MailSubject;
|
|||
|
|
mailSender.Body = pSchedularSetup.MailBody.Replace("<<EmployeeName>>", emp.Name);
|
|||
|
|
|
|||
|
|
if (pSchedularSetup.Type == EnumSchedularType.Yesterday_Absent_Notification_Self)
|
|||
|
|
{
|
|||
|
|
mailSender.Body = mailSender.Body.Replace("<<Date>>", DateTime.Today.AddDays(-1).ToLongDateString());
|
|||
|
|
mailSender.Subject = mailSender.Subject.Replace("<<Date>>", DateTime.Today.AddDays(-1).ToLongDateString());
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (pdfFileLocation != "")
|
|||
|
|
{
|
|||
|
|
mailSender.AddAttachment(pdfFileLocation);
|
|||
|
|
}
|
|||
|
|
mailSender.SendMail(emailSettings);
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
private void CreateAndSendMailForLM(SchedularSetup pSchedularSetup, string toEmail, string empString)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
MailSender mailSender = new MailSender();
|
|||
|
|
mailSender.AddTo(toEmail);
|
|||
|
|
mailSender.Subject = pSchedularSetup.MailSubject;
|
|||
|
|
mailSender.Body = pSchedularSetup.MailBody.Replace("<<EmployeeName>>", "Sir/Madam")
|
|||
|
|
.Replace("<<AbsentEmployeeName>>", empString)
|
|||
|
|
.Replace("<<Date>>", DateTime.Today.AddDays(-1).ToLongDateString());
|
|||
|
|
|
|||
|
|
mailSender.SendMail(emailSettings);
|
|||
|
|
}
|
|||
|
|
catch (Exception)
|
|||
|
|
{
|
|||
|
|
throw;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region functionality for Schedular
|
|||
|
|
|
|||
|
|
#region AnniversaryNofication
|
|||
|
|
public void AnniversaryNofication(SchedularSetup pSchedularSetup)
|
|||
|
|
{
|
|||
|
|
if (waitTheThread(pSchedularSetup.StartAt))
|
|||
|
|
{
|
|||
|
|
List<Employee> employeeList = new EmployeeService().GetAllHREmpsWorkAniversary(mailNotificationProcessConfiguration.PayrollTypeForMailSchedular);
|
|||
|
|
List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
MailNotificationHistory tempMailNotificationHistory = null;
|
|||
|
|
|
|||
|
|
foreach (Employee emp in employeeList)
|
|||
|
|
{
|
|||
|
|
tempMailNotificationHistory = new MailNotificationHistory(emp.EmployeeNo.ToString(), pSchedularSetup.Type);
|
|||
|
|
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
if (emp.EmailAddress != null && emp.EmailAddress.Trim() == string.Empty)
|
|||
|
|
{
|
|||
|
|
CreateAndSendMail(pSchedularSetup, emp.EmailAddress);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
string ErrorMsg = ex.Message;
|
|||
|
|
CreateAndSendMailSelfOnError(pSchedularSetup, ErrorMsg, [], String.Empty);
|
|||
|
|
tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
tempMailNotificationHistory.Status = false;
|
|||
|
|
}
|
|||
|
|
finally
|
|||
|
|
{
|
|||
|
|
oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
{
|
|||
|
|
new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region BirthdayNofication
|
|||
|
|
public void BirthdayNofication(SchedularSetup pSchedularSetup)
|
|||
|
|
{
|
|||
|
|
if (waitTheThread(pSchedularSetup.StartAt))
|
|||
|
|
{
|
|||
|
|
List<Employee> employeeList = new EmployeeService().GetAllHREmpsBirthday(mailNotificationProcessConfiguration.PayrollTypeForMailSchedular);
|
|||
|
|
List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
MailNotificationHistory tempMailNotificationHistory = null;
|
|||
|
|
|
|||
|
|
foreach (Employee emp in employeeList)
|
|||
|
|
{
|
|||
|
|
tempMailNotificationHistory = new MailNotificationHistory(emp.EmployeeNo.ToString(), pSchedularSetup.Type);
|
|||
|
|
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
if (emp.EmailAddress != null && emp.EmailAddress.Trim() == string.Empty)
|
|||
|
|
{
|
|||
|
|
CreateAndSendMail(pSchedularSetup, emp.EmailAddress);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
string ErrorMsg = ex.Message;
|
|||
|
|
CreateAndSendMailSelfOnError(pSchedularSetup, ErrorMsg, [], String.Empty);
|
|||
|
|
tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
tempMailNotificationHistory.Status = false;
|
|||
|
|
}
|
|||
|
|
finally
|
|||
|
|
{
|
|||
|
|
oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
{
|
|||
|
|
new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region DailyAttendanceNofication
|
|||
|
|
//public void DailyAttendanceNofication(SchedularSetup pSchedularSetup)
|
|||
|
|
//{
|
|||
|
|
// if (waitTheThread(pSchedularSetup.StartAt))
|
|||
|
|
// {
|
|||
|
|
// byte[] report = null;
|
|||
|
|
// string fileFormate = Enum.GetName(pSchedularSetup.ReportFormat.GetType(), pSchedularSetup.ReportFormat);
|
|||
|
|
// string fileExtention = EnumHelper.GetEnumDescription(pSchedularSetup.ReportFormat);
|
|||
|
|
|
|||
|
|
// MailNotificationHistory tempMailNotificationHistory = null;
|
|||
|
|
// List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
|
|||
|
|
// DateTime fromDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0);
|
|||
|
|
// DateTime toDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, pSchedularSetup.StartAt.Hour, pSchedularSetup.StartAt.Minute, pSchedularSetup.StartAt.Second);
|
|||
|
|
|
|||
|
|
// if (pSchedularSetup.ToEmailAddress != null && pSchedularSetup.ToEmailAddress.Count > 0)
|
|||
|
|
// {
|
|||
|
|
// foreach (string toEmail in pSchedularSetup.ToEmailAddress)
|
|||
|
|
// {
|
|||
|
|
// try
|
|||
|
|
// {
|
|||
|
|
// tempMailNotificationHistory = new MailNotificationHistory(toEmail, pSchedularSetup.Type);
|
|||
|
|
|
|||
|
|
// report = report == null ? new AttendanceReport().GetDailyAttnReport(fromDate, toDate, EnumAttendanceType.None, mailNotificationProcessConfiguration.PayrollTypeForMailSchedular, fileFormate, true) : report;
|
|||
|
|
|
|||
|
|
// string pdfFileLocation = Directory.GetCurrentDirectory() + "\\CurrentDayAttnReport" + "(" + fromDate.ToString("dd MMM yyyy") + ")" + fileExtention;
|
|||
|
|
// File.WriteAllBytes(pdfFileLocation, report);
|
|||
|
|
|
|||
|
|
// CreateAndSendMail(pSchedularSetup, toEmail, pdfFileLocation);
|
|||
|
|
// }
|
|||
|
|
// catch (Exception ex)
|
|||
|
|
// {
|
|||
|
|
// tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
// tempMailNotificationHistory.Status = false;
|
|||
|
|
// }
|
|||
|
|
// finally
|
|||
|
|
// {
|
|||
|
|
// oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
// if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
// {
|
|||
|
|
// new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
//}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region PreviousDayAttendanceNofication
|
|||
|
|
//public void PreviousDayAttendanceNofication(SchedularSetup pSchedularSetup)
|
|||
|
|
//{
|
|||
|
|
// if (waitTheThread(pSchedularSetup.StartAt))
|
|||
|
|
// {
|
|||
|
|
// byte[] report = null;
|
|||
|
|
// string fileFormate = Enum.GetName(pSchedularSetup.ReportFormat.GetType(), pSchedularSetup.ReportFormat);
|
|||
|
|
// string fileExtention = EnumHelper.GetEnumDescription(pSchedularSetup.ReportFormat);
|
|||
|
|
|
|||
|
|
// MailNotificationHistory tempMailNotificationHistory = null;
|
|||
|
|
// List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
|
|||
|
|
// DateTime fromDate = DateTime.Today.AddDays(-1);
|
|||
|
|
// DateTime toDate = new DateTime(fromDate.Year, fromDate.Month, fromDate.Day, 23, 59, 0);
|
|||
|
|
|
|||
|
|
// if (pSchedularSetup.ToEmailAddress != null && pSchedularSetup.ToEmailAddress.Count > 0)
|
|||
|
|
// {
|
|||
|
|
// foreach (string toEmail in pSchedularSetup.ToEmailAddress)
|
|||
|
|
// {
|
|||
|
|
// try
|
|||
|
|
// {
|
|||
|
|
// tempMailNotificationHistory = new MailNotificationHistory(toEmail, pSchedularSetup.Type);
|
|||
|
|
|
|||
|
|
// report = report == null ? new AttendanceReport().GetDailyAttnReport(fromDate, toDate, EnumAttendanceType.None, mailNotificationProcessConfiguration.PayrollTypeForMailSchedular, fileFormate) : report;
|
|||
|
|
|
|||
|
|
// string pdfFileLocation = Directory.GetCurrentDirectory() + "\\PreviousDayAttnReport" + "(" + fromDate.ToString("dd MMM yyyy") + ")" + fileExtention;
|
|||
|
|
// File.WriteAllBytes(pdfFileLocation, report);
|
|||
|
|
|
|||
|
|
// CreateAndSendMail(pSchedularSetup, toEmail, pdfFileLocation);
|
|||
|
|
// }
|
|||
|
|
// catch (Exception ex)
|
|||
|
|
// {
|
|||
|
|
// tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
// tempMailNotificationHistory.Status = false;
|
|||
|
|
// }
|
|||
|
|
// finally
|
|||
|
|
// {
|
|||
|
|
// oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
// if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
// {
|
|||
|
|
// new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
//}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region PreviousDayAbsentNotification
|
|||
|
|
public void PreviousDayAbsentNotificationForEmp(SchedularSetup pSchedularSetup)
|
|||
|
|
{
|
|||
|
|
List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
EnumSchedularType notificationtype = pSchedularSetup.Type;
|
|||
|
|
List<Employee> employeeList = new EmployeeService().GetAllAbsentOnYesterdayEmps(mailNotificationProcessConfiguration.PayrollTypeForMailSchedular);
|
|||
|
|
List<Employee> allemps = new EmployeeService().GetAllEmps();
|
|||
|
|
List<EmployeeCordinator> empCord = new EmployeeCordinatorService().Get();
|
|||
|
|
Employee _employeeCordinator =new Employee();
|
|||
|
|
List<string> ccemail = new List<string>();
|
|||
|
|
foreach (Employee emp in employeeList)
|
|||
|
|
{
|
|||
|
|
ccemail = new List<string>();
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
#region check CoOrdinator and line manager
|
|||
|
|
|
|||
|
|
EmployeeCordinator cordinatorCheck = empCord.Find(x => x.EmployeeID == emp.ID);
|
|||
|
|
if (cordinatorCheck != null)
|
|||
|
|
{
|
|||
|
|
pSchedularSetup.IsCCCordinator = true;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
pSchedularSetup.IsCCCordinator = false;
|
|||
|
|
}
|
|||
|
|
if (emp.LineManagerID != null)
|
|||
|
|
{
|
|||
|
|
pSchedularSetup.IsCCLM = true;
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
pSchedularSetup.IsCCLM = false;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
if (emp.EmailAddress == "")
|
|||
|
|
{
|
|||
|
|
MailNotificationHistory own = new MailNotificationHistory();
|
|||
|
|
own.Description = "Employee Email address not found";
|
|||
|
|
own.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
own.Status = false;
|
|||
|
|
own.NotificationType = notificationtype;
|
|||
|
|
oMailNotificationHistoryList.Add(own);
|
|||
|
|
continue;
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (pSchedularSetup.IsCCLM == true) // line email address not found
|
|||
|
|
{
|
|||
|
|
Employee linemanager = new Employee();
|
|||
|
|
linemanager = allemps.Find(x => x.ID == emp.LineManagerID);
|
|||
|
|
if (linemanager == null)
|
|||
|
|
{
|
|||
|
|
MailNotificationHistory cc = new MailNotificationHistory();
|
|||
|
|
cc.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
cc.NotificationType = notificationtype;
|
|||
|
|
cc.Status = false;
|
|||
|
|
cc.Description = "Line Manager not found for the employee: " + emp.EmployeeNo;
|
|||
|
|
oMailNotificationHistoryList.Add(cc);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
if (pSchedularSetup.IsCCLM == true && linemanager.EmailAddress == "")
|
|||
|
|
{
|
|||
|
|
MailNotificationHistory cc = new MailNotificationHistory();
|
|||
|
|
cc.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
cc.NotificationType = notificationtype;
|
|||
|
|
cc.Status = false;
|
|||
|
|
cc.Description = "Line Manager Email address not found for the employee" + emp.EmployeeNo;
|
|||
|
|
oMailNotificationHistoryList.Add(cc);
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
ccemail.Add(linemanager.EmailAddress);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (pSchedularSetup.IsCCCordinator == true) // line email address not found
|
|||
|
|
{
|
|||
|
|
MailNotificationHistory crd = new MailNotificationHistory();
|
|||
|
|
EmployeeCordinator coordinator = empCord.Find(x => x.EmployeeID == emp.ID);
|
|||
|
|
|
|||
|
|
if(coordinator == null)
|
|||
|
|
{
|
|||
|
|
crd.Status = false;
|
|||
|
|
crd.NotificationType = notificationtype;
|
|||
|
|
crd.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
crd.Description = "Cordinator not found for themployee:" + emp.EmployeeNo + ' ' + emp.Name;
|
|||
|
|
oMailNotificationHistoryList.Add(crd);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
_employeeCordinator.ID = coordinator.CordinatorID;
|
|||
|
|
Employee tempCordinator = allemps.Find(x => x.ID == _employeeCordinator.ID);
|
|||
|
|
|
|||
|
|
if (tempCordinator != null && tempCordinator.EmailAddress == "")
|
|||
|
|
{
|
|||
|
|
crd.Status = false;
|
|||
|
|
crd.NotificationType = notificationtype;
|
|||
|
|
crd.EmployeeNo = tempCordinator.EmployeeNo;
|
|||
|
|
crd.Description = "CoOrdinator " + tempCordinator.EmployeeNo + tempCordinator.Name + "Email address not found";
|
|||
|
|
oMailNotificationHistoryList.Add(crd);
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
ccemail.Add(tempCordinator.EmailAddress);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
//allemps.
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
CreateAndSendMailSelf(pSchedularSetup, emp, ccemail, String.Empty);
|
|||
|
|
Thread.Sleep(100);
|
|||
|
|
MailNotificationHistory success = new MailNotificationHistory();
|
|||
|
|
success.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
success.Status = true;
|
|||
|
|
success.NotificationType = notificationtype;
|
|||
|
|
success.Description = "Successful for " + emp.EmployeeNo;
|
|||
|
|
oMailNotificationHistoryList.Add(success);
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
string ErrorMsg = ex.Message;
|
|||
|
|
CreateAndSendMailSelfOnError(pSchedularSetup, ErrorMsg, ccemail, String.Empty);
|
|||
|
|
Thread.Sleep(100);
|
|||
|
|
MailNotificationHistory mailFailed = new MailNotificationHistory();
|
|||
|
|
mailFailed.NotificationType = notificationtype;
|
|||
|
|
mailFailed.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
mailFailed.Status = false;
|
|||
|
|
mailFailed.Description = ex.Message.Length > 256 ? ex.Message.Substring(0,256):ex.Message;
|
|||
|
|
oMailNotificationHistoryList.Add(mailFailed);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
MailNotificationHistory mailFailed = new MailNotificationHistory();
|
|||
|
|
mailFailed.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
mailFailed.Description = ex.Message.Length > 256 ? ex.Message.Substring(0, 256) : ex.Message;
|
|||
|
|
mailFailed.NotificationType = notificationtype;
|
|||
|
|
mailFailed.Status = false;
|
|||
|
|
}
|
|||
|
|
//finally
|
|||
|
|
//{
|
|||
|
|
// oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
//}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
{
|
|||
|
|
new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
pSchedularSetup.Remarks = ex.Message.Length > 256 ? ex.Message.Substring(0, 256) : ex.Message;
|
|||
|
|
}
|
|||
|
|
finally
|
|||
|
|
{
|
|||
|
|
pSchedularSetup.LastExecuteDateTime = DateTime.Now;
|
|||
|
|
SchedularSetupService oSchedularSetupService = new SchedularSetupService();
|
|||
|
|
oSchedularSetupService.Save(pSchedularSetup);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region MonthlyAttendanceSummaryForLM
|
|||
|
|
public void MonthlyAttendanceSummaryForLM(SchedularSetup pSchedularSetup)
|
|||
|
|
{
|
|||
|
|
if (waitTheThread(pSchedularSetup.StartAt) && (mailNotificationProcessConfiguration.IsTest || DateTime.Today == GlobalFunctions.FirstDateOfMonth(DateTime.Today)))
|
|||
|
|
{
|
|||
|
|
List<MailNotificationHistory> oMailNotificationHistoryList = new();
|
|||
|
|
pSchedularSetup.Type = EnumSchedularType.MonthlyAttendanceSummaryLM;
|
|||
|
|
byte[] report = null;
|
|||
|
|
string fileFormate = Enum.GetName(pSchedularSetup.ReportFormat.GetType(), pSchedularSetup.ReportFormat);
|
|||
|
|
string fileExtention = EnumHelper.GetEnumDescription(pSchedularSetup.ReportFormat);
|
|||
|
|
List<EmployeeCordinator> empCord = new EmployeeCordinatorService().Get();
|
|||
|
|
//string fileExtention = "pdf";
|
|||
|
|
List<Employee> allemps = new EmployeeService().GetAllEmps();
|
|||
|
|
//List<Employee> linemanagers = new List<Employee>();
|
|||
|
|
//allemps.ForEach(x =>{
|
|||
|
|
// if(x.LineManagerID != null )
|
|||
|
|
// {
|
|||
|
|
// if (linemanagers.FindIndex(y => y.ID == (int)x.LineManagerID) != -1)
|
|||
|
|
// linemanagers.Add(x);
|
|||
|
|
// }
|
|||
|
|
|
|||
|
|
//});
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
foreach (Employee emp in allemps) //Here, Emp is the linemanager/Co Ordinators and _employees are the subordinates!!
|
|||
|
|
{
|
|||
|
|
List<Employee> _employees = new EmployeeService().GetSubordinatesByLineManager(emp.ID);
|
|||
|
|
MailNotificationHistory tempMailNotificationHistory = null;
|
|||
|
|
DateTime fromDate = GlobalFunctions.FirstDateOfMonth(DateTime.Now.AddMonths(-24));
|
|||
|
|
DateTime toDate = GlobalFunctions.LastDateOfMonth(DateTime.Now.AddMonths(-1));
|
|||
|
|
EmployeeCordinator cordinatorCheck = empCord.Find(x => x.CordinatorID == emp.ID);
|
|||
|
|
if (cordinatorCheck != null)
|
|||
|
|
{
|
|||
|
|
if (emp.EmailAddress != null)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
tempMailNotificationHistory = new MailNotificationHistory(emp.EmployeeNo, pSchedularSetup.Type);
|
|||
|
|
|
|||
|
|
|
|||
|
|
//report = new AttendanceReport().GetMonthlyAttendanceSummaryCordinator(emp.ID, fromDate, toDate, EnumAttendanceType.None, mailNotificationProcessConfiguration.PayrollTypeForMailSchedular, fileFormate);
|
|||
|
|
string pdfFileLocation = Directory.GetCurrentDirectory() + "\\PreviousMonthAttnReportToCordinator" + "(" + emp.EmployeeNo + ")" + "(" + fromDate.ToString("dd MMM yyyy") + "-" + toDate.ToString("dd MMM yyyy") + ")" + fileExtention;
|
|||
|
|
File.WriteAllBytes(pdfFileLocation, report);
|
|||
|
|
|
|||
|
|
//CreateAndSendMail(pSchedularSetup, emp.EmailAddress, pdfFileLocation);
|
|||
|
|
CreateAndSendMailForMonthlyAttendanceSummary(pSchedularSetup, fromDate, emp.EmailAddress, pdfFileLocation);
|
|||
|
|
|
|||
|
|
MailNotificationHistory emnotfound = new MailNotificationHistory(emp.EmailAddress, pSchedularSetup.Type);
|
|||
|
|
emnotfound.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
emnotfound.Description = "successfully sent monthly attendance report for the Cordinator:" + emp.EmployeeNo + " " + emp.Name + "";
|
|||
|
|
oMailNotificationHistoryList.Add(emnotfound);
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
tempMailNotificationHistory.Status = false;
|
|||
|
|
oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
}
|
|||
|
|
//finally
|
|||
|
|
//{
|
|||
|
|
// oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
//}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
MailNotificationHistory emnotfound = new MailNotificationHistory(emp.EmailAddress, pSchedularSetup.Type);
|
|||
|
|
emnotfound.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
emnotfound.Description = "Line manager:" + emp.EmployeeNo + " " + emp.Name + " email not found";
|
|||
|
|
oMailNotificationHistoryList.Add(emnotfound);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
if (_employees.Count != 0)
|
|||
|
|
{
|
|||
|
|
if (emp.EmailAddress != null)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
tempMailNotificationHistory = new MailNotificationHistory(emp.EmployeeNo, pSchedularSetup.Type);
|
|||
|
|
|
|||
|
|
//report = report == null ? new AttendanceReport().GetMonthlyAttendanceSummary(emp.ID, fromDate, toDate, EnumAttendanceType.None, mailNotificationProcessConfiguration.PayrollTypeForMailSchedular, fileFormate) : report;
|
|||
|
|
//report = new AttendanceReport().GetMonthlyAttendanceSummary(emp.ID, fromDate, toDate, EnumAttendanceType.None, mailNotificationProcessConfiguration.PayrollTypeForMailSchedular, fileFormate);
|
|||
|
|
|
|||
|
|
//string pdfFileLocation = Directory.GetCurrentDirectory() + "\\PreviousMonthAttnReport(Line Manager " + emp.ID + ")" + "(" + fromDate.ToString("dd MMM yyyy") + "-" + toDate.ToString("dd MMM yyyy") + ")" + fileExtention;
|
|||
|
|
|
|||
|
|
string pdfFileLocation = Directory.GetCurrentDirectory() + "\\PreviousMonthAttnReportToLineManager" + "(" + emp.EmployeeNo + ")" + "(" + fromDate.ToString("dd MMM yyyy") + "-" + toDate.ToString("dd MMM yyyy") + ")" + fileExtention;
|
|||
|
|
File.WriteAllBytes(pdfFileLocation, report);
|
|||
|
|
|
|||
|
|
//CreateAndSendMail(pSchedularSetup, emp.EmailAddress, pdfFileLocation);
|
|||
|
|
CreateAndSendMailForMonthlyAttendanceSummary(pSchedularSetup, fromDate, emp.EmailAddress, pdfFileLocation);
|
|||
|
|
|
|||
|
|
MailNotificationHistory emnotfound = new MailNotificationHistory(emp.EmailAddress, pSchedularSetup.Type);
|
|||
|
|
emnotfound.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
emnotfound.Description = "successfully sent monthly attendance report for the Line manager:" + emp.EmployeeNo + " " + emp.Name + "";
|
|||
|
|
oMailNotificationHistoryList.Add(emnotfound);
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
string ErrorMsg = ex.Message;
|
|||
|
|
CreateAndSendMailSelfOnError(pSchedularSetup, ErrorMsg, [], String.Empty);
|
|||
|
|
tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
tempMailNotificationHistory.Status = false;
|
|||
|
|
oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
}
|
|||
|
|
//finally
|
|||
|
|
//{
|
|||
|
|
// oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
//}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
MailNotificationHistory emnotfound = new MailNotificationHistory(emp.EmailAddress, pSchedularSetup.Type);
|
|||
|
|
emnotfound.EmployeeNo = emp.EmployeeNo;
|
|||
|
|
emnotfound.Description = "Line manager:" + emp.EmployeeNo + " " + emp.Name + " email not found";
|
|||
|
|
oMailNotificationHistoryList.Add(emnotfound);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
{
|
|||
|
|
new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region PreviousDayAbsentNotificationLM
|
|||
|
|
public void PreviousDayAbsentNotificationForLM(SchedularSetup pSchedularSetup)
|
|||
|
|
{
|
|||
|
|
if (waitTheThread(pSchedularSetup.StartAt))
|
|||
|
|
{
|
|||
|
|
List<Employee> employeeList = new EmployeeService().GetAllAbsentOnYesterdayEmps(mailNotificationProcessConfiguration.PayrollTypeForMailSchedular);
|
|||
|
|
List<Employee> allemp = new EmployeeService().GetAllEmps();
|
|||
|
|
List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
MailNotificationHistory tempMailNotificationHistory = null;
|
|||
|
|
|
|||
|
|
foreach (Employee emp in employeeList)
|
|||
|
|
{
|
|||
|
|
if (emp.LineManagerID != null)
|
|||
|
|
{
|
|||
|
|
Employee lm = allemp.FirstOrDefault(x => x.ID == emp.ID); //new EmployeeService().GetAllAbsentOnYesterdayEmpLM((int)emp.LineManagerID, mailNotificationProcessConfiguration.PayrollTypeForMailSchedular);
|
|||
|
|
|
|||
|
|
tempMailNotificationHistory = new MailNotificationHistory(lm.EmployeeNo.ToString(), pSchedularSetup.Type);
|
|||
|
|
string EmpString = emp.Name + " [" + emp.EmployeeNo + "]";
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
if (lm.EmailAddress != null && lm.EmailAddress.Trim() != string.Empty)
|
|||
|
|
{
|
|||
|
|
CreateAndSendMailForLM(pSchedularSetup, lm.EmailAddress, EmpString);
|
|||
|
|
|
|||
|
|
} else
|
|||
|
|
{
|
|||
|
|
tempMailNotificationHistory.Description = "Email address not found for line manager";
|
|||
|
|
tempMailNotificationHistory.Status = false;
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
string ErrorMsg = ex.Message;
|
|||
|
|
CreateAndSendMailSelfOnError(pSchedularSetup, ErrorMsg, [], String.Empty);
|
|||
|
|
tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
tempMailNotificationHistory.Status = false;
|
|||
|
|
}
|
|||
|
|
finally
|
|||
|
|
{
|
|||
|
|
oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
else
|
|||
|
|
{
|
|||
|
|
tempMailNotificationHistory = new MailNotificationHistory(emp.EmployeeNo.ToString(), pSchedularSetup.Type);
|
|||
|
|
tempMailNotificationHistory.Description = "Line manager not found";
|
|||
|
|
tempMailNotificationHistory.Status = false;
|
|||
|
|
oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
{
|
|||
|
|
new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region PreviousWeekAbsentNotification
|
|||
|
|
//public void PreviousWeekAttendanceNotification(SchedularSetup pSchedularSetup)
|
|||
|
|
//{
|
|||
|
|
// if (waitTheThread(pSchedularSetup.StartAt) && (mailNotificationProcessConfiguration.IsTest || DateTime.Today.DayOfWeek == DayOfWeek.Sunday))
|
|||
|
|
// {
|
|||
|
|
// byte[] report = null;
|
|||
|
|
// string fileFormate = Enum.GetName(pSchedularSetup.ReportFormat.GetType(), pSchedularSetup.ReportFormat);
|
|||
|
|
// string fileExtention = EnumHelper.GetEnumDescription(pSchedularSetup.ReportFormat);
|
|||
|
|
|
|||
|
|
// MailNotificationHistory tempMailNotificationHistory = null;
|
|||
|
|
// List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
|
|||
|
|
// //DateTime fromDate = DateTime.Now.AddDays(-(int)DateTime.Now.DayOfWeek - 7); // previous week Sunday
|
|||
|
|
// //DateTime toDate = DateTime.Now.AddDays((int)DateTime.Now.DayOfWeek - 7); // recent Sturday
|
|||
|
|
|
|||
|
|
// // as it will fire on Sunday
|
|||
|
|
// DateTime fromDate = DateTime.Now.AddDays(-7); // Sunday
|
|||
|
|
// DateTime toDate = DateTime.Now.AddDays(-1); // recent Sturday
|
|||
|
|
|
|||
|
|
// if (pSchedularSetup.ToEmailAddress != null && pSchedularSetup.ToEmailAddress.Count > 0)
|
|||
|
|
// {
|
|||
|
|
// foreach (string toEmail in pSchedularSetup.ToEmailAddress)
|
|||
|
|
// {
|
|||
|
|
// try
|
|||
|
|
// {
|
|||
|
|
// tempMailNotificationHistory = new MailNotificationHistory(toEmail, pSchedularSetup.Type);
|
|||
|
|
|
|||
|
|
// report = report == null ? new AttendanceReport().GetWeeklyAttnReport(fromDate, toDate, EnumAttendanceType.None, mailNotificationProcessConfiguration.PayrollTypeForMailSchedular, fileFormate) : report;
|
|||
|
|
|
|||
|
|
// string pdfFileLocation = Directory.GetCurrentDirectory() + "\\PreviousWeekAttnReport" + "(" + fromDate.ToString("dd MMM yyyy") + "-" + toDate.ToString("dd MMM yyyy") + ")" + fileExtention;
|
|||
|
|
// File.WriteAllBytes(pdfFileLocation, report);
|
|||
|
|
|
|||
|
|
// CreateAndSendMail(pSchedularSetup, toEmail, pdfFileLocation);
|
|||
|
|
// }
|
|||
|
|
// catch (Exception ex)
|
|||
|
|
// {
|
|||
|
|
// tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
// tempMailNotificationHistory.Status = false;
|
|||
|
|
// }
|
|||
|
|
// finally
|
|||
|
|
// {
|
|||
|
|
// oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
// if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
// {
|
|||
|
|
// new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
//}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region PreviousMonthAbsentNotification
|
|||
|
|
//public void PreviousMonthAttendanceNotification(SchedularSetup pSchedularSetup)
|
|||
|
|
//{
|
|||
|
|
// if (waitTheThread(pSchedularSetup.StartAt) && (mailNotificationProcessConfiguration.IsTest || DateTime.Today == GlobalFunctions.FirstDateOfMonth(DateTime.Today)))
|
|||
|
|
// {
|
|||
|
|
// byte[] report = null;
|
|||
|
|
// string fileFormate = Enum.GetName(pSchedularSetup.ReportFormat.GetType(), pSchedularSetup.ReportFormat);
|
|||
|
|
// string fileExtention = EnumHelper.GetEnumDescription(pSchedularSetup.ReportFormat);
|
|||
|
|
|
|||
|
|
// MailNotificationHistory tempMailNotificationHistory = null;
|
|||
|
|
// List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
|
|||
|
|
// DateTime fromDate = GlobalFunctions.FirstDateOfMonth(DateTime.Now.AddMonths(-1));
|
|||
|
|
// DateTime toDate = GlobalFunctions.LastDateOfMonth(DateTime.Now.AddMonths(-1));
|
|||
|
|
|
|||
|
|
// if (pSchedularSetup.ToEmailAddress != null && pSchedularSetup.ToEmailAddress.Count > 0)
|
|||
|
|
// {
|
|||
|
|
// foreach (string toEmail in pSchedularSetup.ToEmailAddress)
|
|||
|
|
// {
|
|||
|
|
// try
|
|||
|
|
// {
|
|||
|
|
// tempMailNotificationHistory = new MailNotificationHistory(toEmail, pSchedularSetup.Type);
|
|||
|
|
|
|||
|
|
// report = report == null ? new AttendanceReport().GetMonthlyAttnReport(fromDate, toDate, EnumAttendanceType.None, mailNotificationProcessConfiguration.PayrollTypeForMailSchedular, fileFormate) : report;
|
|||
|
|
|
|||
|
|
// string pdfFileLocation = Directory.GetCurrentDirectory() + "\\PreviousMonthAttnReport" + "(" + fromDate.ToString("dd MMM yyyy") + "-" + toDate.ToString("dd MMM yyyy") + ")" + fileExtention;
|
|||
|
|
// File.WriteAllBytes(pdfFileLocation, report);
|
|||
|
|
|
|||
|
|
// CreateAndSendMail(pSchedularSetup, toEmail, pdfFileLocation);
|
|||
|
|
// }
|
|||
|
|
// catch (Exception ex)
|
|||
|
|
// {
|
|||
|
|
// tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
// tempMailNotificationHistory.Status = false;
|
|||
|
|
// }
|
|||
|
|
// finally
|
|||
|
|
// {
|
|||
|
|
// oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
// if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
// {
|
|||
|
|
// new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
// }
|
|||
|
|
// }
|
|||
|
|
//}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region PendingListNotification
|
|||
|
|
public void PendingListNotification(SchedularSetup pSchedularSetup)
|
|||
|
|
{
|
|||
|
|
if (waitTheThread(pSchedularSetup.StartAt) && (mailNotificationProcessConfiguration.IsTest || DateTime.Today.DayOfWeek == DayOfWeek.Sunday))
|
|||
|
|
{
|
|||
|
|
DataSet linemanagerPendingList = new EmployeeService().GetLinemanagerPendingList();
|
|||
|
|
List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
MailNotificationHistory tempMailNotificationHistory = null;
|
|||
|
|
|
|||
|
|
if (linemanagerPendingList != null &&
|
|||
|
|
linemanagerPendingList.Tables != null &&
|
|||
|
|
linemanagerPendingList.Tables.Count > 0 &&
|
|||
|
|
linemanagerPendingList.Tables[0].Rows.Count > 0)
|
|||
|
|
{
|
|||
|
|
foreach (DataRow emp in linemanagerPendingList.Tables[0].Rows)
|
|||
|
|
{
|
|||
|
|
tempMailNotificationHistory = new MailNotificationHistory(emp["EMPLOYEENO"].ToString(), pSchedularSetup.Type);
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
CreateAndSendMail(pSchedularSetup, emp["EMAILADDRESS"].ToString());
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
string ErrorMsg = ex.Message;
|
|||
|
|
CreateAndSendMailSelfOnError(pSchedularSetup, ErrorMsg, [], String.Empty);
|
|||
|
|
tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
tempMailNotificationHistory.Status = false;
|
|||
|
|
}
|
|||
|
|
finally
|
|||
|
|
{
|
|||
|
|
oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
{
|
|||
|
|
new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region PreviousDayApprovedLeaveNofication
|
|||
|
|
public void PreviousDayApprovedLeaveNofication(SchedularSetup pSchedularSetup)
|
|||
|
|
{
|
|||
|
|
if (waitTheThread(pSchedularSetup.StartAt))
|
|||
|
|
{
|
|||
|
|
byte[] report = null;
|
|||
|
|
string fileFormate = Enum.GetName(pSchedularSetup.ReportFormat.GetType(), pSchedularSetup.ReportFormat);
|
|||
|
|
string fileExtention = EnumHelper.GetEnumDescription(pSchedularSetup.ReportFormat);
|
|||
|
|
|
|||
|
|
MailNotificationHistory tempMailNotificationHistory = null;
|
|||
|
|
List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
|
|||
|
|
DateTime leaveApprovedDate = DateTime.Today.AddDays(-1);
|
|||
|
|
|
|||
|
|
if (pSchedularSetup.ToEmailAddress != null && pSchedularSetup.ToEmailAddress.Count > 0)
|
|||
|
|
{
|
|||
|
|
foreach (string toEmail in pSchedularSetup.ToEmailAddress)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
tempMailNotificationHistory = new MailNotificationHistory(toEmail, pSchedularSetup.Type);
|
|||
|
|
|
|||
|
|
report = report == null ? new rptLeave().GetPreviousDayApprovedLeaveReport(toEmail, leaveApprovedDate, EnumLeaveStatus.Approved, fileFormate) : report;
|
|||
|
|
|
|||
|
|
string pdfFileLocation = Directory.GetCurrentDirectory() + "\\PreviousDayApprovedLeaveReport" + "(" + leaveApprovedDate.ToString("dd MMM yyyy") + ")" + fileExtention;
|
|||
|
|
File.WriteAllBytes(pdfFileLocation, report);
|
|||
|
|
|
|||
|
|
CreateAndSendMail(pSchedularSetup, toEmail, pdfFileLocation);
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
string ErrorMsg = ex.Message;
|
|||
|
|
CreateAndSendMailSelfOnError(pSchedularSetup, ErrorMsg, [], String.Empty);
|
|||
|
|
tempMailNotificationHistory.Description = ex.Message;
|
|||
|
|
tempMailNotificationHistory.Status = false;
|
|||
|
|
}
|
|||
|
|
finally
|
|||
|
|
{
|
|||
|
|
oMailNotificationHistoryList.Add(tempMailNotificationHistory);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
{
|
|||
|
|
new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#region Attendance Auto Process
|
|||
|
|
public void AttendanceAutoProcess(SchedularSetup pSchedularSetup)
|
|||
|
|
{
|
|||
|
|
EnumSchedularType notificationtype = pSchedularSetup.Type;
|
|||
|
|
AttendanceAutoProcessConfiguration oAttendanceAutoProcessConfiguration = new AttendanceAutoProcessConfiguration();
|
|||
|
|
List<MailNotificationHistory> oMailNotificationHistoryList = new List<MailNotificationHistory>();
|
|||
|
|
//StreamWriter ofile = null;
|
|||
|
|
//string basepath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
|
|||
|
|
//string loc = basepath + "\\log.txt";
|
|||
|
|
|
|||
|
|
//if (!File.Exists(loc))
|
|||
|
|
//{
|
|||
|
|
// File.Create(loc).Dispose();
|
|||
|
|
//}
|
|||
|
|
|
|||
|
|
var configurationBuilder = new ConfigurationBuilder().AddJsonFile("appsettings.json").Build();
|
|||
|
|
configurationBuilder.GetSection("AttendanceAutoProcess").Bind(oAttendanceAutoProcessConfiguration);
|
|||
|
|
|
|||
|
|
// List<PayrollType> oPtypes = new PayrollTypeService().Get();
|
|||
|
|
|
|||
|
|
string[] ptypeid = mailNotificationProcessConfiguration.PayrollTypeForMailSchedular.Split(",");
|
|||
|
|
foreach (string ptype in ptypeid)
|
|||
|
|
{
|
|||
|
|
try
|
|||
|
|
{
|
|||
|
|
new AttendanceProcess().Process(DateTime.Today, EnumProcessMode.Auto, Convert.ToInt32(ptype), 1);
|
|||
|
|
Thread.Sleep(5000);
|
|||
|
|
MailNotificationHistory success = new MailNotificationHistory();
|
|||
|
|
success.Description = "Date & Time : " + DateTime.Now.ToString() + ", Attendence Process Completed Successfully For " + DateTime.Today.AddDays(-oAttendanceAutoProcessConfiguration.NumberOfDaysToProcess).Date.ToString("dd MMM yyyy") + ".";
|
|||
|
|
success.NotificationType = notificationtype;
|
|||
|
|
success.Status = true;
|
|||
|
|
oMailNotificationHistoryList.Add(success);
|
|||
|
|
}
|
|||
|
|
catch (Exception ex)
|
|||
|
|
{
|
|||
|
|
string ErrorMsg = ex.Message;
|
|||
|
|
CreateAndSendMailSelfOnError(pSchedularSetup, ErrorMsg, [], String.Empty);
|
|||
|
|
MailNotificationHistory failed = new MailNotificationHistory();
|
|||
|
|
failed.Description = "Date & Time : " + DateTime.Now.ToString() + ", Error While Processing Attendence Data For " + DateTime.Today.AddDays(-oAttendanceAutoProcessConfiguration.NumberOfDaysToProcess).Date.ToString("dd MMM yyyy") + ". Reason: " + ex.Message;
|
|||
|
|
failed.NotificationType = notificationtype;
|
|||
|
|
failed.Status = false;
|
|||
|
|
oMailNotificationHistoryList.Add(failed);
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
if (oMailNotificationHistoryList != null && oMailNotificationHistoryList.Count > 0)
|
|||
|
|
{
|
|||
|
|
new SchedularSetupService().SaveMailHistory(oMailNotificationHistoryList);
|
|||
|
|
}
|
|||
|
|
pSchedularSetup.LastExecuteDateTime = DateTime.Now;
|
|||
|
|
SchedularSetupService oSchedularSetupService = new SchedularSetupService();
|
|||
|
|
oSchedularSetupService.Save(pSchedularSetup);
|
|||
|
|
}
|
|||
|
|
#endregion
|
|||
|
|
|
|||
|
|
#endregion
|
|||
|
|
}
|
|||
|
|
}
|