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)); }
/// <summary> /// Gets the payment table. /// </summary> /// <param name="claimFieldDoc">The claim field document.</param> /// <returns></returns> public PaymentTableContainer GetPaymentTable(ClaimFieldDoc claimFieldDoc) { PaymentTableContainer paymentTableContainer = new PaymentTableContainer { ClaimFieldValues = new List <ClaimFieldValue>() }; if (claimFieldDoc != null) { //holds the response string finalStrXml = string.Empty; //Checks for Payers, if payers exists stores it in DB if (claimFieldDoc.PageSetting != null && claimFieldDoc.PageSetting.SearchCriteriaList != null && claimFieldDoc.PageSetting.SearchCriteriaList.Any()) { finalStrXml = claimFieldDoc.XmlSerialize(); } // Initialize the Stored Procedure _databaseCommandObj = _databaseObj.GetStoredProcCommand("GetPaymentTable"); _databaseCommandObj.CommandTimeout = claimFieldDoc.SessionTimeOut; // Pass parameters to Stored Procedure(i.e., @ParamName), add values for _databaseObj.AddInParameter(_databaseCommandObj, "@ClaimFieldDocID", DbType.Int64, claimFieldDoc.ClaimFieldDocId); _databaseObj.AddInParameter(_databaseCommandObj, "@UserName", DbType.String, claimFieldDoc.UserName); // ReSharper disable once PossibleNullReferenceException _databaseObj.AddInParameter(_databaseCommandObj, "@Take", DbType.Int32, claimFieldDoc.PageSetting.Take); _databaseObj.AddInParameter(_databaseCommandObj, "@Skip", DbType.Int32, claimFieldDoc.PageSetting.Skip); _databaseObj.AddInParameter(_databaseCommandObj, "@SortField", DbType.String, claimFieldDoc.PageSetting.SortField); _databaseObj.AddInParameter(_databaseCommandObj, "@SortDirection", DbType.String, claimFieldDoc.PageSetting.SortDirection); _databaseObj.AddInParameter(_databaseCommandObj, "@XmlSearchCriteria", DbType.Xml, finalStrXml); // Retrieve the results of the Stored Procedure in Dataset DataSet paymentTableDataSet = _databaseObj.ExecuteDataSet(_databaseCommandObj); if (paymentTableDataSet.IsTableDataPopulated() && paymentTableDataSet.Tables.Count > 1) { paymentTableContainer.Total = Convert.ToInt32(paymentTableDataSet.Tables[0].Rows[0][0]); // Bind Claimfield Value Data paymentTableContainer.ClaimFieldValues = new List <ClaimFieldValue>(); paymentTableContainer.ClaimFieldValues = (from DataRow row in paymentTableDataSet.Tables[1].Rows select new ClaimFieldValue { Identifier = Convert.ToString(row["Identifier"]), Value = Convert.ToString(row["Value"]) }).ToList(); } } return(paymentTableContainer); }
public void GetPaymentTable() { var mockPaymentTableLogic = new Mock <IPaymentTableRepository>(); PaymentTableContainer result = new PaymentTableContainer(); mockPaymentTableLogic.Setup(f => f.GetPaymentTable(It.IsAny <ClaimFieldDoc>())).Returns(result); PaymentTableLogic target = new PaymentTableLogic(mockPaymentTableLogic.Object); PaymentTableContainer actual = target.GetPaymentTable(new ClaimFieldDoc()); Assert.AreEqual(result, actual); }
public void GetCustomPaymentTable() { var repository = new Mock <IPaymentTableRepository>(); PaymentTableContainer result = new PaymentTableContainer(); var value = new ClaimFieldDoc { ClaimFieldDocId = 10101, ClaimFieldId = 35, PageSetting = new PageSetting { Skip = 0, SortDirection = "", SortField = "", Take = 5 } }; repository.Setup( f => f.GetCustomPaymentTable(value)).Returns(result); PaymentTableLogic target = new PaymentTableLogic(repository.Object); PaymentTableContainer actual = target.GetPaymentTable(value); Assert.AreEqual(result, actual); }