private static string ReadUser(XmlNode node)
{
if (node.Name == "User")
{
string username = NodeGetString(node, "username");
string passwd = NodeGetString(node, "password");
// Creamos usuario
User u = new User (username, passwd);
u.Save();
// u.Save no tiene un u valido para hacer un Groups.Add
u = User.Find(u.Id);
u.Groups = NodeGetObjectList(node, "Group", groups);
System.Console.WriteLine ("Usuario: "+username);
u.Save();
users[username] = u;
}
return null;
}
public static ScheduledEvent[] FindByDateAndUser(string datetime, User user)
{
if ((datetime.Length > 0) && (user != null))
{
/* This works on hibernate but not in nhibernate yet:
return (ScheduledEvent[]) ActiveRecordBase.FindOne(typeof(ScheduledEvent),
Expression.geProperty("StartDate", datetime),
Expression.ltProperty("EndDate", datetime),
Expression.eq("Schedule", user.Schedule));
*/
SimpleQuery q = new SimpleQuery(typeof(ScheduledEvent), @"
from ScheduledEvent S
where S.StartDate < ? and
S.EndDate > ? and
S.Schedule.Owner = ?", datetime, datetime, user);
return (ScheduledEvent[]) ExecuteQuery(q);
}
else
return null;
}
public Schedule(User user)
{
_Owner = user;
}
public new static User[] FindByName(string name)
{
if (name.Length > 0)
name = name.ToLower();
name += '%';
User[] ulower = (User[])ActiveRecordBase.FindAll(
typeof(User),
new Order[] { Order.Asc("Name") },
Expression.Like("Name", name));
name = name.ToUpper();
User[] uupper = (User[])ActiveRecordBase.FindAll(
typeof(User),
new Order[] { Order.Asc("Name") },
Expression.Like("Name", name));
User[] r = new User[uupper.Length + ulower.Length];
int i;
for (i = 0; i < uupper.Length; i++)
r[i] = uupper[i];
for (int j = 0; j < ulower.Length; j++)
{
r[i] = ulower[j];
i++;
}
return r;
}
public void UserCreate ([DataBind ("user")] User user)
{
Commons.CheckSuperUser(Session);
try
{
User u = new User(user.Name, user.UserPassword);
u.Save();
Flash["aviso"] = "Creado usuario";
}
catch (Castle.ActiveRecord.Framework.ActiveRecordException e)
{
System.Console.WriteLine (e);
Flash["aviso"] = "Ya existe un usuario con ese nombre!";
}
RedirectToAction ("usersedit");
}
public static Schedule FindByUser(User user)
{
SimpleQuery q = new SimpleQuery(typeof(Schedule), @"
from Schedule S
where S.Owner = ?", user);
Schedule[] schedules = (Schedule[])ExecuteQuery(q);
if (schedules.Length == 0)
return null;
else
return schedules[0];
}
public string Name(User user)
{
return "<input name=\"Form.Name\" type=\"text\" value=\"" + user.Name + "\" />";
}
public TreeLeftWithVinyetas (Menu givenMenu, Category currentCategory, Menu actualMenu, User user) {
_givenMenu = givenMenu;
_currentCategory = currentCategory;
_actualMenu = actualMenu;
_user = user;
}
/*public string Groups(User u)
{
return Groups(u, Group.FindAll());
}*/
public string Groups(User u, Group [] gg)
{
string salida = "";
foreach (Group g in gg)
{
//string selected = u.Groups.Contains(g) ? "checked" : ""; // sería lo optimo pero no funciona :-((( a lo cutre...
string selected = "";
if (u!=null)
foreach (Group gx in u.Groups)
if (gx.Id == g.Id)
{
selected = "checked";
break;
}
//System.Console.WriteLine("mostrando group enabled {0}", g.Name);
salida += System.String.Format("{0}: <input type=\"checkbox\" NAME=\"GroupIds\" VALUE=\"{1}\" {2}/> ", g.Name, g.Id, selected);
}
return salida;
}
/* este select no se puede sustituir por un createoptionswitharray porque
* se usa un arraylist, no un array[] */
public string SessionGroup(User u)
{
string salida = "<select name=\"SessionGroupId\">";
salida += "<option value=\"0\">ningun grupo</option>";
if (u != null && u.Groups != null)
foreach (Group g in u.Groups)
{
string selected = (u.SessionGroup != null && u.SessionGroup.Id == g.Id) ? "selected" : "";
salida += System.String.Format("<option value=\"{0}\" {2}>{1}</option>", g.Id, g.Name, selected);
}
salida += "</select>";
return salida;
}
public string GroupNames(User u)
{
string salida = "<ul>";
foreach (Group g in u.Groups)
salida += "<li>"+g.Name+"</li>";
salida += "</ul>";
foreach (Group g in u.Groups)
salida += " <input type=\"hidden\" name=\"GroupIds\" value=\""+g.Id+"\" />";
return salida;
}
public TreeTable (string menuName, Category currentCategory, Menu actualMenu, User user) {
_givenMenu = Menu.FindByName (menuName);
_currentCategory = currentCategory;
_actualMenu = actualMenu;
_user = user;
}
public TreeTable (Menu givenMenu, Category currentCategory, Menu actualMenu, User user) {
_givenMenu = givenMenu;
_currentCategory = currentCategory;
_actualMenu = actualMenu;
_user = user;
}
public static ArrayList SearchByWordAndUser(string s, User u)
{
Category[] results = SearchByWord2(s);
ArrayList visibleResults = new ArrayList();
foreach (Category category in results)
if (category.CanRead(u))
visibleResults.Add(category);
return visibleResults;
}
public string UserPassword(User user)
{
return "<input name=\"Form.UserPassword\" type=\"text\" value=\"" + user.UserPassword + "\" />";
}
/*public static Category FindWithContentsByLang(int id, string lang)
{
if ((lang == null) || (lang.Length == 0))
return null;
ISessionFactoryHolder sessionHolder = ActiveRecordMediator.GetSessionFactoryHolder();
ISession session = sessionHolder.CreateSession(typeof (Category));
string query = "select category.categoryid from category, content, language, template ";
query += "where category.categoryid = " + id;
query += " and category.template = template.id ";
query += " and content.lang = language.id and language.englishname = '" + lang +"'";
IQuery sqlQuery = session.CreateSQLQuery(query, "category", typeof(Category));
sqlQuery.SetMaxResults(1);
IList results = sqlQuery.List();
if ((results != null) && (results.Count > 0))
return (Category)results[0];
else
return null; // Constants.NO_TRANSLATION_FOUND;
}*/
public new static IList FindWithContentsByLang(int id, string lang, User user)
{
Category category = (Category) ActiveRecordBase.FindByPrimaryKey( typeof(Category), id );
ArrayList contents = new ArrayList();
foreach(Content content in category.ContentList)
{
if (content.Lang.Name == lang)
if (user != null)
contents.Add(content);
else
if (content.Published)
contents.Add(content);
}
return contents;
}
public bool HasUser(User user)
{
foreach (User index in Users)
if (index.Id == user.Id)
return true;
return false;
}
