public ActionResult CreateManpowerRequest()
        {
            var model = new CreateManpowerViewModel();

            ViewBag.ManpowerRequestActive = "active";
            return(View(model));
        }
        public async Task <ActionResult> CreateManpowerRequest(CreateManpowerViewModel i)
        {
            string userid        = User.Identity.GetUserId();
            var    mrfid         = db.fn_generate_mrf_id(userid, i.BusinessUnit);
            var    am            = db.sp_get_account_manager_id(userid).FirstOrDefault();
            var    User_fullname = Users.Fullname(userid);



            //create mrf
            db.sp_create_mrf_request(userid, mrfid, i.DateRequested, i.DateofDeployment, i.RequiredPosition, i.RequiredNumber, i.EducationalAttainment, i.Course, i.Gender, i.AgeRequirement, i.SkillType, i.SpecificSkill, i.Certification, i.CostCenter, i.Department, Tools.ToTitleCase(i.JobDescription), i.SalaryDetails, i.BasicPay, i.Cola, i.Skilled, i.Meal, i.Transportation, i.Gas, i.Communication, i.Motorcycle, i.Clothing, (decimal)i.Medical, i.PayoutDate, Tools.ToTitleCase(i.WhotoLookfor), Tools.ToTitleCase(i.Establishment), Tools.ToTitleCase(i.OfficeAddresstoReport), i.LocationofDeployment, i.BusinessUnit, i.Classification, i.EmploymentStatus, i.ProjectName, i.CompanyRequested, Tools.ToTitleCase(i.Requestor), i.RequestorContactNumber, i.RequestorEmailAddress);
            //notify 2 am
            db.sp_add_notification(userid, am.account_manager_1, string.Format("{0} sent {1} to {2} for approval", User_fullname, mrfid, Users.Fullname(am.account_manager_1)), mrfid);
            db.sp_add_notification(userid, am.account_manager_2, string.Format("{0} sent {1} to {2} for approval", User_fullname, mrfid, Users.Fullname(am.account_manager_2)), mrfid);
            //notify admins
            foreach (var admin in db.sp_admin_list().ToList())
            {
                db.sp_add_notification(userid, admin.UserId, string.Format("{0} sent {1} to {2} for approval", User_fullname, mrfid, Users.Fullname(am.account_manager_1)), mrfid);
                db.sp_add_notification(userid, admin.UserId, string.Format("{0} sent {1} to {2} for approval", User_fullname, mrfid, Users.Fullname(am.account_manager_2)), mrfid);
            }
            //Send approval via email
            await Task.Run(new Action(() =>
            {
                EmailSender email = new EmailSender();
                email.EmailNotification(generateurl(Users.EmailAddress(am.account_manager_1), mrfid), mrfid, am.account_manager_1);
                email.EmailNotification(generateurl(Users.EmailAddress(am.account_manager_1), mrfid), mrfid, am.account_manager_2);
            }));

            i = new CreateManpowerViewModel();
            return(RedirectToAction("dashboard", "manpower", new { createmanpower = "Successfully created Manpower Request " + mrfid }));
            //return View(i);
        }
        public ActionResult UpdateManpowerRequestDetail_(CreateManpowerViewModel i, string mrfid)
        {
            db.sp_update_manpower_request(mrfid, i.DateofDeployment, i.RequiredPosition, i.RequiredNumber, i.EducationalAttainment, i.Course, i.Gender, i.AgeRequirement, i.SkillType,
                                          i.SpecificSkill, i.Certification, i.CostCenter, i.Department, i.JobDescription, i.SalaryDetails, i.BasicPay, i.Cola, i.Skilled, i.Meal, i.Transportation, i.Gas, i.Communication, i.Motorcycle, i.Clothing, i.Medical, i.PayoutDate, i.WhotoLookfor, i.Establishment, i.OfficeAddresstoReport, i.LocationofDeployment, i.Classification, i.ProjectName, i.CompanyRequested, i.Requestor, i.RequestorContactNumber, i.RequestorEmailAddress, "For AM Approval");
            var user   = db.sp_get_mrf_user_involved(mrfid).FirstOrDefault();
            var userid = User.Identity.GetUserId();

            db.sp_add_notification(userid, user.am_1_id, Users.Fullname(userid) + " sent " + mrfid + " to " + Users.Fullname(user.am_1_id) + " for approval", mrfid);
            db.sp_add_notification(userid, user.am_2_id, Users.Fullname(userid) + " sent " + mrfid + " to " + Users.Fullname(user.am_2_id) + " for approval", mrfid);
            return(RedirectToAction("dashboard", "recruitmentprocess", new { mrfid = mrfid }));
        }