public static void CreateFeedItem(string feedText, int userId) { MySqlCommand cmd = new MySqlCommand("INSERT INTO ActivityFeed (FeedItemText, UserID) VALUES (@feedText, @userId)"); cmd.Parameters.AddWithValue("@feedText", feedText); cmd.Parameters.AddWithValue("@userId", userId); DBConn conn = new DBConn(); conn.ExecuteInsertCommand(cmd); conn.CloseConnection(); UserUtil.SendEmail(userId, feedText); }
public static Project CreateProject(string name, int workflowId, int companyId, int coachId, string notes) { Project p = new Project(workflowId, companyId, 0, coachId, name, notes); MySqlCommand cmd = new MySqlCommand("INSERT INTO Project (WorkflowID, CompanyID, StatusID, CoachID, ProjectName, ProjectNotes) VALUES (@workflowId, @companyId, @statusId, @coachId, @name, @notes)"); cmd.Parameters.AddWithValue("@workflowId", workflowId); cmd.Parameters.AddWithValue("@companyId", companyId); cmd.Parameters.AddWithValue("@statusId", 0); cmd.Parameters.AddWithValue("@coachId", coachId); cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@notes", notes); DBConn conn = new DBConn(); p.ProjectId = conn.ExecuteInsertCommand(cmd); //creates notification for the coach FeedUtil.CreateProjectFeedItem("Added as a coach for " + name, coachId, p.ProjectId); List <WorkflowComponent> workflowComponents = WorkflowComponentUtil.GetWorkflowComponents(workflowId); foreach (WorkflowComponent wc in workflowComponents) { //create completion status and forms for the project if (wc.FormID != -1) { Form f = FormUtil.CreateForm(wc.FormID, p.ProjectId); //creates notifications for each member of the company and each form List <User> clients = UserUtil.GetClients(companyId); foreach (User client in clients) { FeedUtil.CreateProjectFormFeedItem("Form " + f.FormName + " needs completion for " + name, client.UserId, p.ProjectId, f.FormId); } } } conn.CloseConnection(); return(p); }
public static Form DenyForm(int formId, string denialReason, int roleId) { Form f = GetForm(formId); Form ft = GetFormTemplate(f.FormTemplateId); int denialItemCt = -1; string[] approvalIDs = new string[0]; if (ft.ApproverIDs.Length > 0) { approvalIDs = ft.ApproverIDs.Split(','); } if (approvalIDs.Length > 0) { int i = 0; foreach (string roleID in approvalIDs) { int userRoleID = int.Parse(roleID); //if they are one of the users who needs to approve the form if (userRoleID == roleId) { denialItemCt = i; } i++; } } if (denialItemCt != -1) { string newDenial = ""; string[] currentDenial = f.Denied.Split(','); if (currentDenial.Length > denialItemCt) { int i = 0; foreach (string approval in currentDenial) { if (i == denialItemCt) { newDenial += "1"; } else { newDenial += currentDenial[i]; } i++; if (i != currentDenial.Length) { newDenial += ","; } } } MySqlCommand cmd = new MySqlCommand("UPDATE Forms SET Denied=@denied, DenialReason=@denialReason, Submission=0 WHERE FormID=@formId"); cmd.Parameters.AddWithValue("@denialReason", denialReason); cmd.Parameters.AddWithValue("@formId", formId); cmd.Parameters.AddWithValue("@denied", newDenial); DBConn conn = new DBConn(); conn.ExecuteInsertCommand(cmd); conn.CloseConnection(); Project p = ProjectUtil.GetProject(f.ProjectId); //notify all clients of the approval List <User> clients = UserUtil.GetClients(p.CompanyId); foreach (User client in clients) { FeedUtil.CreateProjectFormFeedItem(f.FormName + " was denied by " + UserUtil.GetCoachName(p.CoachId) + " for " + denialReason, client.UserId, p.ProjectId, formId); } } return(f); }