/// <summary>
/// Saves the specified identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="name">The name.</param>
/// <param name="groupId">The group identifier.</param>
/// <returns></returns>
public bool Save(int id, string name)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
bool retVal = false;
if (id > 0)
{
var item = model.Profiles.FirstOrDefault(p => p.Id.Equals(id));
if (item != null)
{
item.Name = name;
}
model.SaveChanges();
retVal = true;
}
else
{
var item = new Profile
{
Name = name
};
model.Profiles.AddObject(item);
model.SaveChanges();
retVal = true;
}
return(retVal);
}
#endregion
}
/// <summary>
/// Saves the specified identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="name">The name.</param>
/// <returns></returns>
public bool Save(int id, string name)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
bool retVal = false;
if (id > 0)
{
Group item = model.Groups.FirstOrDefault(g => g.Id.Equals(id));
if (item != null)
{
item.Name = name;
model.SaveChanges();
retVal = true;
}
}
else
{
Group item = new Group()
{
Name = name
};
model.Groups.AddObject(item);
retVal = true;
}
return(retVal);
}
}
/// <summary>
/// Creates the specified user name.
/// </summary>
/// <param name="userName">Name of the user.</param>
/// <param name="firstName">The first name.</param>
/// <param name="lastName">The last name.</param>
/// <param name="email">The email.</param>
/// <param name="mobile">The mobile.</param>
/// <param name="password">The password.</param>
/// <param name="profileId">The profile identifier.</param>
/// <returns></returns>
public User Create(string userName, string firstName, string lastName, string email, string mobile, string password, int profileId)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
User retVal = null;
if (!model.Users.Any(u => u.UserName.Equals(userName)))
{
var user = new User
{
UserName = userName,
FirstName = firstName,
LastName = lastName,
Email = email,
Mobile = mobile,
Password = password,
ProfilesId = profileId
};
model.Users.AddObject(user);
model.SaveChanges();
retVal = this.GetById(user.Id);
}
return(model.Users.Include(u => u.Profile).FirstOrDefault(u => u.Id.Equals(retVal.Id)));
}
}
/// <summary>
/// Gets all.
/// </summary>
/// <returns></returns>
public List <Group> GetAll()
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
List <Group> retVal = model.Groups.ToList();
return(retVal);
}
}
/// <summary>
/// Gets the name of the by.
/// </summary>
/// <param name="name">The name.</param>
/// <returns></returns>
public Group GetByName(string name)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
Group retVal = model.Groups.FirstOrDefault(g => g.Name.Equals(name));
return(retVal);
}
}
/// <summary>
/// Gets the by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
public Group GetById(int id)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
Group retVal = model.Groups.FirstOrDefault(g => g.Equals(id));
return(retVal);
}
}
/// <summary>
/// Gets all.
/// </summary>
/// <returns></returns>
public List <User> GetAll()
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
var retVal = model.Users.Include(u => u.Profile).ToList();
return(retVal);
}
}
/// <summary>
/// Authenticates the specified user name.
/// </summary>
/// <param name="userName">Name of the user.</param>
/// <param name="password">The password.</param>
/// <returns></returns>
public bool Authenticate(string userName, string password)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
var retVal = model.Users.Any(u => u.UserName.Equals(userName) && u.Password.Equals(password));
return(retVal);
}
}
/// <summary>
/// Gets all.
/// </summary>
/// <returns></returns>
public List <Profile> GetAll()
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
var retVal = model.Profiles.ToList();
return(retVal);
}
}
/// <summary>
/// Gets the name of the profile by.
/// </summary>
/// <param name="name">The name.</param>
/// <returns></returns>
public Profile GetProfileByName(string name)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
var retVal = model.Profiles.FirstOrDefault(p => p.Name.Equals(name));
return(retVal);
}
}
/// <summary>
/// Gets the profil by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
public Profile GetProfileById(int id)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
var retVal = model.Profiles.FirstOrDefault(p => p.Id.Equals(id));
return(retVal);
}
}
/// <summary>
/// Gets the by identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns></returns>
public User GetById(int id)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
var retVal = model.Users
.Include(u => u.Profile)
.FirstOrDefault(u => u.Id.Equals(id));
return(retVal);
}
}
/// <summary>
/// Gets the name of the by user.
/// </summary>
/// <param name="userName">Name of the user.</param>
/// <returns></returns>
public User GetByUserName(string userName)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
var retVal = model.Users
.Include(u => u.Profile)
.FirstOrDefault(u => u.UserName.Equals(userName));
return(model.Users.Include(u => u.Profile).FirstOrDefault(u => u.Id.Equals(retVal.Id)));
}
}
/// <summary>
/// Disables the specified user name.
/// </summary>
/// <param name="userName">Name of the user.</param>
/// <returns>True if operation is successfull</returns>
public bool Disable(string userName)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
bool retVal = false;
var user = model.Users.FirstOrDefault(u => u.UserName.Equals(userName));
user.Enabled = false;
model.SaveChanges();
retVal = true;
return(retVal);
}
}
/// <summary>
/// Saves the specified identifier.
/// </summary>
/// <param name="id">The identifier.</param>
/// <param name="userName">Name of the user.</param>
/// <param name="firstName">The first name.</param>
/// <param name="lastName">The last name.</param>
/// <param name="email">The email.</param>
/// <param name="mobile">The mobile.</param>
/// <param name="password">The password.</param>
/// <param name="profileId">The profile identifier.</param>
/// <returns></returns>
public User Save(int id, string userName, string firstName, string lastName, string email, string mobile, string password, int profileId, bool enabled)
{
using (SecurityModelEntities model = new SecurityModelEntities())
{
var user = model.Users.FirstOrDefault(u => u.UserName.Equals(userName));
if (user != null)
{
user.UserName = userName;
user.FirstName = firstName;
user.LastName = lastName;
user.Email = email;
user.Mobile = mobile;
user.Password = !string.IsNullOrEmpty(password) ? password : user.Password;
user.ProfilesId = profileId;
user.Enabled = enabled;
}
else
{
user = new User
{
UserName = userName,
FirstName = firstName,
LastName = lastName,
Email = email,
Mobile = mobile,
Password = password,
ProfilesId = profileId,
Enabled = true
};
model.Users.AddObject(user);
}
model.SaveChanges();
return(model.Users.Include(u => u.Profile).FirstOrDefault(u => u.Id.Equals(user.Id)));
}
}
