public bool updateProject(Project project) { try { using (var context = new ProjectManagementSystemEntities()) { context.Database.ExecuteSqlCommand($"UPDATE Project SET Name = '{project.Name}', ProjectManager = '{project.ProjectManager}' WHERE ProjectCode='{project.ProjectCode}'; "); context.SaveChanges(); } return(true); } catch (Exception) { throw; return(false); } }
public bool createTask(Task task) { try { using (var context = new ProjectManagementSystemEntities()) { context.Database.ExecuteSqlCommand($"insert into Tasks values({task.TaskID},'{task.ProjectCode}','{task.Assignee}',{task.Status},{task.Progress},'{task.Deadline}','{task.Description}')"); context.SaveChanges(); } return(true); } catch (Exception) { throw; return(false); } }
public bool createUser(User user) { try { using (var context = new ProjectManagementSystemEntities()) { context.Database.ExecuteSqlCommand($"insert into Users values('{user.Username}','{user.Password}','{user.Email}','{user.Name}','{user.Surname}',{user.Role})"); context.SaveChanges(); } return(true); } catch (Exception) { throw; return(false); } }
public bool updateTask(Task task) { try { using (var context = new ProjectManagementSystemEntities()) { context.Database.ExecuteSqlCommand($"UPDATE Tasks " + $"SET Assignee='{task.Assignee}',Status={task.Status},Progress={task.Progress}, Deadline='{task.Deadline}',Description='{task.Description}'" + $" WHERE ProjectCode='{task.ProjectCode}' and TaskID={task.TaskID}; "); context.SaveChanges(); } return(true); } catch (Exception) { throw; return(false); } }
public bool removeProject(Project project) { using (var context = new ProjectManagementSystemEntities()) { try { using (var dbContextTransaction = context.Database.BeginTransaction()) { context.Database.ExecuteSqlCommand($"DELETE FROM Tasks WHERE ProjectCode='{project.ProjectCode}'"); context.Database.ExecuteSqlCommand($"DELETE FROM Project WHERE ProjectCode='{project.ProjectCode}'"); context.SaveChanges(); dbContextTransaction.Commit(); } return(true); } catch (Exception) { throw; return(false); } } }
public bool createProject(Project project) { try { using (var context = new ProjectManagementSystemEntities()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { context.Database.ExecuteSqlCommand($"insert into Project values('{project.ProjectCode}','{project.Name}','{project.User.Username}')"); context.SaveChanges(); dbContextTransaction.Commit(); } } return(true); } catch (Exception) { throw; return(false); } }
public bool removeUser(User user) { using (var context = new ProjectManagementSystemEntities()) { try { using (var dbContextTransaction = context.Database.BeginTransaction()) { context.Database.ExecuteSqlCommand($"DELETE FROM Project WHERE ProjectManager='{user.Username}'"); context.Database.ExecuteSqlCommand($"DELETE FROM Users WHERE Username='******'"); context.SaveChanges(); dbContextTransaction.Commit(); } return(true); } catch (Exception) { throw; return(false); } } }
public bool updateUser(User user, string oldUsername) { try { using (var context = new ProjectManagementSystemEntities()) { context.Database.ExecuteSqlCommand($"UPDATE Users " + $"SET Username ='******', Password = '******',Email='{user.Email}',Name='{user.Name}', Surname='{user.Surname}',Role='{user.Role}'" + $" WHERE Username='******' "); context.Database.ExecuteSqlCommand($"UPDATE Tasks " + $"SET Assignee='{user.Username}'" + $" WHERE Assignee='{oldUsername}' "); context.SaveChanges(); } return(true); } catch (Exception) { throw; return(false); } }