public UsuarioVM Status(int id, string status)
{
bool result = _repository.Status(id, status);
UsuarioVM view = result ? Find(id) : null;
return(view);
}
public UsuarioVM Reset(int id)
{
bool result = _repository.Reset(id);
UsuarioVM view = result ? Find(id) : null;
return(view);
}
public static UsuarioVM ReaderToView(this MySqlDataReader reader)
{
UsuarioVM view = null;
if (reader == null)
{
return(view);
}
else
{
view = new UsuarioVM
{
Id = reader.GetInt32(0),
Nome = reader.GetString(1),
Fone = reader.GetString(2),
Email = reader.GetString(3),
Login = reader.GetString(4),
Senha = reader.GetString(5),
Ativo = reader.GetString(6),
Id_funcao = reader.GetInt32(7),
Funcao = reader.GetString(8)
};
}
return(view);
}
public UsuarioVM Update(ObjetoVM obj)
{
Usuario model = obj.ObjToModel();
_repository.Update(model);
UsuarioVM view = obj.Id > 0 ? Find(obj.Id) : null;
return(view);
}
public UsuarioVM Insert(ObjetoVM obj)
{
Usuario model = obj.ObjToModel();
_repository.Insert(model);
UsuarioVM view = obj.Login != " " ? FindUser(obj.Login) : null;
return(view);
}
public bool Reset(int id)
{
UsuarioVM view = _context.Usuarios.Where(a => a.Id.Equals(id)).FirstOrDefault();
Usuario model = view.ViewToModel();
model.Senha = "123456";
Db.Entry(model).CurrentValues.SetValues(model);
Db.Entry(model).State = EntityState.Modified;
Save();
return(true);
}
public bool Status(int id, string status)
{
UsuarioVM view = _context.Usuarios.Where(a => a.Id.Equals(id)).FirstOrDefault();
Usuario model = view.ViewToModel();
model.Ativo = status;
Db.Entry(model).CurrentValues.SetValues(model);
Db.Entry(model).State = EntityState.Modified;
Save();
return(true);
}
public static AuthVM TokenToAuth(this UsuarioVM user)
{
if (user == null)
{
return(null);
}
AuthVM auth = new AuthVM()
{
Identity = user.Id.ToString(),
Function = user.Id_funcao.ToString(),
Token = ToToken(user.Id.ToString())
};
return(auth);
}
public static UsuarioVM ModelToView(this Usuario model)
{
if (model == null)
{
return(null);
}
var viewModel = new UsuarioVM()
{
Id = model.Id,
Nome = model.Nome,
Fone = model.Fone,
Email = model.Email,
Login = model.Login,
Senha = model.Senha,
Ativo = model.Ativo,
Id_funcao = model.Id_funcao
};
return(viewModel);
}
public static Usuario ViewToModel(this UsuarioVM view)
{
if (view == null)
{
return(null);
}
var model = new Usuario()
{
Id = view.Id,
Nome = view.Nome,
Fone = view.Fone,
Email = view.Email,
Login = view.Login,
Senha = view.Senha,
Ativo = view.Ativo,
Id_funcao = view.Id_funcao
};
return(model);
}
public AuthVM Auth(LoginVM login)
{
var procedure = "sp_usuario";
var parameters = new List <MySqlParameter>
{
new MySqlParameter {
MySqlDbType = MySqlDbType.VarChar, ParameterName = "@login", Value = login.Login
},
new MySqlParameter {
MySqlDbType = MySqlDbType.VarChar, ParameterName = "@senha", Value = login.Senha
},
new MySqlParameter {
MySqlDbType = MySqlDbType.VarChar, ParameterName = "@auth", Value = "", Direction = ParameterDirection.Output
}
};
MySqlConnection connection = new MySqlConnection(DbConn.ConnectionString);
connection.Open();
MySqlCommand command = new MySqlCommand(procedure, connection);
command.Parameters.AddRange(parameters.ToArray());
command.CommandTimeout = 5;
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
int userId = int.Parse(command.Parameters["@auth"].Value.ToString());
command.Dispose();
//Modelo 1
//UsuarioVM user = userId > 0 ? Find(userId) : null;
//TokenVM token = user != null ? user.ViewToToken() : null;
//Modelo 2
UsuarioVM user = userId > 0 ? Find(userId) : null;
AuthVM auth = user.TokenToAuth();
return(auth);
}
public static TokenVM ViewToToken(this UsuarioVM view)
{
if (view == null)
{
return(null);
}
var token = new TokenVM()
{
Id = view.Id,
Nome = view.Nome,
Fone = view.Fone,
Email = view.Email,
Login = view.Login,
Senha = view.Senha,
Ativo = view.Ativo,
Id_funcao = view.Id_funcao,
Funcao = view.Funcao,
Token = ToToken(view.Id.ToString())
};
return(token);
}
