public override void loadRate(RateBO rateToLoad)
{
Rate_PassThruBO passThruRate = (Rate_PassThruBO) rateToLoad;
rateBx.Text = Convert.ToString(passThruRate.Rate);
thresholdBx.Text = Convert.ToString(passThruRate.Threshold);
}
public override void loadRate(RateBO rateToLoad)
{
Rate_FFS_Out_CaseRateBO caseRate = (Rate_FFS_Out_CaseRateBO) rateToLoad;
caseRateBx.Text = caseRate.Rate.ToString();
priorityBx.Text = caseRate.Priority.ToString();
}
public override void loadRate(RateBO rateToLoad)
{
Rate_FFS_In_CaseRateBO caseRate = (Rate_FFS_In_CaseRateBO) rateToLoad;
rateBx.Text = Convert.ToString(caseRate.Rate);
losBx.Text = Convert.ToString(caseRate.LOS);
addDayBx.Text = Convert.ToString(caseRate.AddtnlDayRate);
}
public override void loadRate(RateBO rateToLoad)
{
Rate_StopLossBO stopLoss = (Rate_StopLossBO) rateToLoad;
thresholdBx.Text = Convert.ToString(stopLoss.Threshold);
pocBx.Text = Convert.ToString(stopLoss.POC);
dailyCapBx.Text = Convert.ToString(stopLoss.DailyCap);
}
public void deleteRate(RateBO rate)
{
SqlParameter[] sqlParams = base.GetParameters("DeleteRateCodeAll");
// RateSeqNum
sqlParams[fld_RateSeqNum].Value = rate.ID;
base.ExecuteDelete("DeleteRateCodeAll", sqlParams);
}
public override void loadRate(RateBO rateToLoad)
{
Rate_BaseRateBO baseRate = (Rate_BaseRateBO) rateToLoad;
rateBx.Text = Convert.ToString(baseRate.Rate);
WeightTableStruct weightTable;
for(int k=0; k<drgWgtComboBx.Items.Count; k++)
{
weightTable = (WeightTableStruct) drgWgtComboBx.Items[k];
if (weightTable.TableID == baseRate.WeightTable.TableID)
{ drgWgtComboBx.SelectedIndex = k; }
}
}
public override void loadRate(RateBO rateToLoad)
{
Rate_CeilingBO ceiling = (Rate_CeilingBO) rateToLoad;
pocBx.Text = Convert.ToString(ceiling.Rate);
}
public override void loadRate(RateBO rateToLoad)
{
Rate_PerDiemBO perDiem = (Rate_PerDiemBO) rateToLoad;
rateBx.Text = Convert.ToString(perDiem.Rate);
}
public override void loadRate(RateBO rateToLoad)
{
Rate_FFS_POCBO caseRate = (Rate_FFS_POCBO) rateToLoad;
rateBx.Text = Convert.ToString(caseRate.Rate);
}
public int updateRate(RateBO rate)
{
SqlParameter[] sqlParams = base.GetParameters("UpdateRate");
RateDataRow inputRow = rate.getRateAsRateDataRow();
// RateSeqNum
if (inputRow.RateID==0)
{ sqlParams[fld_RateSeqNum].Value = null; }
else
{ sqlParams[fld_RateSeqNum].Value = inputRow.RateID; }
// RateSchedSeqNum
sqlParams[fld_RateSchedSeqNum].Value = inputRow.RateScheduleID;
// AddtnlDayRate
sqlParams[fld_AddtnlDayRate].Value = inputRow.AddtnlDayRate;
// InOutPatientInd
sqlParams[fld_InOutPatientInd].Value = inputRow.InOut;
// RateName
sqlParams[fld_RateName].Value = inputRow.Name;
// RateCatgryDescr
sqlParams[fld_RateCatgryDescr].Value = inputRow.RateCategory;
// RateTypeDescr
sqlParams[fld_RateTypeDescr].Value = inputRow.RateType;
// RateValue
sqlParams[fld_RateValue].Value = inputRow.Rate;
// LOS
sqlParams[fld_LOSNum].Value = inputRow.LOS;
// Threshold
sqlParams[fld_ThreshldNum].Value = inputRow.Threshold;
base.ExecuteUpdate("UpdateRate", sqlParams);
int rateID = Convert.ToInt16(sqlParams[fld_RateSeqNum].Value);
rate.ID = rateID;
rate.Codes.RateID = rateID;
rate.Codes.RateScheduleID = rate.RateScheduleID;
this.CodesData.insertCodes(rate.Codes);
if (rate.HasPassThrus)
{
this.PassThrusData.insertPassThrus( ((Rate_W_PassThruBO) rate).PassThrus, rate);
}
if (inputRow.RateCategory=="BaseRate")
{
this.CodesData.insertWeightTable(rate, ((Rate_BaseRateBO) rate).WeightTable);
}
return rateID;
}
public int insertRate(RateBO rate)
{
return updateRate(rate);
}
public void insertWeightTable(RateBO rate, WeightTableStruct weightTable)
{
SqlParameter[] sqlParams;
SqlDataReader sqlDataRdr = base.GetDataReader("SELECT * FROM RateCode WHERE RateTypeCode='Table' AND RateSeqNum=" + rate.ID);
sqlParams = base.GetParameters("DeleteRateCode");
while(sqlDataRdr.Read())
{
sqlParams[fld_RateCodeSeqNum].Value = sqlDataRdr["RateCodeSeqNum"];
sqlParams[fld_RateSeqNum].Value = sqlDataRdr["RateSeqNum"];
sqlParams[fld_RateSchedSeqNum].Value = sqlDataRdr["RateSchedSeqNum"];
base.ExecuteDelete("DeleteRateCode", sqlParams);
}
base.CloseConnection();
sqlParams = base.GetParameters("UpdateRateCode");
sqlParams[fld_RateCodeSeqNum].Value = null;
sqlParams[fld_RateSeqNum].Value = rate.ID;
sqlParams[fld_RateSchedSeqNum].Value = rate.RateScheduleID;
sqlParams[fld_RateCode].Value = weightTable.TableID;
sqlParams[fld_RateTypeCode].Value = "Table";
base.ExecuteUpdate("UpdateRateCode", sqlParams);
}
public void updatePassThrus(PassThrusBO passThrus, RateBO rate)
{
SqlParameter[] sqlParams;
ArrayList passThrusList = passThrus.getArrayListOfPassThrus();
ArrayList passThrusCodeList = new ArrayList();
PassThruStruct passThru;
for(int k=0; k<passThrusList.Count; k++)
{
passThru = (PassThruStruct) passThrusList[k];
if ( (passThru.RateName=="All") || (passThru.RateName=="None") )
{ passThrusCodeList.Add(passThru.RateName); }
else
{ passThrusCodeList.Add(passThru.RateID.ToString()); }
}
DataSet oDataSet = base.GetDataSet("SELECT * FROM RateCode WHERE RateTypeCode='PassThru' AND RateSeqNum=" + rate.ID);
sqlParams = base.GetParameters("DeleteRateCode");
foreach(DataRow dRow in oDataSet.Tables[0].Rows)
{
if (! passThrusCodeList.Contains(dRow["RateCode"].ToString()) )
{
sqlParams[0].Value = dRow["RateCodeSeqNum"];
sqlParams[1].Value = dRow["RateSeqNum"];
sqlParams[2].Value = dRow["RateSchedSeqNum"];
base.ExecuteDelete("DeleteRateCode", sqlParams);
}
else
{ passThrusCodeList.Remove(dRow["RateCode"].ToString()); }
}
sqlParams = base.GetParameters("UpdateRateCode");
for(int k=0; k<passThrusCodeList.Count; k++)
{
foreach(SqlParameter sqlParam in sqlParams)
{
switch(sqlParam.ParameterName)
{
case "@RateCodeSeqNum" : sqlParam.Value = DBNull.Value; break;
case "@RateSeqNum" : sqlParam.Value = rate.ID; break;
case "@RateSchedSeqNum" : sqlParam.Value = rate.RateScheduleID; break;
case "@RateTypeCode" : sqlParam.Value = "PassThru"; break;
case "@RateCode" : sqlParam.Value = passThrusCodeList[k].ToString(); break;
default : break;
}
}
base.ExecuteUpdate("UpdateRateCode", sqlParams);
}
}
public void insertPassThrus(PassThrusBO passThrus, RateBO rate)
{
updatePassThrus(passThrus, rate);
}
public abstract void loadRate(RateBO rateToLoad);
public override void loadRate(RateBO rateToLoad)
{
}
public override void loadRate(RateBO rateToLoad)
{
Rate_FloorBO floor = (Rate_FloorBO) rateToLoad;
pocBx.Text = Convert.ToString(floor.Rate);
}
