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