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); }