public async Task <IResponseItem <IUser> > GetAllUsersAsync() { IResponseItem <IUser> response = new ResponseItem <IUser>(); DbConnection connection = null; DbDataReader reader; IUser user; try { string commandText = @"SELECT * FROM USERS"; using var command = this.GetCommand(commandText, CommandType.Text); (connection, reader) = await this.ExecuteReaderAsync(command); while (await reader.ReadAsync()) { user = new User { Id = DBNullExt.ToValue <string>(reader["Id"]), Name = DBNullExt.ToValue <string>(reader["NAME"]), FirstName = DBNullExt.ToValue <string>(reader["FIRSTNAME"]), lastName = DBNullExt.ToValue <string>(reader["LASTNAME"]), Email = DBNullExt.ToValue <string>(reader["EMAIL"]), CreateDate = DBNullExt.ToValue <DateTime>(reader["CREATEDATE"]), ModifyDate = DBNullExt.ToValue <DateTime>(reader["MODIFYDATE"]), LastSignInDate = DBNullExt.ToValue <DateTime>(reader["LASTSIGNINDATE"]), ConnectionId = DBNullExt.ToValue <string>(reader["CONNECTIONID"]), //Token = DBNullExt.ToValue<string>(reader["TOKEN"]), IsLive = DBNullExt.ToValue <int>(reader["ISLIVE"]), IsActive = DBNullExt.ToValue <int>(reader["ISACTIVE"]) }; response.Items.Add(user); } await reader.CloseAsync(); } catch (Exception ex) { throw new DatabaseException(ex.Message, ex); } finally { if (connection?.State == ConnectionState.Open) { await connection.CloseAsync(); } } return(response); }
public async Task <IConnectRootResponse <IUser> > GetUserAsync(string email) { IConnectRootResponse <IUser> response = new ConnectRootResponse <IUser>(); DbConnection connection = null; DbDataReader reader; IUser user = null; try { string commandText = @"SELECT * FROM USERS WHERE EMAIL=@EMAIL"; using var command = this.GetCommand(commandText, CommandType.Text); this.CreateParameter(command, "@EMAIL", email, DbType.String); (connection, reader) = await this.ExecuteReaderAsync(command); if (await reader.ReadAsync()) { user = new User { Id = DBNullExt.ToValue <string>(reader["Id"]), Name = DBNullExt.ToValue <string>(reader["NAME"]), FirstName = DBNullExt.ToValue <string>(reader["FIRSTNAME"]), lastName = DBNullExt.ToValue <string>(reader["LASTNAME"]), Email = DBNullExt.ToValue <string>(reader["EMAIL"]), CreateDate = DBNullExt.ToValue <DateTime>(reader["CREATEDATE"]), ModifyDate = DBNullExt.ToValue <DateTime>(reader["MODIFYDATE"]), LastSignInDate = DBNullExt.ToValue <DateTime>(reader["LASTSIGNINDATE"]), ConnectionId = DBNullExt.ToValue <string>(reader["CONNECTIONID"]), //Token = DBNullExt.ToValue<string>(reader["TOKEN"]), IsLive = DBNullExt.ToValue <int>(reader["ISLIVE"]), IsActive = DBNullExt.ToValue <int>(reader["ISACTIVE"]) }; } await reader.CloseAsync(); if (user != null) { response.Status = ConnectConstants.Success; response.Message = ConnectResponseCodes.CP024_MESSAGE; response.ResponseCode = ConnectResponseCodes.CP024; response.ResponseData = user; } else { response.Status = ConnectConstants.Failed; response.Message = ConnectResponseCodes.CP023_MESSAGE; response.ResponseCode = ConnectResponseCodes.CP023; } } catch (Exception ex) { throw new DatabaseException(ex.Message, ex); } finally { if (connection?.State == ConnectionState.Open) { await connection.CloseAsync(); } } return(response); }