public void ONInsertOrUpdate(AprajitaRetailsContext db, Attendance attendance, bool isDeleted, bool isUpdated)
{
try
{
if (!isDeleted && !isUpdated)
{
var sName = db.Employees.Find(attendance.EmployeeId).StaffName;
if (attendance.Status != AttUnits.Present)
{
MyMail.SendEmail(sName + " Attendance Report status.", sName + " is not present and current status is " + attendance.Status + " on date " + attendance.AttDate, "*****@*****.**");
}
else if (attendance.Status == AttUnits.Sunday)
{
//TODO: do Some things
}
HRMBot.NotifyStaffAttandance(db, sName, attendance.AttendanceId, attendance.Status, attendance.EntryTime);
}
else if (isDeleted)
{
var sName = db.Employees.Find(attendance.EmployeeId).StaffName;
MyMail.SendEmail(sName + " Attendance Report status for delete.", sName + " is deleted and current status was " + attendance.Status + " on date " + attendance.AttDate, "*****@*****.**");
}
else if (isUpdated)
{
var sName = db.Employees.Find(attendance.EmployeeId).StaffName;
var before = db.Attendances.Where(c => c.AttendanceId == attendance.AttendanceId).Select(c => c.Status).FirstOrDefault();
MyMail.SendEmail(sName + " Attendance Report status for Updated Record. It was " + before, sName + " is updated and current status is " + attendance.Status + " on date " + attendance.AttDate, "*****@*****.**");
HRMBot.NotifyStaffAttandance(db, sName, attendance.AttendanceId, attendance.Status, attendance.EntryTime);
}
}
catch (Exception ex)
{
Console.WriteLine("Error :" + ex.Message);
}
}
public void OnUpdate(AprajitaRetailsContext db, StaffAdvancePayment salPayment)
{
var old = db.StaffAdvancePayments.Where(c => c.StaffAdvancePaymentId == salPayment.StaffAdvancePaymentId).Select(d => new { d.Amount, d.PaymentDate, d.PayMode }).FirstOrDefault();
if (old != null)
{
UpdateOutAmount(db, old.Amount, old.PayMode, old.PaymentDate, true);
}
UpdateOutAmount(db, salPayment.Amount, salPayment.PayMode, salPayment.PaymentDate, false);
HRMBot.NotifyStaffPayment(db, "", salPayment.EmployeeId, salPayment.Amount, "Advance Payment: " + salPayment.Details);
}
public void OnInsert(AprajitaRetailsContext db, SalaryPayment salPayment)
{
UpdateOutAmount(db, salPayment.Amount, salPayment.PayMode, salPayment.PaymentDate, false);
HRMBot.NotifyStaffPayment(db, "", salPayment.EmployeeId, salPayment.Amount, "Salary payment for month of " + salPayment.SalaryMonth + " details: " + salPayment.Details);
;
}
public void OnInsert(AprajitaRetailsContext db, StaffAdvancePayment salPayment)
{
UpdateOutAmount(db, salPayment.Amount, salPayment.PayMode, salPayment.PaymentDate, false);
HRMBot.NotifyStaffPayment(db, "", salPayment.EmployeeId, salPayment.Amount, "Advance Payment: " + salPayment.Details);
}
