示例#1
0
        public ActionResult EditorOT(VMOTEntry vmdata)
        {
            try
            {
                User           LoggedInUser = Session["LoggedUser"] as User;
                List <EmpView> emps         = new List <EmpView>();
                emps = db.EmpViews.Where(aa => aa.EmpNo == vmdata.EmpNo && aa.Status == true).ToList();
                emps = AssistantQuery.GetFilteredEmps(emps, db.UserSections.Where(aa => aa.UserID == LoggedInUser.UserID).ToList());

                if (emps.Count() > 0 && vmdata.FromDate != null && vmdata.ToDate != null)
                {
                    List <ViewAttData> attdata = new List <ViewAttData>();
                    attdata = db.ViewAttDatas.Where(aa => aa.EmpNo == vmdata.EmpNo && aa.AttDate >= vmdata.FromDate && aa.AttDate <= vmdata.ToDate).ToList();
                    vmdata.dbViewAttData = attdata;
                    vmdata.Count         = attdata.Count;
                }
                else
                {
                    ViewBag.Message = "There is no employee found";
                }
                return(View("Index", vmdata));
            }
            catch (Exception)
            {
                throw;
            }
        }
示例#2
0
 public ActionResult UpdateApprovedOT(VMOTEntry vmdata)
 {
     if (vmdata.EmpNo != "" && vmdata.FromDate != null && vmdata.ToDate != null)
     {
         List <string> empDates = db.ViewAttDatas.Where(aa => aa.EmpNo == vmdata.EmpNo && aa.AttDate >= vmdata.FromDate && aa.AttDate <= vmdata.ToDate).Select(aa => aa.EmpDate).ToList();
         foreach (var empDate in empDates)
         {
             if (Request.Form["EmpDate-" + empDate].ToString() != null && Request.Form["EmpDate-" + empDate].ToString() != "")
             {
                 AttData attData = db.AttDatas.First(aa => aa.EmpDate == empDate);
                 attData.ApprovedOT = Convert.ToInt16(Request.Form["EmpDate-" + empDate].ToString());
                 db.SaveChanges();
             }
         }
     }
     vmdata.dbViewAttData = db.ViewAttDatas.Where(aa => aa.EmpNo == vmdata.EmpNo && aa.AttDate >= vmdata.FromDate && aa.AttDate <= vmdata.ToDate).ToList();
     return(View("Index", vmdata));
 }
        public ActionResult GetAttendance(VMOTEntry vmdata)
        {
            User LoggedInUser = Session["LoggedUser"] as User;

            try
            {
                if (vmdata.FromDate != null && vmdata.ToDate != null)
                {
                    List <ViewAttData> attdata = new List <ViewAttData>();
                    attdata = db.ViewAttDatas.Where(aa => aa.EmpID == LoggedInUser.EmpID && aa.AttDate >= vmdata.FromDate && aa.AttDate <= vmdata.ToDate).ToList();
                    vmdata.dbViewAttData = attdata;
                    vmdata.Count         = attdata.Count;
                }
                return(View("Index", vmdata));
            }
            catch (Exception)
            {
                throw;
            }
        }
        //
        // GET: /EmpAttendance/
        public ActionResult Index()
        {
            VMOTEntry vm           = new VMOTEntry();
            User      LoggedInUser = Session["LoggedUser"] as User;

            try
            {
                DateTime           todate   = DateTime.Today;
                DateTime           datefrom = DateTime.Today.AddDays(-10);
                List <ViewAttData> attdata  = new List <ViewAttData>();
                attdata          = db.ViewAttDatas.Where(aa => aa.EmpID == LoggedInUser.EmpID && aa.AttDate >= datefrom && aa.AttDate <= todate).ToList();
                vm.dbViewAttData = attdata;
                vm.Count         = attdata.Count;
            }
            catch (Exception)
            {
                throw;
            }
            return(View(vm));
        }
示例#5
0
        public ActionResult Index()
        {
            VMOTEntry vm = new VMOTEntry();

            return(View(vm));
        }