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); }