public static void DeleteNominations(FC_LocalContract InContract) { string Query = "select bp.FC_BuyerToPlannerContractID, bp.FC_LocalContractID " + "from FC_BuyerToPlannerContract as bp " + "left join FC_LocalContract on FC_LocalContract.FC_LocalContractID = bp.FC_LocalContractID " + "where FC_LocalContract.FC_LocalContractID = " + InContract.FC_LocalContractID + ";"; FC_BuyerToPlannerContract p = new FC_BuyerToPlannerContract(); List <FC_BuyerToPlannerContract> B2P = p.ObjToTable(SQL.Select(p, Query)); Query = "delete from FC_CarrierNom where FC_BuyerToPlannerContractID = " + B2P[0].FC_BuyerToPlannerContractID + ";"; SQL.GenericFunction(Query); Query = "delete from FC_BuyerToPlannerContract where FC_BuyerToPlannerContractID = " + B2P[0].FC_BuyerToPlannerContractID + ";"; SQL.GenericFunction(Query); }
// METHOD HEADER COMMENT ------------------------------------------------------------------------------- /** * \fn PushToDataBase * \brief This method inserts a new contract into the database * \param[in] none * \param[out] none * \return bool * ---------------------------------------------------------------------------------------------------- */ public bool PushToDataBase() { TheContract = new FC_LocalContract(SQL.GetNextID("FC_LocalContract"), InContract.Client_Name, InContract.Job_type, InContract.Quantity, InContract.Origin, InContract.Destination, InContract.Van_type, 0); SQL.Insert(TheContract); FC_BuyerToPlannerContract B2PC = new FC_BuyerToPlannerContract(); B2PC.FC_BuyerToPlannerContractID = SQL.GetNextID("FC_BuyerToPlannerContract"); B2PC.FC_LocalContractID = TheContract.FC_LocalContractID; SQL.Insert(B2PC); foreach (FC_Carrier x in TheCarriers) { SQL.Insert(new FC_CarrierNom(B2PC.FC_BuyerToPlannerContractID, x.FC_CarrierID)); } TMSLogger.LogIt(" | " + "NominateForPlanner.cs" + " | " + "NominateForPlanner" + " | " + "PushToDataBase" + " | " + "Confirmation" + " | " + "Contract pushed to database" + " | "); return(true); }