示例#1
0
 /// <summary>
 /// Database definitions
 /// </summary>
 /// <param name="modelBuilder">model builder</param>
 protected new virtual void OnModelCreating(ModelBuilder modelBuilder)
 {
     Cluster.OnModelCreating(modelBuilder);
     Contract.OnModelCreating(modelBuilder);
     Invoice.OnModelCreating(modelBuilder);
     Organisation.OnModelCreating(modelBuilder);
     OrganisationMetadata.OnModelCreating(modelBuilder);
     Server.OnModelCreating(modelBuilder);
     MicroService.OnModelCreating(modelBuilder);
 }
示例#2
0
        /// <summary>
        /// Update an existing organisation
        /// </summary>
        /// <param name="organisation">DTO containing the organisation definition</param>
        /// <param name="scope">In which scope is the organisation updated</param>
        /// <returns>The updated organisation</returns>
        public static Organisation Update(Monosoft.Auth.DTO.Organisation organisation, string scope)
        {
            // TODO: revisionslog, hvem har opdateret (fra hvad, til hvad og hvornår)
            Organisation dborg = DataContext.Instance.Organisations.Where(p => p.Id == organisation.Id).FirstOrDefault();

            if (dborg != null)
            {
                dborg.Name = organisation.Name;
                dborg.ParentOrganisation = DataContext.Instance.Organisations.Where(p => p.Id == organisation.ParentOrganisation).FirstOrDefault();
                dborg.Cluster            = DataContext.Instance.Clusters.Where(p => p.ClusterId == organisation.Cluster.ClusterId).FirstOrDefault();

                if (dborg.Cluster != null)
                {
                    if (organisation.Contracts != null)
                    {
                        var removedContracts = dborg.Contracts.Where(p => organisation.Contracts.Select(x => x.ContractNo).Contains(p.ContractNo) == false).ToList();
                        var updatedContracts = dborg.Contracts.Where(p => organisation.Contracts.Select(x => x.ContractNo).Contains(p.ContractNo) == true).ToList();
                        var addedContracts   = organisation.Contracts.Where(x => dborg.Contracts.Select(p => p.ContractNo).Contains(x.ContractNo) == false).ToList();

                        foreach (var contract in removedContracts)
                        {
                            DataContext.Instance.Contracts.Remove(contract);
                        }

                        foreach (var contract in addedContracts)
                        {
                            Contract dbcontract = new Contract();
                            dbcontract.Base64File      = contract.Base64File;
                            dbcontract.Description     = contract.Description;
                            dbcontract.Interval        = contract.Interval;
                            dbcontract.IsActive        = contract.IsActive;
                            dbcontract.NextInvoicedate = contract.NextInvoicedate;
                            dbcontract.OngoingPayment  = contract.OngoingPayment;
                            dbcontract.Organisation    = dborg;
                            dbcontract.Payout          = contract.Payout;
                            dbcontract.Title           = contract.Title;
                            DataContext.Instance.Contracts.Add(dbcontract);
                        }

                        foreach (var contract in updatedContracts)
                        {
                            var dbcontract = DataContext.Instance.Contracts.Where(p => p.ContractNo == contract.ContractNo && p.Organisation == dborg).FirstOrDefault();
                            dbcontract.Base64File      = contract.Base64File;
                            dbcontract.Description     = contract.Description;
                            dbcontract.Interval        = contract.Interval;
                            dbcontract.IsActive        = contract.IsActive;
                            dbcontract.NextInvoicedate = contract.NextInvoicedate;
                            dbcontract.OngoingPayment  = contract.OngoingPayment;
                            dbcontract.Organisation    = dborg;
                            dbcontract.Payout          = contract.Payout;
                            dbcontract.Title           = contract.Title;
                        }
                    }

                    if (organisation.Invoices != null)
                    {
                        var removedInvoices = dborg.Invoices.Where(p => organisation.Invoices.Select(x => x.Invoiceno).Contains(p.InvoiceNo) == false).ToList();
                        var updatedInvoices = dborg.Invoices.Where(p => organisation.Invoices.Select(x => x.Invoiceno).Contains(p.InvoiceNo) == true).ToList();
                        var addedInvoices   = organisation.Invoices.Where(x => dborg.Invoices.Select(p => p.InvoiceNo).Contains(x.Invoiceno) == false).ToList();

                        foreach (var invoice in removedInvoices)
                        {
                            DataContext.Instance.Invoices.Remove(invoice);
                        }

                        foreach (var invoice in addedInvoices)
                        {
                            Invoice dbinvoice = new Invoice();
                            dbinvoice.Amout        = invoice.Amout;
                            dbinvoice.Base64File   = invoice.Base64File;
                            dbinvoice.Details      = invoice.Details;
                            dbinvoice.DueDate      = invoice.DueDate;
                            dbinvoice.Invoicedate  = invoice.Invoicedate;
                            dbinvoice.Organisation = dborg;
                            dbinvoice.Status       = invoice.Status;
                            dbinvoice.Titel        = invoice.Titel;
                            DataContext.Instance.Invoices.Add(dbinvoice);
                        }

                        foreach (var invoice in updatedInvoices)
                        {
                            var dbinvoice = DataContext.Instance.Invoices.Where(p => p.InvoiceNo == invoice.InvoiceNo && p.Organisation == dborg).FirstOrDefault();
                            dbinvoice.Amout        = invoice.Amout;
                            dbinvoice.Base64File   = invoice.Base64File;
                            dbinvoice.Details      = invoice.Details;
                            dbinvoice.DueDate      = invoice.DueDate;
                            dbinvoice.Invoicedate  = invoice.Invoicedate;
                            dbinvoice.Organisation = dborg;
                            dbinvoice.Status       = invoice.Status;
                            dbinvoice.Titel        = invoice.Titel;
                        }
                    }

                    dborg.Metadata.Clear();
                    foreach (var metadata in organisation.Metadata)
                    {
                        OrganisationMetadata meta = new OrganisationMetadata();
                        meta.Organisation = dborg;
                        meta.Key          = metadata.Key;
                        // if (metadata.Scope != scope)
                        // {
                        //     throw new Exception("CRITICAL ERROR: Metadata scope does not match login scope");
                        // }
                        meta.Scope = metadata.Scope;
                        meta.Value = metadata.Value;

                        DataContext.Instance.OrganisationMetadatas.Add(meta);
                    }

                    DataContext.Instance.SaveChanges();
                    return(dborg);
                }
            }

            return(null);
        }
示例#3
0
        /// <summary>
        /// Create a new organisation
        /// </summary>
        /// <param name="organisation">DTO containing the organisation definition</param>
        /// <param name="scope">In which scope is the organisation created</param>
        /// <returns>The created organisation</returns>
        public static Organisation Create(Monosoft.Auth.DTO.Organisation organisation, string scope)
        {
            // TODO: revisionslog, hvem har opdateret (fra hvad, til hvad og hvornår)
            Organisation dborg = new Organisation();

            dborg.Name = organisation.Name;
            dborg.ParentOrganisation = DataContext.Instance.Organisations.Where(p => p.Id == organisation.ParentOrganisation).FirstOrDefault();
            dborg.Cluster            = DataContext.Instance.Clusters.Where(p => p.ClusterId == organisation.Cluster.ClusterId).FirstOrDefault();

            if (dborg.Cluster != null) // dborg.ParentOrganisation != null &&  <-- fjernet pga. problem med første org. (i.e. vil altid være null)
            {
                DataContext.Instance.Organisations.Add(dborg);
                if (organisation.Contracts != null)
                {
                    foreach (var contract in organisation.Contracts)
                    {
                        Contract dbcontract = new Contract();
                        dbcontract.Organisation    = dborg;
                        dbcontract.Base64File      = contract.Base64File;
                        dbcontract.Description     = contract.Description;
                        dbcontract.Interval        = contract.Interval;
                        dbcontract.IsActive        = contract.IsActive;
                        dbcontract.NextInvoicedate = contract.NextInvoicedate;
                        dbcontract.OngoingPayment  = contract.OngoingPayment;
                        dbcontract.Payout          = contract.Payout;
                        dbcontract.Title           = contract.Title;
                        DataContext.Instance.Contracts.Add(dbcontract);
                    }
                }

                if (organisation.Invoices != null)
                {
                    foreach (var invoice in organisation.Invoices)
                    {
                        Invoice dbinvoice = new Invoice();
                        dbinvoice.Organisation = dborg;
                        dbinvoice.Amout        = invoice.Amout;
                        dbinvoice.Base64File   = invoice.Base64File;
                        dbinvoice.Details      = invoice.Details;
                        dbinvoice.DueDate      = invoice.DueDate;
                        dbinvoice.Invoicedate  = invoice.Invoicedate;
                        dbinvoice.Status       = invoice.Status;
                        dbinvoice.Titel        = invoice.Titel;
                        DataContext.Instance.Invoices.Add(dbinvoice);
                    }
                }

                if (organisation.Metadata != null)
                {
                    foreach (var metadata in organisation.Metadata)
                    {
                        OrganisationMetadata meta = new OrganisationMetadata();
                        meta.Organisation = dborg;
                        meta.Key          = metadata.Key;
                        // if (metadata.Scope != scope)
                        //{
                        //    throw new Exception("CRITICAL ERROR: Metadata scope does not match login scope");
                        //}

                        meta.Scope = metadata.Scope;
                        meta.Value = metadata.Value;

                        DataContext.Instance.OrganisationMetadatas.Add(meta);
                    }
                }

                DataContext.Instance.SaveChanges();
                return(dborg);
            }

            return(null);
        }