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);
}
}
