public Person ControlPerson(string _email, string _password) { try { using (var context = new ProjectManagementEntities()) { var user = context.Person.FirstOrDefault(x => x.Email == _email && x.Password == _password && x.Status > 0); if (user != null) { return(user); } return(null); } } catch (Exception exc) { throw exc; } }
public List <Project> GetAllDetailTaskProjectById(int _id) { try { var _personId = JsonConvert.DeserializeObject <Person>(HttpContext.Session.GetString("ActivePerson")).Id; using (var context = new ProjectManagementEntities()) { var list = new List <Project>(); var item = ProjectDB.GetInstance().GetProjeById(_id); list.Add(item); return(list); } } catch (System.Exception exc) { throw exc; } }
public List <ChartDetailViewModel> GetChartDetail(string _milestoneName, int _projectId) { try { var returnList = new List <ChartDetailViewModel>(); using (var context = new ProjectManagementEntities()) { var milestone = context.Milestone.FirstOrDefault(x => x.Name == _milestoneName.Trim() && x.ProjectId == _projectId); if (milestone != null) { var steps = context.Step.Where(x => x.MilestoneId == milestone.Id).ToList(); foreach (var item in steps) { var assignedUser = context.Person.FirstOrDefault(x => x.Id == item.AssigneeUser); var sprint = context.Sprint.FirstOrDefault(x => x.Id == item.SprintId); returnList.Add(new ChartDetailViewModel() { AssigneeUserName = $"{assignedUser.Name} {assignedUser.Surname}", SprintId = item.SprintId, SprintName = sprint.Name, TaskId = item.Id, TaskName = item.Name, TaskStatus = item.Status, Workers = GetWorkersForChartDetail(item.Id) }); } } return(returnList); } } catch (Exception exc) { throw exc; } }
public ActionResult doNewCost(string tbID, string ddlProject, string ddlPartyB, string dpDate, string nbMoney, string ddlMoneyUnit) { if (Session["username"] == null || Session["username"].Equals("")) { return(RedirectToAction("Index", "Session")); } if (!ValidateCostID(tbID)) { ShowNotify(string.Format("存在{0}这样的支出编号", tbID), MessageBoxIcon.Warning); UIHelper.TextBox("tbID").MarkInvalid("已存在相同的支出编号"); return(UIHelper.Result()); } Cost cos = new Cost(); cos.ID = Convert.ToInt32(tbID); cos.ProjectID = Convert.ToInt32(ddlProject); cos.PartyBID = Convert.ToInt32(ddlPartyB); cos.Money = computeMoney(nbMoney, ddlMoneyUnit); cos.Date = parseDate(dpDate); using (var db = new ProjectManagementEntities()) { db.Cost.Add(cos); try { db.SaveChanges(); ShowNotify("发票添加成功", MessageBoxIcon.Success); UIHelper.Form("mainForm").Reset(); } catch (System.Data.Entity.Validation.DbEntityValidationException) { ShowNotify("数据无效,请检查表单!", MessageBoxIcon.Error); } catch (Exception) { ShowNotify("服务器发生了未能处理的异常,请联系技术人员进行检测。", MessageBoxIcon.Error); } } return(UIHelper.Result()); }
public ActionResult NewInvoice() { if (Session["username"] == null || Session["username"].Equals("")) { return(RedirectToAction("Index", "Session")); } NewInvoiceViewModel vm = new NewInvoiceViewModel(); using (var db = new ProjectManagementEntities()) { //Get Project DataTable dtPro = new DataTable(); dtPro.Columns.Add(new DataColumn("ID", typeof(string))); dtPro.Columns.Add(new DataColumn("Name", typeof(string))); var proArr = db.Project; foreach (var pro in proArr) { var dtProRow = dtPro.NewRow(); dtProRow["ID"] = pro.ID; dtProRow["Name"] = String.Format("(代码:{0}) {1}", pro.ID, pro.Name); dtPro.Rows.Add(dtProRow); } vm.Project = dtPro; //GetPartyB DataTable dtPartyB = new DataTable(); dtPartyB.Columns.Add(new DataColumn("ID", typeof(string))); dtPartyB.Columns.Add(new DataColumn("Name", typeof(string))); var partyBArr = db.PartyB; foreach (var partyB in partyBArr) { var dtPartyBRow = dtPartyB.NewRow(); dtPartyBRow["ID"] = partyB.ID; dtPartyBRow["Name"] = "(代码:" + partyB.ID + ") " + partyB.Name; dtPartyB.Rows.Add(dtPartyBRow); } vm.PartyB = dtPartyB; } return(View(vm)); }
public List <DateTime> GetProjectStartAndEndDate(int _projectId) { try { using (var context = new ProjectManagementEntities()) { var mileStoneList = context.Milestone.Where(x => x.Status > 0 && x.ProjectId == _projectId).ToList(); var startDate = mileStoneList.Select(x => x.StartDate).ToList().OrderBy(x => x).ToList().FirstOrDefault(); var endDate = mileStoneList.Select(x => x.EndDate).ToList().OrderByDescending(x => x).ToList().FirstOrDefault(); return(new List <DateTime>() { startDate, endDate }); } } catch (Exception exc) { throw exc; } }
/// <summary> /// Updated Project /// </summary> /// <param name="project">Project</param> /// <returns>Boolean</returns> public int UpdateProject(Project project) { using (ProjectManagementEntities projectMngtEntity = new ProjectManagementEntities()) { var existingProject = projectMngtEntity.tblProjects.Find(project.ProjectID); if (existingProject != null) { existingProject.ProjectName = project.ProjectName; existingProject.StartDt = project.StartDate; existingProject.EndDt = project.EndDate; existingProject.Priority = project.Priority; //projectMngtEntity.Entry(existingProject).State = System.Data.Entity.EntityState.Modified; return(projectMngtEntity.SaveChanges()); } else { return(-1); } } }
private int getDefaultProjectID() { using (var db = new ProjectManagementEntities()) { // Search the ID int now = Convert.ToInt32(System.DateTime.Now.ToString("yyyyMM")); var pid = (from u in db.Project where u.ID / 1000 == now select u.ID); //.Equals(System.DateTime.Now.ToString("yyyymm")))).Max(u=>u.ID); //if (idres == null) { pid = System.DateTime.Now.ToString("yyyymm") + "0001"; } int m; if (pid.Count() == 0) { m = now * 1000 + 1; } else { m = pid.Max() + 1; } return(m); } }
/// <summary> /// Updated User /// </summary> /// <param name="user">User</param> /// <returns>int</returns> public int UpdateUser(User user) { using (ProjectManagementEntities projectMngtEntity = new ProjectManagementEntities()) { var existingUser = projectMngtEntity.tblUsers.Find(user.UserID); if (existingUser != null) { existingUser.FirstName = user.FirstName; existingUser.LastName = user.LastName; existingUser.EmployeeID = user.EmployeeID; existingUser.ProjectID = user.ProjectID; existingUser.TaskID = user.TaskID; return(projectMngtEntity.SaveChanges()); } else { return(-1); } } }
public Department SaveDepartment(int _id, string _name, int _headOfDepartmentId) { try { using (var context = new ProjectManagementEntities()) { if (_id == 0) { var Department = new Department() { Id = _id, DepartmentName = _name, Status = 1, HeadOfDepartmentId = _headOfDepartmentId }; context.Department.Add(Department); int numberOfInserted = context.SaveChanges(); return(numberOfInserted > 0 ? Department : null); } else { var Department = context.Department.FirstOrDefault(x => x.Id == _id); Department.Id = _id; Department.DepartmentName = _name; Department.Status = 1; Department.HeadOfDepartmentId = _headOfDepartmentId; int numberOfUpdated = context.SaveChanges(); return(numberOfUpdated > 0 ? Department : null); } } } catch (Exception exc) { throw exc; } }
public Team SaveTeam(int _id, string _name, int _departmentId) { try { using (var context = new ProjectManagementEntities()) { if (_id == 0) { var Team = new Team() { Id = _id, Name = _name, Status = 1, DepartmentId = _departmentId }; context.Team.Add(Team); int numberOfInserted = context.SaveChanges(); return(numberOfInserted > 0 ? Team : null); } else { var Team = context.Team.FirstOrDefault(x => x.Id == _id); Team.Id = _id; Team.Name = _name; Team.Status = 1; Team.DepartmentId = _departmentId; int numberOfUpdated = context.SaveChanges(); return(numberOfUpdated > 0 ? Team : null); } } } catch (Exception exc) { throw exc; } }
public List <WhatsappMessageRedirectRepo> GetRedirectNotifications(int _userId) { try { using (var context = new ProjectManagementEntities()) { var returnList = new List <WhatsappMessageRedirectRepo>(); var headDepartmentIds = context.Department.Where(x => x.HeadOfDepartmentId == _userId).ToList().Select(x => x.Id).ToList(); var list = context.WhatsappMessageRedirect.Where(x => headDepartmentIds.Contains(x.DepartmentId) && x.Status > 0).ToList(); foreach (var item in list) { var department = context.Department.FirstOrDefault(x => x.Id == item.DepartmentId); var message = context.WhatsappMessage.FirstOrDefault(x => x.Id == item.MessageId); var redirectUser = context.Person.FirstOrDefault(x => x.Id == item.RedirectedUserId); returnList.Add(new WhatsappMessageRedirectRepo() { RedirectDate = item.Date.ToString("dd/MM/yyyy HH:mm"), MessageDate = message.Date.ToString("dd/MM/yyyy HH:mm"), DepartmentId = item.DepartmentId, DepartmentName = department != null ? department.DepartmentName : "Bilinmiyor", Id = item.Id, Message = message != null ? message.MessageContent : "Bilinmiyor", MessageId = item.MessageId, RedirectedUserId = item.RedirectedUserId, RedirectedUserName = redirectUser != null ? $"{redirectUser.Name} {redirectUser.Surname}" : "Bilinmiyor", Status = item.Status, SenderNumber = message != null ? message.MessageFrom : "Bilinmiyor" }); } return(returnList); } } catch (Exception exc) { throw exc; } }
public DashboardWidgets(int employeeID) { this.EmployeeID = employeeID; dbContext = new ProjectManagementEntities(); Items = new ObservableCollection <Widget>(); var query = dbContext.Dashboard.Where(d => d.DashBoardID == employeeID); foreach (var item in query) { Items.Add(new Widget() { WidgetID = (int)item.WidgetID, WidgetName = item.WidgetDetail.WidgetName.ToString(), Desc = item.WidgetDetail.WidgetDesc.ToString(), CanvasLeft = (int)item.PositionLeft, CanvasTop = (int)item.PositionTop, ImagePath = new BitmapImage(new Uri(item.WidgetDetail.WidgetImagePath.ToString(), UriKind.Relative)), WidgetWidth = (int)item.WidgetWidth, WidgetHeight = (int)item.WidgetHeight }); } }
public void MakeMessagesSeen(int _messageId, int _userId) { try { using (var context = new ProjectManagementEntities()) { var message = context.Message.FirstOrDefault(x => x.Id == _messageId); var allMessagesBetween = context.Message.Where(x => x.ReceiverId == message.SenderId && x.SenderId == message.ReceiverId).ToList(); allMessagesBetween.AddRange(context.Message.Where(x => x.SenderId == message.SenderId && x.ReceiverId == message.ReceiverId).ToList()); allMessagesBetween = allMessagesBetween.Where(x => x.ReceiverId == _userId).ToList(); foreach (var item in allMessagesBetween) { item.IsSeen = true; context.SaveChanges(); } } } catch (Exception exc) { throw exc; } }
public List <Category> GetCategoryNameandId(int _id) { try { using (var context = new ProjectManagementEntities()) { var returnList = new List <Category>(); var list = context.Category.FirstOrDefault(x => x.Id == _id); returnList.Add(new Category() { Id = list.Id, Name = list.Name, ProjectId = list.ProjectId }); return(returnList); } } catch (System.Exception exc) { throw exc; } }
public List <Category> GetCategoryById(int _CategoryId) { try { using (var context = new ProjectManagementEntities()) { var returnList = new List <Category>(); var list = context.Category.FirstOrDefault(x => x.Status > 0 && x.Id == _CategoryId); returnList.Add(new Category() { Name = list.Name, Id = list.Id, ProjectId = list.ProjectId }); return(returnList); } } catch (Exception exc) { throw exc; } }
public bool DeleteMessage(int _messageId) { try { using (var context = new ProjectManagementEntities()) { var message = context.WhatsappMessage.FirstOrDefault(x => x.Id == _messageId); if (message != null) { message.IsSeen = true; int numberOfUpdated = context.SaveChanges(); return(numberOfUpdated > 0); } return(false); } } catch (Exception exc) { throw exc; } }
public ActionResult ProvinceChange(string ddlProvince) { var ddlCity = UIHelper.DropDownList("ddlCity"); List <ListItem> items = new List <ListItem>(); items.Add(new ListItem("选择地区市", "-1", true)); if (ddlProvince != "-1") { using (var db = new ProjectManagementEntities()){ int ddlProvinceNum = Convert.ToInt32(ddlProvince); var CityArr = db.City.Where(u => (u.ProvinceID == ddlProvinceNum)); foreach (var City in CityArr) { ListItem item = new ListItem(); item.Text = City.Name; item.Value = City.ID.ToString(); items.Add(item); } } } ddlCity.LoadData(items.ToArray()); // 是否禁用 ddlCity.Enabled(!(ddlCity.Source.Items.Count == 1)); var ddlCounty = UIHelper.DropDownList("ddlCounty"); List <ListItem> items2 = new List <ListItem>(); items2.Add(new ListItem("选择县", "-1", true)); ddlCounty.LoadData(items2.ToArray()); ddlCounty.Enabled(false); return(UIHelper.Result()); }
public bool DeleteSprint(int _sprintId) { try { using (var context = new ProjectManagementEntities()) { var sprint = context.Sprint.FirstOrDefault(x => x.Id == _sprintId); if (sprint != null) { sprint.Status = 0; int numberOfDeleted = context.SaveChanges(); return(numberOfDeleted > 0); } } return(false); } catch (System.Exception exc) { throw exc; } }
public bool DeleteCategory(int _CategoryId) { try { using (var context = new ProjectManagementEntities()) { var Category = context.Category.FirstOrDefault(x => x.Id == _CategoryId); if (Category != null) { Category.Status = 0; int numberOfDeleted = context.SaveChanges(); return(numberOfDeleted > 0); } } return(false); } catch (System.Exception exc) { throw exc; } }
public bool DeleteTask(int _TaskId) { try { using (var context = new ProjectManagementEntities()) { var Task = context.Task.FirstOrDefault(x => x.Id == _TaskId); if (Task != null) { Task.Status = 0; int numberOfDeleted = context.SaveChanges(); return(numberOfDeleted > 0); } } return(false); } catch (System.Exception exc) { throw exc; } }
public bool DeletePano(int _panoId) { try { using (var context = new ProjectManagementEntities()) { var board = context.Board.FirstOrDefault(x => x.Id == _panoId); if (board != null) { board.Status = 0; int numberOfDeleted = context.SaveChanges(); return(numberOfDeleted > 0); } } return(false); } catch (System.Exception exc) { throw exc; } }
/// <summary> /// Updated Task /// </summary> /// <param name="task">Project</param> /// <returns>int</returns> public int UpdateTask(task.Task task) { using (ProjectManagementEntities projectMngtEntity = new ProjectManagementEntities()) { var existingTask = projectMngtEntity.tblTasks.Find(task.TaskID); if (existingTask != null) { existingTask.ParentID = task.ParentTaskId; existingTask.ProjectID = task.ProjectId; existingTask.Task = task.TaskDesc; existingTask.StartDt = task.StartDate; existingTask.EndDt = task.EndDate; existingTask.Priority = task.Priority; existingTask.Status = task.Status; return(projectMngtEntity.SaveChanges()); } else { return(-1); } } }
public bool DeleteRedirectedMessage(int _redirectId) { try { using (var context = new ProjectManagementEntities()) { var redirect = context.WhatsappMessageRedirect.FirstOrDefault(x => x.Id == _redirectId); if (redirect != null) { redirect.Status = 0; int numberOfUpdated = context.SaveChanges(); return(numberOfUpdated > 0); } return(false); } } catch (Exception exc) { throw exc; } }
public Project Update(int id, Project project) { ProjectManagementEntities ctx = ProjectManagementEntities.Context; Project proj = null; try { proj = ctx.Projects.FirstOrDefault(x => x.Project_ID == id); proj.Project_Name = project.Project_Name; proj.Start_Date = project.Start_Date; proj.End_Date = project.End_Date; proj.Priority = project.Priority; proj.Manager = project.Manager; ctx.SaveChanges(); } catch (Exception ex) { Debug.WriteLine(ex.Message); throw; } return(proj); }
public bool DeleteGorev(int _gorevId) { try { using (var context = new ProjectManagementEntities()) { var gorev = context.Step.FirstOrDefault(x => x.Id == _gorevId); if (gorev != null) { gorev.Status = 0; int numberOfDeleted = context.SaveChanges(); return(numberOfDeleted > 0); } } return(false); } catch (System.Exception exc) { throw exc; } }
public bool DeleteMilestone(int _projeId) { try { using (var context = new ProjectManagementEntities()) { var milestone = context.Milestone.FirstOrDefault(x => x.Id == _projeId); if (milestone != null) { milestone.Status = 0; int numberOfDeleted = context.SaveChanges(); return(numberOfDeleted > 0); } } return(false); } catch (System.Exception exc) { throw exc; } }
public JsonResult GetProjectPercentage() { try { using (var context = new ProjectManagementEntities()) { var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id; var pct = StepDB.GetInstance().GetProjectPercentage(_projectId); pct.Gerceklesen = pct.Gerceklesen == null || pct.Gerceklesen.Trim() == "" ? "0" : pct.Gerceklesen; var yuzde = Math.Round(Convert.ToDouble(pct.Gerceklesen.Replace(".", ",").Trim(), CultureInfo.GetCultureInfo("tr-TR")) * 100, 2); return(Json(yuzde)); } } catch (System.Exception exc) { throw exc; } /* * SET @pct = 0; * SET @boardId = 0; * SET @allItems = 0; * SET @completedItems = 0; * * SET @boardId = (SELECT Id FROM Board AS B * WHERE ProjectId = 1 * LIMIT 2,1); * * SET @allItems = (SELECT COUNT(1) FROM Step AS S INNER JOIN Milestone AS MS ON MS.Id = S.MilestoneId WHERE MS.ProjectId = 1); * SET @completedItems = (SELECT COUNT(1) FROM Step AS S INNER JOIN Milestone AS MS ON MS.Id = S.MilestoneId INNER JOIN BoardStep AS BS ON BS.StepId = S.Id WHERE MS.ProjectId = 1 AND BS.BoardId = @boardId); * SET @pct = (@completedItems * 100 / @allItems) / 100; * SELECT @pct; */ }
public int FinishSprint(int _projectId) { try { using (var context = new ProjectManagementEntities()) { var boards = context.Board.Where(x => x.ProjectId == _projectId & x.Status == 1).ToList(); var boardIds = boards.Select(x => x.Id).ToList(); var boardSteps = context.BoardStep.Where(x => boardIds.Contains(x.BoardId)).ToList(); var boardStepIds = boardSteps.Select(x => x.StepId).ToList(); var steps = context.Step.Where(x => boardStepIds.Contains(x.Id)).ToList(); var stepIds = steps.Select(x => x.Id).ToList(); var stepPerson = context.StepPerson.Where(x => stepIds.Contains(x.StepId)).ToList(); var stepPersonIds = stepPerson.Select(x => x.Id).ToList(); var control = context.StepPersonDetail.FirstOrDefault(x => stepPersonIds.Contains(x.StepPersonId) && x.EndDate == null); if (control != null) { return(-1); } foreach (var item in steps) { item.Status = 3; context.SaveChanges(); } context.BoardStep.RemoveRange(boardSteps); context.SaveChanges(); return(1); } } catch (Exception exc) { throw exc; } }
public ActionResult DeleteProject(string ID) { if (Session["username"] == null || Session["username"].Equals("")) { return(RedirectToAction("Index", "Session")); } using (var db = new ProjectManagementEntities()) { Project deleteItem = new Project { ID = Convert.ToInt32(ID) }; db.Project.Attach(deleteItem); db.Project.Remove(deleteItem); int result; try { result = db.SaveChanges(); } catch (Exception) { ShowNotify("服务器出现异常,删除失败", MessageBoxIcon.Error); return(UIHelper.Result()); } if (result > 0) { ShowNotify("成功删除", MessageBoxIcon.Success); PageContext.Redirect(Url.Action("SearchProject")); } else { ShowNotify("删除失败", MessageBoxIcon.Error); } return(UIHelper.Result()); } }