public ActionResult SaveApprovalStatus(EmployeeChangesApprovalViewModel model, FormCollection frmColl)
{
try
{
PersonalDetailsDAL dal = new PersonalDetailsDAL();
bool success = false;
string result = null;
if (model != null)
{
success = dal.saveApprovalStatus(model);
if (success)
{
result = "saved";
}
else
{
result = "error";
}
return(Json(new { status = success, resultmessage = result }, JsonRequestBehavior.AllowGet));
}
else
{
result = "ErrorInSave";
}
return(Json(new { status = success, resultmessage = result }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { status = "Error" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Index()
{
try
{
EmployeeChangesApprovalViewModel model = new EmployeeChangesApprovalViewModel();
EmployeeDAL employeeDAL = new EmployeeDAL();
model.SearchedUserDetails = new SearchedUserDetails();
string employeeCode = Membership.GetUser().UserName;
int employeeId = employeeDAL.GetEmployeeID(employeeCode);
string[] role = Roles.GetRolesForUser(employeeCode);
string maxRole = Commondal.GetMaxRoleForUser(role);
if (employeeCode != null)
{
model.EmployeeID = employeeId;
model.SearchedUserDetails.EmployeeId = employeeId;
model.SearchedUserDetails.EmployeeCode = employeeCode;
model.SearchedUserDetails.UserRole = maxRole;
ViewBag.UserRole = maxRole;
}
return(View(model));
}
catch (Exception)
{
return(RedirectToAction("Index", "Error", new { errorCode = "You are not authorised to do this action" }));
}
}
public ActionResult SelectedModuleDetails(int employeeId, string module, int page, int rows)
{
try
{
PersonalDetailsDAL dal = new PersonalDetailsDAL();
EmployeeChangesApprovalViewModel changesApprovalModel = new EmployeeChangesApprovalViewModel();
int totalCount;
changesApprovalModel.ChangeDetailsList = new List <EmployeeChangeDetails>();
changesApprovalModel.ChangeDetailsList = dal.SelectedModuleDetailsList(employeeId, module, page, rows, out totalCount);
if ((changesApprovalModel.ChangeDetailsList == null || changesApprovalModel.ChangeDetailsList.Count <= 0) && page - 1 > 0)
{
page = page - 1;
changesApprovalModel.ChangeDetailsList = dal.SelectedModuleDetailsList(employeeId, module, page, rows, out totalCount);
}
var totalRecords = totalCount;
var totalPages = (int)Math.Ceiling((double)totalRecords / (double)rows);
var jsonData = new
{
total = totalPages,
page = page,
records = totalRecords,
rows = changesApprovalModel.ChangeDetailsList,
};
return(Json(jsonData));
}
catch (Exception)
{
return(RedirectToAction("Index", "Error", new { errorCode = "There are some errors." }));
}
}
public ActionResult CertificateSendMail(int EmpID, EmployeeChangesApprovalViewModel model)
{
var EmployeeID = EmpID;
var ChildEmployeeID = model.EmployeeID;
try
{
model.Mail = new EmployeeMailTemplate();
int empid = Convert.ToInt32(EmployeeID);
int childemployeeid = Convert.ToInt32(ChildEmployeeID);
HRMS_tbl_PM_Employee ChildemployeeDetails = employeeDAL.GetEmployeeDetails(childemployeeid);
HRMS_tbl_PM_Employee employeeDetails = employeeDAL.GetEmployeeDetails(empid);
if (employeeDetails != null)
{
model.Mail.From = employeeDetails.EmailID;
model.Mail.To = ChildemployeeDetails.EmailID;
string mailBody = null;
int templateId = 4;
List <EmployeeMailTemplate> template = Commondal.GetEmailTemplate(templateId);
foreach (var emailTemplate in template)
{
model.Mail.Subject = emailTemplate.Subject;
mailBody = emailTemplate.Message;
}
mailBody = mailBody.Replace("##HR Admin##", Server.HtmlEncode(employeeDetails.EmployeeName));
model.Mail.Message = mailBody.Replace("<br>", Environment.NewLine);
ViewBag.Body = mailBody;
string[] roles = { "HR Admin" };
foreach (string r in roles)
{
string[] users = Roles.GetUsersInRole(r);
foreach (string user in users)
{
HRMS_tbl_PM_Employee employee = employeeDAL.GetEmployeeDetailsFromEmpCode(Convert.ToInt32(user));
if (employee == null)
{
model.Mail.Cc = model.Mail.Cc + string.Empty;
}
else
{
model.Mail.Cc = model.Mail.Cc + employee.EmailID + ";";
}
}
}
}
return(PartialView("_MailTemplateApprovalStatus", model.Mail));
}
catch (Exception)
{
return(RedirectToAction("Index", "Error", new { errorCode = "There are some errors." }));
}
}
public ActionResult EmployeeApprovals(int?employeeId)
{
Session["SearchEmpFullName"] = null; // to hide emp search
Session["SearchEmpCode"] = null;
Session["SearchEmpID"] = null;
if (employeeId == null)
{
EmployeeDAL employeeDAL = new EmployeeDAL();
employeeId = employeeDAL.GetEmployeeID(Membership.GetUser().UserName);
}
if (!HttpContext.User.Identity.IsAuthenticated)
{
return(RedirectToAction("Index", "PersonalDetails"));
}
try
{
EmployeeChangesApprovalViewModel changesApprovalModel = new EmployeeChangesApprovalViewModel();
PersonalDetailsDAL dal = new PersonalDetailsDAL();
tbl_ApprovalChanges approvalChanges = dal.GetChangedFields(employeeId);
if (approvalChanges != null)
{
changesApprovalModel.EmployeeID = approvalChanges.EmployeeID;
changesApprovalModel.FieldDiscription = approvalChanges.FieldDiscription;
changesApprovalModel.Module = approvalChanges.Module;
changesApprovalModel.FieldDbColumnName = approvalChanges.FieldDbColumnName;
changesApprovalModel.OldValue = approvalChanges.OldValue;
changesApprovalModel.NewValue = approvalChanges.NewValue;
changesApprovalModel.ApprovalStatusMasterID = approvalChanges.ApprovalStatusMasterID;
changesApprovalModel.Comments = approvalChanges.Comments;
changesApprovalModel.CreatedBy = approvalChanges.CreatedBy;
changesApprovalModel.CreatedDateTime = approvalChanges.CreatedDateTime;
}
changesApprovalModel.ChangeDetailsList = new List <EmployeeChangeDetails>();
changesApprovalModel.Mail = new EmployeeMailTemplate();
changesApprovalModel.EmployeeID = employeeId;
return(PartialView("_EmployeeApprovals", changesApprovalModel));
}
catch (Exception)
{
return(RedirectToAction("Index", "Error", new { errorCode = "There are some errors." }));
}
}
public ActionResult AdminSendMail(EmployeeChangesApprovalViewModel model)
{
try
{
if (model.Module == "New Personal Details" || model.Module == "New Residential Details" || model.Module == "OnHold Personal Details" || model.Module == "OnHold Residential Details")
{
StringBuilder builder = new StringBuilder();
foreach (var item in model.ChangeDetailsList)
{
if (item.ChildApprovalStatusMasterID == 1 || item.ChildApprovalStatusMasterID == 2 || item.ChildApprovalStatusMasterID == 3)
{
model.Mail = new EmployeeMailTemplate();
int empid = Convert.ToInt32(model.EmployeeID);
int childemployeeid = Convert.ToInt32(item.ChildEmployeeID);
HRMS_tbl_PM_Employee ChildemployeeDetails = employeeDAL.GetEmployeeDetails(childemployeeid);
HRMS_tbl_PM_Employee employeeDetails = employeeDAL.GetEmployeeDetails(empid);
if (employeeDetails != null)
{
model.Mail.From = employeeDetails.EmailID;
model.Mail.To = ChildemployeeDetails.EmailID;
string ChildMasterstatus;
if (item.ChildApprovalStatusMasterID == 1)
{
ChildMasterstatus = "On Hold";
}
else if (item.ChildApprovalStatusMasterID == 2)
{
ChildMasterstatus = "Approved";
}
else
{
ChildMasterstatus = "Rejected";
}
string approvalStatus = (builder.Append(item.ChildFieldDiscription).Append(" : ").Append(ChildMasterstatus).Append("<br>")
+ "Comments: " + model.Comments);
int templateId = 0;
if (model.Module == "New Personal Details" || model.Module == "OnHold Personal Details")
{
templateId = 1;
}
if (model.Module == "New Residential Details" || model.Module == "OnHold Residential Details")
{
templateId = 2;
}
string mailBody = null;
List <EmployeeMailTemplate> template = Commondal.GetEmailTemplate(templateId);
foreach (var emailTemplate in template)
{
model.Mail.Subject = emailTemplate.Subject;
mailBody = emailTemplate.Message;
}
mailBody = mailBody.Replace("##Approval Status##", approvalStatus);
mailBody = mailBody.Replace("##HR Admin##", Server.HtmlEncode(employeeDetails.EmployeeName));
model.Mail.Message = mailBody.Replace("<br>", Environment.NewLine);
ViewBag.Body = mailBody;
string[] roles = { "HR Admin" };
foreach (string r in roles)
{
string[] users = Roles.GetUsersInRole(r);
foreach (string user in users)
{
HRMS_tbl_PM_Employee employee = employeeDAL.GetEmployeeDetailsFromEmpCode(Convert.ToInt32(user));
if (employee == null)
{
model.Mail.Cc = model.Mail.Cc + string.Empty;
}
else
{
model.Mail.Cc = model.Mail.Cc + employee.EmailID + ";";
}
}
}
}
}
}
}
else
{
}
return(PartialView("_MailTemplateApprovalStatus", model.Mail));
}
catch (Exception)
{
return(RedirectToAction("Index", "Error", new { errorCode = "There are some errors." }));
}
}
