public void deleteRateSchedule(int rateScheduleID)
{
SqlParameter[] sqlParams;
SqlDataReader sqlDataRdr = base.GetDataReader("SELECT * FROM Contrct_RateSched WHERE RateSchedSeqNum=" + rateScheduleID);
sqlParams = base.GetParameters("DeleteContrct_RateSched");
while (sqlDataRdr.Read())
{
sqlParams[0].Value = sqlDataRdr["ContrctIDNum"];
sqlParams[1].Value = rateScheduleID;
base.ExecuteDelete("DeleteContrct_RateSched", sqlParams);
}
sqlParams = base.GetParameters("DeleteRateAll");
sqlParams[0].Value = rateScheduleID;
base.ExecuteDelete("DeleteRateAll", sqlParams);
CoverageDAL coverageData = new CoverageDAL();
coverageData.deleteCoverage(rateScheduleID);
sqlParams = base.GetParameters("DeleteRateSched");
sqlParams[0].Value = rateScheduleID;
base.ExecuteDelete("DeleteRateSched", sqlParams);
}
public CoverageForm(RMS_Controller in_RmsController)
{
InitializeComponent(); // Required for Windows Form Designer support
rmsController = in_RmsController;
data = new BaseDALObject();
coverage = new CoverageDAL();
// Setup UI
setupStatusComboBox();
RateScheduleDAL rateScheduleData = new RateScheduleDAL();
rateSchedule = rateScheduleData.getRateScheduleWithoutRates(rmsController.RateScheduleID);
rateScheduleNameBx.Text = rateSchedule.RateScheduleName;
startDateBx.Text = rateSchedule.Coverage.StartDate.ToString();
endDateBx.Text = rateSchedule.Coverage.EndDate.ToString();
for(int k=0; k<statusTypeComboBx.Items.Count; k++)
{
if (statusTypeComboBx.Items[k].ToString() == rateSchedule.Status)
{ statusTypeComboBx.SelectedItem = statusTypeComboBx.Items[k]; }
}
// Setup Entity List
setupEntityListBox();
}
public RateScheduleBO getRateScheduleWithoutRates(int rateScheduleID)
{
// Fill out Rate Schedule info
SqlDataReader sqlDataRdr = base.GetDataReader("SELECT * FROM RateSched WHERE RateSchedSeqNum=" + rateScheduleID);
RateScheduleBO rateSchedule = new RateScheduleBO();
if (sqlDataRdr.Read())
{
rateSchedule.ID = rateScheduleID;
rateSchedule.RateScheduleName = sqlDataRdr["RateSchedName"].ToString();
rateSchedule.Status = sqlDataRdr["StatusTypeCode"].ToString();
CoverageDAL coverageData = new CoverageDAL();
rateSchedule.Coverage = coverageData.getRateScheduleCoverage(rateScheduleID);
}
return rateSchedule;
}
