public (CharacterAbilityListWithFilterCount, Character, RuleSet) SP_CharacterAbility_GetByCharacterId(int characterId, int rulesetId, int page, int pageSize, int sortType = 1)
{
CharacterAbilityListWithFilterCount result = new CharacterAbilityListWithFilterCount();
CharacterAbility _characterAbility = new CharacterAbility();
RuleSet ruleset = new RuleSet();
Character character = new Character();
string connectionString = _configuration.GetSection("ConnectionStrings").GetSection("DefaultConnection").Value;
using (SqlConnection connection = new SqlConnection(connectionString))
{
List <CharacterAbility> _CharacterAbilityList = new List <CharacterAbility>();
string qry = "EXEC CharacterAbility_GetByCharacterId @CharacterId='" + characterId + "',@RulesetID='" + rulesetId + "',@page='" + page + "',@size='" + pageSize + "',@SortType='" + sortType + "'";
try
{
var characterability_record = connection.QueryMultiple(qry);
var _characterAbilitySPList = characterability_record.Read <CharacterAbilitySP>().ToList();
ruleset = characterability_record.Read <RuleSet>().FirstOrDefault();
character = characterability_record.Read <Character>().FirstOrDefault();
_characterAbilitySPList.ForEach(obj =>
{
_characterAbility = new CharacterAbility()
{
CharacterAbilityId = obj.CharacterAbilityId,
CharacterId = obj.CharacterId,
AbilityId = obj.AbilityId,
CurrentNumberOfUses = obj.CurrentNumberOfUses,
MaxNumberOfUses = obj.MaxNumberOfUses,
IsEnabled = obj.IsEnabled,
Ability = new Ability()
{
Name = obj.Name,
Stats = obj.Stats,
Metatags = obj.Metatags,
Command = obj.Command,
CommandName = obj.CommandName,
Description = obj.Description,
gmOnly = obj.gmOnly,
ImageUrl = obj.ImageUrl,
Level = obj.Level,
IsDeleted = obj.IsDeleted,
IsEnabled = obj.IsEnabled ?? false,
AbilityId = obj.AbilityId ?? 0,
ParentAbilityId = obj.ParentAbilityId ?? 0,
RuleSetId = obj.RuleSetId,
CurrentNumberOfUses = obj.CurrentNumberOfUses ?? 0,
MaxNumberOfUses = obj.MaxNumberOfUses ?? 0,
RuleSet = ruleset,
},
// Character = character
};
_CharacterAbilityList.Add(_characterAbility);
});
result = new CharacterAbilityListWithFilterCount()
{
FilterAplhabetCount = characterability_record.Read <AlphabetCountSP>().FirstOrDefault().AplhabetCount,
FilterEnabledCount = characterability_record.Read <EnabledCountSP>().FirstOrDefault().EnabledCount,
FilterLevelCount = characterability_record.Read <LevelCountSP>().FirstOrDefault().LevelCount,
AbilityList = _CharacterAbilityList
};
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
//(CharacterAbilityListWithFilterCount characterAbilityresult, Character _character, RuleSet _ruleSet) = SP_CharacterAbility_GetByCharacterId_Old(characterId, rulesetId, page, pageSize, sortType);
return(result, character, ruleset);
}
public (CharacterAbilityListWithFilterCount, Character, RuleSet) SP_CharacterAbility_GetByCharacterId_Old(int characterId, int rulesetId, int page, int pageSize, int sortType = 1)
{
CharacterAbilityListWithFilterCount result = new CharacterAbilityListWithFilterCount();
List <CharacterAbility> _CharacterAbilityList = new List <CharacterAbility>();
RuleSet ruleset = new RuleSet();
Character character = new Character();
int FilterAplhabetCount = 0;
int FilterEnabledCount = 0;
int FilterLevelCount = 0;
result.AbilityList = _CharacterAbilityList;
result.FilterAplhabetCount = FilterAplhabetCount;
result.FilterEnabledCount = FilterEnabledCount;
result.FilterLevelCount = FilterLevelCount;
short num = 0;
string connectionString = _configuration.GetSection("ConnectionStrings").GetSection("DefaultConnection").Value;
//string qry = "EXEC CharacterAbility_GetByCharacterId @CharacterId='" + characterId + "',@RulesetID='" + rulesetId + "',@page='" + page + "',@size='" + pageSize + "'";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
try
{
connection.Open();
command = new SqlCommand("CharacterAbility_GetByCharacterId", connection);
// Add the parameters for the SelectCommand.
command.Parameters.AddWithValue("@CharacterId", characterId);
command.Parameters.AddWithValue("@RulesetID", rulesetId);
command.Parameters.AddWithValue("@page", page);
command.Parameters.AddWithValue("@size", pageSize);
command.Parameters.AddWithValue("@SortType", sortType);
command.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand = command;
adapter.Fill(ds);
command.Dispose();
connection.Close();
}
catch (Exception ex)
{
command.Dispose();
connection.Close();
}
if (ds.Tables[1].Rows.Count > 0)
{
ruleset = _repo.GetRuleset(ds.Tables[1], num);
}
if (ds.Tables[2].Rows.Count > 0)
{
character = _repo.GetCharacter(ds.Tables[2]);
}
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
CharacterAbility _characterAbility = new CharacterAbility();
_characterAbility.CharacterAbilityId = row["CharacterAbilityId"] == DBNull.Value ? 0 : Convert.ToInt32(row["CharacterAbilityId"].ToString());
_characterAbility.CharacterId = characterId;
_characterAbility.AbilityId = row["AbilityId"] == DBNull.Value ? 0 : Convert.ToInt32(row["AbilityId"].ToString());
_characterAbility.CurrentNumberOfUses = row["CharacterCurrentNumberOfUses"] == DBNull.Value ? 0 : Convert.ToInt32(row["CharacterCurrentNumberOfUses"].ToString());
_characterAbility.MaxNumberOfUses = row["CharacterMaxNumberOfUses"] == DBNull.Value ? 0 : Convert.ToInt32(row["CharacterMaxNumberOfUses"].ToString());
_characterAbility.IsEnabled = row["CharacterIsEnabled"] == DBNull.Value ? false : Convert.ToBoolean(row["CharacterIsEnabled"]);
Ability _ability = new Ability();
_ability.Name = row["Name"] == DBNull.Value ? null : row["Name"].ToString();
_ability.Stats = row["Stats"] == DBNull.Value ? null : row["Stats"].ToString();
_ability.Metatags = row["Metatags"] == DBNull.Value ? null : row["Metatags"].ToString();
_ability.Command = row["Command"] == DBNull.Value ? null : row["Command"].ToString();
_ability.CommandName = row["CommandName"] == DBNull.Value ? null : row["CommandName"].ToString();
_ability.Description = row["Description"] == DBNull.Value ? null : row["Description"].ToString();
_ability.gmOnly = row["gmOnly"] == DBNull.Value ? null : row["gmOnly"].ToString();
_ability.ImageUrl = row["ImageUrl"] == DBNull.Value ? null : row["ImageUrl"].ToString();
_ability.Level = row["Level"] == DBNull.Value ? null : row["Level"].ToString();
_ability.IsDeleted = row["IsDeleted"] == DBNull.Value ? false : Convert.ToBoolean(row["IsDeleted"]);
_ability.IsEnabled = row["IsEnabled"] == DBNull.Value ? false : Convert.ToBoolean(row["IsEnabled"]);
_ability.AbilityId = row["AbilityId"] == DBNull.Value ? 0 : Convert.ToInt32(row["AbilityId"].ToString());
_ability.ParentAbilityId = row["ParentAbilityId"] == DBNull.Value ? 0 : Convert.ToInt32(row["ParentAbilityId"].ToString());
_ability.RuleSetId = row["RuleSetId"] == DBNull.Value ? 0 : Convert.ToInt32(row["RuleSetId"].ToString());
_ability.CurrentNumberOfUses = row["CurrentNumberOfUses"] == DBNull.Value ? 0 : Convert.ToInt32(row["CurrentNumberOfUses"].ToString());
_ability.MaxNumberOfUses = row["MaxNumberOfUses"] == DBNull.Value ? 0 : Convert.ToInt32(row["MaxNumberOfUses"].ToString());
_ability.RuleSet = ruleset;
_characterAbility.Ability = _ability;
//_characterAbility.Character = character;
_CharacterAbilityList.Add(_characterAbility);
}
}
if (ds.Tables[3].Rows.Count > 0)
{
FilterAplhabetCount = ds.Tables[3].Rows[0][0] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[3].Rows[0][0]);
FilterLevelCount = ds.Tables[3].Rows[0][1] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[3].Rows[0][1]);
}
if (ds.Tables[4].Rows.Count > 0)
{
FilterEnabledCount = ds.Tables[4].Rows[0][0] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[4].Rows[0][0]);
}
if (ds.Tables[5].Rows.Count > 0)
{
FilterLevelCount = ds.Tables[5].Rows[0][0] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[5].Rows[0][0]);
}
result.AbilityList = _CharacterAbilityList;
result.FilterAplhabetCount = FilterAplhabetCount;
result.FilterEnabledCount = FilterEnabledCount;
result.FilterLevelCount = FilterLevelCount;
//return result;
return(result, character, ruleset);
}