public ActionResult GetPaymentTable(long claimFieldDocId, int take, int skip, IEnumerable <Sort> sort,
                                            Kendo.DynamicLinq.Filter filter, string defaultSortField, long claimFieldId)
        {
            PageSetting pageSetting = CommonUtil.GetPageSetting(take, skip, sort, filter, defaultSortField,
                                                                Constants.PaymentTableFields, claimFieldId);

            ClaimFieldDoc claimFieldDoc = new ClaimFieldDoc
            {
                ClaimFieldDocId = claimFieldDocId,
                PageSetting     = pageSetting,
                ClaimFieldId    = claimFieldId,
                UserName        = GetCurrentUserName(),
                SessionTimeOut  = Convert.ToInt32(GlobalConfigVariable.CommandTimeout)
            };

            PaymentTableContainer paymentTableContainer = PostApiResponse <PaymentTableContainer>(Constants.PaymentTable,
                                                                                                  Constants.GetPaymentTable, claimFieldDoc);

            if (paymentTableContainer != null)
            {
                return(Json(new DataSourceResult
                {
                    Total = paymentTableContainer.Total,
                    Data = paymentTableContainer.ClaimFieldValues
                }));
            }
            return(Json(null));
        }
        public ActionResult GetMedicareLabFeeSchedule(int date, int take, int skip, IEnumerable <Sort> sort,
                                                      Kendo.DynamicLinq.Filter filter, string defaultSortField)
        {
            PageSetting pageSetting = CommonUtil.GetPageSetting(take, skip, sort, filter, defaultSortField,
                                                                Constants.MedicareLabFeeScheduleFields, (long)Enums.ClaimFieldTypes.MedicareLabFeeSchedule);
            UserInfo userInfoViewModel = GetUserInfo();

            if (userInfoViewModel != null && userInfoViewModel.AssignedFacilities != null && userInfoViewModel.AssignedFacilities.Any())
            {
                MedicareLabFeeSchedule mCareLabFeeSchedule = new MedicareLabFeeSchedule
                {
                    Date        = date,
                    PageSetting = pageSetting,
                    UserName    = userInfoViewModel.UserName,
                    FacilityId  = GetCurrentFacilityId()
                };
                MedicareLabFeeScheduleResult medicareLabFeeScheduleResult =
                    PostApiResponse <MedicareLabFeeScheduleResult>(Constants.MedicareLabFeeSchedule,
                                                                   Constants.GetMedicareLabFeeSchedule,
                                                                   mCareLabFeeSchedule);
                if (medicareLabFeeScheduleResult != null)
                {
                    DataSourceResult dataSourceResult = new DataSourceResult
                    {
                        Total = medicareLabFeeScheduleResult.Total,
                        Data  = medicareLabFeeScheduleResult.MedicareLabFeeScheduleList
                    };
                    return(Json(dataSourceResult));
                }
            }
            return(Json(null));
        }
예제 #3
0
        public ActionResult DownloadClaims(IEnumerable <Sort> sort, Kendo.DynamicLinq.Filter filter, string selectionCriteria, DateTime?dateFrom, DateTime?dateTo, long?modelId, int?dateType, string currentDateTime, bool isSelectClaims)
        {
            PageSetting pageSetting     = CommonUtil.GetPageSettingClaim(10, -1, sort, filter, Constants.OpenClaimFields, modelId);
            var         currentuserName = GetCurrentUserName();
            var         userGuId        = GetUserKey();//replacing for user keys

            if (dateFrom == DateTime.MinValue ||
                dateTo == DateTime.MinValue || dateFrom == null ||
                dateTo == null)
            {
                dateTo   = DateTime.Now;
                dateFrom =
                    DateTime.Now.AddYears(-GlobalConfigVariable.PullDataForNumberOfYears);
                if (!string.IsNullOrEmpty(selectionCriteria) &&
                    selectionCriteria.Contains(Constants.AdjudicationRequestCriteria))
                {
                    dateType = -1;
                }
            }
            ClaimAdjudicationReport adjudicationReport = new ClaimAdjudicationReport
            {
                ClaimSearchCriteria  = selectionCriteria,
                UserName             = GetLoggedInUserName(),
                RequestedUserId      = string.IsNullOrEmpty(currentuserName) ? Guid.Empty.ToString() : userGuId,
                RequestedUserName    = currentuserName,
                MaxLinesForPdfReport = GlobalConfigVariable.MaxPagesForTelerikReport * GlobalConfigVariable.MaxNumberOfLinesInPdfPage,
                StartDate            = Convert.ToDateTime(dateFrom),
                EndDate         = Convert.ToDateTime(dateTo),
                ModelId         = Convert.ToInt64(modelId),
                DateType        = Convert.ToInt32(dateType),
                CurrentDateTime = currentDateTime,
                IsSelectClaims  = isSelectClaims,
                UserId          = GetUserInfo().UserId,
                PageSetting     = pageSetting
            };


            ClaimAdjudicationReport          claimAdjudicationReport     = PostApiResponse <ClaimAdjudicationReport>(Constants.ClaimAdjudicationReport, Constants.GetSelectedClaim, adjudicationReport);
            ClaimAdjudicationReportViewModel claimAdjudicationReportList =
                Mapper.Map <ClaimAdjudicationReport, ClaimAdjudicationReportViewModel>(claimAdjudicationReport);

            claimAdjudicationReportList.LoggedInUser = currentuserName;

            string fileName = new ClaimAdjudicationReportUtil().GetExportedFileName(Enums.DownloadFileType.Xls,
                                                                                    claimAdjudicationReportList, GlobalConfigVariable.ReportsFilePath, currentDateTime);

            return(Json(fileName));
        }
        public DataSourceResult Get(Kendo.DynamicLinq.View filters)
        {
            Kendo.DynamicLinq.Filter Filter = null;
            if (filters.Filter != null)
            {
                Filter = filters.FieldTypeCheckAll(filters.Filter);
            }
            if (Filter != null)
            {
                filters.Filter = Filter;
            }
            //List<Models.Domain.User> result = new List<User>();
            DataSourceResult result = _identityDatabaseContext.Set <Models.Domain.User>()
                                      .OrderBy(p => p.CreateDate) // EF requires ordering for paging
                                      .ToDataSourceResult(filters.Take, filters.Skip, filters.Sort, filters.Filter, filters.Aggregates);

            return(result);
        }
예제 #5
0
        public ActionResult Read(int take, int skip, IEnumerable <Sort> sort, Kendo.DynamicLinq.Filter filter)
        {
            using (var northwind = new Northwind())
            {
                var result = northwind.Products
                             .OrderBy(p => p.ProductID) // EF requires ordered IQueryable in order to do paging
                                                        // Use a view model to avoid serializing internal Entity Framework properties as JSON
                             .Select(p => new ProductViewModel
                {
                    ProductID    = p.ProductID,
                    ProductName  = p.ProductName,
                    UnitPrice    = p.UnitPrice,
                    UnitsInStock = p.UnitsInStock,
                    Discontinued = p.Discontinued
                })
                             .ToDataSourceResult(take, skip, sort, filter);

                return(Json(result));
            }
        }
예제 #6
0
        public ActionResult GetTracks(int audioId, int take, int skip, IEnumerable <Sort> sort, Kendo.DynamicLinq.Filter filter)
        {
            IQueryable <Track> result = _trackService.GetListTrackByAudioId(audioId).AsQueryable();


            return(Json(
                       result.ToDataSourceResult(take, skip, sort, filter), JsonRequestBehavior.AllowGet
                       ));
        }
예제 #7
0
        public ActionResult GetAllOpenClaim(string selectionCriteria, int take, int skip, IEnumerable <Sort> sort, Kendo.DynamicLinq.Filter filter, DateTime?dateFrom, DateTime?dateTo, long?modelId, int?dateType, string zoneDateTime, bool isSelectClaims)
        {
            PageSetting pageSetting     = CommonUtil.GetPageSettingClaim(take, skip, sort, filter, Constants.OpenClaimFields, modelId);
            var         currentUserName = GetCurrentUserName();
            var         userGuid        = GetUserKey();//user key replaced

            if (dateFrom == DateTime.MinValue ||
                dateTo == DateTime.MinValue || dateFrom == null ||
                dateTo == null)
            {
                dateTo   = DateTime.Now;
                dateFrom =
                    DateTime.Now.AddYears(-GlobalConfigVariable.PullDataForNumberOfYears);
                if (!string.IsNullOrEmpty(selectionCriteria) &&
                    selectionCriteria.Contains(Constants.AdjudicationRequestCriteria))
                {
                    dateType = -1;
                }
            }
            ClaimAdjudicationReport adjudicationReportData = new ClaimAdjudicationReport
            {
                ClaimSearchCriteria  = selectionCriteria,
                UserName             = GetLoggedInUserName(),
                RequestedUserId      = string.IsNullOrEmpty(currentUserName) ? Guid.Empty.ToString() : userGuid,
                RequestedUserName    = currentUserName,
                MaxLinesForPdfReport = GlobalConfigVariable.MaxPagesForTelerikReport * GlobalConfigVariable.MaxNumberOfLinesInPdfPage,
                Take            = take,
                Skip            = skip,
                DateType        = Convert.ToInt32(dateType),
                StartDate       = Convert.ToDateTime(dateFrom),
                EndDate         = Convert.ToDateTime(dateTo),
                ModelId         = Convert.ToInt64(modelId),
                CurrentDateTime = zoneDateTime,
                IsSelectClaims  = isSelectClaims,
                UserId          = GetUserInfo().UserId,
                PageSetting     = pageSetting
            };

            ClaimAdjudicationReport          adjudicationReportInfo = PostApiResponse <ClaimAdjudicationReport>(Constants.ClaimAdjudicationReport, Constants.GetSelectedClaim, adjudicationReportData);
            ClaimAdjudicationReportViewModel adjudicationReportList =
                Mapper.Map <ClaimAdjudicationReport, ClaimAdjudicationReportViewModel>(adjudicationReportInfo);

            //Need to get claim-id as string. If claim-id is exceeding 16 digit then it was not showing correctly. IF we will remove then it will not display properly into open-claims grid
            foreach (ClaimDataViewModel claim in adjudicationReportList.ClaimData)
            {
                claim.ClaimIdValue = claim.ClaimId.ToString(CultureInfo.InvariantCulture);
            }

            adjudicationReportList.LoggedInUser = currentUserName;
            if (adjudicationReportList.ReportThreshold == Constants.ReportThreshold)
            {
                var data = adjudicationReportList.ReportThreshold;
                return(Json(new { total = data }));
            }

            DataSourceResult claimAdjudicationReportResult = new DataSourceResult
            {
                Data  = adjudicationReportList.ClaimData,
                Total = adjudicationReportInfo.TotalRecords
            };

            return(Json(new { data = claimAdjudicationReportResult, total = adjudicationReportList.ReportThreshold }));
        }
예제 #8
0
        public ActionResult TampilMasterKamar(int take, int skip,
                                              IEnumerable <Kendo.DynamicLinq.Sort> sort, Kendo.DynamicLinq.Filter filter)
        {
            cls_data_master i_cls_master_karantina = new cls_data_master();

            return(Json(i_cls_master_karantina.MenampilkanMasterKamar().ToDataSourceResult(take, skip, sort, filter)));
        }
예제 #9
0
        public ActionResult listemployee(string paramst, int take, int skip, IEnumerable <Kendo.DynamicLinq.Sort> sort, Kendo.DynamicLinq.Filter filter)
        {
            try
            {
                IQueryable <VW_MASTER_SALARY> i_tbl_t;

                pb_db_ctx = new DB_FINGERDataContext();
                if (paramst == "")
                {
                    i_tbl_t = pb_db_ctx.VW_MASTER_SALARies.OrderBy(o => o.NAME);
                }

                else if (paramst == "PT.PMS")
                {
                    i_tbl_t = pb_db_ctx.VW_MASTER_SALARies.OrderBy(o => o.NAME);
                }
                else
                {
                    i_tbl_t = pb_db_ctx.VW_MASTER_SALARies.Where(t => t.GROUPS == paramst).OrderBy(o => o.NAME);
                }
                return(Json(i_tbl_t.ToDataSourceResult(take, skip, sort, filter)));
            }
            catch (Exception ex)
            {
                return(this.Json(ex));
            }
        }
예제 #10
0
        public List <Models.Domain.Order> Get(int take, int skip, List <Kendo.DynamicLinq.Sort> sort, Kendo.DynamicLinq.Filter filter, List <Aggregator> aggregates)
        {
            List <Models.Domain.Order> result = (List <Models.Domain.Order>)_productDatabaseContext.Set <Models.Domain.Order>()
                                                .OrderBy(p => p.CreateDate) // EF requires ordering for paging
                                                .ToDataSourceResult(take, skip, sort, filter, aggregates).Data;

            return(result);
        }
예제 #11
0
        public ActionResult ContractAlertsInfo(int take, int skip, IEnumerable <Sort> sort, Kendo.DynamicLinq.Filter filter)
        {
            ContractAlert data = new ContractAlert
            {
                NumberOfDaysToDismissAlerts = GlobalConfigVariables.NumberOfDaysToDismissAlerts,
                FacilityId = GetCurrentFacilityId()
            };

            List <ContractAlert> contractAlertList = PostApiResponse <List <ContractAlert> >(Constants.ContractAlert, Constants.GetContractAlerts, data);

            return(Json(contractAlertList.AsQueryable().ToDataSourceResult(take, skip, sort, filter)));
        }
예제 #12
0
        public ActionResult listemployeesalary(string paramst, int take, int skip, IEnumerable <Kendo.DynamicLinq.Sort> sort, Kendo.DynamicLinq.Filter filter)
        {
            try
            {
                IQueryable <VW_MASTER_SALARY_KARYAWAN> i_tbl_t;

                pb_db_ctx = new DB_FINGERDataContext();

                i_tbl_t = pb_db_ctx.VW_MASTER_SALARY_KARYAWANs.Where(t => t.NAME.Contains(paramst) || t.NIK.Contains(paramst)).OrderBy(o => o.NIK).OrderBy(s => s.active_date_start);



                return(Json(i_tbl_t.ToDataSourceResult(take, skip, sort, filter)));
            }
            catch (Exception ex)
            {
                return(this.Json(ex));
            }
        }