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