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