/// <summary>
/// Gets Open Claim Columns By UserId
/// </summary>
/// <param name="data">The data.</param>
/// <returns></returns>
public ClaimColumnOptions GetOpenClaimColumnOptionByUserId(ClaimColumnOptions data)
{
// Initialize the Stored Procedure
_databaseCommand = _databaseObj.GetStoredProcCommand("GetOpenClaimColumnOptionByUserId");
_databaseObj.AddInParameter(_databaseCommand, "@UserId", DbType.Int64, data.UserId);
// Retrieve the results of the Stored Procedure
DataSet claimColumnOptionsDataset = _databaseObj.ExecuteDataSet(_databaseCommand);
ClaimColumnOptions claimColumnOptionsModelsList = new ClaimColumnOptions();
if (claimColumnOptionsDataset != null)
{
if (claimColumnOptionsDataset.Tables[0].Rows.Count > 0)
{
DataRow[] dataRows = claimColumnOptionsDataset.Tables[0].Select();
var availableColumnList = dataRows.Select(claimColumns => new ClaimColumnOptions
{
ClaimColumnOptionId = Convert.ToInt32(claimColumns["ClaimColumnOptionId"]),
ColumnName = Convert.ToString(claimColumns["ColumnName"])
}).ToList();
claimColumnOptionsModelsList.AvailableColumnList = availableColumnList;
}
if (claimColumnOptionsDataset.Tables[1].Rows.Count > 0)
{
DataRow[] dataRows = claimColumnOptionsDataset.Tables[1].Select();
var selectedColumnList = dataRows.Select(claimColumns => new ClaimColumnOptions
{
ClaimColumnOptionId = Convert.ToInt32(claimColumns["ClaimColumnOptionId"]),
ColumnName = Convert.ToString(claimColumns["ColumnName"])
}).ToList();
claimColumnOptionsModelsList.SelectedColumnList = selectedColumnList;
}
}
return(claimColumnOptionsModelsList);
}
public JsonResult SaveClaimColumnOptions(string claimColumnOptionIds, int userId)
{
ClaimColumnOptions claimColumnsInfo = new ClaimColumnOptions {
ClaimColumnOptionIds = claimColumnOptionIds, UserId = userId
};
bool claimColumnsSuccess = PostApiResponse <bool>(Constants.JobsData, Constants.SaveClaimColumnOptions, claimColumnsInfo);
return(Json(claimColumnsSuccess));
}
/// <summary>
/// Save Claim Column Options.
/// </summary>
/// <param name="claimColumnsInfo"></param>
/// <returns></returns>
public bool SaveClaimColumnOptions(ClaimColumnOptions claimColumnsInfo)
{
// Initialize the Stored Procedure
_databaseCommand = _databaseObj.GetStoredProcCommand("AddEditOpenClaimColumnByUserId");
_databaseObj.AddInParameter(_databaseCommand, "@SelectedColumn", DbType.String, claimColumnsInfo.ClaimColumnOptionIds);
_databaseObj.AddInParameter(_databaseCommand, "@UserId", DbType.Int64, claimColumnsInfo.UserId);
// Retrieve the results of the Stored Procedure
return(Convert.ToInt32(_databaseObj.ExecuteScalar(_databaseCommand)) > 0);
}
/// <summary>
/// Gets Open Claim Columns By UserId
/// </summary>
/// <param name="claimColumnOptions">The claimColumnOptions.</param>
/// <returns></returns>
public ActionResult OpenClaimColumnOption(ClaimColumnOptionsViewModel claimColumnOptions)
{
ClaimColumnOptions claimColumns = PostApiResponse <ClaimColumnOptions>(Constants.JobsData, Constants.GetOpenClaimColumnOptionByUserId, claimColumnOptions);
ClaimColumnOptionsViewModel claimColumnOptionsInfo = Mapper.Map <ClaimColumnOptions, ClaimColumnOptionsViewModel>(claimColumns);
CommonUtil.ReplaceOpenClaimColumName(claimColumnOptionsInfo);
return(View(claimColumnOptionsInfo));
}
public void GetAdjudicationColumnsByNegativeLoggedInUserId()
{
var jobStatusRepository = new Mock <IJobStatusRepository>();
// Arrange
ClaimColumnOptions claimColumnOptions = new ClaimColumnOptions
{
UserId = 0
};
List <ClaimColumnOptions> availableColumnList = new List <ClaimColumnOptions>
{
new ClaimColumnOptions
{
ClaimColumnOptionId = 0,
ColumnName = ""
}
};
List <ClaimColumnOptions> selectedColumnList = new List <ClaimColumnOptions>
{
new ClaimColumnOptions
{
ClaimColumnOptionId = 0,
ColumnName = ""
}
};
ClaimColumnOptions expectedResult = new ClaimColumnOptions
{
AvailableColumnList = availableColumnList,
SelectedColumnList = selectedColumnList
};
jobStatusRepository.Setup(f => f.GetOpenClaimColumnOptionByUserId(claimColumnOptions)).Returns(expectedResult);
_target = new JobStatusLogic(jobStatusRepository.Object);
//Act
ClaimColumnOptions actual = _target.GetOpenClaimColumnOptionByUserId(claimColumnOptions);
// Assert
Assert.AreEqual(expectedResult.AvailableColumnList, actual.AvailableColumnList);
Assert.AreEqual(expectedResult.SelectedColumnList, actual.SelectedColumnList);
}
public void SaveClaimColumnOptionClaimColumnOptionIdIsNull()
{
var jobStatusRepository = new Mock <IJobStatusRepository>();
// Arrange
ClaimColumnOptions claimColumnsInfo = new ClaimColumnOptions
{
ClaimColumnOptionIds = " ",
UserId = 4178
};
const bool expectedResult = false;
jobStatusRepository.Setup(f => f.SaveClaimColumnOptions(claimColumnsInfo)).Returns(expectedResult);
_target = new JobStatusLogic(jobStatusRepository.Object);
//Act
bool actual = _target.SaveClaimColumnOptions(claimColumnsInfo);
// Assert
Assert.AreEqual(expectedResult, actual);
}
/// <summary>
/// Save Claim Column Options.
/// </summary>
/// <param name="claimColumnsInfo"></param>
/// <returns></returns>
public bool SaveClaimColumnOptions(ClaimColumnOptions claimColumnsInfo)
{
return(_jobsStatusRepository.SaveClaimColumnOptions(claimColumnsInfo));
}
/// <summary>
/// Gets Adjudication Columns By UserId
/// </summary>
/// <param name="data">The data.</param>
/// <returns></returns>
public ClaimColumnOptions GetOpenClaimColumnOptionByUserId(ClaimColumnOptions data)
{
return(_jobsStatusRepository.GetOpenClaimColumnOptionByUserId(data));
}
public ClaimColumnOptions GetOpenClaimColumnOptionByUserId(ClaimColumnOptions data)
{
return(_jobStatusLogic.GetOpenClaimColumnOptionByUserId(data));
}
public bool SaveClaimColumnOptions(ClaimColumnOptions claimColumnsInfo)
{
return(_jobStatusLogic.SaveClaimColumnOptions(claimColumnsInfo));
}
