public async Task <Guild> GetAsync(uint identifier)
{
using (var db = SqlDatabase.SqlInstance)
{
using (var command = new SqlCommand
{
CommandText = "proc_clan_v3_get_by_id",
CommandType = CommandType.StoredProcedure,
CommandTimeout = 10,
Connection = db.GetConnection()
})
{
ClanV3 temporaryClan = null;
try
{
command.Parameters.AddWithValue("@id", int.Parse(identifier.ToString()));
await db.OpenConnectionAsync();
using (var dataReader = await command.ExecuteReaderAsync())
{
if (!dataReader.HasRows)
{
return(temporaryClan);
}
try
{
while (await dataReader.ReadAsync())
{
temporaryClan = new ClanV3(
identifier: dataReader.GetInt32(0),
name: dataReader.GetString(1),
about: dataReader.GetString(2),
clanPlatform: new ClanPlatform(
identifier: dataReader.GetInt32(3),
name: dataReader.GetString(5),
platformImageURL: dataReader.GetString(6)),
founder: new ClanFounder(
identity: dataReader.GetInt32(7),
userName: dataReader.GetString(8),
isFounder: dataReader.GetBoolean(9))
);
}
}
catch (Exception)
{
throw new Exception("Failed to read Clan Data.");
}
}
return(temporaryClan);
}
catch (Exception)
{
throw new Exception("Failed to handle request.");
}
}
}
}
public async Task <IEnumerable <Guild> > GetAllAsync()
{
using var command = new SqlCommand
{
CommandText = "proc_clan_v3_get_all",
CommandType = CommandType.StoredProcedure,
CommandTimeout = 10,
Connection = _databaseInstance.GetConnection()
};
var temporaryClans = new List <ClanV3>();
try
{
await _databaseInstance.OpenConnectionAsync();
using (var dataReader = await command.ExecuteReaderAsync())
{
if (!dataReader.HasRows)
{
return(temporaryClans);
}
try
{
while (await dataReader.ReadAsync())
{
// Check if clan already exists.
if (temporaryClans.Any(clan => clan.Identifier == dataReader.GetInt32(0)) == false)
{
var clanObj = new ClanV3(
identifier: dataReader.GetInt32(0),
name: dataReader.GetString(1),
about: dataReader.GetString(2),
clanPlatform: new ClanPlatform(identifier: dataReader.GetInt32(3), name: dataReader.GetString(5), platformImageURL: dataReader.GetString(6)),
founder: dataReader.GetBoolean(9) == true ? new ClanFounder(identity: dataReader.GetInt32(7), userName: dataReader.GetString(8), isFounder: dataReader.GetBoolean(9)) : null,
admins: new List <Member>()
);
temporaryClans.Add(clanObj);
}
// If member is not founder.
if (dataReader.GetBoolean(9) == false)
{
var memberObj = new ClanAdminV3(
identifier: dataReader.GetInt32(7),
userName: dataReader.GetString(8)
);
if (temporaryClans.Any(clan => clan.Identifier == dataReader.GetInt32(7)))
{
var getClan = temporaryClans.Where(clan => clan.Identifier == dataReader.GetInt32(7)).FirstOrDefault();
getClan.Admins.Add(memberObj);
}
}
//var temporaryClan = new ClanV3(
// identifier: dataReader.GetInt32(0),
// name: dataReader.GetString(1),
// about: dataReader.GetString(2),
// clanPlatform: new ClanPlatform(
// identifier: dataReader.GetInt32(3),
// name: dataReader.GetString(5),
// platformImageURL: dataReader.GetString(6)),
// founder: new ClanFounder(
// identity: dataReader.GetInt32(7),
// userName: dataReader.GetString(8),
// isFounder: dataReader.GetBoolean(9))
// );
}
}
catch (Exception)
{
throw new Exception("Failed to read Clan Data.");
}
}
return(temporaryClans);
}
catch (Exception)
{
throw;
}
}
public async Task <IEnumerable <Guild> > GetAllAsync()
{
using (var db = SqlDatabase.SqlInstance)
{
using (var command = new SqlCommand
{
CommandText = "proc_clan_v3_get_all",
CommandType = CommandType.StoredProcedure,
CommandTimeout = 10,
Connection = db.GetConnection()
})
{
var temporaryClans = new List <ClanV3>();
try
{
await db.OpenConnectionAsync();
using (var dataReader = await command.ExecuteReaderAsync())
{
if (!dataReader.HasRows)
{
return(temporaryClans);
}
try
{
while (await dataReader.ReadAsync())
{
var temporaryClan = new ClanV3(
identifier: dataReader.GetInt32(0),
name: dataReader.GetString(1),
about: dataReader.GetString(2),
clanPlatform: new ClanPlatform(
identifier: dataReader.GetInt32(3),
name: dataReader.GetString(5),
platformImageURL: dataReader.GetString(6)),
founder: new ClanFounder(
identity: dataReader.GetInt32(7),
userName: dataReader.GetString(8),
isFounder: dataReader.GetBoolean(9))
);
temporaryClans.Add(temporaryClan);
}
}
catch (Exception)
{
throw new Exception("Failed to read Clan Data.");
}
}
return(temporaryClans);
}
catch (Exception ex)
{
throw ex;
}
}
}
}
public async Task <Guild> GetAsync(uint identifier)
{
using var command = new SqlCommand
{
CommandText = "proc_clan_v3_get_by_id",
CommandType = CommandType.StoredProcedure,
CommandTimeout = 10,
Connection = _databaseInstance.GetConnection()
};
ClanV3 temporaryClan = null;
try
{
command.Parameters.AddWithValue("@id", int.Parse(identifier.ToString()));
await _databaseInstance.OpenConnectionAsync();
using (var dataReader = await command.ExecuteReaderAsync())
{
if (!dataReader.HasRows)
{
return(temporaryClan);
}
try
{
while (await dataReader.ReadAsync())
{
if (temporaryClan == null)
{
temporaryClan = new ClanV3(
identifier: dataReader.GetInt32(0),
name: dataReader.GetString(1),
about: dataReader.GetString(2),
clanPlatform: new ClanPlatform(identifier: dataReader.GetInt32(3), name: dataReader.GetString(5), platformImageURL: dataReader.GetString(6)),
founder: dataReader.GetBoolean(9) == true ? new ClanFounder(identity: dataReader.GetInt32(7), userName: dataReader.GetString(8), isFounder: dataReader.GetBoolean(9)) : null,
admins: new List <Member>()
);
}
// If member is not founder.
if (dataReader.GetBoolean(9) == false)
{
var memberObj = new ClanAdminV3(
identifier: dataReader.GetInt32(7),
userName: dataReader.GetString(8)
);
temporaryClan.Admins.Add(memberObj);
}
//temporaryClan = new ClanV3(
// identifier: dataReader.GetInt32(0),
// name: dataReader.GetString(1),
// about: dataReader.GetString(2),
// clanPlatform: new ClanPlatform(
// identifier: dataReader.GetInt32(3),
// name: dataReader.GetString(5),
// platformImageURL: dataReader.GetString(6)),
// founder: new ClanFounder(
// identity: dataReader.GetInt32(7),
// userName: dataReader.GetString(8),
// isFounder: dataReader.GetBoolean(9))
// );
}
}
catch (Exception)
{
throw new Exception("Failed to read Clan Data.");
}
}
return(temporaryClan);
}
catch (Exception)
{
throw new Exception("Failed to handle request.");
}
}
