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 WeightTableStruct getWeightTable(int rateID)
{
SqlDataReader sqlDataRdr = base.GetDataReader("SELECT RateCode, RateTypeCode FROM RateCode WHERE RateTypeCode='Table' AND RateSeqNum=" + rateID + " ORDER BY RateTypeCode ASC");
WeightTableStruct weightTable = new WeightTableStruct(1, "DEFAULT");
if(sqlDataRdr.Read())
{
weightTable.TableID = Convert.ToInt16(sqlDataRdr["RateCode"]);
sqlDataRdr = base.GetDataReader("SELECT DRGWgtName FROM DRGWgtID WHERE DRGWgtIDSeqNum=" + weightTable.TableID);
if (sqlDataRdr.Read())
{ weightTable.TableName = sqlDataRdr["DRGWgtName"].ToString(); }
}
base.CloseConnection();
return weightTable;
}
public void setRate(int id, int in_RateScheduleID, string in_RateName, string in_RateCategory, string in_RateType, char in_InOut, CodesBO in_RateCodes, double in_Rate, int in_DRG_WgtTableID, string in_DRG_WgtTableName)
{
this.setMainRate(id, in_RateScheduleID, in_RateName, in_RateCategory, in_RateType, in_InOut, in_RateCodes);
this.Rate = in_Rate;
this.WeightTable = new WeightTableStruct(in_DRG_WgtTableID, in_DRG_WgtTableName);
}
