public T Get(int id) { ModelOfUser User = new ModelOfUser(); string sqlRequest = string.Format("SELECT * FROM {0} WHERE Id=@IdParam", name); using (var connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(); connection.Open(); command.Connection = connection; command.CommandText = sqlRequest; SqlParameter IdParam = new SqlParameter("@IdParam", id); command.Parameters.Add(IdParam); SqlDataReader dr = command.ExecuteReader(); if (dr.HasRows) { User.UserId = (int)dr["ID"]; User.UserRole = (UserRole)dr["UserRole"]; User.UserName = dr["UserName"].ToString(); User.UserEmail = dr["UserEmail"].ToString(); User.UserPassword = dr["UserPassword"].ToString(); } } return(User as T); }
public void DeleteExistingId() { IUserRepository <ModelOfUser> userRepository = new UserRepository <ModelOfUser>(); int ExistingId = 1; ModelOfUser user = new ModelOfUser(); user.UserId = 1; user.UserName = "******"; user.UserPassword = "******"; user.UserRole = UserRole.Manager; user.UserEmail = "afffff"; userRepository.Save(user); Assert.IsTrue(userRepository.Delete(ExistingId)); }
public List <T> GetAll() { List <ModelOfUser> AllUsers = new List <ModelOfUser>(); string sql = string.Format("SELECT * FROM {0}s", name); using (SqlCommand cmd = new SqlCommand(sql, connection)) { SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { ModelOfUser User = new ModelOfUser(); User.UserId = (int)reader["ID"]; User.UserRole = (UserRole)reader["UserRole"]; User.UserName = reader["UserName"].ToString(); User.UserEmail = reader["UserEmail"].ToString(); User.UserPassword = reader["UserPassword"].ToString(); AllUsers.Add(User); } } return(AllUsers as List <T>);; } }