Esempio n. 1
0
        public ActionResult Index()
        {
            ViewUserEmp LoggedInUser   = Session["LoggedUser"] as ViewUserEmp;
            var         att_jobcardapp = db.ViewJobCards.Where(aa => aa.SupervisorID == LoggedInUser.EmpID && aa.StatusID == "Pending").OrderByDescending(aa => aa.DateCreated);

            return(View(att_jobcardapp));
        }
Esempio n. 2
0
        public ActionResult Cancel(int?id)
        {
            Att_JobCardApp job = new Att_JobCardApp();

            job              = db.Att_JobCardApp.First(aa => aa.JobCardAppID == id);
            job.StatusID     = "Rejected";
            job.ApprovedDate = DateTime.Now;
            db.SaveChanges();
            if (job.StatusID == "Rejected")
            {
                var    EName   = db.EmpViews.First(aa => aa.EmployeeID == job.EmpID).FullName;
                string Toadd   = "*****@*****.**";
                string subject = "Job Card Approval/Rejection" + EName;
                string body    = "Dear Sir/Madam, <br/> job card request was Rejected < br /> Date : " + job.DateCreated + "+ < br /> , kindly review it. <br/> Employee Name: " + EName + "<br/> Employee No: " + job.EmpID + "<br/>  Date Time: " + job.DateCreated.Value.ToShortDateString() + "<br/> Please Click on below link to procced further <a href='http://192.168.0.21/wms'>http://192.168.0.21/ESSP</a>";
                EmailManager.SendEmail(Toadd, subject, body);
            }
            ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;

            AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Job_Cards), Convert.ToInt16(AuditManager.AuditOperation.Reject), DateTime.Now, (int)id);

            int RecordID = job.JobCardAppID;
            // Below Code is for Notification
            ViewUserEmp LoggedInUser = Session["LoggedUser"] as ViewUserEmp;
            int         TypeID       = Convert.ToInt16(Utilities.NotificationType.Job_Card);
            string      TypeName     = Utilities.NotificationType.Job_Card.ToString().Replace("_", " ");
            int         EmployeeID   = LoggedInUser.EmpID ?? 0;

            Utilities.DeleteNotification(job.JobCardAppID, Convert.ToInt16(Utilities.NotificationType.Pending_Job_Card));
            Utilities.InsertEMPNotification(TypeID, TypeName, EmployeeID, id ?? 0, job.EmpID ?? 0, BaseURL + "Attendance/JobCard/Index");
            return(RedirectToAction("Index"));
        }
        public ActionResult EmployeeJCList()
        {
            ViewUserEmp LoggedInUser   = Session["LoggedUser"] as ViewUserEmp;
            var         att_jobcardapp = db.ViewJobCards.Where(aa => aa.StatusID == "Approved");

            return(View(att_jobcardapp.ToList()));
        }
        public ActionResult Create([Bind(Include = "RdrID,RdrName,ReaderDutyCode,IpAdd,IpPort,RdrTypeID,Status,LocID")] Att_Reader att_reader)
        {
            //att_shift.GZDays = (bool)ValueProvider.GetValue("GZDays").ConvertTo(typeof(bool));
            ViewBag.Location   = new SelectList(db.HR_Location, "LocID", "LocationName");
            ViewBag.DutyCode   = new SelectList(db.Att_ReaderDutyCode, "RdrDuty", "DutyName");
            ViewBag.ReaderType = new SelectList(db.Att_ReaderType, "RdrTypeID", "RdrTypeName");
            try
            {
                if (string.IsNullOrEmpty(att_reader.IpAdd))
                {
                    ModelState.AddModelError("IpAdd", "Ip Address is required!");
                }
                else
                {
                    att_reader.ClearRecords = true;
                    if (ModelState.IsValid)
                    {
                        db.Att_Reader.Add(att_reader);
                        db.SaveChanges();
                        ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
                        AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Device), Convert.ToInt16(AuditManager.AuditOperation.Add), DateTime.Now, (int)att_reader.RdrID);
                        return(RedirectToAction("Index"));
                    }

                    return(View(att_reader));
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(View());
        }
Esempio n. 5
0
        // GET: /HumanResource/Designation/
        public ActionResult Index()
        {
            //return View(db.HR_Designation.OrderBy(aa => aa.DesignationName).ToList());
            List <HR_Designation> _View        = new List <HR_Designation>();
            List <HR_Designation> _TempView    = new List <HR_Designation>();
            ViewUserEmp           LoggedInUser = Session["LoggedUser"] as ViewUserEmp;
            QueryBuilder          qb           = new QueryBuilder();
            string    query = qb.QueryForReportsDepartment(LoggedInUser);
            DataTable dt    = new DataTable();

            if (query != "where")
            {
                dt = qb.GetValuesfromDB("select * from HR_Designation" + query + " DesignationName");
            }
            _View = dt.ToList <HR_Designation>();
            List <HR_Employee>     emps       = db.HR_Employee.Where(aa => aa.Status == "Active").ToList();
            List <DesignationList> desigtList = new List <DesignationList>();

            foreach (var item in _View.ToList())
            {
                DesignationList sl = new DesignationList();
                sl.DesignationID   = item.DesgID;
                sl.DesignationName = item.DesignationName;
                sl.CommonName      = item.OCommonName;
                sl.NoOfEmps        = emps.Where(aa => aa.HR_Designation.DesgID == item.DesgID).Count();
                desigtList.Add(sl);
            }
            return(View(desigtList.OrderBy(aa => aa.DesignationName).ToList()));
        }
 public ActionResult Edit([Bind(Include = "DeptID,DepartmentName,DivsionID,Status")] HR_Department hr_department)
 {
     if (hr_department.DepartmentName == null || hr_department.DepartmentName == "")
     {
         ViewBag.error = "Empty Feild";
     }
     else
     {
         try
         {
             if (ModelState.IsValid)
             {
                 db.Entry(hr_department).State = System.Data.Entity.EntityState.Modified;
                 db.SaveChanges();
                 ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
                 AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Department), Convert.ToInt16(AuditManager.AuditOperation.Edit), DateTime.Now, (int)hr_department.DeptID);
                 return(RedirectToAction("Index"));
             }
         }
         catch (Exception)
         {
             throw;
         }
     }
     //ViewBag.DivsionID = new SelectList(db.HR_Division, "DivID", "DivisionName", hr_department.DivsionID);
     return(View(hr_department));
 }
Esempio n. 7
0
        public ActionResult Rejected(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            VMS_SVisitor vms_svisitor = db.VMS_SVisitor.Find(id);

            if (vms_svisitor != null)
            {
                vms_svisitor.Status = "Rejected";
                db.SaveChanges();
                if (vms_svisitor.Status == "Rejected")
                {
                    var    EName   = db.EmpViews.First(aa => aa.EmployeeID == vms_svisitor.EmpID).FullName;
                    string Toadd   = "*****@*****.**";
                    string subject = "Pending Visitor's Vehicle Access for Employee" + EName;
                    string body    = "Dear Concerned, <br/> your request is Rejected. <br/> Employee Name: " + EName + "<br/> Visitor Name: " + vms_svisitor.VisitorName + "<br/> Vehicle No: " + vms_svisitor.VehicleNo + "<br/> Date Time: " + vms_svisitor.Arrival_Date.Value.ToShortDateString() + vms_svisitor.ArrivalTime + "<br/> Please Click on below link to procced further <a href='http://192.168.0.21/wms'>http://192.168.0.21/ESSP</a>";
                    EmailManager.SendEmail(Toadd, subject, body);
                }
                ViewUserEmp LoggedInUser = Session["LoggedUser"] as ViewUserEmp;
                int         TypeID       = Convert.ToInt16(Utilities.NotificationType.PendingVisitorEntry);
                string      TypeName     = Utilities.NotificationType.PendingVisitorEntry.ToString().Replace("_", " ");
                int         EmployeeID   = LoggedInUser.EmpID ?? 0;
                Utilities.DeleteNotification(vms_svisitor.ID, Convert.ToInt16(Utilities.NotificationType.PendingVisitorEntry));
                Utilities.InsertEMPNotification(TypeID, TypeName, EmployeeID, id ?? 0, vms_svisitor.EmpID ?? 0, BaseURL + "Attendance/ScheduleVisitor/Index");

                ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
                AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Visitor_Entry), Convert.ToInt16(AuditManager.AuditOperation.Reject), DateTime.Now, (int)id);
                return(RedirectToAction("ListOfPendingVisitor"));
            }
            return(RedirectToAction("ListOfPendingVisitor"));
        }
Esempio n. 8
0
        // GET: /Attendance/ScheduleVisitor/
        public ActionResult Index()
        {
            ViewUserEmp LoggedInUser = Session["LoggedUser"] as ViewUserEmp;

            Utilities.DeleteNotificationByType(LoggedInUser.EmpID ?? 0, Convert.ToInt16(Utilities.NotificationType.PendingVisitorEntry));
            return(View(db.VMS_SVisitor.Where(aa => aa.EmpID == LoggedInUser.EmpID).OrderByDescending(aa => aa.ID).ToList()));
        }
        public ActionResult FocalUsers([Bind(Include = "PID,FocalUID,UserID,StartDate,EndDate")] int?id, FocalUser focaluser)
        {
            ViewUserEmp LoggedInUser = Session["LoggedUser"] as ViewUserEmp;

            if (focaluser.StartDate == null)
            {
                ViewBag.error = "required field must have a value";
            }
            else
            {
                if (db.FocalUsers.Where(aa => aa.FocalUID == focaluser.FocalUID && aa.EndDate == null).Count() > 0)
                {
                    FocalUser OldEntry = db.FocalUsers.Where(aa => aa.FocalUID == focaluser.FocalUID && aa.EndDate == null).OrderByDescending(aa => aa.PID).First();
                    OldEntry.EndDate = DateTime.Now.AddDays(-1);
                }
                focaluser.UserID     = id;
                focaluser.FocalUName = db.ViewUserEmps.First(aa => aa.UserID == focaluser.FocalUID).FullName;
                ViewBag.FocalUID     = new SelectList(db.ViewUserEmps.Where(aa => aa.Status == true).ToList(), "UserID", "FullName");
                db.FocalUsers.Add(focaluser);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            ViewBag.FocalUID = new SelectList(db.ViewUserEmps.Where(aa => aa.Status == true).ToList(), "UserID", "FullName");
            return(View());
        }
        public ActionResult HAOTDeptList(int?PayrollPeriodID)
        {
            ViewUserEmp             LoggedInUser    = Session["LoggedUser"] as ViewUserEmp;
            List <short?>           deptIds         = new List <short?>();
            List <short?>           divIds          = new List <short?>();
            List <int?>             empIds          = new List <int?>();
            List <EmpView>          totalEmps       = new List <EmpView>();
            List <EmpView>          emps            = new List <EmpView>();
            List <PR_PayrollPeriod> activePeriods   = new List <PR_PayrollPeriod>();
            List <int?>             activePeriodIds = new List <int?>();
            int SelectedPeriodID           = 0;
            List <ViewDailyOTEntry> otList = new List <ViewDailyOTEntry>();
            PR_PayrollPeriod        prp    = new PR_PayrollPeriod();
            ModelRDeptPending       vm     = new ModelRDeptPending();

            totalEmps = db.EmpViews.Where(aa => aa.Status == "Active").ToList();
            if (LoggedInUser.UserType != "H" && LoggedInUser.UserType != "A")
            {
                totalEmps = OTHelperManager.GetEmployees(totalEmps, LoggedInUser);
            }
            SelectedPeriodID = Convert.ToInt32(Session["PRID"].ToString());
            if (PayrollPeriodID == null)
            {
                PayrollPeriodID = SelectedPeriodID;
            }
            else
            {
                Session["PRID"] = PayrollPeriodID.ToString();
            }
            //activePeriodIds = db.ViewDailyOTEntries.Where(aa => ((aa.SupervisorID == LoggedInUser.EmployeeID && aa.StatusID == "P") || (aa.StatusID == "F" && aa.ForwardToID == LoggedInUser.EmployeeID))).Select(aa => aa.PeriodID).Distinct().ToList();
            //activePeriods = OTHelperManager.GetActivePeriods(db.PR_PayrollPeriod.ToList(), activePeriodIds);
            prp     = OTHelperManager.GetPayrollPeriod(db.PR_PayrollPeriod.ToList(), (int)PayrollPeriodID);
            empIds  = db.ViewDailyOTEntries.Where(aa => aa.OTProcessingPeriodID == prp.PID && aa.StatusID == "A").Select(aa => aa.EmployeeID).Distinct().ToList();
            emps    = OTHelperManager.GetEmployeeConvertedFromIds(empIds, totalEmps);
            deptIds = OTHelperManager.GetDeptIDs(emps);
            divIds  = OTHelperManager.GetDivisionIDs(deptIds, db.HR_Section.ToList());
            if (deptIds.Count == 1)
            {
                return(RedirectToAction("HAOTEmpList", new { DeptID = deptIds.First(), PayrollPeriodID = prp.PID }));
            }
            else
            {
                otList = db.ViewDailyOTEntries.Where(aa => aa.OTProcessingPeriodID == prp.PID && aa.StatusID == "A").ToList();

                vm.List            = OTHelperRecommended.GetConvertedOTListDepts(otList, emps, deptIds);
                vm.Count           = vm.List.Count;
                vm.PayrollPeriodID = (int)PayrollPeriodID;
                if (prp.FinYearID != null)
                {
                    vm.DivRemainingBudget = OTHelperManager.GetDivRemainingBudget(divIds, db.BG_OTDivision.ToList(), (int)prp.FinYearID);
                }
                vm.TotalOTAmount = OTHelperManager.GetTotalOTAmount(vm.List);

                ViewBag.PayrollPeriodID = new SelectList(activePeriods, "PID", "PName", PayrollPeriodID);
                ViewBag.DecisionID      = new SelectList(OTHelperManager.GetOTStatusForSupervisor(db.Att_OTStatus.ToList()), "PSID", "StatusName", "F");
                //ViewBag.RecommendID = new SelectList(OTHelperManager.GetUsersForSupervisor(db.ViewUserEmps.Where(aa => aa.EmpStatus == "Active" && aa.UserType == "R" && aa.sec).ToList()), "UserID", "FullName");
                vm.Message = new List <string>();
                return(View(vm));
            }
        }
Esempio n. 11
0
        public ModelSOTEmpList GetEmpPending(ViewUserEmp LoggedInUser, int?PayrollPeriodID, int DeptID)
        {
            // Varibale Initilization
            ModelSOTEmpList         vm              = new ModelSOTEmpList();
            List <short?>           deptIds         = new List <short?>();
            List <short?>           divIds          = new List <short?>();
            List <int?>             empIds          = new List <int?>();
            List <EmpView>          totalEmps       = new List <EmpView>();
            List <EmpView>          emps            = new List <EmpView>();
            List <PR_PayrollPeriod> activePeriods   = new List <PR_PayrollPeriod>();
            List <int?>             activePeriodIds = new List <int?>();
            PR_PayrollPeriod        prp             = new PR_PayrollPeriod();
            int SelectedPeriodID           = 0;
            List <ViewDailyOTEntry> otList = new List <ViewDailyOTEntry>();

            deptIds.Add((short)DeptID);
            divIds    = OTHelperManager.GetDivisionIDs(deptIds, db.HR_Section.ToList());
            totalEmps = db.EmpViews.Where(aa => aa.Status == "Active").ToList();

            // Get Payroll Period
            SelectedPeriodID = Convert.ToInt32(Session["PRID"].ToString());
            if (PayrollPeriodID == null)
            {
                PayrollPeriodID = SelectedPeriodID;
            }
            else
            {
                Session["PRID"] = PayrollPeriodID.ToString();
            }
            activePeriodIds = db.ViewDailyOTEntries.Where(aa => (aa.SupervisorID == LoggedInUser.EmployeeID && aa.StatusID == "P") || (aa.StatusID == "F" && aa.ForwardToID == LoggedInUser.EmployeeID)).Select(aa => aa.PeriodID).Distinct().ToList();
            activePeriods   = OTHelperManager.GetActivePeriods(db.PR_PayrollPeriod.ToList(), activePeriodIds);
            prp             = OTHelperManager.GetPayrollPeriod(activePeriods, (int)PayrollPeriodID);

            empIds = db.ViewDailyOTEntries.Where(aa => aa.OTDate >= prp.PStartDate && aa.OTDate <= prp.PEndDate && aa.SecID == DeptID && ((aa.SupervisorID == LoggedInUser.EmployeeID && aa.StatusID == "P") || (aa.StatusID == "F" && aa.ForwardToID == LoggedInUser.EmployeeID))).Select(aa => aa.EmployeeID).Distinct().ToList();
            emps   = OTHelperManager.GetEmployeeConvertedFromIds(empIds, totalEmps);

            otList    = db.ViewDailyOTEntries.Where(aa => aa.OTDate >= prp.PStartDate && aa.OTDate <= prp.PEndDate && aa.SecID == DeptID && ((aa.SupervisorID == LoggedInUser.EmployeeID && aa.StatusID == "P") || (aa.StatusID == "F" && aa.ForwardToID == LoggedInUser.EmployeeID))).ToList();
            vm.DeptID = (int)DeptID;
            if (prp.FinYearID != null)
            {
                vm.DivRemainingBudget = OTHelperManager.GetDivRemainingBudget(divIds, db.BG_OTDivision.ToList(), (int)prp.FinYearID);
            }
            vm.List = OTHelperRecommended.GetConvertedOTListEmp(otList, emps);
            //if (DateTime.Today > prp.SupervisorCutOffDate)
            //    vm.IsLate = true;
            //else
            vm.IsLate = false;
            if (vm.List.Count() > 1)
            {
                vm.TotalOTAmount = vm.List.Sum(aa => aa.OTAmount);
                vm.SystemOT      = OTHelperManager.ConverMinIntoHours(vm.List.Sum(aa => aa.SystemOTMins));
                vm.ClaimedOT     = OTHelperManager.ConverMinIntoHours(vm.List.Sum(aa => aa.ClaimedOTMins));
                vm.TotalEmps     = vm.List.Count().ToString();
            }
            vm.Count                = vm.List.Count;
            ViewBag.DecisionID      = new SelectList(OTHelperManager.GetOTStatusForApprover(db.Att_OTStatus.ToList()), "PSID", "StatusName", "F");
            ViewBag.RecommendID     = new SelectList(OTHelperManager.GetUsersForRecommender(db.ViewUserEmps.Where(aa => aa.EmpStatus == "Active").ToList()), "UserID", "FullName");
            ViewBag.PayrollPeriodID = new SelectList(activePeriods, "PID", "PName", PayrollPeriodID);
            return(vm);
        }
        public ActionResult Edit([Bind(Include = "HolidayID,HolidayDate,HolidayName")] Att_Holiday att_holiday)
        {
            if (att_holiday.HolidayDate == null)
            {
                ViewBag.date = "required field!";
            }

            else
            {
                if (att_holiday.HolidayName == null || att_holiday.HolidayName == "")
                {
                    ViewBag.name = "required field!";
                }
                else
                {
                    if (ModelState.IsValid)
                    {
                        db.Entry(att_holiday).State = System.Data.Entity.EntityState.Modified;
                        db.SaveChanges();
                        ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
                        AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Holiday), Convert.ToInt16(AuditManager.AuditOperation.Edit), DateTime.Now, (int)att_holiday.HolidayID);

                        return(RedirectToAction("Index"));
                    }
                }
            }
            return(View(att_holiday));
        }
 // GET: /HumanResource/EmpType/
 public ActionResult Index()
 {
     try
     {
         List <HR_EmpType> _View        = new List <HR_EmpType>();
         List <HR_EmpType> _TempView    = new List <HR_EmpType>();
         ViewUserEmp       LoggedInUser = Session["LoggedUser"] as ViewUserEmp;
         QueryBuilder      qb           = new QueryBuilder();
         string            query        = qb.QueryForReportsDepartment(LoggedInUser);
         DataTable         dt           = new DataTable();
         if (query != "where")
         {
             dt = qb.GetValuesfromDB("select * from HR_EmpType" + query + " TypeName");
         }
         _View = dt.ToList <HR_EmpType>();
         List <HR_Employee> emps     = db.HR_Employee.Where(aa => aa.Status == "Active").ToList();
         List <EmpTypeList> typelist = new List <EmpTypeList>();
         foreach (var item in _View.ToList())
         {
             EmpTypeList sl = new EmpTypeList();
             sl.TypeID   = item.TypID;
             sl.TypeName = item.TypeName;
             sl.NoOfEmps = emps.Where(aa => aa.EmpTypeID == item.TypID).Count();
             typelist.Add(sl);
         }
         return(View(typelist.ToList()));
     }
     catch (Exception)
     {
         throw;
     }
 }
Esempio n. 14
0
        public ActionResult Create([Bind(Include = "JobCardAppID,DateCreated,DateStarted,DateEnded,JCTypeID,UserID,JobCardCriteria,CriteriaData,Status,TimeIn,TimeOut,WorkMin,Remarks,OtherValue,SupervisorID,StartTime,EndTime,EmpID,Justification")] Att_JobCardApp att_jobcardapp)
        {
            if (att_jobcardapp.EmpID == null)
            {
                ViewBag.error = "required field!";
            }
            else
            {
                if (ModelState.IsValid)
                {
                    if (att_jobcardapp.DateEnded != null)
                    {
                        att_jobcardapp.DateCreated = DateTime.Now;
                        att_jobcardapp.StatusID    = "Approved";
                        att_jobcardapp.StartTime   = null;
                        att_jobcardapp.EndTime     = null;
                        db.Att_JobCardApp.Add(att_jobcardapp);
                        db.SaveChanges();
                    }
                    else
                    {
                        att_jobcardapp.DateCreated = DateTime.Now;
                        att_jobcardapp.StatusID    = "Approved";
                        db.Att_JobCardApp.Add(att_jobcardapp);
                        db.SaveChanges();
                        ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
                        AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Job_Cards), Convert.ToInt16(AuditManager.AuditOperation.Add), DateTime.Now, (int)att_jobcardapp.JobCardAppID);
                    }
                }
                ViewBag.JCTypeID = new SelectList(db.Att_JobCard, "JCID", "JCName", att_jobcardapp.JCTypeID);
                return(RedirectToAction("Index"));
            }

            return(View(att_jobcardapp));
        }
Esempio n. 15
0
        public static List <EmpView> GetEmployees(List <EmpView> emps, ViewUserEmp LoggedInUser)
        {
            List <EmpView> nEmps = emps.Where(aa => aa.ReportingToID == LoggedInUser.EmpID).ToList();

            // Add LoggedInUser Employee object in list
            if (nEmps.Where(aa => aa.EmployeeID == LoggedInUser.EmpID).Count() == 0)
            {
                nEmps.AddRange(emps.Where(aa => aa.EmployeeID == LoggedInUser.EmpID).ToList());
            }
            List <EmpView> rEmps = GetReportingToEmps(emps, nEmps);

            if (rEmps.Count > 0)
            {
                while (true)
                {
                    rEmps = GetReportingToEmps(emps, rEmps).ToList();
                    nEmps.AddRange(rEmps);
                    if (rEmps.Count == 0)
                    {
                        return(nEmps);
                    }
                    if (nEmps.Count() >= emps.Count())
                    {
                        return(nEmps);
                    }
                }
            }
            else
            {
                return(nEmps);
            }
        }
Esempio n. 16
0
        public ModelSOTPEmpDetail GetDetailPending(int prid, int EmpID, ViewUserEmp LoggedInUser)
        {
            ModelSOTPEmpDetail vm  = new ModelSOTPEmpDetail();
            PR_PayrollPeriod   prp = OTHelperManager.GetPayrollPeriod(db.PR_PayrollPeriod.ToList(), prid);
            HR_Employee        emp = db.HR_Employee.First(aa => aa.EmployeeID == EmpID);

            //if (DateTime.Today > prp.SupervisorCutOffDate)
            //    vm.IsLate = true;
            //else
            vm.IsLate  = false;
            vm.EmpID   = (int)EmpID;
            vm.EmpName = emp.FullName;
            vm.DeptID  = (int)emp.SectionID;
            vm.List    = OTHelperRecommended.GetConvertedDailyOTList(db.ViewDailyOTEntries.Where(aa => aa.EmployeeID == vm.EmpID && aa.OTDate >= prp.PStartDate && aa.OTDate <= prp.PEndDate).ToList());
            if (vm.List.Count > 0)
            {
                vm.SystemOT    = OTHelperManager.ConverMinIntoHours(vm.List.Sum(aa => aa.SystemOTMins));
                vm.ClaimedOT   = OTHelperManager.ConverMinIntoHours(vm.List.Sum(aa => aa.ClaimedOTMins));
                vm.TotalDays   = vm.List.Count();
                vm.TotalAmount = vm.List.Sum(aa => aa.OTAmount);
            }
            vm.DivRemainingBudget = OTHelperManager.GetDivRemainingBudget(OTHelperManager.GetDivisionIDs(OTHelperManager.ConvertDeptIDList(emp.SectionID), db.HR_Section.ToList()), db.BG_OTDivision.ToList(), (int)prp.FinYearID);
            vm.PeriodName         = prp.PName;
            vm.PeriodID           = prp.PID;
            vm.OTPolicy           = "OT Days Forward Policy: Maximum Days in Week = " + emp.Att_OTPolicy.DaysInWeek.ToString() + " , Maximum Days in Month = " + emp.Att_OTPolicy.DaysInMonth.ToString();
            vm.OTPolicyDays       = "OT Claimed Hours Policy: Normal Day= " + OTHelperManager.ConverMinIntoHours((int)emp.Att_OTPolicy.PerDayOTStartLimitHour) + " to " + OTHelperManager.ConverMinIntoHours((int)emp.Att_OTPolicy.PerDayOTEndLimitHour) + ", Rest & GZ Day= " + OTHelperManager.ConverMinIntoHours((int)emp.Att_OTPolicy.PerDayGOTStartLimitHour) + " to " + OTHelperManager.ConverMinIntoHours((int)emp.Att_OTPolicy.PerDayGOTEndLimitHour);
            vm.Count = vm.List.Count;

            ViewBag.DecisionID  = new SelectList(OTHelperManager.GetOTStatusForApprover(db.Att_OTStatus.ToList()), "PSID", "StatusName", "F");
            ViewBag.RecommendID = new SelectList(OTHelperManager.GetUsersForRecommender(db.ViewUserEmps.Where(aa => aa.EmpStatus == "Active").ToList()), "UserID", "FullName");
            return(vm);
        }
        public ActionResult Edit([Bind(Include = "GrdID,GradeName,OGradeID,NormalOTAmount,RestOTAmount,GZOTAmount")] HR_Grade hr_grade)
        {
            if (ModelState.IsValid)
            {
                ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
                using (var ctx = new HRMEntities())
                {
                    HR_Grade        OldGrade     = ctx.HR_Grade.First(aa => aa.GrdID == hr_grade.GrdID);
                    HR_GradeHistory GradeHistory = new HR_GradeHistory();
                    GradeHistory.CDateTime      = DateTime.Now;
                    GradeHistory.GradeName      = OldGrade.GradeName;
                    GradeHistory.GrdID          = OldGrade.GrdID;
                    GradeHistory.GZOTAmount     = OldGrade.GZOTAmount;
                    GradeHistory.IP             = AuditManager.GetIPAddress();
                    GradeHistory.NormalOTAmount = OldGrade.NormalOTAmount;
                    GradeHistory.OGradeID       = OldGrade.OGradeID;
                    GradeHistory.OGradeID       = OldGrade.OGradeID;
                    GradeHistory.RestOTAmount   = OldGrade.RestOTAmount;
                    GradeHistory.UserID         = loggedUser.UserID;
                    ctx.HR_GradeHistory.Add(GradeHistory);
                    ctx.SaveChanges();
                    hr_grade.OGradeID = OldGrade.OGradeID;
                }
                db.Entry(hr_grade).State = System.Data.Entity.EntityState.Modified;
                db.SaveChanges();

                AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Grade), Convert.ToInt16(AuditManager.AuditOperation.Edit), DateTime.Now, (int)hr_grade.GrdID);
                return(RedirectToAction("Index"));
            }
            return(View(hr_grade));
        }
Esempio n. 18
0
        internal string QueryForSectionReport(ViewUserEmp LoggedInUser)
        {
            string              query = "";
            HRMEntities         db    = new HRMEntities();
            List <UserRoleData> uAcc  = new List <UserRoleData>();

            uAcc = db.UserRoleDatas.Where(aa => aa.RoleUserID == LoggedInUser.UserID && aa.UserRoleLegend == "D").ToList();
            // List<HR_Division> division = db.HR_Division.ToList();
            List <HR_Department> department = db.HR_Department.ToList();
            List <HR_Section>    section    = db.HR_Section.ToList();
            List <string>        queryList  = new List <string>();

            foreach (var access in uAcc)
            {
                switch (LoggedInUser.UserType)
                {
                case "G":    //ADmin
                    query = "";
                    List <HR_Section> locs = new List <HR_Section>();
                    break;

                //case "V"://Division
                //    List<HR_Section> locs = new List<HR_Section>();
                //    locs = db.HR_Section.Where(aa => aa.HR_Department.DivsionID == access.RoleDataValue).ToList();
                //    foreach (var c in locs)
                //    {
                //        queryList.Add(" SecID =" + c.SecID);
                //    }
                //    break;
                case "D":    //Depts
                    locs = db.HR_Section.Where(aa => aa.DepartmentID == access.RoleDataValue).ToList();
                    foreach (var c in locs)
                    {
                        queryList.Add(" SecID =" + c.SecID);
                    }
                    break;

                case "S":    //Section
                    string cityIDForLoc = section.Where(aa => aa.SecID == access.RoleDataValue).FirstOrDefault().SecID.ToString();
                    queryList.Add(" SecID =" + cityIDForLoc);
                    break;
                }
            }
            if (queryList.Count == 1)
            {
                query = query + queryList[0];
            }
            else if (queryList.Count > 1)
            {
                for (int i = 0; i < queryList.Count - 1; i++)
                {
                    query = query + queryList[i] + " or ";
                }
                query = query + queryList[queryList.Count - 1];
            }

            return(query);
        }
Esempio n. 19
0
        internal string QueryForLocReport(ViewUserEmp LoggedInUser)
        {
            string              query = "";
            HRMEntities         db    = new HRMEntities();
            List <UserRoleData> uAcc  = new List <UserRoleData>();

            uAcc = db.UserRoleDatas.Where(aa => aa.RoleUserID == LoggedInUser.UserID && aa.UserRoleLegend == "L").ToList();
            List <HR_Location> locss     = db.HR_Location.ToList();
            List <string>      queryList = new List <string>();

            foreach (var access in uAcc)
            {
                switch (LoggedInUser.UserType)
                {
                case "A":    //ADmin
                    query = "";
                    List <HR_Location> locs = new List <HR_Location>();
                    break;

                //case "R"://REgion
                //    List<HR_Location> locs = new List<HR_Location>();
                //    locs = db.HR_Location.Where(aa => aa.HR_City.CityID == access.RoleDataValue).ToList();
                //    foreach (var c in locs)
                //    {
                //        queryList.Add(" LocID =" + c.LocID);
                //    }
                //    break;
                //case "C"://City
                //    locs = db.HR_Location.Where(aa => aa.CityID == access.RoleDataValue).ToList();
                //    foreach (var c in locs)
                //    {
                //        queryList.Add(" LocID =" + c.LocID);
                //    }
                //    break;
                case "L":    //Location
                    if (locss.Where(aa => aa.LocID == access.RoleDataValue).Count() > 0)
                    {
                        string cityIDForLoc = locss.Where(aa => aa.LocID == access.RoleDataValue).FirstOrDefault().LocID.ToString();
                        queryList.Add(" LocID =" + cityIDForLoc);
                    }
                    break;
                }
            }
            if (queryList.Count == 1)
            {
                query = query + queryList[0];
            }
            else if (queryList.Count > 1)
            {
                for (int i = 0; i < queryList.Count - 1; i++)
                {
                    query = query + queryList[i] + " or ";
                }
                query = query + queryList[queryList.Count - 1];
            }

            return(query);
        }
Esempio n. 20
0
        public ActionResult AOTEmpList(int?DeptID, int?PayrollPeriodID)
        {
            ModelSOTEmpList vm           = new ModelSOTEmpList();
            ViewUserEmp     LoggedInUser = Session["LoggedUser"] as ViewUserEmp;

            vm         = GetEmpPending(LoggedInUser, (int)PayrollPeriodID, (int)DeptID);
            vm.Message = new List <string>();
            return(View(vm));
        }
        // GET: /Attendance/JobCard/
        public ActionResult Index()
        {
            Session["SelectedMenu"] = "JobCardHistory";
            ViewUserEmp LoggedInUser   = Session["LoggedUser"] as ViewUserEmp;
            var         att_jobcardapp = db.ViewJobCards.Where(aa => aa.EmployeeID == LoggedInUser.EmpID).OrderByDescending(aa => aa.DateCreated);

            Utilities.DeleteNotificationByType(LoggedInUser.EmpID ?? 0, Convert.ToInt16(Utilities.NotificationType.Job_Card));
            return(View(att_jobcardapp.ToList()));
        }
        public ActionResult SOTDetailList(int?EmpID, int?PayrollPeriodID)
        {
            ViewUserEmp        LoggedInUser = Session["LoggedUser"] as ViewUserEmp;
            ModelSOTPEmpDetail vm           = new ModelSOTPEmpDetail();
            int prid = Convert.ToInt32(Session["PRID"].ToString());

            vm         = GetDetailPending(prid, (int)EmpID, LoggedInUser);
            vm.Message = new List <string>();
            return(View(vm));
        }
 private bool CheckCreateActionPermission(ViewUserEmp _User)
 {
     if (_User.CanAdd == true)
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }
 private bool CheckEditActionPermission(ViewUserEmp _User)
 {
     if (_User.CanEdit == true)
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }
        public ActionResult DeleteConfirmed(byte id)
        {
            Att_Holiday att_holiday = db.Att_Holiday.Find(id);

            db.Att_Holiday.Remove(att_holiday);
            db.SaveChanges();
            ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;

            AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Holiday), Convert.ToInt16(AuditManager.AuditOperation.Delete), DateTime.Now, (int)att_holiday.HolidayID);
            return(RedirectToAction("Index"));
        }
 private bool CheckDetailActionPermission(ViewUserEmp _User)
 {
     if (_User.CanView == true)
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }
Esempio n. 27
0
 public ActionResult Edit([Bind(Include = "ID,SupervisorCutOffDate,RecommendCutOffDate,ApprovedCutOffDate")] Att_Setting att_setting)
 {
     if (ModelState.IsValid)
     {
         db.Entry(att_setting).State = System.Data.Entity.EntityState.Modified;
         db.SaveChanges();
         ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
         AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Att_Setting), Convert.ToInt16(AuditManager.AuditOperation.Edit), DateTime.Now, (int)att_setting.ID);
         return(RedirectToAction("Index"));
     }
     return(View(att_setting));
 }
 public ActionResult Edit([Bind(Include = "PFinYearID,FinYearName,StartDate,EndDate,Status")] PR_FinYear pr_finyear)
 {
     if (ModelState.IsValid)
     {
         db.Entry(pr_finyear).State = System.Data.Entity.EntityState.Modified;
         db.SaveChanges();
         ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;
         AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.FinYear), Convert.ToInt16(AuditManager.AuditOperation.Edit), DateTime.Now, (int)pr_finyear.PFinYearID);
         return(RedirectToAction("Index"));
     }
     return(View(pr_finyear));
 }
        public ActionResult DeleteConfirmed(int id)
        {
            PR_FinYear pr_finyear = db.PR_FinYear.Find(id);

            db.PR_FinYear.Remove(pr_finyear);
            db.SaveChanges();
            ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;

            AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.FinYear), Convert.ToInt16(AuditManager.AuditOperation.Delete), DateTime.Now, (int)pr_finyear.PFinYearID);

            return(RedirectToAction("Index"));
        }
Esempio n. 30
0
        // GET: /Attendance/EmployeeJobCard/Delete/5
        public ActionResult Delete(int?id)
        {
            Att_JobCardApp att_jobcardapp = db.Att_JobCardApp.Find(id);

            db.Att_JobCardApp.Remove(att_jobcardapp);
            db.SaveChanges();
            ViewUserEmp loggedUser = Session["LoggedUser"] as ViewUserEmp;

            AuditManager.SaveAuditLog(loggedUser.UserID, Convert.ToInt16(AuditManager.AuditForm.Job_Cards), Convert.ToInt16(AuditManager.AuditOperation.Delete), DateTime.Now, (int)att_jobcardapp.JobCardAppID);

            return(RedirectToAction("Index"));
        }