public void Save()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
query = QueryInformation.Create(ClassLevelDetailModel.InsertQuery);
this.Id = Guid.NewGuid();
}
else
{
query = QueryInformation.Create(ClassLevelDetailModel.UpdateQuery);
}
//update the last modified fields
LastUpdatedDate = DateTime.Now;
LastUpdatedVersion = Constant.PlannerVersion;
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + ClassLevelDetailModel.IdField, DbType.Guid, this.Id));
query.Parameters.Add(new QueryParameter("@" + ClassLevelDetailModel.ClassIdField, DbType.Guid, this.ClassId));
query.Parameters.Add(new QueryParameter("@" + ClassLevelDetailModel.LevelField, DbType.Byte, this.Level));
query.Parameters.Add(new QueryParameter("@" + ClassLevelDetailModel.FortitudeSaveField, DbType.Int32, this.FortitudeSave));
query.Parameters.Add(new QueryParameter("@" + ClassLevelDetailModel.ReflexSaveField, DbType.Int32, this.ReflexSave));
query.Parameters.Add(new QueryParameter("@" + ClassLevelDetailModel.WillSaveField, DbType.Int32, this.WillSave));
query.Parameters.Add(new QueryParameter("@" + ClassLevelDetailModel.BaseAttackBonusField, DbType.Int32, this.BaseAttackBonus));
query.Parameters.Add(new QueryParameter("@" + ClassLevelDetailModel.FeatTypeIdField, DbType.Guid, this.FeatTypeId));
query.Parameters.Add(new QueryParameter("@" + LastUpdatedDateField, DbType.DateTime, LastUpdatedDate));
query.Parameters.Add(new QueryParameter("@" + LastUpdatedVersionField, DbType.String, LastUpdatedVersion));
BaseModel.RunCommand(query);
}
public void Delete()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
Debug.WriteLine("Error: You can't delete this record as one doesn't exist for it. StanceModel:Delete()");
return;
}
//We need to delete any associated records first before deleteing this Stance record
//TODO: FeatModifierModel.DeleteAllByStanceId(this.id);
//TODO: EnhancementRankModel.DeleteAllByStanceId(this.id);
//TODO: DestinyRankModel.DeleteAllByStanceId(this.id);
//We need to update any associated records first before deleting this Stance Record
//TODO: FeatModel.UpdateStanceIdWithNull(this.Id);
//TODO: Enhancement.UpdateStanceIdWithNull(this.Id);
query = QueryInformation.Create(StanceModel.DeleteQuery);
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + StanceModel.IdField, DbType.Guid, this.Id));
BaseModel.RunCommand(query);
//reset the id so that the model knows it is a new record if someone tries to call the save() method afterwards.
this.Id = Guid.Empty;
}
public void Delete()
{
QueryInformation query;
//alignments
query = QueryInformation.Create(ClassModel.DeleteAlignmentsQuery);
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + ClassModel.IdField, DbType.Guid, this.Id));
BaseModel.RunCommand(query);
//class skills
query = QueryInformation.Create(ClassModel.DeleteClassSkillsQuery);
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + ClassModel.IdField, DbType.Guid, this.Id));
BaseModel.RunCommand(query);
//level details
Array.ForEach(LevelDetails, item => item.Delete());
//record
query = QueryInformation.Create(ClassModel.DeleteQuery);
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + ClassModel.IdField, DbType.Guid, this.Id));
BaseModel.RunCommand(query);
}
public ClassModel()
{
QueryInformation query;
List <string> destinyNames;
DestinySphereModel DefaultDestiny;
//set up default values for properties where needed
Name = DefaultName;
Abbreviation = DefaultAbbreviation;
//starting destiny sphere
destinyNames = DestinySphereModel.GetNames();
DefaultDestiny = new DestinySphereModel();
DefaultDestiny.Initialize(destinyNames[0]);
MaxSpellLevel = 0;
StartingDestinySphereId = DefaultDestiny.Id;
ImageFilename = DefaultImageFilename;
Description = DefaultDescription;
LevelDetails = new ClassLevelDetailModel[Constant.NumHeroicLevels];
for (int i = 0; i < Constant.NumHeroicLevels; i++)
{
LevelDetails[i] = new ClassLevelDetailModel();
}
//the sequence and reincarnation priority number (default to last record in sequence)
query = QueryInformation.Create(ClassModel.CountQuery);
query.CommandType = CommandType.Text;
Sequence = BaseModel.GetCount(query);
ReincarnationPriority = Sequence;
}
public void Save()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
query = QueryInformation.Create(EnhancementRankRequirementModel.InsertQuery);
this.Id = Guid.NewGuid();
}
else
{
query = QueryInformation.Create(EnhancementRankRequirementModel.UpdateQuery);
}
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + EnhancementRankRequirementModel.IdField, DbType.Guid, this.Id));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankRequirementModel.EnhancementRankIdField, DbType.Guid, this.EnhancementRankId));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankRequirementModel.RequireAllField, DbType.Boolean, this.RequireAll));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankRequirementModel.LastUpdatedDateField, DbType.DateTime, DateTime.Now));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankRequirementModel.LastUpdatedVersionField, DbType.String, Constant.PlannerVersion));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankRequirementModel.RequirementIdField, DbType.Guid, this.RequirementId));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankRequirementModel.RequirementValueField, DbType.Double, this.RequirementValue));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankRequirementModel.ComparisonField, DbType.String, this.Comparison));
BaseModel.RunCommand(query);
//This is for testing purposes, remove when done
Debug.WriteLine("Record has been saved: " + this.Id);
}
public void Save()
{
QueryInformation query;
QueryInformation countquery;
if (this.Id == Guid.Empty)
{
query = QueryInformation.Create(RaceModel.InsertQuery);
this.Id = Guid.NewGuid();
//since this is a new record, lets assign the sequence number automatically.
countquery = QueryInformation.Create(RaceModel.CountQuery);
countquery.CommandType = CommandType.Text;
Sequence = BaseModel.GetCount(countquery);
}
else
{
query = QueryInformation.Create(RaceModel.UpdateQuery);
}
//update the last modified fields
LastUpdatedDate = DateTime.Now;
LastUpdatedVersion = Constant.PlannerVersion;
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + RaceModel.IdField, DbType.Guid, this.Id));
query.Parameters.Add(new QueryParameter("@" + RaceModel.NameField, DbType.String, this.Name));
query.Parameters.Add(new QueryParameter("@" + RaceModel.DescriptionField, DbType.String, this.Description));
query.Parameters.Add(new QueryParameter("@" + RaceModel.StrengthMinimumField, DbType.Int32, this.StrengthMinimum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.StrengthMaximumField, DbType.Int32, this.StrengthMaximum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.DexterityMinimumField, DbType.Int32, this.DexterityMinimum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.DexterityMaximumField, DbType.Int32, this.DexterityMaximum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.ConstitutionMinimumField, DbType.Int32, this.ConstitutionMinimum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.ConstitutionMaximumField, DbType.Int32, this.ConstitutionMaximum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.IntelligenceMinimumField, DbType.Int32, this.IntelligenceMinimum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.IntelligenceMaximumField, DbType.Int32, this.IntelligenceMaximum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.WisdomMinimumField, DbType.Int32, this.WisdomMinimum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.WisdomMaximumField, DbType.Int32, this.WisdomMaximum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.CharismaMinimumField, DbType.Int32, this.CharismaMinimum));
query.Parameters.Add(new QueryParameter("@" + RaceModel.CharismaMaximumField, DbType.Int32, this.CharismaMaximum));
if (this.StartingClassId == Guid.Empty)
{
query.Parameters.Add(new QueryParameter("@" + RaceModel.StartingClassIdField, DbType.Guid, null));
}
else
{
query.Parameters.Add(new QueryParameter("@" + RaceModel.StartingClassIdField, DbType.Guid, this.StartingClassId));
}
query.Parameters.Add(new QueryParameter("@" + RaceModel.MaleImageFileNameField, DbType.String, this.MaleImageFileName));
query.Parameters.Add(new QueryParameter("@" + RaceModel.FemaleImageFileNameField, DbType.String, this.FemaleImageFileName));
query.Parameters.Add(new QueryParameter("@" + RaceModel.AbbreviationField, DbType.String, this.Abbreviation));
query.Parameters.Add(new QueryParameter("@" + RaceModel.LastUpdatedDateField, DbType.DateTime, this.LastUpdatedDate));
query.Parameters.Add(new QueryParameter("@" + RaceModel.LastUpdatedVersionField, DbType.String, this.LastUpdatedVersion));
query.Parameters.Add(new QueryParameter("@" + RaceModel.SequenceField, DbType.Byte, this.Sequence));
query.Parameters.Add(new QueryParameter("@" + RaceModel.IconicField, DbType.Boolean, this.Iconic));
query.Parameters.Add(new QueryParameter("@" + RaceModel.PastLifeFeatIdField, DbType.Guid, this.PastLifeFeatId));
BaseModel.RunCommand(query);
}
public void Save()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
query = QueryInformation.Create(EnhancementModel.InsertQuery);
this.Id = Guid.NewGuid();
}
else
{
query = QueryInformation.Create(EnhancementModel.UpdateQuery);
}
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.IdField, DbType.Guid, this.Id));
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.EnhancementSlotIdField, DbType.Guid, this.EnhancementSlotId));
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.DisplayOrderField, DbType.Byte, this.DisplayOrder));
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.NameField, DbType.String, this.Name));
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.APCostField, DbType.Int16, this.APCost));
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.IconField, DbType.String, this.Icon));
if (StanceId == Guid.Empty)
{
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.StanceIdField, DbType.Guid, null));
}
else
{
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.StanceIdField, DbType.Guid, this.StanceId));
}
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.LastUpdatedDateField, DbType.DateTime, DateTime.Now));
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.LastUpdatedVersionField, DbType.String, Constant.PlannerVersion));
BaseModel.RunCommand(query);
}
public void Save()
{
QueryInformation query;
if (Id == Guid.Empty)
{
query = QueryInformation.Create(InsertQuery);
Id = Guid.NewGuid();
}
else
{
query = QueryInformation.Create(UpdateQuery);
}
//update the last modified fields
LastUpdatedDate = DateTime.Now;
LastUpdatedVersion = Constant.PlannerVersion;
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + IdField, DbType.Guid, Id));
query.Parameters.Add(new QueryParameter("@" + TypeField, DbType.String, TomeType));
query.Parameters.Add(new QueryParameter("@" + ModifiedIDField, DbType.Guid, ModifiedID));
query.Parameters.Add(new QueryParameter("@" + MinLevelField, DbType.Int16, MinLevel));
query.Parameters.Add(new QueryParameter("@" + NameField, DbType.String, TomeName));
query.Parameters.Add(new QueryParameter("@" + LongNameField, DbType.String, TomeLongName));
query.Parameters.Add(new QueryParameter("@" + BonusField, DbType.Int16, TomeBonus));
query.Parameters.Add(new QueryParameter("@" + LastUpdatedDateField, DbType.DateTime, LastUpdatedDate));
query.Parameters.Add(new QueryParameter("@" + LastUpdatedVersionField, DbType.String, LastUpdatedVersion));
BaseModel.RunCommand(query);
return;
}
public void Delete()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
Debug.WriteLine("Error: You can delete this record as an actual Database record doesn't exist for it. EnhancementModel : Delete()");
return;
}
//We need to delete any associated records before deleting this one
//TODO: EnhancementRankModel.DeleteAllbyEnhancementId(this.Id);
//TODO: EnhancementRankModifierModel.DeleteAllByEnhancementId(this.Id);
//TODO: EnhancementRankRequirementModel.DeleteAllByEnhancementId(this.Id);
//we need to remove any Enhancement entries in other tables for this feat
query = QueryInformation.Create(EnhancementModel.DeleteQuery);
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + EnhancementModel.IdField, DbType.Guid, this.Id));
BaseModel.RunCommand(query);
//lets rest the id to empty so that the model knows it is now a new record if the save method is called.
this.Id = Guid.Empty;
}
public RaceModel()
{
QueryInformation query;
//set up default values for the properties when needed.
Description = DefaultDescription;
MaleImageFileName = DefaultImageFileName;
FemaleImageFileName = DefaultImageFileName;
StrengthMinimum = DefaultBaseScore;
StrengthMaximum = DefaultMaxScore;
DexterityMinimum = DefaultBaseScore;
DexterityMaximum = DefaultMaxScore;
ConstitutionMinimum = DefaultBaseScore;
ConstitutionMaximum = DefaultMaxScore;
IntelligenceMinimum = DefaultBaseScore;
IntelligenceMaximum = DefaultMaxScore;
WisdomMinimum = DefaultBaseScore;
WisdomMaximum = DefaultMaxScore;
CharismaMinimum = DefaultBaseScore;
CharismaMaximum = DefaultMaxScore;
//set the default sequence number (default to last record in sequence)
query = QueryInformation.Create(RaceModel.CountQuery);
query.CommandType = CommandType.Text;
Sequence = BaseModel.GetCount(query);
}
public void Save()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
query = QueryInformation.Create(CharacterBonusFeatModel.InsertQuery);
this.Id = Guid.NewGuid();
}
else
{
query = QueryInformation.Create(CharacterBonusFeatModel.UpdateQuery);
}
//update the last modified fields
LastUpdatedDate = DateTime.Now;
LastUpdatedVersion = Constant.PlannerVersion;
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + CharacterBonusFeatModel.IdField, DbType.Guid, this.Id));
query.Parameters.Add(new QueryParameter("@" + CharacterBonusFeatModel.FeatIdField, DbType.Guid, this.FeatId));
query.Parameters.Add(new QueryParameter("@" + CharacterBonusFeatModel.IgnorePreReqsField, DbType.Boolean, this.IgnorePreRequirements));
query.Parameters.Add(new QueryParameter("@" + CharacterBonusFeatModel.LevelField, DbType.Byte, this.Level));
query.Parameters.Add(new QueryParameter("@" + CharacterBonusFeatModel.LastUpdatedDateField, DbType.DateTime, this.LastUpdatedDate));
query.Parameters.Add(new QueryParameter("@" + CharacterBonusFeatModel.LastUpdatedVersionField, DbType.String, this.LastUpdatedVersion));
BaseModel.RunCommand(query);
}
public void Save()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
query = QueryInformation.Create(EnhancementSlotModel.InsertQuery);
this.Id = Guid.NewGuid();
}
else
{
query = QueryInformation.Create(EnhancementSlotModel.UpdateQuery);
}
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.IdField, DbType.Guid, this.Id));
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.EnhancementTreeIdField, DbType.Guid, this.EnhancementTreeId));
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.SlotIndexField, DbType.Int32, this.SlotIndex));
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.APRequirementField, DbType.Int32, this.APRequirement));
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.NameField, DbType.String, this.Name));
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.DescriptionField, DbType.String, this.Description));
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.IconField, DbType.String, this.Icon));
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.ActiveField, DbType.Boolean, this.Active));
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.LastUpdatedDateField, DbType.DateTime, DateTime.Now));
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.LastUpdatedVersionField, DbType.String, Constant.PlannerVersion));
query.Parameters.Add(new QueryParameter("@" + EnhancementSlotModel.UseEnhancementInfoField, DbType.Boolean, this.UseEnhancementInfo));
BaseModel.RunCommand(query);
}
public void Save()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
query = QueryInformation.Create(FeatRequirementModel.InsertQuery);
this.Id = Guid.NewGuid();
}
else
{
query = QueryInformation.Create(FeatRequirementModel.UpdateQuery);
}
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + FeatRequirementModel.IdField, DbType.Guid, this.Id));
query.Parameters.Add(new QueryParameter("@" + FeatRequirementModel.FeatIdField, DbType.Guid, this.FeatId));
query.Parameters.Add(new QueryParameter("@" + FeatRequirementModel.RequireAllField, DbType.Boolean, this.RequireAll));
query.Parameters.Add(new QueryParameter("@" + FeatRequirementModel.LastUpdatedDateField, DbType.DateTime, DateTime.Now));
query.Parameters.Add(new QueryParameter("@" + FeatRequirementModel.LastUpdatedVersionField, DbType.String, Constant.PlannerVersion));
query.Parameters.Add(new QueryParameter("@" + FeatRequirementModel.RequirementIdField, DbType.Guid, this.RequirementId));
query.Parameters.Add(new QueryParameter("@" + FeatRequirementModel.ValueField, DbType.Double, this.Value));
query.Parameters.Add(new QueryParameter("@" + FeatRequirementModel.ComparisonField, DbType.String, this.Comparison));
BaseModel.RunCommand(query);
}
public void Save()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
query = QueryInformation.Create(RaceLevelDetailModel.InsertQuery);
this.Id = Guid.NewGuid();
}
else
{
query = QueryInformation.Create(RaceLevelDetailModel.UpdateQuery);
}
//update the last modified fields
LastUpdatedDate = DateTime.Now;
LastUpdatedVersion = Constant.PlannerVersion;
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + RaceLevelDetailModel.IdField, DbType.Guid, this.Id));
query.Parameters.Add(new QueryParameter("@" + RaceLevelDetailModel.RaceIdField, DbType.Guid, this.RaceId));
query.Parameters.Add(new QueryParameter("@" + RaceLevelDetailModel.LevelField, DbType.Int32, this.Level));
if (FeatTypeId == Guid.Empty)
{
query.Parameters.Add(new QueryParameter("@" + RaceLevelDetailModel.FeatTypeIdField, DbType.Guid, null));
}
else
{
query.Parameters.Add(new QueryParameter("@" + RaceLevelDetailModel.FeatTypeIdField, DbType.Guid, this.FeatTypeId));
}
query.Parameters.Add(new QueryParameter("@" + RaceLevelDetailModel.BonusSkillPointsField, DbType.Int32, this.BonusSkillPoints));
query.Parameters.Add(new QueryParameter("@" + RaceLevelDetailModel.LastUpdatedDateField, DbType.DateTime, this.LastUpdatedDate));
query.Parameters.Add(new QueryParameter("@" + RaceLevelDetailModel.LastUpdatedVersionField, DbType.String, this.LastUpdatedVersion));
BaseModel.RunCommand(query);
}
public void Save()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
query = QueryInformation.Create(FeatCategoryModel.InsertQuery);
this.Id = Guid.NewGuid();
}
else
{
query = QueryInformation.Create(FeatCategoryModel.UpdateQuery);
}
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + FeatCategoryModel.IdField, DbType.Guid, this.Id));
query.Parameters.Add(new QueryParameter("@" + FeatCategoryModel.NameField, DbType.String, this.Name));
query.Parameters.Add(new QueryParameter("@" + FeatCategoryModel.DescriptionField, DbType.String, this.Description));
query.Parameters.Add(new QueryParameter("@" + FeatCategoryModel.ParentFeatCategoryIdField, DbType.Guid, this.ParentFeatCategoryId));
query.Parameters.Add(new QueryParameter("@" + FeatCategoryModel.LastUpdatedDateField, DbType.DateTime, DateTime.Now));
query.Parameters.Add(new QueryParameter("@" + FeatCategoryModel.LastUpdatedVersionField, DbType.String, Constant.PlannerVersion));
query.Parameters.Add(new QueryParameter("@" + FeatCategoryModel.IconNameField, DbType.String, this.IconName));
BaseModel.RunCommand(query);
}
/// <summary>
/// Saves the currently loaded EnhancementRankModifier
/// </summary>
public void Save()
{
QueryInformation query;
if (this.Id == Guid.Empty)
{
query = QueryInformation.Create(EnhancementRankModifierModel.InsertQuery);
this.Id = Guid.NewGuid();
}
else
{
query = QueryInformation.Create(EnhancementRankModifierModel.UpdateQuery);
}
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.IdField, DbType.Guid, this.Id));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.EnhancementRankIdField, DbType.Guid, this.EnhancementRankId));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.ModifierIdField, DbType.Guid, this.ModifierId));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.ModifierTypeField, DbType.Byte, this.ModifierType));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.ModifierMethodIdField, DbType.Guid, this.ModifierMethodId));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.PullFromIdField, DbType.Guid, this.PullFromId));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.ModifierValueField, DbType.Double, this.ModifierValue));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.BonusTypeIdField, DbType.Guid, this.BonusTypeId));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.RequirementIdField, DbType.Guid, this.RequirementId));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.StanceIdField, DbType.Guid, this.StanceId));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.ComparisonField, DbType.String, this.Comparison));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.RequirementValueField, DbType.Double, this.RequirementValue));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.LastUpdatedDateField, DbType.DateTime, DateTime.Now));
query.Parameters.Add(new QueryParameter("@" + EnhancementRankModifierModel.LastUpdatedVersionField, DbType.String, Constant.PlannerVersion));
BaseModel.RunCommand(query);
}
public static List <Guid> GetIds()
{
QueryInformation query;
query = QueryInformation.Create(ModifierMethodModel.GetIdsQuery);
query.CommandType = CommandType.Text;
return(BaseModel.GetIds(query, ModifierMethodModel.ReadId));
}
/// <summary>
/// Gets the names.
/// </summary>
/// <returns>A list of all the class names.</returns>
public static List<string> GetNames()
{
QueryInformation query;
query = QueryInformation.Create(DestinySphereModel.LoadNamesQuery);
query.CommandType = CommandType.Text;
return BaseModel.GetNames(query, DestinySphereModel.ReadNames);
}
/// <summary>
/// Gets all the race names
/// </summary>
/// <returns>A list of all the Race names.</return>
public static List <string> GetNames()
{
QueryInformation query;
query = QueryInformation.Create(RaceModel.LoadNamesQuery);
query.CommandType = CommandType.Text;
return(BaseModel.GetNames(query, RaceModel.ReadNames));
}
public static List <Guid> GetIds()
{
QueryInformation query;
query = QueryInformation.Create(FeatTargetModel.GetIdsQuery);
query.CommandType = CommandType.Text;
return(BaseModel.GetIds(query, FeatTargetModel.ReadId));
}
/// <summary>
/// Gets all records associated with the character
/// </summary>
/// <returns> A list of all CharacterBonusFeat Records.</return>
public static List <CharacterBonusFeatModel> GetAll()
{
QueryInformation query;
query = QueryInformation.Create(CharacterBonusFeatModel.LoadDetailsQuery);
query.CommandType = CommandType.Text;
return(BaseModel.GetAll <CharacterBonusFeatModel>(query, CharacterBonusFeatModel.Create));
}
public static List <string> GetNames()
{
QueryInformation query;
query = QueryInformation.Create(ModifierMethodModel.GetNamesQuery);
query.CommandType = CommandType.Text;
return(BaseModel.GetNames(query, ModifierMethodModel.ReadName));
}
public static int GetRecordCount()
{
QueryInformation query;
query = QueryInformation.Create(CountQuery);
query.CommandType = CommandType.Text;
return(BaseModel.GetCount(query));
}
public static Dictionary <Guid, string> GetNamesByID()
{
QueryInformation query;
query = QueryInformation.Create(SkillModel.LoadNamesQuery);
query.CommandType = CommandType.Text;
return(BaseModel.GetNamesByID(query, SkillModel.ReadNameById));
}
public void Delete()
{
QueryInformation query;
query = QueryInformation.Create(DeleteQuery);
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + ClassIdField, DbType.Guid, ClassId));
BaseModel.RunCommand(query);
}
public static void DeleteBySpell(Guid spellId)
{
QueryInformation query;
query = QueryInformation.Create(DeleteQuery);
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + SpellIdField, DbType.Guid, spellId));
BaseModel.RunCommand(query);
}
public static List <SkillModel> GetAll()
{
QueryInformation query;
query = QueryInformation.Create(SkillModel.LoadAllQuery);
query.CommandType = CommandType.Text;
return(BaseModel.GetAll <SkillModel>(query, SkillModel.Create));
}
public static bool DoesNameExist(string name)
{
QueryInformation query;
query = QueryInformation.Create(RaceModel.CountbyNameQuery);
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + RaceModel.NameField, DbType.String, name));
return(BaseModel.GetCount(query) > 0);
}
public static bool DoesAbbreviationExist(string abbreviation)
{
QueryInformation query;
query = QueryInformation.Create(RaceModel.CountByAbbreviationQuery);
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + RaceModel.AbbreviationField, DbType.String, abbreviation));
return(BaseModel.GetCount(query) > 0);
}
public static int GetNumIconic()
{
QueryInformation query;
query = QueryInformation.Create(RaceModel.CountIconicNumQuery);
query.CommandType = CommandType.Text;
query.Parameters.Add(new QueryParameter("@" + RaceModel.IconicField, DbType.Boolean, true));
return(BaseModel.GetCount(query));
}
