private static void deleteAllRights(int sharedContainerId)
{
using (var cmd = new DBManager.DBAccess().getDBAccess().CreateCommand())
{
cmd.CommandText = "DELETE FROM CLIST WHERE RID=" + sharedContainerId;
cmd.ExecuteNonQuery();
}
}
/* This should be moved into Resource.cs but the file is checked out right now */
private static string makeAbsPath(string username, string path)
{
string[] tokens = path.Split(path_sep);
string containerGivenName = tokens[0];
string relPath = tokens[1];
using (var conn = new DBManager.DBAccess().getDBAccess())
{
using (var stmt = conn.CreateCommand())
{
stmt.CommandText = "SELECT ContainerName FROM containers WHERE OWNER IN (SELECT UID FROM USERS WHERE EMAIL = @USERID) AND GivenName = @SHFNAME UNION SELECT ContainerName From containers WHERE RID IN (SELECT RID FROM CLIST WHERE UID IN (SELECT UID FROM USERS WHERE EMAIL = @USERID)) AND GivenName = @SHFNAME";
stmt.Parameters.AddWithValue("@USERID", username);
stmt.Parameters.AddWithValue("@SHFNAME", containerGivenName);
return((string)stmt.ExecuteScalar() + path_sep + relPath);
}
}
}
private static string makeSharedUsersXML(int containerID)
{
StringBuilder result = new StringBuilder();
using (var cmd = new DBManager.DBAccess().getDBAccess().CreateCommand())
{
cmd.CommandText = "Select U.EMAIL, U.FULLNAME, C.READWRITE from CLIST C, USERS U WHERE C.UID = U.UID AND RID=" + containerID;
var Reader = cmd.ExecuteReader();
using (Reader)
{
while (Reader.Read())
{
result.Append("\t\t<user email='");
result.Append(Reader.GetString(0));
result.Append("' name='");
if (Reader.IsDBNull(1))
{
result.Append(Reader.GetString(0));
}
else
{
result.Append(Reader.GetString(1));
}
result.Append("' access='");
if (Reader.GetInt32(2) == 1)
{
result.Append("readwrite");
}
else
{
result.Append("readonly");
}
result.Append("' />\r\n");
}
}
}
result.Replace('\'', '\"');
return(result.ToString());
}
