/// <summary>
/// Get Contract Payer Info data
/// </summary>
/// <param name="contractPayerInfoId"></param>
/// <returns>contractPayerInfo</returns>
public ContractPayerInfo GetContractPayerInfo(long contractPayerInfoId)
{
// Initialize the Stored Procedure
_cmd = _db.GetStoredProcCommand("GetPayerInfoById");
// Pass parameters to Stored Procedure(i.e., @ParamName), add values for
_db.AddInParameter(_cmd, "@PayerInfoByID ", DbType.Int64, contractPayerInfoId);
// Retrieve the results of the Stored Procedure
DataTable contractPayerDataTable = _db.ExecuteDataSet(_cmd).Tables[0];
//Map datatable to business objects
if (contractPayerDataTable != null && contractPayerDataTable.Rows != null && contractPayerDataTable.Rows.Count > 0)
{
ContractPayerInfo contractPayerInfo = new ContractPayerInfo
{
ContractPayerInfoId =
Convert.ToInt64(contractPayerDataTable.Rows[0]["ContractInfoId"]),
InsertDate =
DBNull.Value == contractPayerDataTable.Rows[0]["InsertDate"]
? (DateTime?)null
: Convert.ToDateTime(contractPayerDataTable.Rows[0]["InsertDate"]),
UpdateDate =
DBNull.Value == contractPayerDataTable.Rows[0]["UpdateDate"]
? (DateTime?)null
: Convert.ToDateTime(contractPayerDataTable.Rows[0]["UpdateDate"]),
ContractId =
DBNull.Value == contractPayerDataTable.Rows[0]["ContractId"]
? (long?)null
: Convert.ToInt64(contractPayerDataTable.Rows[0]["ContractId"]),
PayerId =
DBNull.Value == contractPayerDataTable.Rows[0]["ContractPayerID"]
? (long?)null
: Convert.ToInt64(
contractPayerDataTable.Rows[0]["ContractPayerID"]),
ContractInfoPayerName =
Convert.ToString(
contractPayerDataTable.Rows[0]["ContractInfoName"]),
MailAddress1 =
Convert.ToString(contractPayerDataTable.Rows[0]["MailAddress1"]),
MailAddress2 =
Convert.ToString(contractPayerDataTable.Rows[0]["MailAddress2"]),
City = Convert.ToString(contractPayerDataTable.Rows[0]["City"]),
State = Convert.ToString(contractPayerDataTable.Rows[0]["State"]),
Zip = Convert.ToString(contractPayerDataTable.Rows[0]["Zip"]),
Phone1 = Convert.ToString(contractPayerDataTable.Rows[0]["Phone1"]),
Phone2 = Convert.ToString(contractPayerDataTable.Rows[0]["Phone2"]),
Fax = Convert.ToString(contractPayerDataTable.Rows[0]["Fax"]),
Email = Convert.ToString(contractPayerDataTable.Rows[0]["Email"]),
Website = Convert.ToString(contractPayerDataTable.Rows[0]["Website"]),
TaxId = Convert.ToString(contractPayerDataTable.Rows[0]["TaxId"]),
Npi = Convert.ToString(contractPayerDataTable.Rows[0]["NPI"]),
Memo = Convert.ToString(contractPayerDataTable.Rows[0]["Memo"]),
ProviderId = Convert.ToString(contractPayerDataTable.Rows[0]["ProvderID"]),
PlanId = Convert.ToString(contractPayerDataTable.Rows[0]["PlanId"])
};
//returns the response to Business layer
return(contractPayerInfo);
}
return(null);
}
/// <summary>
/// Add & Edit Contract Payer Info data
/// </summary>
/// <param name="contractPayerInfo"></param>
/// <returns>return value</returns>
public long AddEditContractPayerInfo(ContractPayerInfo contractPayerInfo)
{
//Checks if input request is not null
if (contractPayerInfo != null)
{
// Initialize the Stored Procedure
_cmd = _db.GetStoredProcCommand("AddEditContractPayerInfo");
// Pass parameters to Stored Procedure(i.e., @ParamName), add values for
_db.AddInParameter(_cmd, "@ContractPayerInfoID", DbType.Int64, contractPayerInfo.ContractPayerInfoId);
_db.AddInParameter(_cmd, "@ContractID", DbType.Int64, contractPayerInfo.ContractId);
_db.AddInParameter(_cmd, "@ContractPayerID", DbType.Int64, contractPayerInfo.PayerId);
_db.AddInParameter(_cmd, "@ContractPayerInfoName", DbType.String, contractPayerInfo.ContractInfoPayerName.ToTrim());
_db.AddInParameter(_cmd, "@MailAddress1", DbType.String, contractPayerInfo.MailAddress1.ToTrim());
_db.AddInParameter(_cmd, "@MailAddress2", DbType.String, contractPayerInfo.MailAddress2.ToTrim());
_db.AddInParameter(_cmd, "@City", DbType.String, contractPayerInfo.City.ToTrim());
_db.AddInParameter(_cmd, "@State", DbType.String, contractPayerInfo.State.ToTrim());
_db.AddInParameter(_cmd, "@Zip", DbType.String, contractPayerInfo.Zip.ToTrim());
_db.AddInParameter(_cmd, "@Phone1", DbType.String, contractPayerInfo.Phone1.ToTrim());
_db.AddInParameter(_cmd, "@Phone2", DbType.String, contractPayerInfo.Phone2.ToTrim());
_db.AddInParameter(_cmd, "@Fax", DbType.String, contractPayerInfo.Fax.ToTrim());
_db.AddInParameter(_cmd, "@Email", DbType.String, contractPayerInfo.Email.ToTrim());
_db.AddInParameter(_cmd, "@Website", DbType.String, contractPayerInfo.Website.ToTrim());
_db.AddInParameter(_cmd, "@TaxID", DbType.String, contractPayerInfo.TaxId.ToTrim());
_db.AddInParameter(_cmd, "@NPI", DbType.String, contractPayerInfo.Npi.ToTrim());
_db.AddInParameter(_cmd, "@Memo", DbType.String, contractPayerInfo.Memo.ToTrim());
_db.AddInParameter(_cmd, "@ProvderID", DbType.String, contractPayerInfo.ProviderId.ToTrim());
_db.AddInParameter(_cmd, "@PlanId", DbType.String, contractPayerInfo.PlanId.ToTrim());
_db.AddInParameter(_cmd, "@UserName", DbType.String, contractPayerInfo.UserName.ToTrim());
// Retrieve the results of the Stored Procedure
long returnValue = long.Parse(_db.ExecuteScalar(_cmd).ToString());
//returns response to Business layer
return(returnValue);
}
return(0);
}
public JsonResult AddContractInfo(ContractInfoViewModel info)
{
ContractPayerInfo payermodel = AutoMapper.Mapper.Map <ContractInfoViewModel, ContractPayerInfo>(info);
//Get the Name of User logged in
payermodel.UserName = GetCurrentUserName();
long id = PostApiResponse <long>("ContractPayerInfo", "AddEditContractPayerInfo", payermodel);
return(Json(new { addedId = id }));
}
public JsonResult DeleteContractInfo(long conrtactPayerInfoId, long contractId)
{
ContractPayerInfo contractPayerInfo = new ContractPayerInfo
{
UserName = GetCurrentUserName(),
ContractPayerInfoId = conrtactPayerInfoId,
ContractId = contractId
};
//Get the UserName logged in
bool isSuccess = PostApiResponse <bool>("ContractPayerInfo", "DeleteContractPayerInfoById", contractPayerInfo);
return(Json(new { sucess = isSuccess }));
}
public void AddEditContractPayerInfoIfNull()
{
Mock <IContractPayerInfoRepository> mockAddEditContractPayerInfo = new Mock <IContractPayerInfoRepository>();
mockAddEditContractPayerInfo.Setup(f => f.AddEditContractPayerInfo(It.IsAny <ContractPayerInfo>())).Returns(1);
ContractPayerInfoLogic target = new ContractPayerInfoLogic(mockAddEditContractPayerInfo.Object);
ContractPayerInfo objAddEditContractPayerInfo = new ContractPayerInfo {
ContractPayerInfoId = 1
};
long actual = target.AddContractPayerInfo(objAddEditContractPayerInfo);
Assert.IsNotNull(actual);
}
public void DeleteContractPayerInfoByIdMockTest1()
{
var mockAddEditContractPayerInfo = new Mock <IContractPayerInfoRepository>();
ContractPayerInfo objAddEditContractPayerInfo = new ContractPayerInfo {
ContractPayerInfoId = 1, UserName = "******"
};
mockAddEditContractPayerInfo.Setup(f => f.DeleteContractPayerInfo(objAddEditContractPayerInfo)).Returns(true);
ContractPayerInfoLogic target = new ContractPayerInfoLogic(mockAddEditContractPayerInfo.Object);
bool actual = target.DeleteContractPayerInfo(objAddEditContractPayerInfo);
Assert.AreEqual(true, actual);
}
public void GetContractPayerInfoMockTest1()
{
ContractPayerInfo objAddEditContractPayerInfo = new ContractPayerInfo {
ContractPayerInfoId = 1
};
var mockAddEditContractPayerInfo = new Mock <IContractPayerInfoRepository>();
mockAddEditContractPayerInfo.Setup(f => f.GetContractPayerInfo(It.IsAny <long>())).Returns(objAddEditContractPayerInfo);
ContractPayerInfoLogic target = new ContractPayerInfoLogic(mockAddEditContractPayerInfo.Object);
ContractPayerInfo actual = target.GetContractPayerInfo(1);
Assert.IsNotNull(actual);
}
/// <summary>
/// Delete Contract Payer Info By ID
/// </summary>
/// <param name="contractPayerInfo"></param>
/// <returns>returnvalue</returns>
public bool DeleteContractPayerInfo(ContractPayerInfo contractPayerInfo)
{
//holds the response data
bool returnvalue = false;
// Initialize the Stored Procedure
_cmd = _db.GetStoredProcCommand("DeleteContractPayerInfoById");
_db.AddInParameter(_cmd, "@contractPayerInfoID", DbType.Int64, contractPayerInfo.ContractPayerInfoId);
_db.AddInParameter(_cmd, "@ContractId", DbType.Int64, contractPayerInfo.ContractId);
_db.AddInParameter(_cmd, "@UserName", DbType.String, contractPayerInfo.UserName.ToTrim());
// Retrieve the results of the Stored Procedure in Datatable
int updatedRow = _db.ExecuteNonQuery(_cmd);
//returns response to Business layer
if (updatedRow > 0)
{
returnvalue = true;
}
//returns false if any exception occurs
return(returnvalue);
}
public JsonResult GetContractInfo(long conrtactPayerInfoId)
{
ContractPayerInfo contractPayerInfo = GetApiResponse <ContractPayerInfo>("ContractPayerInfo", "GetContractPayerInfo", conrtactPayerInfoId);
return(Json(new { data = contractPayerInfo }));
}
/// <summary>
/// Delete Contract Payer Info By ID
/// </summary>
/// <param name="contractPayerInfo"></param>
/// <returns></returns>
public bool DeleteContractPayerInfo(ContractPayerInfo contractPayerInfo)
{
return(_contractInfoRepository.DeleteContractPayerInfo(contractPayerInfo));
}
/// <summary>
/// Add & Edit Contract Payer Info data
/// </summary>
/// <param name="contractPayerInfo"></param>
/// <returns></returns>
public long AddContractPayerInfo(ContractPayerInfo contractPayerInfo)
{
return(_contractInfoRepository.AddEditContractPayerInfo(contractPayerInfo));
}
/// <summary>
/// Get Contract Payer Info data
/// </summary>
/// <param name="contractPayerInfoId"></param>
/// <returns></returns>
public ContractPayerInfo GetContractPayerInfo(long contractPayerInfoId)
{
ContractPayerInfo contractPayerInfo = _contractInfoRepository.GetContractPayerInfo(contractPayerInfoId);
return(contractPayerInfo);
}
public bool DeleteContractPayerInfoById(ContractPayerInfo contractPayerInfo)
{
return(_contractLogic.DeleteContractPayerInfo(contractPayerInfo));
}
public long AddEditContractPayerInfo(ContractPayerInfo contractPayerInfo)
{
return(_contractLogic.AddContractPayerInfo(contractPayerInfo));
}
