/// <summary> /// LoadAllUnitTypes /// </summary> /// <param name="companyId">companyId</param> public void LoadAllUnitTypes(int companyId) { CategoryGateway categoryGateway = new CategoryGateway(Data); categoryGateway.ClearBeforeFill = false; categoryGateway.LoadByUnitType("Equipment", companyId); categoryGateway.LoadByUnitType("Vehicle", companyId); categoryGateway.ClearBeforeFill = true; UpdateDataForView(); }
// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // STEP6 - SUMMARY // // //////////////////////////////////////////////////////////////////////// // STEP6 - SUMMARY - METHODS // private void StepSummaryIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Summary"; hdfUpdate.Value = "yes"; string mto = "No"; if (cbxMtoDot.Checked) mto = "Yes"; string generateServiceRequest = tbxServicesRequestDaysBefore.Text + " days before"; string categoriesSelected = ""; foreach (int categoryId in arrayCategoriesSelected) { CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.LoadByCategoryId(categoryId, Int32.Parse(hdfCompanyId.Value)); categoriesSelected += categoryGateway.GetName(categoryId)+ ", "; } if (categoriesSelected.Length > 2) { categoriesSelected = categoriesSelected.Substring(0, categoriesSelected.Length - 2); } string unitsSelected = ""; foreach (ListItem lst in cbxlUnitsSelected.Items) { if (lst.Selected) unitsSelected += lst.Text + ", "; } if (unitsSelected.Length > 2) { unitsSelected = unitsSelected.Substring(0, unitsSelected.Length - 2); } string companyLevelsSelected = ""; foreach (int companyLevelId in arrayCompanyLevelsSelected) { CompanyLevelGateway companyLevelGateway = new CompanyLevelGateway(); companyLevelGateway.LoadByCompanyLevelId(companyLevelId, Int32.Parse(hdfCompanyId.Value)); companyLevelsSelected += companyLevelGateway.GetName(companyLevelId) + ", "; } if (companyLevelsSelected.Length > 2) { companyLevelsSelected = companyLevelsSelected.Substring(0, companyLevelsSelected.Length - 2); } tbxSummary.Text = "Name: " + tbxName.Text + "\nFixed Date: " + mto + "\nDescription: " + tbxDescription.Text + "\nFrequency: " + ddlFrequency.SelectedValue + "\nGenerate Service Request?: " + generateServiceRequest + "\nCompany Levels: " + companyLevelsSelected+ "\nCategories: " + categoriesSelected + "\nUnits: " + unitsSelected ; }
// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // STEP6 - SUMMARY // // //////////////////////////////////////////////////////////////////////// // STEP6 - SUMMARY - METHODS // private void StepSummaryIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Summary"; hdfUpdate.Value = "yes"; if (rbtnAddCategory.Checked) tbxSummary.Text = "Operation: Add category"; if (rbtnDeleteCategory.Checked) tbxSummary.Text = "Operation: Delete category"; if (rbtnEditCategory.Checked) tbxSummary.Text = "Operation: Edit category"; if (!rbtnDeleteCategory.Checked) { if (arrayCategoriesSelected.Count > 0) { foreach (int categoryIdInArray in arrayCategoriesSelected) { CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.LoadByCategoryId(categoryIdInArray, int.Parse(hdfCompanyId.Value)); tbxSummary.Text += "\nParent category: " + categoryGateway.GetName(categoryIdInArray); } } else { tbxSummary.Text += "\nParent category: (Empty)"; } } if (!rbtnDeleteCategory.Checked) { tbxSummary.Text += "\nName: " + tbxName.Text; } else { foreach (int categoryIdInArray in arrayCategoriesSelected) { CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.LoadByCategoryId(categoryIdInArray, int.Parse(hdfCompanyId.Value)); tbxSummary.Text += "\nName: " + categoryGateway.GetName(categoryIdInArray); } } }
private void LoadData(int ruleId) { RuleGateway ruleGateway = new RuleGateway(ruleTDS); if (ruleGateway.Table.Rows.Count > 0) { tbxName.Text = ruleGateway.GetName(ruleId); cbxMtoDot.Checked = ruleGateway.GetMto(ruleId); tbxDescription.Text = ruleGateway.GetDescription(ruleId); tbxFrecuency.Text = ruleGateway.GetFrequency(ruleId); tbxServicesRequestDaysBefore.Text = ""; if (ruleGateway.GetServiceRequestDays(ruleId).HasValue) tbxServicesRequestDaysBefore.Text = ((int)(ruleGateway.GetServiceRequestDays(ruleId))).ToString(); // Load Trees GetNodeForCategory(tvCategoriesRoot.Nodes, 0); GetNodeForCompanyLevels(tvCompanyLevelsRoot.Nodes, 0); // Load Units int companyId = Int32.Parse(hdfCompanyId.Value); string category = ""; UnitsList unitsList = new UnitsList(new DataSet()); foreach (int categoryId in arrayCategoriesSelected) { CategoryGateway categoryGateway = new CategoryGateway(); //Verify the location of the unit foreach (int companyLevelId in arrayCompanyLevelsSelected) { // Load the unit if corresponds categoryGateway.LoadByCategoryId(categoryId, Int32.Parse(hdfCompanyId.Value)); category = categoryGateway.GetName(categoryId); unitsList.LoadAndAddItemByCategoryCompanyLevelId(category, companyLevelId, companyId); } } if (unitsList.Table != null) { cbxlUnitsSelected.DataSource = RemoveDuplicateRows(unitsList.Table, "UnitID"); cbxlUnitsSelected.DataValueField = "UnitID"; cbxlUnitsSelected.DataTextField = "UnitCode"; cbxlUnitsSelected.DataBind(); // Total units lblTotalUnits.Text = "Total Units: " + cbxlUnitsSelected.Items.Count; } else { // Total units lblTotalUnits.Text = "Total Units: 0"; } } }
/// <summary> /// GetConditionForCategory /// </summary> /// <param name="category">category</param> /// <param name="companyId">companyId</param> /// <returns>categoriesId</returns> private ArrayList GetConditionForCategory(string category, int companyId) { CategoryGateway categoryGateway2 = new CategoryGateway(); int categoryId = categoryGateway2.GetCategoryId(category); ArrayList categoriesId = new ArrayList(); categoriesId.Add(categoryId); categoriesId = GetChilds(categoryId, categoriesId, companyId); return categoriesId; }
/// <summary> /// UpdateRuleCategory /// </summary> /// <param name="ruleId">ruleId</param> /// <param name="companyId">companyId</param> /// <param name="categoriesSelected">categoriesSelected</param> /// <param name="companyLevelsSelected">companyLevelsSelected</param> private void UpdateRuleCategory(int ruleId, int companyId, ArrayList categoriesSelected, ArrayList companyLevelsSelected) { CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.Load(companyId); foreach (CategoriesTDS.LFS_FM_CATEGORYRow row in (CategoriesTDS.LFS_FM_CATEGORYDataTable)categoryGateway.Table) { int categoryId = row.CategoryID; RuleCategoryGateway ruleCategoryGateway = new RuleCategoryGateway(null); if (ruleCategoryGateway.IsUsedInRuleCategory(ruleId, categoryId, true)) { // Delete if (!categoriesSelected.Contains(categoryId)) { RuleCategory ruleCategory = new RuleCategory(null); ruleCategory.DeleteDirect(ruleId, categoryId, companyId); } else // Undelete { RuleCategory ruleCategory = new RuleCategory(null); ruleCategory.UnDeleteDirect(ruleId, categoryId, companyId); } } else { if (categoriesSelected.Contains(categoryId)) { RuleCategory ruleCategory = new RuleCategory(null); ruleCategory.InsertDirect(ruleId, categoryId, false, 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> /// Save /// </summary> /// <param name="categoriesSelected">categoriesSelected</param> /// <param name="companyId">companyId</param> public void Save(ArrayList categoriesSelected, int companyId) { UnitInformationTDS unitsInformationChanges = (UnitInformationTDS)Data.GetChanges(); if (unitsInformationChanges.UnitDetails.Rows.Count > 0) { UnitInformationUnitDetailsGateway unitInformationUnitDetailsGateway = new UnitInformationUnitDetailsGateway(unitsInformationChanges); // Update unit foreach (UnitInformationTDS.UnitDetailsRow unitDetailsRow in (UnitInformationTDS.UnitDetailsDataTable)unitsInformationChanges.UnitDetails) { // Unchanged values int unitId = unitDetailsRow.UnitID; string state = unitInformationUnitDetailsGateway.GetState(unitId); string type = unitInformationUnitDetailsGateway.GetType(unitId); bool deleted = false; string notes = ""; if (!unitDetailsRow.IsNotesNull()) notes = unitDetailsRow.Notes; string originalCategories = ""; if (!unitDetailsRow.IsCategoriesNull()) originalCategories = unitDetailsRow.Categories; // Original Unit values string originalUnitCode = unitInformationUnitDetailsGateway.GetUnitCodeOriginal(unitId); string originalDescription = unitInformationUnitDetailsGateway.GetDescriptionOriginal(unitId); string originalVin = unitInformationUnitDetailsGateway.GetVinOriginal(unitId); string originalManufacturer = unitInformationUnitDetailsGateway.GetManufacturerOriginal(unitId); string originalModel = unitInformationUnitDetailsGateway.GetModelOriginal(unitId); string originalYear_ = unitInformationUnitDetailsGateway.GetYear_Original(unitId); bool originalIsTowable = unitInformationUnitDetailsGateway.GetIsTowableOriginal(unitId); int originalCompanyLevelId = unitInformationUnitDetailsGateway.GetCompanyLevelIdOriginal(unitId); DateTime? originalAcquisitionDate = null; if (unitInformationUnitDetailsGateway.GetAcquisitionDateOriginal(unitId).HasValue) originalAcquisitionDate = (DateTime)unitInformationUnitDetailsGateway.GetAcquisitionDateOriginal(unitId); DateTime? originalDispositionDate = null; if (unitInformationUnitDetailsGateway.GetDispositionDateOriginal(unitId).HasValue) originalDispositionDate = (DateTime)unitInformationUnitDetailsGateway.GetDispositionDateOriginal(unitId); string originalDispositionReason = unitInformationUnitDetailsGateway.GetDispositionReasonOriginal(unitId); string originalOwnerType = unitInformationUnitDetailsGateway.GetOwnerTypeOriginal(unitId); Int64? originalOwnerCountry = null; if (unitInformationUnitDetailsGateway.GetOwnerCountryOriginal(unitId).HasValue) originalOwnerCountry = (Int64)unitInformationUnitDetailsGateway.GetOwnerCountryOriginal(unitId); Int64? originalOwnerState = null; if (unitInformationUnitDetailsGateway.GetOwnerStateOriginal(unitId).HasValue) originalOwnerState = (Int64)unitInformationUnitDetailsGateway.GetOwnerStateOriginal(unitId); string originalOwnerName = unitInformationUnitDetailsGateway.GetOwnerNameOriginal(unitId); string originalOwnerContact = unitInformationUnitDetailsGateway.GetOwnerContactOriginal(unitId); DateTime? originalQualifiedDate = null; if (unitInformationUnitDetailsGateway.GetQualifiedDateOriginal(unitId).HasValue) originalQualifiedDate = (DateTime)unitInformationUnitDetailsGateway.GetQualifiedDateOriginal(unitId); DateTime? originalNotQualifiedDate = null; if (unitInformationUnitDetailsGateway.GetNotQualifiedDateOriginal(unitId).HasValue) originalNotQualifiedDate = (DateTime)unitInformationUnitDetailsGateway.GetNotQualifiedDateOriginal(unitId); string originalNotQualifiedExplain = unitInformationUnitDetailsGateway.GetNotQualifiedExplainOriginal(unitId); string originalInsuranceClass = unitInformationUnitDetailsGateway.GetInsuranceClassOriginal(unitId); string originalInsuranceClassRyderSpecified = unitInformationUnitDetailsGateway.GetInsuranceClassRyderSpecifiedOriginal(unitId); decimal? originalPurchasePrice = null; if (unitInformationUnitDetailsGateway.GetPurchasePriceOriginal(unitId).HasValue) originalPurchasePrice = unitInformationUnitDetailsGateway.GetPurchasePriceOriginal(unitId).Value; DateTime? originalScrapDate = null; if (unitInformationUnitDetailsGateway.GetScrapDateOriginal(unitId).HasValue) originalScrapDate = (DateTime)unitInformationUnitDetailsGateway.GetScrapDateOriginal(unitId); decimal? originalSaleProceeds = null; if (unitInformationUnitDetailsGateway.GetSaleProceedsOriginal(unitId).HasValue) originalSaleProceeds = unitInformationUnitDetailsGateway.GetSaleProceedsOriginal(unitId).Value; int? originalLibraryCategoriesId = null; if (unitInformationUnitDetailsGateway.GetLibraryCategoriesIdOriginal(unitId).HasValue) originalLibraryCategoriesId = unitInformationUnitDetailsGateway.GetLibraryCategoriesIdOriginal(unitId).Value; // New Unit values string newUnitCode = unitInformationUnitDetailsGateway.GetUnitCode(unitId); string newDescription = unitInformationUnitDetailsGateway.GetDescription(unitId); string newVin = unitInformationUnitDetailsGateway.GetVin(unitId); string newManufacturer = unitInformationUnitDetailsGateway.GetManufacturer(unitId); string newModel = unitInformationUnitDetailsGateway.GetModel(unitId); string newYear_ = unitInformationUnitDetailsGateway.GetYear_(unitId); bool newIsTowable = unitInformationUnitDetailsGateway.GetIsTowable(unitId); int newCompanyLevelId = unitInformationUnitDetailsGateway.GetCompanyLevelId(unitId); DateTime? newAcquisitionDate = null; if (unitInformationUnitDetailsGateway.GetAcquisitionDate(unitId).HasValue) newAcquisitionDate = (DateTime)unitInformationUnitDetailsGateway.GetAcquisitionDate(unitId); DateTime? newDispositionDate = null; if (unitInformationUnitDetailsGateway.GetDispositionDate(unitId).HasValue) newDispositionDate = (DateTime)unitInformationUnitDetailsGateway.GetDispositionDate(unitId); string newDispositionReason = unitInformationUnitDetailsGateway.GetDispositionReason(unitId); string newOwnerType = unitInformationUnitDetailsGateway.GetOwnerType(unitId); Int64? newOwnerCountry = null; if (unitInformationUnitDetailsGateway.GetOwnerCountry(unitId).HasValue) newOwnerCountry = (Int64)unitInformationUnitDetailsGateway.GetOwnerCountry(unitId); Int64? newOwnerState = null; if (unitInformationUnitDetailsGateway.GetOwnerState(unitId).HasValue) newOwnerState = (Int64)unitInformationUnitDetailsGateway.GetOwnerState(unitId); string newOwnerName = unitInformationUnitDetailsGateway.GetOwnerName(unitId); string newOwnerContact = unitInformationUnitDetailsGateway.GetOwnerContact(unitId); DateTime? newQualifiedDate = null; if (unitInformationUnitDetailsGateway.GetQualifiedDate(unitId).HasValue) newQualifiedDate = (DateTime)unitInformationUnitDetailsGateway.GetQualifiedDate(unitId); DateTime? newNotQualifiedDate = null; if (unitInformationUnitDetailsGateway.GetNotQualifiedDate(unitId).HasValue) newNotQualifiedDate = (DateTime)unitInformationUnitDetailsGateway.GetNotQualifiedDate(unitId); string newNotQualifiedExplain = unitInformationUnitDetailsGateway.GetNotQualifiedExplain(unitId); string newCategories = ""; if (categoriesSelected.Count > 0) { foreach (int categoryId in categoriesSelected) { CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.LoadByCategoryId(categoryId, companyId); newCategories = newCategories + categoryGateway.GetName(categoryId) + ", "; } if (newCategories.Length > 2) { newCategories = newCategories.Substring(0, newCategories.Length - 2); } } string newInsuranceClass = unitInformationUnitDetailsGateway.GetInsuranceClass(unitId); string newInsuranceClassRyderSpecified = unitInformationUnitDetailsGateway.GetInsuranceClassRyderSpecified(unitId); decimal? newPurchasePrice = null; if (unitInformationUnitDetailsGateway.GetPurchasePrice(unitId).HasValue) newPurchasePrice = unitInformationUnitDetailsGateway.GetPurchasePrice(unitId).Value; DateTime? newScrapDate = null; if (unitInformationUnitDetailsGateway.GetScrapDate(unitId).HasValue) newScrapDate = (DateTime)unitInformationUnitDetailsGateway.GetScrapDate(unitId); decimal? newSaleProceeds = null; if (unitInformationUnitDetailsGateway.GetSaleProceeds(unitId).HasValue) newSaleProceeds = unitInformationUnitDetailsGateway.GetSaleProceeds(unitId).Value; int? newLibraryCategoriesId = null; if (unitInformationUnitDetailsGateway.GetLibraryCategoriesId(unitId).HasValue) newLibraryCategoriesId = unitInformationUnitDetailsGateway.GetLibraryCategoriesId(unitId).Value; // Update unit UpdateUnit(unitId, originalUnitCode, originalDescription, originalVin, originalManufacturer, originalModel, originalYear_, originalIsTowable, originalCompanyLevelId, originalAcquisitionDate, originalDispositionDate, originalDispositionReason, originalOwnerType, originalOwnerCountry, originalOwnerState, originalOwnerName, originalOwnerContact, originalQualifiedDate, originalNotQualifiedDate, originalNotQualifiedExplain, state, type, deleted, companyId, notes, originalCategories, originalInsuranceClass, originalInsuranceClassRyderSpecified, originalPurchasePrice, originalScrapDate, originalSaleProceeds, originalLibraryCategoriesId, unitId, newUnitCode, newDescription, newVin, newManufacturer, newModel, newYear_, newIsTowable, newCompanyLevelId, newAcquisitionDate, newDispositionDate, newDispositionReason, newOwnerType, newOwnerCountry, newOwnerState, newOwnerName, newOwnerContact, newQualifiedDate, newNotQualifiedDate, newNotQualifiedExplain, state, type, deleted, companyId, notes, newCategories, newInsuranceClass, newInsuranceClassRyderSpecified, newPurchasePrice, newScrapDate, newSaleProceeds, newLibraryCategoriesId); UpdateUnitCategory(unitId, companyId, categoriesSelected, newCompanyLevelId); if (type == "Vehicle") { // Original Unit Vehicle values Int64? originalLicenseCountry = null; if (unitInformationUnitDetailsGateway.GetLicenseCountryOriginal(unitId).HasValue) originalLicenseCountry = (Int64)unitInformationUnitDetailsGateway.GetLicenseCountryOriginal(unitId); Int64? originalLicenseState = null; if (unitInformationUnitDetailsGateway.GetLicenseStateOriginal(unitId).HasValue) originalLicenseState = (Int64)unitInformationUnitDetailsGateway.GetLicenseStateOriginal(unitId); string originalLicensePlateNumber = unitInformationUnitDetailsGateway.GetLicensePlateNumbverOriginal(unitId); string originalAportionedTagNumber = unitInformationUnitDetailsGateway.GetAportionedTagNumberOriginal(unitId); string originalActualWeight = unitInformationUnitDetailsGateway.GetActualWeightOriginal(unitId); string originalRegisteredWeight = unitInformationUnitDetailsGateway.GetRegisteredWeightOriginal(unitId); string originalTireSizeFront = unitInformationUnitDetailsGateway.GetTireSizeFrontOriginal(unitId); string originalTireSizeBack = unitInformationUnitDetailsGateway.GetTireSizeBackOriginal(unitId); string originalNumberOfAxes = unitInformationUnitDetailsGateway.GetNumberOfAxesOriginal(unitId); string originalFuelType = unitInformationUnitDetailsGateway.GetFuelTypeOriginal(unitId); string originalBeginningOdometer = unitInformationUnitDetailsGateway.GetBeginningOdometerOriginal(unitId); bool originalIsReeferEquipped = unitInformationUnitDetailsGateway.GetIsReeferEquippedOriginal(unitId); bool originalIsPtoEquipped = unitInformationUnitDetailsGateway.GetIsPTOEquippedOriginal(unitId); // New Unit Vehicle values Int64? newLicenseCountry = null; if (unitInformationUnitDetailsGateway.GetLicenseCountry(unitId).HasValue) newLicenseCountry = (Int64)unitInformationUnitDetailsGateway.GetLicenseCountry(unitId); Int64? newLicenseState = null; if (unitInformationUnitDetailsGateway.GetLicenseState(unitId).HasValue) newLicenseState = (Int64)unitInformationUnitDetailsGateway.GetLicenseState(unitId); string newLicensePlateNumber = unitInformationUnitDetailsGateway.GetLicensePlateNumbver(unitId); string newAportionedTagNumber = unitInformationUnitDetailsGateway.GetAportionedTagNumber(unitId); string newActualWeight = unitInformationUnitDetailsGateway.GetActualWeight(unitId); string newRegisteredWeight = unitInformationUnitDetailsGateway.GetRegisteredWeight(unitId); string newTireSizeFront = unitInformationUnitDetailsGateway.GetTireSizeFront(unitId); string newTireSizeBack = unitInformationUnitDetailsGateway.GetTireSizeBack(unitId); string newNumberOfAxes = unitInformationUnitDetailsGateway.GetNumberOfAxes(unitId); string newFuelType = unitInformationUnitDetailsGateway.GetFuelType(unitId); string newBeginningOdometer = unitInformationUnitDetailsGateway.GetBeginningOdometer(unitId); bool newIsReeferEquipped = unitInformationUnitDetailsGateway.GetIsReeferEquipped(unitId); bool newIsPtoEquipped = unitInformationUnitDetailsGateway.GetIsPTOEquipped(unitId); UpdateUnitVehicle(unitId, originalLicenseCountry, originalLicenseState, originalLicensePlateNumber, originalAportionedTagNumber, originalActualWeight, originalRegisteredWeight, originalTireSizeFront, originalTireSizeBack, originalNumberOfAxes, originalFuelType, originalBeginningOdometer, originalIsReeferEquipped, originalIsPtoEquipped, deleted, companyId, unitId, newLicenseCountry, newLicenseState, newLicensePlateNumber, newAportionedTagNumber, newActualWeight, newRegisteredWeight, newTireSizeFront, newTireSizeBack, newNumberOfAxes, newFuelType, newBeginningOdometer, newIsReeferEquipped, newIsPtoEquipped, deleted, companyId); } } } }
/// <summary> /// LoadByUnitType /// </summary> /// <param name="unitType">unitType</param> /// <param name="companyId">companyId</param> public void LoadByUnitType(string unitType, int companyId) { CategoryGateway categoryGateway = new CategoryGateway(Data); categoryGateway.LoadByUnitType(unitType, companyId); UpdateData(); }
/// <summary> /// InsertDirect /// </summary> /// <param name="type">type</param> /// <param name="name">name</param> /// <param name="parentId">parentId</param> /// <param name="deleted">deleted</param> /// <param name="companyId">companyId</param> public void InsertDirect(string type, string name, int? parentId, bool deleted, int companyId) { CategoryGateway categoryGateway = new CategoryGateway(null); categoryGateway.Insert(type, name, parentId, deleted, companyId); }
// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // /// <summary> /// Load /// </summary> /// <param name="companyId">companyId</param> public void Load(int companyId) { CategoryGateway categoryGateway = new CategoryGateway(Data); categoryGateway.Load(companyId); UpdateData(); }
/// <summary> /// DeletedDirect /// </summary> /// <param name="categoryId">categoryId</param> /// <param name="companyId">companyId</param> public void DeletedDirect(int categoryId, int companyId) { CategoryGateway categoryGateway = new CategoryGateway(null); categoryGateway.Delete(categoryId, companyId); }
/// <summary> /// UpdateDirect /// </summary> /// <param name="originalCategoryId">originalCategoryId</param> /// <param name="originalType">originalType</param> /// <param name="originalName">originalName</param> /// <param name="originalParentId">originalParentId</param> /// <param name="originalDeleted">originalDeleted</param> /// <param name="originalCompanyId">originalCompanyId</param> /// <param name="newCategoryId">newCategoryId</param> /// <param name="newType">newType</param> /// <param name="newName">newName</param> /// <param name="newParentId">newParentId</param> /// <param name="newDeleted">newDeleted</param> /// <param name="newCompanyId">newCompanyId</param> public void UpdateDirect(int originalCategoryId, string originalType, string originalName, int? originalParentId, bool originalDeleted, int originalCompanyId, int newCategoryId, string newType, string newName, int? newParentId, bool newDeleted, int newCompanyId) { CategoryGateway categoryGateway = new CategoryGateway(null); categoryGateway.Update(originalCategoryId, originalType, originalName, originalParentId, originalDeleted, originalCompanyId, newCategoryId, newType, newName, newParentId, newDeleted, newCompanyId); }
/// <summary> /// UpdateRuleCategoryUnits /// </summary> /// <param name="ruleId">ruleId</param> /// <param name="companyId">companyId</param> /// <param name="categoriesSelected">categoriesSelected</param> /// <param name="companyLevelsSelected">companyLevelsSelected</param> /// <param name="unitsSelected">unitsSelected</param> private void UpdateRuleCategoryUnits(int ruleId, int companyId, ArrayList categoriesSelected, ArrayList companyLevelsSelected, ArrayList unitsSelected) { // At each category CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.Load(companyId); foreach (CategoriesTDS.LFS_FM_CATEGORYRow row in (CategoriesTDS.LFS_FM_CATEGORYDataTable)categoryGateway.Table) { int categoryId = row.CategoryID; // At each unit UnitsCategoryGateway unitsCategoryGateway = new UnitsCategoryGateway(); unitsCategoryGateway.LoadByCategoryId(categoryId, companyId); foreach (UnitsTDS.LFS_FM_UNIT_CATEGORYRow rowUnitCategory in (UnitsTDS.LFS_FM_UNIT_CATEGORYDataTable)unitsCategoryGateway.Table) { int unitId = rowUnitCategory.UnitID; RuleCategoryUnitsGateway ruleCategoryUnitsGateway = new RuleCategoryUnitsGateway(null); // If it already exists and it's not deleted if (ruleCategoryUnitsGateway.IsUsedInRuleCategoryUnits(ruleId, categoryId, unitId)) { // Verify if it's at the current selection if ((!categoriesSelected.Contains(categoryId)) || (categoriesSelected.Contains(categoryId) && (!unitsSelected.Contains(unitId)))) { // Delete RuleCategoryUnits ruleCategoryUnits = new RuleCategoryUnits(null); ruleCategoryUnits.DeleteDirect(ruleId, categoryId, unitId, companyId); } else { RuleCategoryUnits ruleCategoryUnits = new RuleCategoryUnits(null); ruleCategoryUnits.UnDeleteDirect(ruleId, categoryId, unitId, companyId); // Insert checklist foreach (int companyLevelId in companyLevelsSelected) { UnitsGateway unitsGateway = new UnitsGateway(null); if (unitsGateway.IsUsedInUnitsAndNotIsDisposed(unitId, companyLevelId)) { ChecklistGateway checklistGateway = new ChecklistGateway(null); if (checklistGateway.IsUsedInChecklist(unitId, ruleId, true)) { Checklist checklist = new Checklist(null); checklist.UnDeleteDirect(ruleId, unitId, companyId); } else { Checklist checklist = new Checklist(null); checklist.InsertDirect(unitId, ruleId, null, null, false, "Unknown", false, companyId); } } } } } else { // If it already exists and it's deleted if (ruleCategoryUnitsGateway.IsUsedInRuleCategoryUnitsAsDeleted(ruleId, categoryId, unitId)) { // Verify if it's at the current selection if (categoriesSelected.Contains(categoryId) && (unitsSelected.Contains(unitId))) { // UnDelete RuleCategoryUnits ruleCategoryUnits = new RuleCategoryUnits(null); ruleCategoryUnits.UnDeleteDirect(ruleId, categoryId, unitId, companyId); // Insert checklist foreach (int companyLevelId in companyLevelsSelected) { UnitsGateway unitsGateway = new UnitsGateway(null); if (unitsGateway.IsUsedInUnitsAndNotIsDisposed(unitId, companyLevelId)) { ChecklistGateway checklistGateway = new ChecklistGateway(null); if (checklistGateway.IsUsedInChecklist(unitId, ruleId, true)) { Checklist checklist = new Checklist(null); checklist.UnDeleteDirect(ruleId, unitId, companyId); } else { Checklist checklist = new Checklist(null); checklist.InsertDirect(unitId, ruleId, null, null, false, "Unknown", false, companyId); } } } } } // If it's not at bd else { // Verify if it's at the current selection if (categoriesSelected.Contains(categoryId) && (unitsSelected.Contains(unitId))) { // Insert rule category units RuleCategoryUnits ruleCategoryUnits = new RuleCategoryUnits(null); ruleCategoryUnits.InsertDirect(ruleId, categoryId, unitId, false, companyId); // Insert checklist foreach (int companyLevelId in companyLevelsSelected) { UnitsGateway unitsGateway = new UnitsGateway(null); if (unitsGateway.IsUsedInUnitsAndNotIsDisposed(unitId, companyLevelId)) { ChecklistGateway checklistGateway = new ChecklistGateway(null); if (checklistGateway.IsUsedInChecklist(unitId, ruleId, true)) { Checklist checklist = new Checklist(null); checklist.UnDeleteDirect(ruleId, unitId, companyId); } else { Checklist checklist = new Checklist(null); checklist.InsertDirect(unitId, ruleId, null, null, false, "Unknown", false, companyId); } } } } } } } } }
// //////////////////////////////////////////////////////////////////////// // STEP5 - UNITS - METHODS // private void StepUnitsIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Please select the units to which the rule will be applied"; // Load Units int companyId = Int32.Parse(hdfCompanyId.Value); string category = ""; UnitsList unitsList = new UnitsList(new DataSet()); foreach (int categoryId in arrayCategoriesSelected) { CategoryGateway categoryGateway = new CategoryGateway(); //Verify the location of the unit foreach (int companyLevelId in arrayCompanyLevelsSelected) { // Load the unit if corresponds categoryGateway.LoadByCategoryId(categoryId, Int32.Parse(hdfCompanyId.Value)); category = categoryGateway.GetName(categoryId); unitsList.LoadAndAddItemByCategoryCompanyLevelId(category, companyLevelId, companyId); } } // Select all units by default if (unitsList.Table != null) { cbxlUnitsSelected.DataSource = RemoveDuplicateRows(unitsList.Table, "UnitID"); cbxlUnitsSelected.DataValueField = "UnitID"; cbxlUnitsSelected.DataTextField = "UnitCode"; cbxlUnitsSelected.DataBind(); foreach (ListItem lst in cbxlUnitsSelected.Items) { lst.Selected = true; } // Total units lblTotalUnits.Text = "Total Units: " + cbxlUnitsSelected.Items.Count; Session["arrayUnitsSelected"] = arrayUnitsSelected; } else { // Total units lblTotalUnits.Text = "Total Units: 0"; } }
/// <summary> /// Save /// </summary> public void Save() { foreach (CategoriesAddTDS.CategoriesAddNewRow row in (CategoriesAddTDS.CategoriesAddNewDataTable)Data.Tables["CategoriesAddNew"]) { // Insert category if ((!row.Deleted) && (!row.InDatabase)) { int? parentId = null; if (!row.IsParentIDNull()) parentId = row.ParentID; InsertCategory(row.Type, row.Name, parentId, row.Deleted, row.COMPANY_ID); } // Update category if ((!row.Deleted) && (row.InDatabase)) { int companyId = row.COMPANY_ID; CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.LoadByCategoryId(row.CategoryID, companyId); int categoryId = row.CategoryID; string originalType = categoryGateway.GetType(categoryId); string originalName = categoryGateway.GetName(categoryId); int? originalParentId = null; if (categoryGateway.GetParentId(categoryId).HasValue) originalParentId = (int)categoryGateway.GetParentId(categoryId); bool originalDeleted = categoryGateway.GetDeleted(categoryId); UpdateCategory(categoryId, originalType, originalName, originalParentId, originalDeleted, companyId, row.CategoryID, row.Type, row.Name, originalParentId, row.Deleted, companyId); } // Delete category if ((row.Deleted) && (row.InDatabase)) { int categoryId = row.CategoryID; int? newCategoryId = null; if (!row.IsNewCategoryIDNull()) newCategoryId = row.NewCategoryID; int companyId = row.COMPANY_ID; UpdateUnitsAndRulesCategories(categoryId, newCategoryId, companyId); DeleteCategory(categoryId, 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); } } } } }
protected void tvCategoriesRoot_TreeNodeCheckChanged(object sender, TreeNodeEventArgs e) { // Validate to load checked units hdfCheckUnitsFlag.Value = "No"; // Get categories arrayCategoriesSelectedForEdit.Clear(); foreach (TreeNode nodes in tvCategoriesRoot.Nodes) { GetCategoriesSelected(nodes); } // Load Units int companyId = Int32.Parse(hdfCompanyId.Value); string category = ""; UnitsList unitsList = new UnitsList(new DataSet()); foreach (int categoryId in arrayCategoriesSelectedForEdit) { CategoryGateway categoryGateway = new CategoryGateway(); //Verify the location of the unit foreach (int companyLevelId in arrayCompanyLevelsSelectedForEdit) { // Load the unit if corresponds categoryGateway.LoadByCategoryId(categoryId, Int32.Parse(hdfCompanyId.Value)); category = categoryGateway.GetName(categoryId); unitsList.LoadAndAddItemByCategoryCompanyLevelId(category, companyLevelId, companyId); } } if (unitsList.Table != null) { cbxlUnitsSelected.DataSource = RemoveDuplicateRows(unitsList.Table, "UnitID"); cbxlUnitsSelected.DataValueField = "UnitID"; cbxlUnitsSelected.DataTextField = "UnitCode"; cbxlUnitsSelected.DataBind(); // Total units lblTotalUnits.Text = "Total Units: " + cbxlUnitsSelected.Items.Count; } else { // Total units lblTotalUnits.Text = "Total Units: 0"; } }
// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // STEP5 - SUMMARY // // //////////////////////////////////////////////////////////////////////// // STEP5 - SUMMARY - METHODS // private void StepSummaryIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Summary"; hdfUpdate.Value = "yes"; string isTowable = "No"; if (cbxIsTowable.Checked) isTowable = "Yes"; else isTowable = "No"; string unitType = (rbtnVehicle.Checked) ? unitType = "Vehicle" : unitType = "Equipment"; string vinOrSerialNumber = (rbtnVehicle.Checked) ? vinOrSerialNumber = "VIN" : vinOrSerialNumber = "Serial Number"; string categoriesSelected = ""; foreach (int categoryId in arrayCategoriesSelected) { CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.LoadByCategoryId(categoryId, Int32.Parse(hdfCompanyId.Value)); categoriesSelected += categoryGateway.GetName(categoryId) + ", "; } if (categoriesSelected.Length > 2) { categoriesSelected = categoriesSelected.Substring(0, categoriesSelected.Length - 2); } string companyLevelsSelected = ""; foreach (int companyLevelId in arrayCompanyLevelsSelected) { CompanyLevelGateway companyLevelGateway = new CompanyLevelGateway(); companyLevelGateway.LoadByCompanyLevelId(companyLevelId, Int32.Parse(hdfCompanyId.Value)); companyLevelsSelected += companyLevelGateway.GetName(companyLevelId) + ", "; } if (companyLevelsSelected.Length > 2) { companyLevelsSelected = companyLevelsSelected.Substring(0, companyLevelsSelected.Length - 2); } tbxSummary.Text = "Unit Type: " + unitType + "\nCode: " + tbxCode.Text + "\nDescription: " + tbxDescription.Text + "\n" + vinOrSerialNumber + ": " + tbxVinSerialNumber.Text + "\nManufacturer: " + tbxManufacturer.Text + "\nModel: " + tbxModel.Text + "\nYear: " + tbxYear.Text + "\nIs Towable?: " + isTowable + "\nCategories: " + categoriesSelected + "\nCompany Levels: " + companyLevelsSelected; if (rbtnVehicle.Checked) { string licenseCountry = ""; string licenceState = ""; if (ddlLicenseCountry.SelectedValue != "-1") { licenseCountry = ddlLicenseCountry.SelectedItem.Text; if (ddlLicenseState.SelectedValue != "-1" && ddlLicenseState.SelectedValue != "") { licenceState = ddlLicenseState.SelectedItem.Text; } } tbxSummary.Text += "\nLicense Country: " + licenseCountry + "\nLicense State: " + licenceState + "\nLicense Plate Number: " + tbxLicensePlateNumber.Text + "\nApportioned Tag Number: " + tbxApportionedTagNumber.Text; } }
/// <summary> /// GetChilds /// </summary> /// <param name="categoryId">categoryId</param> /// <param name="currentCategoriesId">currentCategoriesId</param> /// <param name="companyId">companyId</param> /// <returns></returns> private ArrayList GetChilds(int categoryId, ArrayList currentCategoriesId, int companyId) { ArrayList categoriesId = currentCategoriesId; CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.LoadByParentId(categoryId, companyId); foreach (CategoriesTDS.LFS_FM_CATEGORYRow row in ((CategoriesTDS.LFS_FM_CATEGORYDataTable)categoryGateway.Table)) { categoriesId.Add(row.CategoryID); categoriesId = GetChilds(row.CategoryID, categoriesId, companyId); } return categoriesId; }
/// <summary> /// Save /// </summary> /// <param name="categoriesSelected">categoriesSelected</param> /// <param name="companyId">companyId</param> public void Save(ArrayList categoriesSelected, int companyId) { UnitsAddTDS unitsAddChanges = (UnitsAddTDS)Data.GetChanges(); if (unitsAddChanges.UnitsAddNew.Rows.Count > 0) { foreach (UnitsAddTDS.UnitsAddNewRow row in (UnitsAddTDS.UnitsAddNewDataTable)unitsAddChanges.UnitsAddNew) { string type = ""; if (!row.IsTypeNull()) type = row.Type; string code = row.Code; string description = ""; if (!row.IsDescriptionNull()) description = row.Description; string vin = ""; if (!row.IsVINNull()) vin = row.VIN; string manufacturer = ""; if (!row.IsManufacturerNull()) manufacturer = row.Manufacturer; string model = ""; if (!row.IsModelNull()) model = row.Model; string year_ = ""; if (!row.IsYear_Null()) year_ = row.Year_; bool isTowable = row.IsTowable; Int64? licenseCountry = null; if (!row.IsLicenseCountryNull()) licenseCountry = row.LicenseCountry; Int64? licenseState = null; if (!row.IsLicenseStateNull()) licenseState = row.LicenseState; string licensePlateNumber = ""; if (!row.IsLicensePlateNumberNull()) licensePlateNumber = row.LicensePlateNumber; int companyLevelId = row.CompanyLevelID; string apportionedTagNumber = ""; if (!row.IsApportionedTagNumberNull()) apportionedTagNumber = row.ApportionedTagNumber; string categories = ""; if (categoriesSelected.Count > 0) { foreach (int categoryId in categoriesSelected) { CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.LoadByCategoryId(categoryId, companyId); categories = categories + categoryGateway.GetName(categoryId) + ", "; } if (categories.Length > 2) { categories = categories.Substring(0, categories.Length - 2); } } Units units = new Units(null); int unitId = units.InsertDirect(code, description, vin, manufacturer, model, year_, isTowable, companyLevelId, null, null, "", "", null, null, "", "", null, null, "", "Active", type, false, companyId, "", categories, "", "", null, null, null, null); // ... Insert vehicle info if (type == "Vehicle") { new UnitsVehicle(null).InsertDirect(unitId, licenseCountry, licenseState, licensePlateNumber, apportionedTagNumber, "", "", "", "", "", "", "", false, false, false, companyId); } // Save UnitCategory UpdateUnitCategory(unitId, companyId, categoriesSelected); // Save Checklist UnitsChecklistRulesTemp unitChecklistRulesTemp = new UnitsChecklistRulesTemp(Data); unitChecklistRulesTemp.Save(unitId, companyId); } } }
/// <summary> /// DeleteRuleCategory /// </summary> /// <param name="ruleId">ruleId</param> /// <param name="companyId">companyId</param> private void DeleteRuleCategory(int ruleId, int companyId) { // Delete RuleCategoryUnits RuleCategoryUnits ruleCategoryUnits = new RuleCategoryUnits(null); RuleCategoryUnitsGateway ruleCategoryUnitsGateway = new RuleCategoryUnitsGateway(null); if (ruleCategoryUnitsGateway.IsRuleUsed(ruleId)) { ruleCategoryUnits.DeleteDirectByRuleId(ruleId, companyId); } // Load all categories CategoryGateway categoryGateway = new CategoryGateway(); categoryGateway.Load(companyId); // Delete rule categories if (categoryGateway.Table.Rows.Count > 0) { foreach (CategoriesTDS.LFS_FM_CATEGORYRow row in (CategoriesTDS.LFS_FM_CATEGORYDataTable)categoryGateway.Table) { int categoryId = row.CategoryID; RuleCategoryGateway ruleCategoryGateway = new RuleCategoryGateway(null); if (ruleCategoryGateway.IsUsedInRuleCategory(ruleId, categoryId)) { RuleCategory ruleCategory = new RuleCategory(null); ruleCategory.DeleteDirect(ruleId, categoryId, companyId); } } } }