/// <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> /// UpdateUnitCategory /// </summary> /// <param name="unitId">unitId</param> /// <param name="companyId">companyId</param> /// <param name="categoriesSelected">categoriesSelected</param> private void UpdateUnitCategory(int unitId, int companyId, ArrayList categoriesSelected) { CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.Load(companyId); if (categoryGateway.Table.Rows.Count > 0) { foreach (CategoriesTDS.LFS_FM_CATEGORYRow row in (CategoriesTDS.LFS_FM_CATEGORYDataTable)categoryGateway.Table) { int categoryId = row.CategoryID; UnitsCategoryGateway unitsCategoryGateway = new UnitsCategoryGateway(null); if (unitsCategoryGateway.IsUsedInUnitCategory(unitId, categoryId)) { if (!categoriesSelected.Contains(categoryId)) { UnitsCategory unitsCategory = new UnitsCategory(null); unitsCategory.DeleteDirect(unitId, categoryId, companyId); } } else { if (categoriesSelected.Contains(categoryId)) { UnitsCategory unitsCategory = new UnitsCategory(null); unitsCategory.InsertDirect(unitId, categoryId, false, companyId); } } } } }
/// <summary> /// UpdateUnitCategory /// </summary> /// <param name="unitId">unitId</param> /// <param name="companyId">companyId</param> /// <param name="categoriesSelected">categoriesSelected</param> /// <param name="companyLevelId">companyLevelId</param> private void UpdateUnitCategory(int unitId, int companyId, ArrayList categoriesSelected, int companyLevelId) { RuleCategoryUnitsGateway ruleCategoryUnitsGateway = new RuleCategoryUnitsGateway(null); CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.Load(companyId); if (categoryGateway.Table.Rows.Count > 0) { foreach (CategoriesTDS.LFS_FM_CATEGORYRow row in (CategoriesTDS.LFS_FM_CATEGORYDataTable)categoryGateway.Table) { int categoryId = row.CategoryID; UnitsCategoryGateway unitsCategoryGateway = new UnitsCategoryGateway(null); // Exists in DB if (unitsCategoryGateway.IsUsedInUnitCategory(unitId, categoryId, true)) { if (!categoriesSelected.Contains(categoryId)) { UnitsCategory unitsCategory = new UnitsCategory(null); unitsCategory.DeleteDirect(unitId, categoryId, companyId); RuleCategoryGateway ruleCategoryGateway = new RuleCategoryGateway(); ruleCategoryGateway.LoadByCategoryId(categoryId, companyId); foreach (RuleTDS.LFS_FM_RULE_CATEGORYRow rowRuleCategory in (RuleTDS.LFS_FM_RULE_CATEGORYDataTable)ruleCategoryGateway.Table) { int ruleId = rowRuleCategory.RuleID; if (ruleCategoryUnitsGateway.IsUsedInRuleCategoryUnits(ruleId, categoryId, unitId)) { // Delete RuleCategoryUnits ruleCategoryUnits = new RuleCategoryUnits(null); ruleCategoryUnits.DeleteDirect(ruleId, categoryId, unitId, companyId); } } } else { UnitsCategory unitsCategory = new UnitsCategory(null); unitsCategory.UnDeleteDirect(unitId, categoryId, companyId); } } else { if (categoriesSelected.Contains(categoryId)) { UnitsCategory unitsCategory = new UnitsCategory(null); unitsCategory.InsertDirect(unitId, categoryId, false, companyId); } } } } }
/// <summary> /// UpdateUnitsAndRulesCategories /// </summary> /// <param name="originalCategoryId">originalCategoryId</param> /// <param name="newCategoryId">newCategoryId</param> /// <param name="companyId">companyId</param> private void UpdateUnitsAndRulesCategories(int originalCategoryId, int? newCategoryId, int companyId) { // Update rules categories LiquiForce.LFSLive.DA.FleetManagement.ChecklistRules.RuleGateway ruleGateway = new RuleGateway(); ruleGateway.Load(companyId); if (ruleGateway.Table.Rows.Count > 0) { foreach (RuleTDS.LFS_FM_RULERow row in (RuleTDS.LFS_FM_RULEDataTable)ruleGateway.Table) { int ruleId = row.RuleID; RuleCategoryGateway ruleCategoryGateway = new RuleCategoryGateway(null); if ((ruleCategoryGateway.IsUsedInRuleCategory(ruleId, originalCategoryId)) && (newCategoryId.HasValue)) { if (!ruleCategoryGateway.IsUsedInRuleCategory(ruleId, (int)newCategoryId, true)) { RuleCategory ruleCategory = new RuleCategory(null); // Insert new rule category ruleCategory.InsertDirect(ruleId, (int)newCategoryId, false, companyId); // Delete old rule category ruleCategory.DeleteDirect(ruleId, originalCategoryId, companyId); } else { RuleCategory ruleCategory = new RuleCategory(null); // Undelete nee rule category ruleCategory.UnDeleteDirect(ruleId, (int)newCategoryId, companyId); // Delete old rule category ruleCategory.DeleteDirect(ruleId, originalCategoryId, companyId); } } } } // Update units categories UnitsGateway unitsGateway = new UnitsGateway(); unitsGateway.Load(companyId); if (unitsGateway.Table.Rows.Count > 0) { foreach (UnitsTDS.LFS_FM_UNITRow row in (UnitsTDS.LFS_FM_UNITDataTable)unitsGateway.Table) { int unitId = row.UnitID; int companyLevelId = row.CompanyLevelID; UnitsCategoryGateway unitsCategoryGateway = new UnitsCategoryGateway(null); if ((unitsCategoryGateway.IsUsedInUnitCategory(unitId, originalCategoryId)) && (newCategoryId.HasValue) ) { if (!unitsCategoryGateway.IsUsedInUnitCategory(unitId, (int)newCategoryId, true)) { UnitsCategory unitsCategory = new UnitsCategory(null); // Insert new unit category unitsCategory.InsertDirect(unitId, (int)newCategoryId, false, companyId); // Delete old unit category unitsCategory.DeleteDirect(unitId, originalCategoryId, companyId); // Delete all checklist for unitId DeleteChecklists(unitId, companyId); // Update checklist UpdateUnitChecklists(unitId, row.CompanyLevelID, companyId); } else { UnitsCategory unitsCategory = new UnitsCategory(null); // Undelete new category unitsCategory.UnDeleteDirect(unitId, (int)newCategoryId, companyId); // Delete old category unitsCategory.DeleteDirect(unitId, originalCategoryId, companyId); // Delete all checklist for unitId DeleteChecklists(unitId, companyId); // Update checklist UpdateUnitChecklists(unitId, row.CompanyLevelID, companyId); } } } } }