Ejemplo n.º 1
0
        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));
        }
Ejemplo n.º 2
0
        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));
        }