Ejemplo n.º 1
0
        public static void Insert(Organisation_RegisterBindModel register)
        {
            Organisation       org = Organisations.GetById(register.OrganisationID);
            RegisterManagement registerFromDatabase = RegistersManagement.GetById(register.RegisterID);

            if (org == null || registerFromDatabase == null)
            {
                return;
            }

            string sql = "INSERT INTO Organisation_Register VALUES(@OrganisationID, @RegisterID, @FromDate, @UntilDate)";

            DbParameter par0 = Database.AddParameter(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], "@OrganisationID", register.OrganisationID);
            DbParameter par1 = Database.AddParameter(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], "@RegisterID", register.RegisterID);
            DbParameter par2 = Database.AddParameter(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], "@FromDate", register.FromDate);
            DbParameter par3 = Database.AddParameter(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], "@UntilDate", register.UntilDate);

            Database.InsertData(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], sql, par0, par1, par2, par3);

            sql = "INSERT INTO Registers VALUES(@ID, @RegisterName, @Device)";
            ConnectionStringSettings settings = new ConnectionStringSettings("KlantDynamicConnection", org.DatabaseConnectionString, "System.Data.SqlClient");;

            DbParameter parRegisterName   = Database.AddParameter(settings, "@RegisterName", registerFromDatabase.Name);
            DbParameter parID             = Database.AddParameter(settings, "@ID", registerFromDatabase.ID);
            DbParameter parRegisterDevice = Database.AddParameter(settings, "@Device", registerFromDatabase.Device);

            Database.InsertData(settings, sql, parRegisterDevice, parRegisterName, parID);
        }
Ejemplo n.º 2
0
        public static void DeleteRegister(int id)
        {
            RegisterManagement register = RegistersManagement.GetById(id);

            string sql = "DELETE FROM Organisation_Register WHERE RegisterID=@ID";

            DbParameter parId = Database.AddParameter(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], "@ID", id);

            Database.ModifyData(ConfigurationManager.AppSettings["ConnectionStringItBedrijf"], sql, parId);

            // Delete the register from the client database
            if (register.AssignedTo != null)
            {
                sql = "DELETE FROM Registers WHERE ID=@ID";

                ConnectionStringSettings settings = new ConnectionStringSettings("KlantDynamicConnection", register.AssignedTo.DatabaseConnectionString, "System.Data.SqlClient");;

                DbParameter parRegisterID = Database.AddParameter(settings, "@ID", register.ID);

                Database.ModifyData(settings, sql, parRegisterID);
            }
        }