internal static void AddUserToGroup(string username, string group)
{
using (var dbCon = new MySQLDatabaseConnection(System.Net.IPAddress.Parse("127.0.0.1"), "exceeddb"))
{
dbCon.Username = "******";
dbCon.Password = "******";
dbCon.Connect();
string command = string.Format("SELECT `member` FROM `groupDB` WHERE `groupname`='{0}'", group);
string grpMember = dbCon.SearchForString(command, "member");
if (string.IsNullOrEmpty(grpMember))
{
grpMember += username;
}
else
{
grpMember += string.Format(", {0}", username);
}
command = string.Format("UPDATE `groupDB` SET `member`='{0}' WHERE `groupname`='{1}'", grpMember, group);
dbCon.ExecuteCommand(command);
command = string.Empty;
dbCon.Close();
}
}
internal static void AddMemberToProject(string member, Project project)
{
using (var dbCon = new MySQLDatabaseConnection(System.Net.IPAddress.Parse("127.0.0.1"), "exceeddb"))
{
dbCon.Username = "******";
dbCon.Password = "******";
dbCon.Connect();
string mode = member.Contains("[U]") ? "user" : "group";
string command = string.Format("SELECT `{0}` FROM `projectDB` WHERE `projectname`='{1}'", mode, project.ProjectName);
string projMember = dbCon.SearchForString(command, mode);
string memberAcc = member.Substring(4);
if (string.IsNullOrEmpty(projMember))
{
projMember = memberAcc;
}
else
{
projMember += string.Format(", {0}", memberAcc);
}
command = string.Format("UPDATE `projectDB` SET `{0}`='{1}' WHERE `projectname`='{2}'", mode, projMember, project.ProjectName);
dbCon.ExecuteCommand(command);
command = string.Empty;
dbCon.Close();
}
}
internal static void RemoveMemberFromProject(string member, Project project)
{
using (var dbCon = new MySQLDatabaseConnection(System.Net.IPAddress.Parse("127.0.0.1"), "exceeddb"))
{
dbCon.Username = "******";
dbCon.Password = "******";
dbCon.Connect();
string mode = member.Contains("[U]") ? "user" : "group";
string command = string.Format("SELECT `{0}` FROM `projectDB` WHERE `projectname`='{1}'", mode, project.ProjectName);
string projMember = dbCon.SearchForString(command, mode);
string memberAcc = member.Substring(4);
if (string.IsNullOrEmpty(projMember))
{
throw new MissingMemberException(string.Format("Member [{0}] not found in project {1}.", member, project.ProjectName));
}
int index = projMember.IndexOf(memberAcc);
if (index == -1)
{
throw new MissingMemberException(string.Format("Member [{0}] not found in project {1}.", member, project.ProjectName));
}
int count = memberAcc.Length + 2;
if ((index + count) > (projMember.Length - 1) && index != 0)
{
projMember = projMember.Remove((index - 2), count);
}
else
{
try { projMember = projMember.Remove(index, count); }
catch { projMember = projMember.Remove(index, (count - 2)); }
}
command = string.Format("UPDATE `projectDB` SET `{0}`='{1}' WHERE `projectname`='{2}'", mode, projMember, project.ProjectName);
dbCon.ExecuteCommand(command);
command = string.Empty;
dbCon.Close();
}
}
internal static void RemoveUserFromGroup(string username, string group)
{
using (var dbCon = new MySQLDatabaseConnection(System.Net.IPAddress.Parse("127.0.0.1"), "exceeddb"))
{
dbCon.Username = "******";
dbCon.Password = "******";
dbCon.Connect();
string command = string.Format("SELECT `member` FROM `groupDB` WHERE `groupname`='{0}'", group);
string grpMember = dbCon.SearchForString(command, "member");
if (string.IsNullOrEmpty(grpMember))
{
throw new MissingMemberException(string.Format("Username {0} not found in group {1}.", username, group));
}
int index = grpMember.IndexOf(username);
if (index == -1)
{
throw new MissingMemberException(string.Format("Username {0} not found in group {1}.", username, group));
}
int count = username.Length + 2;
if ((index + count) > (grpMember.Length - 1) && index != 0)
{
grpMember = grpMember.Remove((index - 2), count);
}
else
{
try { grpMember = grpMember.Remove(index, count); } //To make sure the user name is in the first index or not
catch { grpMember = grpMember.Remove(index, (count - 2)); }
}
command = string.Format("UPDATE `groupDB` SET `member`='{0}' WHERE `groupname`='{1}'", grpMember, group);
dbCon.ExecuteCommand(command);
command = string.Empty;
dbCon.Close();
}
}