public static Subheader RemoveProjectUser(ServerUserInformation serverUser, UserInformation userInfo, ProjectInformation projInfo)
{
if (!ProjectAuth(serverUser, projInfo, ProjectRole.Owner))
{
return(Subheader.UNAUTH_ERROR);
}
MySqlCommand cmd;
try
{
cmd = new MySqlCommand("DELETE FROM Project_Users WHERE project_id = '" + projInfo.project_id + "';"
+ "DELETE FROM Projects WHERE project_id = '" + projInfo.project_id + " ';", con);
}
catch (Exception) { return(Subheader.PROJ_ERROR); }
try
{
if (cmd.ExecuteNonQuery() <= 0)
{
return(Subheader.DBQRY_ERROR);
}
return(Subheader.NULL);
}
catch (MySqlException e)
{
if (e.Number == 2627)
{
return(Subheader.DBEXST_ERROR);
}
return(Subheader.DBQRY_ERROR);
}
}
