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();
}
