public ProjectMapping UpdateMappig(int projId, int cpId, string colName) { ProjectMapping mapping = _db.ProjectMappings.SingleOrDefault(pm => pm.ProjectId == projId && pm.CPId == cpId); try { if (mapping != null) { mapping.CPId = cpId; mapping.PropertyName = colName; mapping.ProjectId = projId; } else { mapping = new ProjectMapping(); mapping.ProjectId = projId; mapping.CPId = cpId; mapping.PropertyName = colName; _db.ProjectMappings.Add(mapping); } _db.SaveChanges(); return(mapping); } catch (Exception err) { throw err;; } }
public ActionResult UpdateMapping(int CPId, int ProjectId, string Column) { JSONResult result = new JSONResult(); ProjectMapping mapping = null; ProjectMapping checkData; List <ProjectMapping> mappingList = iProjectMapping.GetProjectMappingsById(ProjectId); if (mappingList.Count > 0) { checkData = mappingList.SingleOrDefault(cp => cp.CPId == CPId); if (checkData != null && string.Compare(checkData.PropertyName, Column) == 0) { result.Code = "2"; return(Json(result)); } } try { mapping = iProjectMapping.UpdateMappig(ProjectId, CPId, Column); result.Code = "1"; result.Message = SuccessMessage; } catch (Exception err) { result.Code = "0"; result.Message = ErrorMessage; } return(Json(result)); }
static MongoDataContext() { ProductMapping.Register(); MachineMapping.Register(); ProjectMapping.Register(); AddressMapping.Register(); }
public ActionResult GetProjectChartPropertyList(int id) { KBProject project = iProj.GetKBProjectById(id); List <ProjectMapping> mappingList = iProjectMapping.GetProjectMappingsById(id); List <ChartProperty> chartPropertiesList = iProperty.GetChartPropertyList(project.ChartId); List <ChartPropertyProjectViewModel> chartPropProjList = new List <ChartPropertyProjectViewModel>(); ChartPropertyProjectViewModel chartProperty = null; ProjectMapping mapping = null; foreach (ChartProperty item in chartPropertiesList) { chartProperty = new ChartPropertyProjectViewModel(); chartProperty.CPId = item.CPId; chartProperty.CPName = item.CPName; mapping = mappingList.SingleOrDefault(mp => mp.CPId == item.CPId); if (mapping != null) { chartProperty.Column = mapping.PropertyName; } chartPropProjList.Add(chartProperty); } var data = JsonConvert.SerializeObject(chartPropProjList, new JsonSerializerSettings() { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(new { total = chartPropProjList.Count, rows = data }, JsonRequestBehavior.AllowGet)); }
public ActionResult TeamTimeEntry(FormCollection form) { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); ProjectMapping ObjPM = new ProjectMapping(); TeamEntryData obj = new TeamEntryData(); try { var curmonth = DateTime.Now.Month; var month = objdb.Master_TeamMonths.Where(o => o.Id < curmonth).ToList(); var userId = (int)Session["UserId"]; int BranchID = (int)objdb.Users.FirstOrDefault(o => o.UserID == userId).BranchId; ViewBag.Months = new SelectList(month, "Id", "Months", (curmonth - 1)); ViewBag.Projects = new SelectList(LoadProjects(), "ProjectID", "ProjectName"); ObjPM.Members = GetMembers(obj); obj.ProjectMembersDetails = GetMembers(obj); obj.MemberList = TimeEntryHelper.GetTeamMemberList(UserId: userId); obj.IsTeamData = true; obj.DateFrom = DateTime.Today.AddDays(-1).ToString("dd/MM/yyyy", CultureInfo.InvariantCulture); obj.DateTo = DateTime.Today.AddDays(-1).ToString("dd/MM/yyyy", CultureInfo.InvariantCulture); obj.EmployeeData = TimeEntryHelper.GetTeamMemberData(teamMembers: obj.MemberList, Date: DateTime.Today.AddDays(-1), IsAscending: true, BranchId: BranchID); } 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)); }
public ActionResult Display(string id) { string json = string.Empty; KBProject projData = iProj.GetProjectByURL(id); DataTable table = iProj.TestSQL(projData.ProjectSQL, projData.ProjectId); Lazy <C3JSLine> line = null; Lazy <C3JSBar> bar = null; switch (projData.Chart.ChartType) { case "Line": ChartProperty chartPtyCatalog = iChartProperty.GetChartPropertyByCatalog(projData.ChartId); ChartProperty chartPtyData = iChartProperty.GetChartPropertyByData(projData.ChartId); //取得專案設定的Chart對應屬性 List <ProjectMapping> projMappingList = iProjectMapping.GetProjectMappingsById(projData.ProjectId); //取得project的catalog col name ProjectMapping projMappingCatalog = projMappingList.SingleOrDefault(pm => pm.CPId == chartPtyCatalog.CPId); //取得project的data col name ProjectMapping projMappingData = projMappingList.SingleOrDefault(pm => pm.CPId == chartPtyData.CPId); line = new Lazy <C3JSLine>(() => new C3JSLine(table, projData.Chart.ChartScript)); json = line.Value.Generate( projMappingList.Where(pm => pm.CPId == projMappingData.CPId).Select(pmc => pmc.PropertyName).ToArray(), projMappingCatalog.PropertyName); break; case "Bar": //bar = new Lazy<C3JSBar>(() => new C3JSBar(table, projData.Chart.ChartScript)); //bar.Value.Generate() break; default: break; } ViewData["Script"] = json; return(View()); }
public bool SaveProjectsToUser(List <string> selectedValues, string user) { var list = new List <int>(); if (string.IsNullOrEmpty(selectedValues.First())) { list = null; } else { list = selectedValues.Select(int.Parse).ToList(); } List <ProjectMapping> projectList = new List <ProjectMapping>(); ProjectMapping project = new ProjectMapping(); projectList = this.context.Query <ProjectMapping>().Where(s => s.UserName == user && s.IsDeleted == false).ToList(); if (projectList != null) { foreach (ProjectMapping prj in projectList) { prj.IsDeleted = true; prj.ModifiedBy = user; prj.ModifiedDate = DateTime.Now; this.context.Update(prj); } } if (list != null) { foreach (int lst in list) { project.IsDeleted = false; project.ProjectId = lst; project.UserName = user; project.CreatedBy = user; project.CreatedDate = DateTime.Now; project.ModifiedBy = user; project.ModifiedDate = DateTime.Now; this.context.Add(project); } } return(true); }
// [DSRCAuthorize(Roles = "Vice President, Project Manager, Tech Lead,Head - Quality")] public ActionResult TeamTimeEntry(ProjectMapping ObjPM, TeamEntryData teamobj, FormCollection form) { DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1(); ViewMembers obj1 = new ViewMembers(); TeamEntryData obj = new TeamEntryData(); try { int userId = (int)(Session["UserID"]); int BranchID = (int)objdb.Users.FirstOrDefault(o => o.UserID == userId).BranchId; string projectID = (form["ProjectList"] == "") ? "0" : form["ProjectList"].ToString(); int PId = Convert.ToInt32(projectID); ViewBag.Projects = new SelectList(LoadProjects(), "ProjectID", "ProjectName", projectID); //if (Convert.ToInt32(teamobj.MemberId) == 0 || teamobj.MemberId==null) if (teamobj.MemberId == null || teamobj.MemberId == "0") { obj.ProjectMembersDetails = GetMembers(teamobj, PId); obj.MemberList = TimeEntryHelper.GetTeamMemberList(UserId: userId); obj.IsTeamData = true; obj.MemberId = "0"; } else { obj.ProjectMembersDetails = null; obj.MemberList = TimeEntryHelper.GetTeamMemberList(UserId: userId); obj.IsTeamData = obj.MemberId == "0"; } if (Convert.ToString(form["DateFrom"]) != null) { DateTime FDate = DateTime.ParseExact(Convert.ToString(form["DateFrom"]), "dd/MM/yyyy", CultureInfo.InvariantCulture); if (obj.IsTeamData) { //obj.EmployeeData = TimeEntryHelper.GetTeamMemberData(teamMembers: obj.MemberList, Date: FDate, IsAscending:true, BranchId: BranchID); obj.EmployeeData = TimeEntryHelper.GetTeamMemberData(teamMembers: obj.ProjectMembersDetails as List <TeamMember>, Date: FDate, IsAscending: true, BranchId: BranchID); } else { DateTime ToDate = DateTime.ParseExact(form["DateTo"], "dd/MM/yyyy", CultureInfo.InvariantCulture); obj.EmployeeData = null; obj.EmployeeData = TimeEntryHelper.GetSingleMemberData(EmpId: teamobj.MemberId, FromDate: FDate, ToDate: ToDate, IsAscending: true, BranchId: BranchID); if (ToDate == FDate) { int count = Convert.ToInt32((ToDate - FDate).TotalDays + 1); ViewData["totaldays"] = count; } else { int count = Convert.ToInt32((ToDate - FDate).TotalDays + 1); ViewData["totaldays"] = count; } } } var holidaysCount = 0; double businessDays = 0; using (var dbhrms = new DSRCManagementSystemEntities1()) { var FromDate = Convert.ToDateTime(obj.DateFrom); var ToDate = Convert.ToDateTime(obj.DateTo); foreach (var item in dbhrms.Master_holiday.Where(holiday => holiday.Date >= FromDate && holiday.Date <= ToDate)) { if (item.Date != null) { var tempDate = ((DateTime)item.Date); if (tempDate.DayOfWeek != DayOfWeek.Saturday && tempDate.DayOfWeek != DayOfWeek.Sunday) { holidaysCount++; } } } businessDays = 1 + ((ToDate - FromDate).TotalDays * 5 - (FromDate.DayOfWeek - ToDate.DayOfWeek) * 2) / 7 - holidaysCount; } ViewBag.businessDays = businessDays; } 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)); }