public ActionResult PaymentTypeAscFeeSchedule(long?contractId, long?serviceTypeId, int paymentTypeId, bool isEdit)
{
PaymentTypeAscFeeScheduleViewModel paymentTypeAscFeeScheduleViewModel = new PaymentTypeAscFeeScheduleViewModel();
List <AscFeeScheduleOption> ascFeeScheduleOptions =
GetApiResponse <List <AscFeeScheduleOption> >(Constants.PaymentTypeAscFeeSchedule, Constants.GetAscFeeScheduleOptions);
List <AscFeeScheduleOptionViewModel> ascFeeScheduleOptionsData =
AutoMapper.Mapper.Map <List <AscFeeScheduleOption>, List <AscFeeScheduleOptionViewModel> >(ascFeeScheduleOptions);
if (isEdit)
{
PaymentTypeAscFeeSchedule paymentTypeAscFeeScheduleDetails = new PaymentTypeAscFeeSchedule
{
ServiceTypeId = serviceTypeId,
ContractId = contractId,
PaymentTypeId = paymentTypeId,
UserName = GetCurrentUserName()
};
PaymentTypeAscFeeSchedule paymentTypeAscFeeScheduleViewModelInfo =
PostApiResponse <PaymentTypeAscFeeSchedule>(Constants.PaymentTypeAscFeeSchedule,
"GetPaymentTypeAscFeeSchedule",
paymentTypeAscFeeScheduleDetails);
paymentTypeAscFeeScheduleViewModel = AutoMapper.Mapper.Map <PaymentTypeAscFeeSchedule, PaymentTypeAscFeeScheduleViewModel>(paymentTypeAscFeeScheduleViewModelInfo);
}
paymentTypeAscFeeScheduleViewModel.ContractId = contractId;
paymentTypeAscFeeScheduleViewModel.ServiceTypeId = serviceTypeId;
paymentTypeAscFeeScheduleViewModel.PaymentTypeId = paymentTypeId;
paymentTypeAscFeeScheduleViewModel.IsEdit = isEdit;
paymentTypeAscFeeScheduleViewModel.AscFeeScheduleOption = ascFeeScheduleOptionsData;
return(View(paymentTypeAscFeeScheduleViewModel));
}
/// <summary>
/// AddEdit PaymentType ASC Fee Schedule Details
/// </summary>
/// <param name="paymentTypeAscFeeSchedule"></param>
/// <returns></returns>
public long AddEditPaymentTypeAscFeeScheduleDetails(PaymentTypeAscFeeSchedule paymentTypeAscFeeSchedule)
{
long paymentTypeAscFeeScheduleId = 0;
//Checks if input request is not null
if (paymentTypeAscFeeSchedule != null)
{
// ReSharper disable once InconsistentNaming
// Initialize the Stored Procedure
_databaseCommandObj = _databaseObj.GetStoredProcCommand("AddEditASCFeeSchedulePayment");
// Pass parameters to Stored Procedure(i.e., @ParamName), add values for
_databaseObj.AddInParameter(_databaseCommandObj, "@PaymentTypeDetailID", DbType.Int64, paymentTypeAscFeeSchedule.PaymentTypeDetailId);
_databaseObj.AddInParameter(_databaseCommandObj, "@Primary ", DbType.Decimal, paymentTypeAscFeeSchedule.Primary);
_databaseObj.AddInParameter(_databaseCommandObj, "@Secondary ", DbType.Decimal, paymentTypeAscFeeSchedule.Secondary);
_databaseObj.AddInParameter(_databaseCommandObj, "@Tertiary ", DbType.Decimal, paymentTypeAscFeeSchedule.Tertiary);
_databaseObj.AddInParameter(_databaseCommandObj, "@Quaternary ", DbType.Decimal, paymentTypeAscFeeSchedule.Quaternary);
_databaseObj.AddInParameter(_databaseCommandObj, "@Others ", DbType.Decimal, paymentTypeAscFeeSchedule.Others);
_databaseObj.AddInParameter(_databaseCommandObj, "@NonFeeSchedule ", DbType.Decimal, paymentTypeAscFeeSchedule.NonFeeSchedule);
_databaseObj.AddInParameter(_databaseCommandObj, "@PaymentTypeID ", DbType.Int64, paymentTypeAscFeeSchedule.PaymentTypeId);
_databaseObj.AddInParameter(_databaseCommandObj, "@ContractID", DbType.Int64, paymentTypeAscFeeSchedule.ContractId);
_databaseObj.AddInParameter(_databaseCommandObj, "@ContractServiceTypeID", DbType.Int64, paymentTypeAscFeeSchedule.ServiceTypeId);
_databaseObj.AddInParameter(_databaseCommandObj, "@ClaimFieldDocID", DbType.Int64, paymentTypeAscFeeSchedule.ClaimFieldDocId);
_databaseObj.AddInParameter(_databaseCommandObj, "@SelectedOption", DbType.Int64, paymentTypeAscFeeSchedule.OptionSelection);
_databaseObj.AddInParameter(_databaseCommandObj, "@UserName", DbType.String, paymentTypeAscFeeSchedule.UserName);
// Retrieve the results of the Stored Procedure in Datatable
paymentTypeAscFeeScheduleId = long.Parse(_databaseObj.ExecuteScalar(_databaseCommandObj).ToString());
}
//returns 0 if any exception occurs. Else returns the result to business layer
return(paymentTypeAscFeeScheduleId);
}
/// <summary>
/// Gets the payment type fee schedules.
/// </summary>
/// <param name="contractServiceTypeId">The contract service type identifier.</param>
/// <param name="feeScheduleTable">The dt fee schedule table.</param>
/// <param name="doc">The dt document.</param>
/// <param name="docValues">The dt document values.</param>
/// <returns></returns>
public static PaymentTypeAscFeeSchedule GetPaymentType(long contractServiceTypeId, DataTable feeScheduleTable, DataTable doc, DataTable docValues)
{
PaymentTypeAscFeeSchedule paymentTypeAscFeeSchedule = null;
if (feeScheduleTable != null && feeScheduleTable.Rows.Count > 0)
{
paymentTypeAscFeeSchedule = (from DataRow row in feeScheduleTable.Rows
where (Convert.ToInt64(DBNull.Value == row["ContractServiceTypeID"]
? (long?)null
: Convert.ToInt64(
row["ContractServiceTypeID"])) == contractServiceTypeId)
select new PaymentTypeAscFeeSchedule
{
Primary = DBNull.Value == row["Primary"]
? (double?)null
: Convert.ToDouble(row["Primary"]),
Secondary = DBNull.Value == row["Secondary"]
? (double?)null
: Convert.ToDouble(
row["Secondary"]),
Tertiary = DBNull.Value == row["Tertiary"]
? (double?)null
: Convert.ToDouble(row["Tertiary"]),
Quaternary = DBNull.Value == row["Quaternary"]
? (double?)null
: Convert.ToDouble(
row["Quaternary"]),
Others = DBNull.Value == row["Others"]
? (double?)null
: Convert.ToDouble(row["Others"]),
NonFeeSchedule = DBNull.Value == row["NonFeeSchedule"]
? (double?)null
: Convert.ToDouble(row["NonFeeSchedule"]),
ClaimFieldDocId =
Convert.ToInt64(row["ClaimFieldDocID"]),
ContractId = DBNull.Value == row["ContractId"]
? (long?)null
: Convert.ToInt64(
row["ContractId"]),
ServiceTypeId = DBNull.Value ==
row["ContractServiceTypeID"]
? (long?)null
: Convert.ToInt64(
row["ContractServiceTypeID"]),
PaymentTypeId = (byte)Enums.PaymentTypeCodes.AscFeeSchedule,
ClaimFieldDoc = GetClaimFieldDoc(
Convert.ToInt64(row["ClaimFieldDocID"]), doc, docValues),
OptionSelection = Convert.ToInt32(row["SelectedOption"])
}).FirstOrDefault();
}
return(paymentTypeAscFeeSchedule);
}
public JsonResult AddEditPaymentTypeAscFee(PaymentTypeAscFeeScheduleViewModel ascFeeScheduleInfo)
{
long ascFeeScheduleId = 0;
if (ascFeeScheduleInfo.ClaimFieldDocId != null)
{
PaymentTypeAscFeeSchedule ascFeeSchedule =
AutoMapper.Mapper.Map <PaymentTypeAscFeeScheduleViewModel, PaymentTypeAscFeeSchedule>(
ascFeeScheduleInfo);
//Get the Name of User logged in
ascFeeSchedule.UserName = GetCurrentUserName();
ascFeeScheduleId = PostApiResponse <long>(Constants.PaymentTypeAscFeeSchedule,
Constants.AddEditPaymentTypeAscFeeSchedule, ascFeeSchedule);
}
return(ascFeeScheduleId > 0 ? Json(new { sucess = true, documentId = ascFeeScheduleInfo.ClaimFieldDocId }) : Json(new { sucess = false, documentId = ascFeeScheduleInfo.ClaimFieldDocId }));
}
/// <summary>
/// Get TableName Selection basing on claimFieldId & contractId
/// </summary>
public JsonResult GetTableNames(long paymentTypeId, string userText)
{
PaymentTypeAscFeeSchedule modelPaymentTypeAscFeeSchedule = new PaymentTypeAscFeeSchedule
{
FacilityId = GetCurrentFacilityId(),
UserName = GetCurrentUserName(),
UserText = userText
};
switch ((Enums.PaymentTypeCodes)paymentTypeId)
{
case Enums.PaymentTypeCodes.AscFeeSchedule:
modelPaymentTypeAscFeeSchedule.ClaimFieldId = EnumHelperLibrary.GetFieldInfoFromEnum(Enums.ClaimFieldTypes.AscFeeSchedule).FieldIdentityNumber;
break;
case Enums.PaymentTypeCodes.DrgPayment:
modelPaymentTypeAscFeeSchedule.ClaimFieldId = EnumHelperLibrary.GetFieldInfoFromEnum(Enums.ClaimFieldTypes.DrgWeightTable).FieldIdentityNumber;
break;
case Enums.PaymentTypeCodes.FeeSchedule:
modelPaymentTypeAscFeeSchedule.ClaimFieldId = EnumHelperLibrary.GetFieldInfoFromEnum(Enums.ClaimFieldTypes.FeeSchedule).FieldIdentityNumber;
break;
case Enums.PaymentTypeCodes.CustomTableFormulas:
modelPaymentTypeAscFeeSchedule.ClaimFieldId =
EnumHelperLibrary.GetFieldInfoFromEnum(Enums.ClaimFieldTypes.CustomPaymentType)
.FieldIdentityNumber;
break;
default:
modelPaymentTypeAscFeeSchedule.ClaimFieldId = EnumHelperLibrary.GetFieldInfoFromEnum(Enums.ClaimFieldTypes.None).FieldIdentityNumber;
break;
}
List <PaymentTypeTableSelection> paymentTypeTableSelection = PostApiResponse <List <PaymentTypeTableSelection> >("PaymentTypeASCFeeSchedule", "GetTableNameSelection", modelPaymentTypeAscFeeSchedule);
List <SelectListItem> paymentTableSelection = new List <SelectListItem>();
if (paymentTypeTableSelection != null && paymentTypeTableSelection.Count > 0)
{
paymentTableSelection.AddRange(paymentTypeTableSelection.Select(item => new SelectListItem {
Text = item.TableName, Value = item.ClaimFieldDocId.ToString(CultureInfo.InvariantCulture)
}));
}
return(Json(paymentTableSelection, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Get PaymentType ASC Fee Schedule Details
/// </summary>
/// <param name="paymentTypeAscFeeSchedule"></param>
/// <returns></returns>
public PaymentTypeAscFeeSchedule GetPaymentTypeAscFeeScheduleDetails(PaymentTypeAscFeeSchedule paymentTypeAscFeeSchedule)
{
// Initialize the Stored Procedure
_databaseCommandObj = _databaseObj.GetStoredProcCommand("GetServiceLinesandPaymentTypes");
// Pass parameters to Stored Procedure(i.e., @ParamName), add values for
_databaseObj.AddInParameter(_databaseCommandObj, "@PaymentTypeID ", DbType.Int64, paymentTypeAscFeeSchedule.PaymentTypeId);
_databaseObj.AddInParameter(_databaseCommandObj, "@ContractID", DbType.Int64, paymentTypeAscFeeSchedule.ContractId);
_databaseObj.AddInParameter(_databaseCommandObj, "@ContractServiceTypeID", DbType.Int64, paymentTypeAscFeeSchedule.ServiceTypeId);
_databaseObj.AddInParameter(_databaseCommandObj, "@ServiceLineTypeId", DbType.Int64, 0);
_databaseObj.AddInParameter(_databaseCommandObj, "@UserName", DbType.String, paymentTypeAscFeeSchedule.UserName);
// Retrieve the results of the Stored Procedure in Datatable
DataSet paymentTypeDetails = _databaseObj.ExecuteDataSet(_databaseCommandObj);
if (paymentTypeDetails != null && paymentTypeDetails.Tables.Count > 0)
{
var paymentTypeInfo = paymentTypeDetails.Tables[0];
//populating ContractBasicInfo data
if (paymentTypeInfo.Rows != null && paymentTypeInfo.Rows.Count > 0)
{
PaymentTypeAscFeeSchedule ascFeeSchedule = new PaymentTypeAscFeeSchedule
{
Primary = DBNull.Value == paymentTypeInfo.Rows[0]["Primary"] ? (double?)null : Convert.ToDouble(paymentTypeInfo.Rows[0]["Primary"]),
Secondary = DBNull.Value == paymentTypeInfo.Rows[0]["Secondary"] ? (double?)null : Convert.ToDouble(paymentTypeInfo.Rows[0]["Secondary"]),
Tertiary = DBNull.Value == paymentTypeInfo.Rows[0]["Tertiary"] ? (double?)null : Convert.ToDouble(paymentTypeInfo.Rows[0]["Tertiary"]),
Quaternary = DBNull.Value == paymentTypeInfo.Rows[0]["Quaternary"] ? (double?)null : Convert.ToDouble(paymentTypeInfo.Rows[0]["Quaternary"]),
Others = DBNull.Value == paymentTypeDetails.Tables[0].Rows[0]["Others"] ? (double?)null : Convert.ToDouble(paymentTypeDetails.Tables[0].Rows[0]["Others"]),
NonFeeSchedule = DBNull.Value == paymentTypeInfo.Rows[0]["NonFeeSchedule"] ? (double?)null : Convert.ToDouble(paymentTypeInfo.Rows[0]["NonFeeSchedule"]),
ClaimFieldDocId = DBNull.Value == paymentTypeInfo.Rows[0]["ClaimFieldDocID"] ? (long?)null : Convert.ToInt64(paymentTypeInfo.Rows[0]["ClaimFieldDocID"]),
PaymentTypeDetailId = Convert.ToInt64(paymentTypeInfo.Rows[0]["PaymentTypeDetailID"]),
OptionSelection = Convert.ToInt32(paymentTypeInfo.Rows[0]["SelectedOption"])
};
//returns response to Business layer
return(ascFeeSchedule);
}
}
//if any exception occurs, returns null to Business layer
return(null);
}
public JsonResult GetTableNameSelection(long paymentTypeId, long?nodeId)
{
PaymentTypeAscFeeSchedule paymentTypeAscFeeSchedule = new PaymentTypeAscFeeSchedule();
switch ((Enums.PaymentTypeCodes)paymentTypeId)
{
case Enums.PaymentTypeCodes.AscFeeSchedule:
paymentTypeAscFeeSchedule.ClaimFieldId = EnumHelperLibrary.GetFieldInfoFromEnum(Enums.ClaimFieldTypes.AscFeeSchedule).FieldIdentityNumber;
break;
case Enums.PaymentTypeCodes.DrgPayment:
paymentTypeAscFeeSchedule.ClaimFieldId = EnumHelperLibrary.GetFieldInfoFromEnum(Enums.ClaimFieldTypes.DrgWeightTable).FieldIdentityNumber;
break;
case Enums.PaymentTypeCodes.FeeSchedule:
paymentTypeAscFeeSchedule.ClaimFieldId = EnumHelperLibrary.GetFieldInfoFromEnum(Enums.ClaimFieldTypes.FeeSchedule).FieldIdentityNumber;
break;
case Enums.PaymentTypeCodes.CustomTableFormulas:
paymentTypeAscFeeSchedule.ClaimFieldId = EnumHelperLibrary.GetFieldInfoFromEnum(Enums.ClaimFieldTypes.CustomPaymentType).FieldIdentityNumber;
break;
}
paymentTypeAscFeeSchedule.NodeId = nodeId;
//Get the Name of User logged in
paymentTypeAscFeeSchedule.UserName = GetCurrentUserName();
List <PaymentTypeTableSelection> paymentTypeTableSelection = PostApiResponse <List <PaymentTypeTableSelection> >(Constants.PaymentTypeAscFeeSchedule, Constants.GetTableNameSelection, paymentTypeAscFeeSchedule);
List <SelectListItem> paymentTableSelection = new List <SelectListItem>();
if (paymentTypeTableSelection != null && paymentTypeTableSelection.Count > 0)
{
paymentTableSelection.AddRange(paymentTypeTableSelection.Select(item => new SelectListItem {
Text = item.TableName, Value = Convert.ToString(item.ClaimFieldDocId)
}));
}
return(Json(new { tableSelectionList = paymentTableSelection }));
}
/// <summary>
/// Gets all TableName list.
/// </summary>
/// <returns>List of Table Names</returns>
public List <PaymentTypeTableSelection> GetTableNameSelection(PaymentTypeAscFeeSchedule paymenttype)
{
List <PaymentTypeTableSelection> tableNameSelection = new List <PaymentTypeTableSelection>();
_databaseCommandObj = _databaseObj.GetStoredProcCommand("GetASCTableNames");
_databaseObj.AddInParameter(_databaseCommandObj, "@FacilityId", DbType.Int32, paymenttype.FacilityId);
_databaseObj.AddInParameter(_databaseCommandObj, "@ClaimFieldId", DbType.Int32, paymenttype.ClaimFieldId);
_databaseObj.AddInParameter(_databaseCommandObj, "@UserText", DbType.String, paymenttype.UserText);
DataSet tableNamesDetails = _databaseObj.ExecuteDataSet(_databaseCommandObj);
if (tableNamesDetails.IsTableDataPopulated(0))
{
tableNameSelection = (from DataRow row in tableNamesDetails.Tables[0].Rows
select new PaymentTypeTableSelection
{
ClaimFieldDocId =
long.Parse(row["ClaimFieldDocID"].ToString()),
TableName = Convert.ToString(row["TableName"])
}).ToList();
}
//returns response to Business layer
return(tableNameSelection);
}
public List <PaymentTypeTableSelection> GetTableNameSelection(PaymentTypeAscFeeSchedule paymenttype)
{
return(_paymentTypeAscFeeScheduleLogic.GetTableNameSelection(paymenttype));
}
public PaymentTypeAscFeeSchedule GetPaymentTypeAscFeeSchedule(PaymentTypeAscFeeSchedule paymentTypeAscFeeSchedule)
{
return((PaymentTypeAscFeeSchedule)_paymentTypeAscFeeScheduleLogic.GetPaymentType(paymentTypeAscFeeSchedule));
}
public long AddEditPaymentTypeAscFeeSchedule(PaymentTypeAscFeeSchedule paymentTypeAscFeeSchedule)
{
return(_paymentTypeAscFeeScheduleLogic.AddEditPaymentType(paymentTypeAscFeeSchedule));
}
public List <PaymentTypeTableSelection> GetTableNameSelection(PaymentTypeAscFeeSchedule paymentTypeAscFeeSchedule)
{
return(_paymentTypeAscFeeScheduleDetailsRepository.GetTableNameSelection(paymentTypeAscFeeSchedule));
}