public bool Delete()
{
bool result = false;
UserRegister user = new UserRegister();
result = user.Delete(UserId);
return result;
}
public bool Block(bool block = true)
{
bool result = false;
UserRegister user = new UserRegister();
result = user.BlockUser(UserId, block);
return result;
}
public UserModel(UserRegister user)
{
UserId = user.UserId;
Title = user.Title;
FirstName = user.FirstName;
LastName = user.LastName;
Blocked = user.Blocked;
}
public UserRegister(UserRegister user)
{
if (user != null)
{
UserId = user.UserId;
UserName = user.UserName;
Title = user.Title;
FirstName = user.FirstName;
LastName = user.LastName;
Blocked = user.Blocked;
}
}
public static UserRegister GetById(string userId)
{
UserRegister user = null;
string sql = @"SELECT u.Id as UserId, u.UserName, p.Title, p.FirstName, p.LastName, u.Blocked FROM AspNetUsers u LEFT JOIN UserProfile p ON u.Id=p.UserId WHERE u.ID=@UserId";
try
{
using (SqlConnection conn = new SqlConnection(DataConnection.AppData))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@UserId", userId);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
user = new UserRegister(reader);
}
}
}
}
catch (Exception e)
{
string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
ErrLogger.Log(_className, methodName, e.Message);
user=null;
}
return user;
}
public UserModel(UserRegister user)
: base(user)
{
}
