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