Esempio n. 1
0
        /// <summary>
        /// DeleteDirect
        /// </summary>
        /// <param name="unitId">unitId</param>
        /// <param name="unitType">unitType</param>
        /// <param name="companyId">companyId</param>
        public void DeleteDirect(int unitId, string unitType, int companyId)
        {
            UnitsGateway unitsGateway = new UnitsGateway();
            unitsGateway.LoadByUnitId(unitId,  companyId);

            if (unitsGateway.Table.Rows.Count > 0)
            {
                // ... Delete unit categories
                UnitsCategory unitsCategory = new UnitsCategory(null);
                UnitsCategoryGateway unitsCategoryGateway = new UnitsCategoryGateway();
                unitsCategoryGateway.LoadByUnitId(unitId, companyId);

                foreach (UnitsTDS.LFS_FM_UNIT_CATEGORYRow rowCategories in (UnitsTDS.LFS_FM_UNIT_CATEGORYDataTable)unitsCategoryGateway.Table)
                {
                    unitsCategory.DeleteDirect(unitId, rowCategories.CategoryID, companyId);
                }

                // ... if vehicle type then delete unit
                if (unitType == "Vehicle")
                {
                    UnitsVehicle unitsVehicle = new UnitsVehicle(null);
                    unitsVehicle.DeleteDirect(unitId, companyId);
                }

                // ... Delete inspections
                UnitsInspection unitsInspection = new UnitsInspection(null);
                UnitsInspectionGateway unitsInspectionGateway = new UnitsInspectionGateway();
                unitsInspectionGateway.LoadByUnitId(unitId, companyId);

                foreach (UnitsTDS.LFS_FM_UNIT_INSPECTIONRow rowInspections in (UnitsTDS.LFS_FM_UNIT_INSPECTIONDataTable)unitsInspectionGateway.Table)
                {
                    unitsInspection.DeletedDirect(unitId, rowInspections.InspectionID, companyId);
                }

                // ... Delete unit
                unitsGateway.Delete(unitId, companyId);
            }
        }
 /// <summary>
 /// DeletedDirect
 /// </summary>
 /// <param name="unitId">unitId</param>
 /// <param name="inspectionId">inspectionId</param>
 /// <param name="companyId">companyId</param>
 public void DeletedDirect(int unitId, int inspectionId, int companyId)
 {
     UnitsInspectionGateway unitsInspectionGateway = new UnitsInspectionGateway(null);
     unitsInspectionGateway.Delete(unitId, inspectionId, companyId);
 }
 // ////////////////////////////////////////////////////////////////////////
 // PUBLIC METHODS
 //
 /// <summary>
 /// InsertDirect
 /// </summary>
 /// <param name="unitId">unitId</param>
 /// <param name="inspectionId">inspectionId</param>
 /// <param name="date_">date_</param>
 /// <param name="country">country</param>
 /// <param name="state">state</param>
 /// <param name="type">type</param>
 /// <param name="result">result</param>
 /// <param name="cost">cost</param>
 /// <param name="notes">notes</param>
 /// <param name="inspectedBy">inspectedBy</param>
 /// <param name="attach">attach</param>
 /// <param name="deleted">deleted</param>
 /// <param name="companyId">companyId</param>
 public void InsertDirect(int unitId, int inspectionId, DateTime date_, Int64 country, Int64 state, string type, string result, decimal? cost, string notes, string inspectedBy, string attach, bool deleted, int companyId)
 {
     UnitsInspectionGateway unitsInspectionGateway = new UnitsInspectionGateway(null);
     unitsInspectionGateway.Insert(unitId, inspectionId, date_, country, state, type, result, cost, notes, inspectedBy, attach, deleted, companyId);
 }
 /// <summary>
 /// UpdateDirect
 /// </summary>
 /// <param name="originalUnitId">originalUnitId</param>
 /// <param name="originalInspectionId">originalInspectionId</param>
 /// <param name="originalDate_">originalDate_</param>
 /// <param name="originalCountry">originalCountry</param>
 /// <param name="originalState">originalState</param>
 /// <param name="originalType">originalType</param>
 /// <param name="originalResult">originalResult</param>
 /// <param name="originalCost">originalCost</param>
 /// <param name="originalNotes">originalNotes</param>
 /// <param name="originalInspectedBy">originalInspectedBy</param>
 /// <param name="originalAttach">originalAttach</param>
 /// <param name="originalDeleted">originalDeleted</param>
 /// <param name="originalCompanyId">originalCompanyId</param>
 /// <param name="newUnitId">newUnitId</param>
 /// <param name="newInspectionId">newInspectionId</param>
 /// <param name="newDate_">newDate_</param>
 /// <param name="newCountry">newCountry</param>
 /// <param name="newState">newState</param>
 /// <param name="newType">newType</param>
 /// <param name="newResult">newResult</param>
 /// <param name="newCost">newCost</param>
 /// <param name="newNotes">newNotes</param>
 /// <param name="newInspectedBy">newInspectedBy</param>
 /// <param name="newAttach">newAttach</param>
 /// <param name="newDeleted">newDeleted</param>
 /// <param name="newCompanyId">newCompanyId</param>
 public void UpdateDirect(int originalUnitId, int originalInspectionId, DateTime originalDate_, Int64 originalCountry, Int64 originalState, string originalType, string originalResult, decimal? originalCost, string originalNotes, string originalInspectedBy, string originalAttach, bool originalDeleted, int originalCompanyId, int newUnitId, int newInspectionId, DateTime newDate_, Int64 newCountry, Int64 newState, string newType, string newResult, decimal? newCost, string newNotes, string newInspectedBy, string newAttach, bool newDeleted, int newCompanyId)
 {
     UnitsInspectionGateway unitsInspectionGateway = new UnitsInspectionGateway(null);
     unitsInspectionGateway.Update(originalUnitId, originalInspectionId, originalDate_, originalCountry, originalState, originalType, originalResult, originalCost, originalNotes, originalInspectedBy, originalAttach, originalDeleted, originalCompanyId, newUnitId, newInspectionId, newDate_, newCountry, newState, newType, newResult, newCost, newNotes, newInspectedBy, newAttach, newDeleted, newCompanyId);
 }