public int Core_GetCountByRuleSetId(int ruleSetId, int parentID)
{
string connectionString = _configuration.GetSection("ConnectionStrings").GetSection("DefaultConnection").Value;
string qry = "EXEC Ruleset_GetRecordCounts @RulesetID = '" + ruleSetId + "'";
SP_RulesetRecordCount res = new SP_RulesetRecordCount();
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
connection.Open();
var rulesetrecord = connection.Query <SP_RulesetRecordCount>(qry).FirstOrDefault();
if (rulesetrecord != null)
{
res.BuffAndEffectCount = rulesetrecord.BuffAndEffectCount;
}
}
catch (Exception ex1)
{
throw ex1;
}
finally
{
connection.Close();
}
return(res.BuffAndEffectCount);
}
}
public int Core_GetCountByRuleSetId(int ruleSetId, int parentID)
{
//var idsToRemove = _context.Spells.Where(p => (p.RuleSetId == ruleSetId) && p.ParentSpellId != null).Select(p => p.ParentSpellId).ToArray();
//var recsToRemove = _context.Spells.Where(p => idsToRemove.Contains(p.SpellId)).ToList();
//var res = _context.Spells.Where(x => (x.RuleSetId == ruleSetId || x.RuleSetId == ) && x.IsDeleted != true)
// .Except(recsToRemove);
//return res.Count();
SP_RulesetRecordCount res = new SP_RulesetRecordCount();
string connectionString = _configuration.GetSection("ConnectionStrings").GetSection("DefaultConnection").Value;
string qry = "EXEC Ruleset_GetRecordCounts @RulesetID = '" + ruleSetId + "'";
using (SqlConnection connection = new SqlConnection(connectionString))
{
try
{
connection.Open();
var data = connection.QueryMultiple(qry);
res = data.Read <SP_RulesetRecordCount>().FirstOrDefault();
}
catch (Exception ex1)
{
throw ex1;
}
finally
{
connection.Close();
}
}
return(res == null ? 0 : res.SpellCount);
}
public int Core_GetCountByRuleSetId_Old(int ruleSetId, int parentID)
{
//var idsToRemove = _context.Abilities.Where(p => (p.RuleSetId == ruleSetId) && p.ParentAbilityId != null).Select(p => p.ParentAbilityId).ToArray();
//var recsToRemove = _context.Abilities.Where(p => idsToRemove.Contains(p.AbilityId)).ToList();
//var res = _context.Abilities.Where(x => (x.RuleSetId == ruleSetId || x.RuleSetId == parentID) && x.IsDeleted != true)
// .Except(recsToRemove);
//return res.Count();
string connectionString = _configuration.GetSection("ConnectionStrings").GetSection("DefaultConnection").Value;
//string qry = "EXEC Ruleset_GetRecordCounts @RulesetID = '" + ruleSetId + "'";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand();
SqlDataAdapter adapter = new SqlDataAdapter();
DataTable dt = new DataTable();
try
{
connection.Open();
command = new SqlCommand("Ruleset_GetRecordCounts", connection);
// Add the parameters for the SelectCommand.
command.Parameters.AddWithValue("@RulesetID", ruleSetId);
command.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand = command;
adapter.Fill(dt);
command.Dispose();
connection.Close();
}
catch (Exception ex)
{
command.Dispose();
connection.Close();
}
SP_RulesetRecordCount res = new SP_RulesetRecordCount();
if (dt.Rows.Count > 0)
{
res.BuffAndEffectCount = Convert.ToInt32(dt.Rows[0]["BuffAndEffectCount"]);
}
return(res.BuffAndEffectCount);
}
