private void CreateBonus(SoftSkill softSkill) { SoftSkillType softSkillType = softSkill.GetSoftSkillType(); switch (softSkillType) { case SoftSkillType.COMMUNICATION: CreateBonusCopy(bonusDetails_Handler.GetBonusDic[INST_CHARM_ID], softSkill.GetTotalBONUS_charm(), softSkill.GetNextBONUS_charm()); CreateBonusCopy(bonusDetails_Handler.GetBonusDic[INST_BaseProject_ID], softSkill.GetTotalBONUS_baseBootUpProject(), softSkill.GetNextBONUS_baseBootUpProject()); break; case SoftSkillType.CRITICALTHINKING: CreateBonusCopy(bonusDetails_Handler.GetBonusDic[INST_BaseMotivation_ID], softSkill.GetTotalBONUS_baseBootUpMotivation(), softSkill.GetNextBONUS_baseBootUpMotivation()); CreateBonusCopy(bonusDetails_Handler.GetBonusDic[INST_BaseEnergy_ID], softSkill.GetTotalBONUS_baseReduceEnergyConsumption(), softSkill.GetNextBONUS_baseReduceEnergyConsumption()); CreateBonusCopy(bonusDetails_Handler.GetBonusDic[INST_BugChance_ID], softSkill.GetTotalBONUS_reduceBugChance(), softSkill.GetNextBONUS_reduceBugChance()); break; case SoftSkillType.TIMEMANAGEMENT: CreateBonusCopy(bonusDetails_Handler.GetBonusDic[INST_TimeCourse_ID], softSkill.GetTotalBONUS_reduceTimeTrainCourse(), softSkill.GetNextBONUS_reduceTimeTrainCourse()); CreateBonusCopy(bonusDetails_Handler.GetBonusDic[INST_TimeTransport_ID], softSkill.GetTotalBONUS_reduceTimeTransport(), softSkill.GetNextBONUS_reduceTimeTransport()); break; case SoftSkillType.WORKETHIC: CreateBonusCopy(bonusDetails_Handler.GetBonusDic[INST_GoldenProject_ID], softSkill.GetTotalBONUS_goldenTimeBootUpProject(), softSkill.GetNextBONUS_goldenTimeBootUpProject()); CreateBonusCopy(bonusDetails_Handler.GetBonusDic[INST_GoldenMotivation_ID], softSkill.GetTotalBONUS_goldenTimeBootUpMotivation(), softSkill.GetNextBONUS_goldenTimeBootUpMotivation()); CreateBonusCopy(bonusDetails_Handler.GetBonusDic[INST_GoldenEnergy_ID], softSkill.GetTotalBONUS_goldenTimeReduceEnergyConsuption(), softSkill.GetNextBONUS_goldenTimeReduceEnergyConsuption()); break; } }
public IActionResult SaveSoftSkill([FromBody] SoftSkill ss) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var id = _skillRepository.SaveSoftSkill(ss); var res = _skillRepository.GetSoftSkillById(id); return(Ok(res)); }
private void DisplayedSoftSkills() { int i = 0; foreach (KeyValuePair <string, SoftSkill> softskill in SoftSkillsController.Instance.Softskills) { SoftSkill copy = softskill.Value; if (!ReferenceEquals(copy, null)) { softSkillSlots[i].SOFTSKILL = softskill.Value; } softSkillSlots[i].Index = i; i++; } }
public void RemoveSoftSkill(int softSkillId) { if (softSkillId > 0) { SoftSkill softSkill = new SoftSkill { Id = softSkillId }; _context.Entry(softSkill).State = EntityState.Deleted; _context.SaveChanges(); } else { Logger.Error($"RemoveSoftSkill: not found softSkill with Id={softSkillId}"); } }
public Dictionary <string, SoftSkill> Interpert() { if (!ReferenceEquals(softskillsLoading, null)) { Dictionary <string, SoftSkill> softSkills = new Dictionary <string, SoftSkill>(); foreach (KeyValuePair <string, string> line in softskillsLoading.textLists) { SoftSkill softSkill = null; string key = line.Key; string value = line.Value; switch (key) { case "COMMUNICATION": softSkill = new SoftSkill(CreateCommunication(value)); break; case "CRITICALTHINKING": softSkill = new SoftSkill(CreateCriticalThinking(value)); break; case "TIMEMANAGEMENT": softSkill = new SoftSkill(CreateTimeManagement(value)); break; case "WORKETHIC": softSkill = new SoftSkill(CreateWorkEthic(value)); break; default: break; } if (!ReferenceEquals(softSkill, null)) { softSkills.Add(key, softSkill); } } if (!ReferenceEquals(softSkills, null)) { return(softSkills); } } return(null); }
public SoftSkill GetSoftSkillById(long id) { SoftSkill skill = null; try { using (var db = new DatabaseContainer()) { skill = db.SoftSkills.Where(x => x.Id == id).First(); } } catch (Exception e) { } return(skill); }
public BaseSkill GetSkillByLevelAndID(int skillid, int skilllevel) { DbParameter skillIdParameter = _db.CreateParameter(DbNames.GETSKILLBYLEVELANDID_SKILLID_PARAMETER, skillid); skillIdParameter.DbType = DbType.Int32; DbParameter skillLevelParameter = _db.CreateParameter(DbNames.GETSKILLBYLEVELANDID_SKILLLEVEL_PARAMETER, skilllevel); skillLevelParameter.DbType = DbType.Int32; _db.Open(); DbDataReader reader = _db.ExcecuteReader(DbNames.GETSKILLBYLEVELANDID_STOREDPROC, CommandType.StoredProcedure, skillLevelParameter, skillIdParameter); int ordinalSkill_skillid = reader.GetOrdinal(DbNames.SKILL_SKILLID); int ordinalSkill_skilllevel = reader.GetOrdinal(DbNames.SKILL_SKILLLEVEL); int ordinalSkill_requiredlevel = reader.GetOrdinal(DbNames.SKILL_REQUIREDLEVEL); int ordinalSkill_requiredstr = reader.GetOrdinal(DbNames.SKILL_REQUIREDSTR); int ordinalSkill_requiredsta = reader.GetOrdinal(DbNames.SKILL_REQUIREDSTA); int ordinalSkill_requireddex = reader.GetOrdinal(DbNames.SKILL_REQUIREDDEX); int ordinalSkill_requiredene = reader.GetOrdinal(DbNames.SKILL_REQUIREDENE); int ordinalSkill_manacost = reader.GetOrdinal(DbNames.SKILL_MANACOST); int ordinalSkill_predelay = reader.GetOrdinal(DbNames.SKILL_PREDELAY); int ordinalSkill_postdelay = reader.GetOrdinal(DbNames.SKILL_POSTDELAY); int ordinalSkill_requiredtraining = reader.GetOrdinal(DbNames.SKILL_REQUIREDTRAINING); int ordinalSkill_readonlybook = reader.GetOrdinal(DbNames.SKILL_READONLYBOOK); int ordinalSkill_incdamage = reader.GetOrdinal(DbNames.SKILL_INCDAMAGE); int ordinalSkill_incdamageperc = reader.GetOrdinal(DbNames.SKILL_INCDAMAGEPERC); int ordinalSkill_incdefense = reader.GetOrdinal(DbNames.SKILL_INCDEFENSE); int ordinalSkill_incdefenseperc = reader.GetOrdinal(DbNames.SKILL_INCDEFENSEPERC); int ordinalSkill_incattackrating = reader.GetOrdinal(DbNames.SKILL_INCATTACKRATING); int ordinalSkill_incattackratingperc = reader.GetOrdinal(DbNames.SKILL_INCATTACKRATINGPERC); int ordinalSkill_inchpmax = reader.GetOrdinal(DbNames.SKILL_INCHPMAX); int ordinalSkill_inchpcur = reader.GetOrdinal(DbNames.SKILL_INCHPCUR); int ordinalSkill_inchpcurperc = reader.GetOrdinal(DbNames.SKILL_INCHPCURPERC); int ordinalSkill_recoverhp = reader.GetOrdinal(DbNames.SKILL_RECOVERHP); int ordinalSkill_recoverhpperc = reader.GetOrdinal(DbNames.SKILL_RECOVERHPPERC); int ordinalSkill_incmanamax = reader.GetOrdinal(DbNames.SKILL_INCMANAMAX); int ordinalSkill_incmanacur = reader.GetOrdinal(DbNames.SKILL_INCMANACUR); int ordinalSkill_incmanacurperc = reader.GetOrdinal(DbNames.SKILL_INCMANACURPERC); int ordinalSkill_recovermana = reader.GetOrdinal(DbNames.SKILL_RECOVERMANA); int ordinalSkill_recovermanaperc = reader.GetOrdinal(DbNames.SKILL_RECOVERMANAPERC); int ordinalSkill_inccritical = reader.GetOrdinal(DbNames.SKILL_INCCRITICAL); int ordinalSkill_inccriticalperc = reader.GetOrdinal(DbNames.SKILL_INCCRITICALPERC); int ordinalSkill_incpkperc = reader.GetOrdinal(DbNames.SKILL_INCPKPERC); int ordinalSkill_keepuptime = reader.GetOrdinal(DbNames.SKILL_KEEPUPTIME); int ordinalSkill_distance = reader.GetOrdinal(DbNames.SKILL_DISTANCE); int ordinalSkill_successchance = reader.GetOrdinal(DbNames.SKILL_SUCCESSCHANCE); int ordinalSkill_netc1 = reader.GetOrdinal(DbNames.SKILL_NETC1); int ordinalSkill_netc2 = reader.GetOrdinal(DbNames.SKILL_NETC2); int ordinalSkill_netc3 = reader.GetOrdinal(DbNames.SKILL_NETC3); BaseSkill skill = null; while (reader.Read()) { short id = reader.GetInt16(ordinalSkill_skillid); if (id <= 15) skill = new SoftSkill(); else skill = new HardSkill(); skill.SkillID = reader.GetInt16(ordinalSkill_skillid); skill.SkillLevel = reader.GetByte(ordinalSkill_skilllevel); skill.RequiredLevel = reader.GetByte(ordinalSkill_requiredlevel); skill.RequiredStrength = reader.GetInt16(ordinalSkill_requiredstr); skill.RequiredStamina = reader.GetInt16(ordinalSkill_requiredsta); skill.RequiredDexterity = reader.GetInt16(ordinalSkill_requireddex); skill.RequiredEnergy = reader.GetInt16(ordinalSkill_requiredene); skill.ManaCost = reader.GetInt16(ordinalSkill_manacost); skill.PreDelay = reader.GetInt16(ordinalSkill_predelay); skill.PostDelay = reader.GetInt16(ordinalSkill_postdelay); skill.RequiredTraining = reader.GetInt16(ordinalSkill_requiredtraining); skill.ReadOnlyBook = reader.GetByte(ordinalSkill_readonlybook); skill.IncDamage = reader.GetInt16(ordinalSkill_incdamage); skill.IncDamagePerc = reader.GetInt16(ordinalSkill_incdamageperc); skill.IncDefense = reader.GetInt16(ordinalSkill_incdefense); skill.IncDefensePerc = reader.GetInt16(ordinalSkill_incdefenseperc); skill.IncAttackRating = reader.GetInt16(ordinalSkill_incattackrating); skill.IncAttackRatingPerc = reader.GetInt16(ordinalSkill_incattackratingperc); skill.IncHpMax = reader.GetInt16(ordinalSkill_inchpmax); skill.IncHpCur = reader.GetInt16(ordinalSkill_inchpcur); skill.IncHpCurPerc = reader.GetInt16(ordinalSkill_inchpcurperc); skill.RecoverHp = reader.GetInt16(ordinalSkill_recoverhp); skill.RecoverHpPerc = reader.GetInt16(ordinalSkill_recoverhpperc); skill.IncManaMax = reader.GetInt16(ordinalSkill_incmanamax); skill.IncManaCur = reader.GetInt16(ordinalSkill_incmanacur); skill.IncManaCurPerc = reader.GetInt16(ordinalSkill_incmanacurperc); skill.RecoverMana = reader.GetInt16(ordinalSkill_recovermana); skill.RecoverManaPerc = reader.GetInt16(ordinalSkill_recovermanaperc); skill.IncCritical = reader.GetInt16(ordinalSkill_inccritical); skill.IncCriticalPerc = reader.GetInt16(ordinalSkill_inccriticalperc); skill.IncPKPerc = reader.GetInt16(ordinalSkill_incpkperc); skill.KeepUpTime = reader.GetInt32(ordinalSkill_keepuptime); skill.Distance = reader.GetInt16(ordinalSkill_distance); skill.SuccessChance = reader.GetInt16(ordinalSkill_successchance); skill.nEtc1 = reader.GetInt32(ordinalSkill_netc1); skill.nEtc2 = reader.GetInt32(ordinalSkill_netc2); skill.nEtc3 = reader.GetInt32(ordinalSkill_netc3); } reader.Close(); _db.Close(); return skill; }
public void CreateTemplate(SoftSkill softSkill) { _template.SetActive(true); ClearTmeplate(); CreateBonus(softSkill); }
public BaseSkill GetSkillByLevelAndID(int skillid, int skilllevel) { DbParameter skillIdParameter = _db.CreateParameter(DbNames.GETSKILLBYLEVELANDID_SKILLID_PARAMETER, skillid); skillIdParameter.DbType = DbType.Int32; DbParameter skillLevelParameter = _db.CreateParameter(DbNames.GETSKILLBYLEVELANDID_SKILLLEVEL_PARAMETER, skilllevel); skillLevelParameter.DbType = DbType.Int32; _db.Open(); DbDataReader reader = _db.ExcecuteReader(DbNames.GETSKILLBYLEVELANDID_STOREDPROC, CommandType.StoredProcedure, skillLevelParameter, skillIdParameter); int ordinalSkill_skillid = reader.GetOrdinal(DbNames.SKILL_SKILLID); int ordinalSkill_skilllevel = reader.GetOrdinal(DbNames.SKILL_SKILLLEVEL); int ordinalSkill_requiredlevel = reader.GetOrdinal(DbNames.SKILL_REQUIREDLEVEL); int ordinalSkill_requiredstr = reader.GetOrdinal(DbNames.SKILL_REQUIREDSTR); int ordinalSkill_requiredsta = reader.GetOrdinal(DbNames.SKILL_REQUIREDSTA); int ordinalSkill_requireddex = reader.GetOrdinal(DbNames.SKILL_REQUIREDDEX); int ordinalSkill_requiredene = reader.GetOrdinal(DbNames.SKILL_REQUIREDENE); int ordinalSkill_manacost = reader.GetOrdinal(DbNames.SKILL_MANACOST); int ordinalSkill_predelay = reader.GetOrdinal(DbNames.SKILL_PREDELAY); int ordinalSkill_postdelay = reader.GetOrdinal(DbNames.SKILL_POSTDELAY); int ordinalSkill_requiredtraining = reader.GetOrdinal(DbNames.SKILL_REQUIREDTRAINING); int ordinalSkill_readonlybook = reader.GetOrdinal(DbNames.SKILL_READONLYBOOK); int ordinalSkill_incdamage = reader.GetOrdinal(DbNames.SKILL_INCDAMAGE); int ordinalSkill_incdamageperc = reader.GetOrdinal(DbNames.SKILL_INCDAMAGEPERC); int ordinalSkill_incdefense = reader.GetOrdinal(DbNames.SKILL_INCDEFENSE); int ordinalSkill_incdefenseperc = reader.GetOrdinal(DbNames.SKILL_INCDEFENSEPERC); int ordinalSkill_incattackrating = reader.GetOrdinal(DbNames.SKILL_INCATTACKRATING); int ordinalSkill_incattackratingperc = reader.GetOrdinal(DbNames.SKILL_INCATTACKRATINGPERC); int ordinalSkill_inchpmax = reader.GetOrdinal(DbNames.SKILL_INCHPMAX); int ordinalSkill_inchpcur = reader.GetOrdinal(DbNames.SKILL_INCHPCUR); int ordinalSkill_inchpcurperc = reader.GetOrdinal(DbNames.SKILL_INCHPCURPERC); int ordinalSkill_recoverhp = reader.GetOrdinal(DbNames.SKILL_RECOVERHP); int ordinalSkill_recoverhpperc = reader.GetOrdinal(DbNames.SKILL_RECOVERHPPERC); int ordinalSkill_incmanamax = reader.GetOrdinal(DbNames.SKILL_INCMANAMAX); int ordinalSkill_incmanacur = reader.GetOrdinal(DbNames.SKILL_INCMANACUR); int ordinalSkill_incmanacurperc = reader.GetOrdinal(DbNames.SKILL_INCMANACURPERC); int ordinalSkill_recovermana = reader.GetOrdinal(DbNames.SKILL_RECOVERMANA); int ordinalSkill_recovermanaperc = reader.GetOrdinal(DbNames.SKILL_RECOVERMANAPERC); int ordinalSkill_inccritical = reader.GetOrdinal(DbNames.SKILL_INCCRITICAL); int ordinalSkill_inccriticalperc = reader.GetOrdinal(DbNames.SKILL_INCCRITICALPERC); int ordinalSkill_incpkperc = reader.GetOrdinal(DbNames.SKILL_INCPKPERC); int ordinalSkill_keepuptime = reader.GetOrdinal(DbNames.SKILL_KEEPUPTIME); int ordinalSkill_distance = reader.GetOrdinal(DbNames.SKILL_DISTANCE); int ordinalSkill_successchance = reader.GetOrdinal(DbNames.SKILL_SUCCESSCHANCE); int ordinalSkill_netc1 = reader.GetOrdinal(DbNames.SKILL_NETC1); int ordinalSkill_netc2 = reader.GetOrdinal(DbNames.SKILL_NETC2); int ordinalSkill_netc3 = reader.GetOrdinal(DbNames.SKILL_NETC3); BaseSkill skill = null; while (reader.Read()) { short id = reader.GetInt16(ordinalSkill_skillid); if (id <= 15) { skill = new SoftSkill(); } else { skill = new HardSkill(); } skill.SkillID = reader.GetInt16(ordinalSkill_skillid); skill.SkillLevel = reader.GetByte(ordinalSkill_skilllevel); skill.RequiredLevel = reader.GetByte(ordinalSkill_requiredlevel); skill.RequiredStrength = reader.GetInt16(ordinalSkill_requiredstr); skill.RequiredStamina = reader.GetInt16(ordinalSkill_requiredsta); skill.RequiredDexterity = reader.GetInt16(ordinalSkill_requireddex); skill.RequiredEnergy = reader.GetInt16(ordinalSkill_requiredene); skill.ManaCost = reader.GetInt16(ordinalSkill_manacost); skill.PreDelay = reader.GetInt16(ordinalSkill_predelay); skill.PostDelay = reader.GetInt16(ordinalSkill_postdelay); skill.RequiredTraining = reader.GetInt16(ordinalSkill_requiredtraining); skill.ReadOnlyBook = reader.GetByte(ordinalSkill_readonlybook); skill.IncDamage = reader.GetInt16(ordinalSkill_incdamage); skill.IncDamagePerc = reader.GetInt16(ordinalSkill_incdamageperc); skill.IncDefense = reader.GetInt16(ordinalSkill_incdefense); skill.IncDefensePerc = reader.GetInt16(ordinalSkill_incdefenseperc); skill.IncAttackRating = reader.GetInt16(ordinalSkill_incattackrating); skill.IncAttackRatingPerc = reader.GetInt16(ordinalSkill_incattackratingperc); skill.IncHpMax = reader.GetInt16(ordinalSkill_inchpmax); skill.IncHpCur = reader.GetInt16(ordinalSkill_inchpcur); skill.IncHpCurPerc = reader.GetInt16(ordinalSkill_inchpcurperc); skill.RecoverHp = reader.GetInt16(ordinalSkill_recoverhp); skill.RecoverHpPerc = reader.GetInt16(ordinalSkill_recoverhpperc); skill.IncManaMax = reader.GetInt16(ordinalSkill_incmanamax); skill.IncManaCur = reader.GetInt16(ordinalSkill_incmanacur); skill.IncManaCurPerc = reader.GetInt16(ordinalSkill_incmanacurperc); skill.RecoverMana = reader.GetInt16(ordinalSkill_recovermana); skill.RecoverManaPerc = reader.GetInt16(ordinalSkill_recovermanaperc); skill.IncCritical = reader.GetInt16(ordinalSkill_inccritical); skill.IncCriticalPerc = reader.GetInt16(ordinalSkill_inccriticalperc); skill.IncPKPerc = reader.GetInt16(ordinalSkill_incpkperc); skill.KeepUpTime = reader.GetInt32(ordinalSkill_keepuptime); skill.Distance = reader.GetInt16(ordinalSkill_distance); skill.SuccessChance = reader.GetInt16(ordinalSkill_successchance); skill.nEtc1 = reader.GetInt32(ordinalSkill_netc1); skill.nEtc2 = reader.GetInt32(ordinalSkill_netc2); skill.nEtc3 = reader.GetInt32(ordinalSkill_netc3); } reader.Close(); _db.Close(); return(skill); }
public SoftSkillViewModel ToSoftSkillViewModel(SoftSkill softSkill) { var softSkillViewModel = _mapper.Map <SoftSkill, SoftSkillViewModel>(softSkill); return(softSkillViewModel); }
public SoftSkillJson ToSoftSkillJsonModel(SoftSkill softSkill) { var softSkillJson = _mapper.Map <SoftSkill, SoftSkillJson>(softSkill); return(softSkillJson); }
public SoftSkillDetailsViewModel() { this.SoftSkill = new SoftSkill(); }