public UserInfo GetUserInfoForUser(User usr)
{
if (IsItMe(usr.username))
{
dbb8e2ff3f72c74b72880ca18a014fe9baEntities3 dataContext = new dbb8e2ff3f72c74b72880ca18a014fe9baEntities3();
return dataContext.UserInfoes.First(c => c.user_id == usr.id);
}
else
{
return null;
}
}
public int AddUserInfoToUser(UserInfo usr_info)
{
User usr = GetUserWithID(usr_info.user_id);
if (usr != null)
{
if (IsItMe(usr.username))
{
dbb8e2ff3f72c74b72880ca18a014fe9baEntities3 dataContext = new dbb8e2ff3f72c74b72880ca18a014fe9baEntities3();
dataContext.UserInfoes.Add(usr_info);
return dataContext.SaveChanges();
}
else
{
return -1;
}
}
else
{
return -1;
}
}
public bool IsUserValid(string userName, string password, out string commaSeparatedRoles)
{
commaSeparatedRoles = string.Empty;
bool result = false;
dbb8e2ff3f72c74b72880ca18a014fe9baEntities3 datacontext = new dbb8e2ff3f72c74b72880ca18a014fe9baEntities3();
User usr = datacontext.Users.First(c => c.username == userName);
if (usr != null)
{
if (usr.password.Trim()==password.Trim())
{
switch (usr.type)
{
case 0:
commaSeparatedRoles = @"User";
break;
case 1:
commaSeparatedRoles = @"User,Editor";
break;
case 999:
commaSeparatedRoles = @"User,Admin,Editor";
break;
}
result = true;
}
else
{
new LogEvent("Wrong pass="******"..."+usr.password).Raise();
}
}
else
{
new LogEvent("Usr=NULL Username="+userName).Raise();
}
return result;
}
public User GetUserWithID(int id)
{
dbb8e2ff3f72c74b72880ca18a014fe9baEntities3 dataContext = new dbb8e2ff3f72c74b72880ca18a014fe9baEntities3();
return dataContext.Users.Where(c => c.id == id).First();
}
public List<User> GetAllUsers()
{
dbb8e2ff3f72c74b72880ca18a014fe9baEntities3 dataContext = new dbb8e2ff3f72c74b72880ca18a014fe9baEntities3();
return dataContext.Users.ToList();
}
public int UpdateUserInfoForUser(UserInfo usr_info)
{
User usr = GetUserWithID(usr_info.user_id);
if (usr != null)
{
if (IsItMe(usr.username))
{
dbb8e2ff3f72c74b72880ca18a014fe9baEntities3 dataContext = new dbb8e2ff3f72c74b72880ca18a014fe9baEntities3();
UserInfo info= dataContext.UserInfoes.First(c => c.user_id == usr.id);
info.meno = usr_info.meno;
info.p_meno = usr_info.p_meno;
info.priezvisko = usr_info.priezvisko;
info.p_priezvisko = usr_info.p_priezvisko;
info.email = usr_info.email;
info.p_email = usr_info.p_email;
return dataContext.SaveChanges();
}
else
{
return -1;
}
}
else
{
return -1;
}
}
/// <summary>
/// Users Managment
/// </summary>
/// <param name="Type"></param>
/// <param name="UserName"></param>
/// <returns></returns>
//User
public int RegisterNewUser(User usr)
{
dbb8e2ff3f72c74b72880ca18a014fe9baEntities3 dataContext = new dbb8e2ff3f72c74b72880ca18a014fe9baEntities3();
if (usr.type == 0)
{
if (dataContext.Users.Count(c => c.username == usr.username) ==0)
{
dataContext.Users.Add(usr);
return dataContext.SaveChanges();
}
else
{
return -100;
}
}
else
{
//User cannot create different roles then users!
return -999;
}
}
