public static SalaryRange InputSalaryRange()
{
var salaryRange = new SalaryRange();
Console.WriteLine("Salary range:");
Console.WriteLine("From: ");
salaryRange.From = GetNumeric(NumericTypes.INT);
while (true)
{
Console.WriteLine("To: ");
salaryRange.To = GetNumeric(NumericTypes.INT);
if (salaryRange.To >= salaryRange.From)
{
break;
}
LoggerPublisher.OnLogError("Max salary must be greater than min!");
}
return(salaryRange);
}
public override UserAccount Execute()
{
var userAccount =
new UserAccount(_user, BalanceRange.GetValue(), SalaryRange.GetValue(),
SpentRange.GetValue(), MoodRange.GetValue());
return(userAccount);
}
public IHttpActionResult searchSalaryRange([FromBody] SalaryRange salaryrange)
{
Console.WriteLine(salaryrange.ClassKeyID);
string sSQL = "select a.fk_class_key_id as 'ClassKeyID', a.fk_class_data_id as 'ClassDataID', ";
sSQL += "SX_CS_CLS_SALRNG_POS as 'SalaryPOS', SR_SALARY_STRUCTURE_CODE as 'SalaryStructureCode', ";
sSQL += "SR_REGULAR_SALARY_RATE_CNT as 'SalaryRateCount', SR_REGULAR_SALARY_RATE_1 as 'SalaryRate1', ";
sSQL += "SR_REGULAR_SALARY_RATE_2 as 'SalaryRate2', SR_SALARY_ADJ_CAT_CODE_1 as 'SalaryAdjustCatCode', ";
sSQL += "SR_SAL_ADJ_PCT_R_1 as 'SalaryAdjustPercentRate1', SR_PAY_FREQUENCY_IND_1_1_1 as 'PayFreqIndicator', ";
sSQL += "SR_PAY_FREQUENCY_UNITS_1_1_1 as 'PayFreqUnits', SR_GEN_SAL_INCR_PCT_R_1 as 'IncrementPercent1' ";
sSQL += "from csp.xfersalaryrange as a, csp.xferclasskey as b, csp.xferclassdata as c ";
sSQL += "where a.fk_class_data_id = c.pk_class_data_id and a.fk_class_key_id = b.pk_class_key_id ";
sSQL += "and a.fk_class_key_id = " + salaryrange.ClassKeyID + " and a.fk_class_data_id in ";
sSQL += "(SELECT [PK_CLASS_DATA_ID] FROM [ScoDatabank].[CSP].[xferClassData] where [FK_CLASS_KEY_ID] = " + salaryrange.ClassKeyID + ")";
var appBlock = new SqlDbConnectionBaseClass();
var result = appBlock.ExecuteForSelect(sSQL);
var json = JsonConvert.SerializeObject(result);
var listData = JsonConvert.DeserializeObject <List <SalaryRange> >(json);
return(Ok(listData));
}
