public IHttpActionResult getEmployeeTransactionsHistory([FromBody] EmployeeTransactionsHistory emptranshistory)
{
Console.WriteLine(emptranshistory.EmployeeSSN);
string sSQL = "select EmployeeSSN, CBID, CountyCode, AppointmentType, HistoryRemarks, PayLetterNumber, TimeBase,";
sSQL += "AppointmentTenure, AppointmentMonths, AppointmentExpirationDate, SalaryPER, PayFrequency, BasePay,";
sSQL += "SalaryRate, SalaryTotal, SalaryFull, PlusSalary, PlusSalaryExpirationDate, AnniversaryDate,";
sSQL += "AcceleratedAnniversaryDate, AlternateRange, PayrollStatus, ShiftDifferential, SpecialPay, WorkWeekGroup,";
sSQL += "FireSeasonSalaryRate, PriorServiceCode, RetirementSystem, PERSRetirementMemberDate, SafetyMember,";
sSQL += "Survivor, OASDI, RetirementRate, ExemptAuthority, PersAccountCode, PersEmployerCode, ClassType,";
sSQL += "FixedMaintMonthlyDeduction, EstablishedEarningsID1, EstablishedEarningsAmount1, EstablishedEarningsID2,";
sSQL += "EstablishedEarningsAmount2, EstablishedEarningsID3, EstablishedEarningsAmount3, ImmediatePay,";
sSQL += "LumSumSickLeave, LumSumSickHours, LumSumVaction, LumSumVactionHours, LumSumExtraHours, LumSumOvertimeHours,";
sSQL += "LumSumPayCode, LumSumUnitSerial, SeparationExpirationDate, IntermittentBeginDate1, IntermittentEndDate1,";
sSQL += "IntermittentHours1, IntermittentBeginDate2, IntermittentEndDate2, IntermittentHours2, IntermittentBeginDate3,";
sSQL += "IntermittentEndDate3, IntermittentHours3, IntermittentHoursExpect, LegalReferenceAnnuitant ";
sSQL += " from [EHDB].[xferTransactionHistory] ";
sSQL += " where EmployeeSSN = '" + emptranshistory.EmployeeSSN + "'";
var appBlock = new SqlDbConnectionBaseClass();
var result = appBlock.ExecuteForSelect(sSQL);
var json = JsonConvert.SerializeObject(result);
var listData = JsonConvert.DeserializeObject <List <EmployeeTransactionsHistory> >(json);
return(Ok(listData));
}
public IHttpActionResult getEmployeeTransactionsHistoryListing([FromBody] EmployeeTransactionsHistory emptranshistory)
{
Console.WriteLine(emptranshistory.EmployeeSSN);
string sSQL = "SELECT EmployeeSSN, PositionSequence,PositionNumber,TransactionEffectiveDate";
sSQL += " ,TransactionCode,EntryDate,PPSDReference1,HistoryType,HistoryRemarks ";
sSQL += " from [EHDB].[xferTransactionHistory] ";
sSQL += " where EmployeeSSN = '" + emptranshistory.EmployeeSSN + "'";
var appBlock = new SqlDbConnectionBaseClass();
var result = appBlock.ExecuteForSelect(sSQL);
var json = JsonConvert.SerializeObject(result);
var listData = JsonConvert.DeserializeObject <List <EmployeeTransactionsHistory> >(json);
return(Ok(result));
}