public RateDAL(ref CodesManager in_CodesManager, int rateScheduleID)
{
this.CodesMngr = in_CodesManager;
this.CodesData = new CodesDAL();
this.PassThrusData = new PassThrusDAL(rateScheduleID);
}
public CodesManager getCodesManager()
{
CodesManager myCodesManager = new CodesManager();
myCodesManager.addCodeList("DRG", getCodeList("DRG"));
myCodesManager.addCodeList("RevCode", getCodeList("RevCode"));
myCodesManager.addCodeList("CPT", getCodeList("CPT"));
myCodesManager.addCodeList("ICD9", getCodeList("ICD9"));
myCodesManager.addCodeList("ICD9D", getCodeList("ICD9D"));
return myCodesManager;
}
public CodesBO getCodes(ref CodesManager codesMngr, int rateID)
{
SqlDataReader sqlDataRdr = base.GetDataReader("SELECT RateCode, RateTypeCode FROM RateCode WHERE (NOT RateTypeCode='PassThru') AND (NOT RateTypeCode='Table') AND RateSeqNum=" + rateID + " ORDER BY RateTypeCode ASC");
CodesBO myCodes = new CodesBO(ref codesMngr);
string codeType = "";
ArrayList codesList = new ArrayList();
bool first = true;
while(sqlDataRdr.Read())
{
if (first)
{
first = false;
codeType = sqlDataRdr["RateTypeCode"].ToString();
codesList.Add(sqlDataRdr["RateCode"]);
}
else if (codeType==sqlDataRdr["RateTypeCode"].ToString())
{
codesList.Add(sqlDataRdr["RateCode"]);
}
else
{
myCodes.addCodes(codeType, codesList);
codesList.Clear();
codeType = sqlDataRdr["RateTypeCode"].ToString();
codesList.Add(sqlDataRdr["RateCode"]);
}
}
if (! (codeType=="") )
{ myCodes.addCodes(codeType, codesList); }
base.CloseConnection();
return myCodes;
}
public CodeTypeBO(ref CodesManager cManager, string in_CodeType, ArrayList in_CodesList)
{
codesMngr = cManager; var_CodeType = in_CodeType; var_CodesList = in_CodesList;
}
public CodeTypeBO(ref CodesManager cManager, string in_CodeType)
{
codesMngr = cManager; var_CodeType = in_CodeType;
}
public CodesBO(ref CodesManager in_codesMngr, int in_RateScheduleID, int in_RateID)
: this(ref in_codesMngr)
{
this.RateID = in_RateID;
this.RateScheduleID = in_RateScheduleID;
}
public CodesBO(ref CodesManager in_codesMngr)
{
this.CodesMngr = in_codesMngr; var_CodesTable = new Hashtable();
}
public Rate_Collection getRates(ref CodesManager codesMngr, int rateScheduleID)
{
// Fill out Rate Collection
DataSet oDataSet = base.GetDataSet("SELECT * FROM Rate WHERE RateSchedSeqNum=" + rateScheduleID);
Rate_Collection Rates = new Rate_Collection();
RateDAL rateData = new RateDAL(ref codesMngr, rateScheduleID);
Rate_ASCRateBO ascRate = new Rate_ASCRateBO();
foreach(DataRow dRow in oDataSet.Tables[0].Rows)
{
// ASC Rates are handled as an exception
if (dRow["RateCatgryDescr"].ToString() == "ASC")
{
switch(dRow["RateTypeDescr"].ToString())
{
case "Main" :
ascRate.ID = Convert.ToInt32(dRow["RateSeqNum"]);
ascRate.RateScheduleID = Convert.ToInt32(dRow["RateSchedSeqNum"]);
ascRate.Name = "ASC Rates";
ascRate.RateCategory = dRow["RateCatgryDescr"].ToString();
ascRate.RateType = dRow["RateTypeDescr"].ToString();
ascRate.GroupTableID = Convert.ToInt16(dRow["RateValue"]);
ascRate.GroupName = dRow["RateName"].ToString();
ascRate.Priority = Convert.ToInt32(dRow["LOSNum"]);
ascRate.Threshold = Convert.ToDouble(dRow["ThreshldNum"]);
if (Convert.ToInt16(dRow["AddtnlDayRate"])==1)
{ ascRate.StandardCPTs = true; }
else
{ ascRate.StandardCPTs = false; }
ascRate.Codes = rateData.CodesData.getCodes(ref codesMngr, ascRate.ID);
break;
case "Group" :
ascRate.addASCRate(dRow["RateName"].ToString(), Convert.ToDouble(dRow["RateValue"]), Convert.ToDouble(dRow["ThreshldNum"]));
break;
case "Rate" :
ascRate.addRateReimbursement(Convert.ToDouble(dRow["RateValue"]));
break;
default: break;
}
}
else // Load rate normally
{ Rates.addRate(rateData.getRate(dRow)); }
}
if ( ! (ascRate.ID==0) )
{ Rates.addRate(ascRate); }
return Rates;
}
public RateScheduleBO getRateSchedule(ref CodesManager codesMngr, int rateScheduleID)
{
RateScheduleBO rateSchedule = getRateScheduleWithoutRates(rateScheduleID);
rateSchedule.Rates = getRates(ref codesMngr, rateScheduleID);
return rateSchedule;
}
