Example #1
0
        /// <summary>
        /// DeleteDirect
        /// </summary>
        /// <param name="assetId">assetId</param>
        /// <param name="companyId">companyId</param>
        public bool DeleteDirect(int assetId, int companyId)
        {
            // delete materials
            AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(null);
            assetSewerMaterial.DeleteAllDirect(assetId, companyId);

            // delete sewer
            AssetSewerGateway assetSewerGateway = new AssetSewerGateway(Data);
            assetSewerGateway.Delete(assetId, companyId);

            return true;
        }
        /// <summary>
        /// Save all materials to database (direct)
        /// </summary>
        /// <param name="companyId">companyId</param>        
        public void Save(int companyId)
        {
            MaterialInformationTDS materialInformationChanges = (MaterialInformationTDS)Data.GetChanges();

            if (materialInformationChanges.MaterialInformation.Rows.Count > 0)
            {
                MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationChanges);

                foreach (MaterialInformationTDS.MaterialInformationRow row in (MaterialInformationTDS.MaterialInformationDataTable)materialInformationChanges.MaterialInformation)
                {
                    // Insert new materials
                    if ((!row.Deleted) && (!row.InDatabase))
                    {
                        AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(null);
                        assetSewerMaterial.InsertDirect(row.AssetID, row.RefID, row.MaterialType, row.Date_, row.Deleted, row.COMPANY_ID);
                    }

                    // Update materials
                    if ((!row.Deleted) && (row.InDatabase))
                    {
                        int assetId = row.AssetID;
                        int refId = row.RefID;
                        bool originalDeleted = false;
                        int originalCompanyId = companyId;

                        // original values
                        string originalMaterialType = materialInformationGateway.GetMaterialTypeOriginal(assetId, refId);
                        DateTime originalDate_ = materialInformationGateway.GetDate_Original(assetId, refId);

                        // new values
                        string newMaterialType = materialInformationGateway.GetMaterialType(assetId, refId);

                        AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(null);
                        assetSewerMaterial.UpdateDirect(assetId, refId, originalMaterialType, originalDate_, originalCompanyId, originalDeleted, assetId, refId, newMaterialType, originalDate_, originalCompanyId, originalDeleted);
                    }

                    // Deleted materials
                    if ((row.Deleted) && (row.InDatabase))
                    {
                        AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(null);
                        assetSewerMaterial.DeleteDirect(row.AssetID, row.RefID, row.COMPANY_ID);
                    }
                }
            }
        }
        /// <summary>
        /// Insert a material
        /// </summary>
        /// <param name="lateral_assetId">lateral_assetId</param>
        /// <param name="material">material</param>
        /// <param name="companyId">companyId</param>
        private void InsertMaterial(int lateral_assetId, string material, int companyId)
        {
            LfsAssetSewerLateralGateway lfsAssetSewertLateralGateway = new LfsAssetSewerLateralGateway(null);
            if (!lfsAssetSewertLateralGateway.IsUsedInMaterials(lateral_assetId, material, companyId))
            {
                MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway();
                materialInformationGateway.LoadAllByAssetId(lateral_assetId, companyId);

                AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(materialInformationGateway.Data);
                assetSewerMaterial.InsertDirect(lateral_assetId, materialInformationGateway.Table.Rows.Count + 1, material, DateTime.Now, false, companyId);
            }
        }