/// <summary>
        /// Save all costs to database (direct)
        /// </summary>
        /// <param name="serviceId">serviceId</param>
        /// <param name="companyId">companyId</param>
        public void Save(int serviceId, int companyId)
        {
            ServiceRequestsManagerToolTDS serviceRequestsManagerToolTDS = (ServiceRequestsManagerToolTDS)Data.GetChanges();

            if (serviceRequestsManagerToolTDS.CostInformation.Rows.Count > 0)
            {
                ServiceRequestsManagerToolCostInformationGateway serviceRequestsManagerToolCostInformationGateway = new ServiceRequestsManagerToolCostInformationGateway(serviceRequestsManagerToolTDS);

                foreach (ServiceRequestsManagerToolTDS.CostInformationRow row in (ServiceRequestsManagerToolTDS.CostInformationDataTable)serviceRequestsManagerToolTDS.CostInformation)
                {
                    // Insert new costs
                    if (!row.Deleted)
                    {
                        // new values
                        int refId = row.RefID;
                        int tempServiceId = row.ServiceID;

                        string newPartNumber = serviceRequestsManagerToolCostInformationGateway.GetPartNumber(tempServiceId, refId);
                        string newPartName = serviceRequestsManagerToolCostInformationGateway.GetPartName(tempServiceId, refId);
                        string newVendor = serviceRequestsManagerToolCostInformationGateway.GetVendor(tempServiceId, refId);
                        decimal newCost = serviceRequestsManagerToolCostInformationGateway.GetCost(tempServiceId, refId);

                        ServicesCost servicesCost = new ServicesCost(null);
                        servicesCost.InsertDirect(serviceId, refId, newPartNumber, newPartName, newVendor, newCost, row.Deleted, row.COMPANY_ID, null);
                    }
                }
            }
        }
 // ////////////////////////////////////////////////////////////////////////
 // PUBLIC METHODS
 //
 /// <summary>
 /// LoadByServiceId
 /// </summary>       
 /// <param name="serviceId">serviceId</param>
 /// <param name="companyId">companyId</param>
 public void LoadByServiceId(int serviceId, int companyId)
 {
     ServiceRequestsManagerToolCostInformationGateway serviceRequestsManagerToolCostInformationGateway = new ServiceRequestsManagerToolCostInformationGateway(Data);
     serviceRequestsManagerToolCostInformationGateway.LoadByServiceId(serviceId, companyId);
 }