public ContractBO getContract(int id)
{
SqlDataReader sqlDataRdr = this.GetDataReader("SELECT ContrctIDNum, ContrctIDDescr FROM ContrctID WHERE ContrctIDNum=" + id);
ContractBO contractToReturn;
if (sqlDataRdr.Read())
{
contractToReturn = new ContractBO((int)sqlDataRdr["ContrctIDNum"], sqlDataRdr["ContrctIDDescr"].ToString());
}
else
{ contractToReturn = new ContractBO(); }
sqlDataRdr = this.GetDataReader("SELECT RateSched.RateSchedSeqNum as RateSchedSeqNum, RateSchedName FROM Contrct_RateSched, RateSched WHERE Contrct_RateSched.RateSchedSeqNum=RateSched.RateSchedSeqNum AND ContrctIDNum=" + id);
while(sqlDataRdr.Read())
{
contractToReturn.addRateSchedule(Convert.ToInt16(sqlDataRdr["RateSchedSeqNum"]), sqlDataRdr["RateSchedName"].ToString());
}
this.CloseConnection();
return contractToReturn;
}
public void deleteContract(ContractBO contract)
{
SqlParameter[] sqlParams;
sqlParams = base.GetParameters("DeleteContrct_RateSched");
RateScheduleDAL rateScheduleData = new RateScheduleDAL();
for(int k=0; k<contract.rateScheduleCount(); k++)
{
sqlParams[fld_Contrct_RateSched_ContrctIDNum].Value = contract.ID;
sqlParams[fld_Contrct_RateSched_RateSchedSeqNum].Value = ((RateScheduleStruct) contract.getRateScheduleAt(k)).ID;
base.ExecuteDelete("DeleteContrct_RateSched", sqlParams);
rateScheduleData.deleteRateSchedule(((RateScheduleStruct) contract.getRateScheduleAt(k)).ID);
}
sqlParams = base.GetParameters("DeleteContrctID");
sqlParams[fld_ContrctIDNum].Value = contract.ID;
base.ExecuteDelete("DeleteContrctID", sqlParams);
}
private void setBtn_Click(object sender, System.EventArgs e)
{
ContractBO newContract = new ContractBO();
newContract.ContractName = contractNameBx.Text;
ContractDAL contractData = new ContractDAL();
int contractID = contractData.insertContract(newContract);
RateScheduleBO rateSchedule = new RateScheduleBO();
rateSchedule.ContractID = contractID;
rateSchedule.RateScheduleName = contractNameBx.Text;
rateSchedule.Coverage.StartDate = System.DateTime.Today;
rateSchedule.Coverage.EndDate = System.DateTime.Today;
// Add by default to Development
rateSchedule.Status = "3";
RateScheduleDAL rateScheduleData = new RateScheduleDAL();
rateScheduleData.insertRateSchedule(rateSchedule);
ContractAdded(this, EventArgs.Empty);
this.Close();
}
public Contract_Collection getContractsByStatusType(string statusType)
{
SqlDataReader sqlDataRdr= this.GetDataReader("SELECT ContrctID.ContrctIDNum as ContrctIDNum, ContrctID.ContrctIDDescr as ContrctIDDescr, RateSched.RateSchedSeqNum as RateSchedSeqNum, RateSchedName FROM ContrctID, Contrct_RateSched, RateSched WHERE ContrctID.ContrctIDNum=Contrct_RateSched.ContrctIDNum AND Contrct_RateSched.RateSchedSeqNum=RateSched.RateSchedSeqNum AND StatusTypeCode='" + statusType + "' GROUP BY ContrctID.ContrctIDNum, ContrctID.ContrctIDDescr, RateSched.RateSchedSeqNum, RateSchedName ORDER BY ContrctID.ContrctIDDescr ASC");
Contract_Collection Contracts = new Contract_Collection();
ContractBO newContract;
if (sqlDataRdr.Read())
{
newContract = new ContractBO((int)sqlDataRdr["ContrctIDNum"], sqlDataRdr["ContrctIDDescr"].ToString());
newContract.addRateSchedule((int)sqlDataRdr["RateSchedSeqNum"], sqlDataRdr["RateSchedName"].ToString());
while(sqlDataRdr.Read())
{
if (! (newContract.ID==(int)sqlDataRdr["ContrctIDNum"]) )
{
Contracts.addContract(newContract);
newContract = new ContractBO((int)sqlDataRdr["ContrctIDNum"], sqlDataRdr["ContrctIDDescr"].ToString());
}
newContract.addRateSchedule((int)sqlDataRdr["RateSchedSeqNum"], sqlDataRdr["RateSchedName"].ToString());
}
Contracts.addContract(newContract);
}
this.CloseConnection();
return Contracts;
}
public int updateContract(ContractBO contract)
{
SqlParameter[] sqlParams = base.GetParameters("UpdateContrctID");
if (contract.ID==0)
{
sqlParams[fld_ContrctIDNum].Value = null;
}
else
{
sqlParams[fld_ContrctIDNum].Value = contract.ID;
}
sqlParams[fld_ContrctIDDescr].Value = contract.ContractName;
base.ExecuteUpdate("UpdateContrctID", sqlParams);
return Convert.ToInt16(sqlParams[fld_ContrctIDNum].Value);
}
public int insertContract(ContractBO contract)
{
return updateContract(contract);
}
