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