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