コード例 #1
0
        public ActionResult ViewTimeSheet(ViewTimeSheetModel model)
        {
            // var selectedtimeSheetData = "";
            try
            {
                int uid = int.Parse(Session["UserID"].ToString());
                int pid = Convert.ToInt32(model.ProjectName);
                using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
                {
                    var selectedtimeSheetData = (from data in dbHrms.TimesheetDatas
                                                 join
                                                 userdata in dbHrms.Users on data.UserID equals userdata.UserID
                                                 join
                                                 projectdata in dbHrms.Projects on data.ProjectID equals projectdata.ProjectID
                                                 where data.UserID == uid && data.ProjectID == pid && EntityFunctions.TruncateTime(data.DateOFSheet) >= model.StartDate && EntityFunctions.TruncateTime(data.DateOFSheet) <= model.EndDate
                                                 select new SelectedTimeSheet()
                    {
                        EmployeeName = ((userdata.FirstName) + " " + (userdata.LastName ?? "")).Trim(),
                        ProjectName = projectdata.ProjectName,
                        Date = data.DateOFSheet,
                        ProjectId = data.ProjectID,
                        UserId = data.UserID
                    }).ToList();

                    return(Json(selectedtimeSheetData, JsonRequestBehavior.AllowGet));
                }
            }
            catch (Exception Ex)
            {
                string actionName     = this.ControllerContext.RouteData.Values["action"].ToString();
                string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
                ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
            }
            return(Json(JsonRequestBehavior.AllowGet));
        }
コード例 #2
0
        public ActionResult ViewTimeSheet()
        {
            ViewTimeSheetModel obj = new ViewTimeSheetModel();

            try
            {
                using (DSRCManagementSystemEntities1 dbHrms = new DSRCManagementSystemEntities1())
                {
                    obj.ProjectNames  = GetProjects();
                    obj.EmployeeNames = new List <SelectListItem>();
                }
            }
            catch (Exception Ex)
            {
                string actionName     = this.ControllerContext.RouteData.Values["action"].ToString();
                string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
                ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
            }

            return(View(obj));
        }