Пример #1
0
        public int Insert(AgentDTO oAgentData)
        {
            DatabaseManager oDB;
            int             agentId = -1;

            try
            {
                oDB = new DatabaseManager();
                string sProcName = "up_Ins_AgentMaster";
                oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sAgentCode", DbType.String, oAgentData.AgentCode);
                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sAgentName", DbType.String, oAgentData.AgentName);
                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AgentEmailId", DbType.String, DataSecurityManager.Encrypt(oAgentData.EmailId));
                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Password", DbType.String, DataSecurityManager.Encrypt(oAgentData.Password));
                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Category", DbType.String, DataSecurityManager.Encrypt(oAgentData.category));
                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@Country", DbType.String, DataSecurityManager.Encrypt(oAgentData.country));
                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@localAgent", DbType.Byte, oAgentData.localagent);
                    << << << < HEAD

                    oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@CssPath", DbType.String, oAgentData.CssPath);

                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RedirectURL", DbType.String, oAgentData.RedirectURL);
                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@IsPaymentBypass", DbType.Boolean, (oAgentData.IsPaymentBypass));

                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AgentURL", DbType.String, (oAgentData.AgentURL));
        /// <summary>
        /// Reads full database schema
        /// </summary>
        public override void FillSchema(DbDatabase schemaDatabase)
        {
            if (schemaDatabase == null)
                throw new ArgumentNullException("schemaDatabase", "Database is not specifed.");

            schemaDatabase.SchemaViews = ReadViews();
            schemaDatabase.SchemaTables = ReadTables(schemaDatabase.SchemaViews);
        }
Пример #3
0
 public Generator(ProjectDefinaton project, PatternProject pattern, DbDatabase database, ExSchemaEngine schemaEngine)
 {
     _patternProject = pattern;
     _projectDef = project;
     _database = database;
     _schemaEngine = schemaEngine;
     _optionGenerateUnselectedForeigns = false;
 }
Пример #4
0
        public static void Start()
        {
            DbDatabase.DefaultConnectionFactory = new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0");

            // Sets the default database initialization code for working with Sql Server Compact databases
            // Uncomment this line and replace CONTEXT_NAME with the name of your DbContext if you are
            // using your DbContext to create and manage your database
            DbDatabase.SetInitializer(new DropCreateCeDatabaseIfModelChanges <TodoContext>());
        }
Пример #5
0
        protected void Application_Start()
        {
            DbDatabase.SetInitializer <SitioWebEntities>(new SitioWebInitializer());

            AreaRegistration.RegisterAllAreas();

            RegisterGlobalFilters(GlobalFilters.Filters);
            RegisterRoutes(RouteTable.Routes);
        }
        public override string ToString()
        {
            DbDatabase db = new DbDatabase();

            this.Person = db.GetPerson(this.PersonId);
            return(String.Format("index: {0}, Type: {1},  Name: {2}, Description: " +
                                 "{3}, Price: {4}, Phone: {5}, Owner: {6} {7}\n",
                                 AdvertId, Type, Name, Description, Price, Person.PhoneNumber, Person.PersonFirstname, Person.PersonLastname));
        }
Пример #7
0
        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();

            RegisterGlobalFilters(GlobalFilters.Filters);
            RegisterRoutes(RouteTable.Routes);

            DbDatabase.SetInitializer(new ActivityLogDbInitilaizer());
        }
Пример #8
0
        /// <summary>
        /// Tries the delete table async.
        /// </summary>
        /// <param name="database"></param>
        /// <param name="databaseName"></param>
        /// <returns>A Task.</returns>
        public static async Task <int> TryDeleteDatabaseAsync <T>(this DbDatabase database, string databaseName)
        {
            var exist = await database.IsExistDataBaseAsync(databaseName);

            if (exist)
            {
                return(await database.CreateDatabaseAsync(databaseName));
            }
            return(-1);
        }
        /// <summary>
        /// Reads full database schema
        /// </summary>
        public override void FillSchema(DbDatabase schemaDatabase)
        {
            if (schemaDatabase == null)
            {
                throw new ArgumentNullException("schemaDatabase", "Database is not specifed.");
            }

            schemaDatabase.SchemaViews  = ReadViews();
            schemaDatabase.SchemaTables = ReadTables(schemaDatabase.SchemaViews);
        }
 public HairAndSolelessContext()
 {
     // Instructions:
     //  * You can add custom code to this file. Changes will *not* be lost when you re-run the scaffolder.
     //  * If you want to regenerate the file totally, delete it and then re-run the scaffolder.
     //  * You can delete these comments if you wish
     //  * If you want Entity Framework to drop and regenerate your database automatically whenever you
     //    change your model schema, uncomment the following line:
     DbDatabase.SetInitializer(new HairAndSolelessInitializer());
 }
        private static void runCodeFirst()
        {
            DbDatabase.SetInitializer <ConferenceModel>(new DropCreateDatabaseAlways <ConferenceModel>());
            using (var context = new ConferenceModel())
            {
                var speaker = new Speaker {
                    FirstName = "Julie", LastName = "Lerman"
                };
                var session = new Session
                {
                    Title           = "Code First Design",
                    ConferenceTrack =
                        new ConferenceTrack {
                        TrackName = "Data", TrackChair = "Damien Guard", MinSessions = 5
                    },
                    Abstract = "tbd",
                };
                var session2 = new Session
                {
                    Title           = "From Sap to Syrup",
                    ConferenceTrack =
                        new ConferenceTrack {
                        TrackName = "Vermont", TrackChair = "Ethan Allen"
                    },
                    Abstract = "How maple syrup is made",
                };
                var speaker2 = new Speaker {
                    FirstName = "Suzanne", LastName = "Shushereba"
                };
                context.Speakers.Add(speaker);
                context.Speakers.Add(speaker2);
                speaker.Sessions = new List <Session>();
                speaker.Sessions.Add(session);
                speaker.Sessions.Add(session2);
                speaker2.Sessions = new List <Session>();
                speaker2.Sessions.Add(session2);
                context.SaveChanges();
            }
            using (var context = new ConferenceModel())
            {
                foreach (var dbSession in context.Sessions.Include("Speakers"))
                {
                    Console.WriteLine();
                    Console.WriteLine(dbSession.Title);
                    Console.WriteLine("Speakers:");

                    foreach (var sessionSpeaker in dbSession.Speakers)
                    {
                        Console.WriteLine(".... {0}", sessionSpeaker.Name);
                    }
                }
                Console.WriteLine("Press Any Key To Continue...");
                Console.ReadKey();
            }
        }
Пример #12
0
        public void InitializeDatabaseTest()
        {
            DbDatabase.SetInitializer(new NotifyIfModelOutOfSync <DatabaseContext>());

            // TODO: Implement unit test

            using (var db = new DatabaseContext())
            {
                db.Database.Initialize(true);
            }
        }
Пример #13
0
    static void Main(string[] args)
    {
        DbDatabase.DefaultConnectionFactory = new System.Data.Entity.Database.SqlConnectionFactory("Data Source=.;Integrated Security=SSPI");
        DbDatabase.SetInitializer <StockContext>(new DropCreateDatabaseIfModelChanges <StockContext>());
        StockContext oContext = new StockContext();

        oContext.StockOrders.Add(new StockOrder {
            StockOrderID = 2, Name = "test"
        });
        oContext.SaveChanges();
    }
        /// <summary>
        /// Reads full database schema
        /// </summary>
        public override void FillSchema(DbDatabase schemaDatabase)
        {
            if (schemaDatabase == null)
                throw new ArgumentNullException("schemaDatabase", "Database is not specifed.");

            try
            {
                schemaDatabase.SchemaViews = ReadViews();
                schemaDatabase.SchemaTables = ReadTables(schemaDatabase.SchemaViews);
            }
            finally
            {
                // be sure the connection is closed
                _dbConnection.Close();
            }
        }
Пример #15
0
        public bool updatestatus(RoomDTO oAccomRoomData)
        {
            string          sProcName;
            DatabaseManager oDB;

            try
            {
                oDB = new DatabaseManager();

                sProcName = "updateactivestatus";
                oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);

                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sRoomNo", DbType.String, oAccomRoomData.RoomNo);
                oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomId", DbType.Int32, oAccomRoomData.AccomodationId);
                    << << << < HEAD
                    oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@roomcatid", DbType.Int32, oAccomRoomData.roomcategoryid);
        /// <summary>
        /// Reads full database schema
        /// </summary>
        public override void FillSchema(DbDatabase schemaDatabase)
        {
            if (schemaDatabase == null)
            {
                throw new ArgumentNullException("schemaDatabase", "Database is not specifed.");
            }

            try {
                schemaDatabase.SchemaViews  = ReadViews();
                schemaDatabase.SchemaTables = ReadTables(schemaDatabase.SchemaViews);
            }
            finally {
                // be sure the connection is closed
                _dbConnection.Close();
            }
        }
Пример #17
0
        public void TableSchemaConventionTest()
        {
            DbDatabase.SetInitializer(new DropCreateDatabaseAlways <DatabaseContext>());

            using (var db = new DatabaseContext())
            {
                db.Database.Initialize(true);

                var expected = typeof(DatabaseContext).GetProperties().Where(x => x.PropertyType.Name == "DbSet`1")
                               .Select(x => new { Namespace = x.PropertyType.GetGenericArguments()[0].FullName, PropertyName = x.Name })
                               .Select(x => { var i1 = x.Namespace.LastIndexOf('.'); var i2 = x.Namespace.LastIndexOf('.', i1 - 1); return(x.Namespace.Substring(i2 + 1, i1 - i2) + x.PropertyName); })
                               .OrderBy(x => x).ToArray();

                var actual = db.Database.SqlQuery <string>(SqlQueries.SelectFullTableNames).ToArray();

                CollectionAssert.AreEqual(expected, actual);
            }
        }
Пример #18
0
 static void Main(string[] args)
 {
     DbDatabase.SetInitializer(new CreateDatabaseIfNotExists <BookDbContext>());
     using (var context = new ShapeDbContext())
     {
         // creating a new object
         context.Polygons.Add(new Polygon {
             Name = "P1", Perimiter = 3
         });
         context.Polygons.Add(new Polygon {
             Name = "P2", Perimiter = 2
         });
         context.SaveChanges();
     }
     using (var context = new ShapeDbContext())
     {
         // creating a new object
         var polygons = context.Polygons.Where(o => o.Perimiter < 3);
         Console.WriteLine(polygons.Count());
     }
 }
        public void InitializeSchemaProject()
        {
            Project  = new ProjectDefinaton();
            Pattern  = new PatternProject();
            Database = new DbDatabase();

            Project.GenerationPath = Path.Combine(Path.GetTempPath(), @"SalarDbCodeGenerator.Tests\" + DateTime.Now.Ticks);
            Project.ProjectName    = "SalarDbCodeGenerator.Tests";

            Pattern.LanguageSettings.KeywordsCaseSensitive        = true;
            Pattern.LanguageSettings.LanguageInvalidChars         = ", ./<>?;'\\:\"|[]{}`-=~!@#$%^&*()+";
            Pattern.LanguageSettings.LanguageInvalidCharsSuppress = '_';
            Pattern.LanguageSettings.LanguageKeywords.AddRange(new string[]
            {
                "readonly", "base", "break", "byte", "case", "catch", "checked",
                "class", "const", "continue", "default", "delegate", "do",
                "value", "else", "enum", "event", "explicit", "extern", "false",
                "finally", "fixed", "for", "foreach", "goto", "if", "implicit",
                "in", "interface", "internal", "is", "namespace", "new", "null",
                "object", "operator", "out", "override", "private", "protected",
                "public", "readonly", "ref", "return", "sealed", "sizeof",
                "static", "struct", "switch", "this", "throw", "true", "try",
                "typeof", "typeof", "unchecked", "unsafe", "using", "virtual",
                "while"
            });
            Pattern.LanguageSettings.NullableDataTypes.AddRange(new[] { "String", "Object" });
            Pattern.LanguageSettings.ExplicitCastDataTypes.AddRange(new[] { "Object", "Guid", "DateTimeOffset", "TimeSpan" });
            Pattern.LanguageSettings.VoidDataType             = "void";
            Pattern.LanguageSettings.TextFieldIdenticator     = "text";
            Pattern.LanguageSettings.ArrayIdenticator         = "[]";
            Pattern.LanguageSettings.DbDecimalName            = "decimal";
            Pattern.LanguageSettings.DbNumericName            = "numeric";
            Pattern.LanguageSettings.DbDecimalType            = "decimal([:Precision:],[:Scale:])";
            Pattern.LanguageSettings.DbNumericType            = "numeric([:Precision:],[:Scale:])";
            Pattern.LanguageSettings.LanguageKeywordsSuppress = "{0}_{1}";


            Database.DatabaseName = "SalarDbCodeGeneratorTests";
            Database.Provider     = DatabaseProvider.SQLServer;
        }
        public void InitializeSchemaProject()
        {
            Project = new ProjectDefinaton();
            Pattern = new PatternProject();
            Database = new DbDatabase();

            Project.GenerationPath = Path.Combine(Path.GetTempPath(), @"SalarDbCodeGenerator.Tests\" + DateTime.Now.Ticks);
            Project.ProjectName = "SalarDbCodeGenerator.Tests";

            Pattern.LanguageSettings.KeywordsCaseSensitive = true;
            Pattern.LanguageSettings.LanguageInvalidChars = ", ./<>?;'\\:\"|[]{}`-=~!@#$%^&*()+";
            Pattern.LanguageSettings.LanguageInvalidCharsSuppress = '_';
            Pattern.LanguageSettings.LanguageKeywords.AddRange(new string[]
                                                               	{
                                                               		"readonly", "base", "break", "byte", "case", "catch", "checked",
                                                               		"class", "const", "continue", "default", "delegate", "do",
                                                               		"value", "else", "enum", "event", "explicit", "extern", "false",
                                                               		"finally", "fixed", "for", "foreach", "goto", "if", "implicit",
                                                               		"in", "interface", "internal", "is", "namespace", "new", "null",
                                                               		"object", "operator", "out", "override", "private", "protected",
                                                               		"public", "readonly", "ref", "return", "sealed", "sizeof",
                                                               		"static", "struct", "switch", "this", "throw", "true", "try",
                                                               		"typeof", "typeof", "unchecked", "unsafe", "using", "virtual",
                                                               		"while"
                                                               	});
            Pattern.LanguageSettings.NullableDataTypes.AddRange(new[] { "String", "Object" });
            Pattern.LanguageSettings.ExplicitCastDataTypes.AddRange(new[] { "Object", "Guid", "DateTimeOffset", "TimeSpan" });
            Pattern.LanguageSettings.VoidDataType = "void";
            Pattern.LanguageSettings.TextFieldIdenticator = "text";
            Pattern.LanguageSettings.ArrayIdenticator = "[]";
            Pattern.LanguageSettings.DbDecimalName = "decimal";
            Pattern.LanguageSettings.DbNumericName = "numeric";
            Pattern.LanguageSettings.DbDecimalType = "decimal([:Precision:],[:Scale:])";
            Pattern.LanguageSettings.DbNumericType = "numeric([:Precision:],[:Scale:])";
            Pattern.LanguageSettings.LanguageKeywordsSuppress = "{0}_{1}";

            Database.DatabaseName = "SalarDbCodeGeneratorTests";
            Database.Provider = DatabaseProvider.SQLServer;
        }
Пример #21
0
        /// <summary>
        /// Checks the connection.
        /// </summary>
        /// <param name="connectionString">The connection string.</param>
        /// <remarks>Documented by Dev03, 2008-11-27</remarks>
        public void CheckConnection(ConnectionStringStruct connectionString)
        {
            if (!dbConnectionValid && connectionString.Typ != DatabaseType.Xml)
            {
                DummyUser    user = new DummyUser(connectionString);
                DbConnection con  = connectionString.Typ == DatabaseType.PostgreSQL ? PostgreSQLConn.CreateConnection(user) as DbConnection : MSSQLCEConn.GetConnection(user) as DbConnection;

                if (con.State == System.Data.ConnectionState.Open)
                {
                    dbConnectionValid = true;
                }
                else
                {
                    throw new ConnectionInvalidException();
                }

                if (connectionString.Typ == DatabaseType.PostgreSQL)
                {
                    con.Close();
                }

                DbDatabase.GetInstance(new ParentClass(new DummyUser(connectionString), this)).CheckIfDatabaseVersionSupported();
            }
        }
Пример #22
0
        public static void Main(string[] args)
        {
            Advertisements Advertise     = new Advertisements();
            People         People        = new People();
            Person         NewUser       = new Person();
            Person         AutorizedUser = new Person();
            Validation     Valid         = new Validation();
            DbDatabase     db            = new DbDatabase();

            bool TimeToExit = false;
            bool NotValid   = true;
            int  choice     = -1;

            while (!TimeToExit)
            {
                Console.WriteLine("///////////////////M E N U////////////////////////\n" +
                                  "Press number of action, that you want to do:\n" +
                                  "1: Show all services\n" +
                                  "2: Add new service\n" +
                                  "3: Delete certain service\n" +
                                  "4: Delete all services\n" +
                                  "5: Sort by...\n" +
                                  "6: Search by...\n" +
                                  "7: Save to...\n" +
                                  "8: Load from file\n" +
                                  "9: Show certain type\n" +
                                  "0: Exit");
                try
                {
                    choice = Convert.ToInt32(Console.ReadLine());
                }
                catch
                {
                    Console.WriteLine("Invalid symbol");
                }
                switch (choice)
                {
                case 1:      //Show all ads
                    Console.WriteLine(Advertise.ToString());
                    if (Advertise.Count == 0)
                    {
                        Console.WriteLine("The List is empty");
                    }
                    break;

                case 2:      //Add new ad
                    Console.WriteLine("Are you registered? Type Y for  YES, N for NO");
                    string YesNo = Console.ReadLine();
                    if (YesNo == "Y" || YesNo == "y")
                    {
                        Console.WriteLine("Authentification:");
                        Console.WriteLine("Enter your email");
                        string email = Console.ReadLine();
                        Console.WriteLine("Enter your password");
                        string pass   = Console.ReadLine();
                        Person person = People.Search(email)[0];
                        if (person.Password != pass)
                        {
                            Console.WriteLine("Invalid login or password");
                        }
                        else
                        {
                            AutorizedUser = person;
                        }
                    }
                    if (YesNo == "N" || YesNo == "n")
                    {
                        Console.WriteLine("Authorization:");
                        Console.WriteLine("Enter your firstname");
                        string fname = "";
                        NotValid = true;
                        while (NotValid)
                        {
                            fname = Console.ReadLine();
                            if (Valid.IsValidFirstname(fname))
                            {
                                NotValid = false;
                            }
                            else
                            {
                                Console.WriteLine("Invalid Name. Try again");
                            }
                        }

                        Console.WriteLine("Enter your lastname");
                        string lname = "";
                        NotValid = true;
                        while (NotValid)
                        {
                            lname = Console.ReadLine();
                            if (Valid.IsValidFirstname(lname))
                            {
                                NotValid = false;
                            }
                            else
                            {
                                Console.WriteLine("Invalid lastname. Try again");
                            }
                        }

                        Console.WriteLine("Enter your phone number");
                        string phoneNumber = "";
                        NotValid = true;
                        while (NotValid)
                        {
                            phoneNumber = Console.ReadLine();
                            if (Valid.IsValidPhone(phoneNumber))
                            {
                                NotValid = false;
                            }
                            else
                            {
                                Console.WriteLine("Invalid Phone. Try again");
                            }
                        }
                        Console.WriteLine("Enter your email");
                        string email = "";
                        NotValid = true;
                        while (NotValid)
                        {
                            email = Console.ReadLine();
                            if (Valid.IsValidEmail(email))
                            {
                                NotValid = false;
                            }
                            else
                            {
                                Console.WriteLine("Invalid email. Try again");
                            }
                        }
                        Console.WriteLine("Enter your password");
                        string pass = "";
                        NotValid = true;
                        while (NotValid)
                        {
                            pass = Console.ReadLine();
                            if (Valid.IsValidPassword(pass))
                            {
                                NotValid = false;
                            }
                            else
                            {
                                Console.WriteLine("Invalid password. Try again");
                            }
                        }
                        People.Add(new Person(fname, lname, phoneNumber, email, pass));
                        AutorizedUser = People.Search(email)[0];
                    }
                    Console.WriteLine("Add new service:");
                    Console.WriteLine("Select type of service: press 1 for EDUCATION or 2 for REPAIR");
                    NotValid = true;
                    string indexOfType = "";
                    while (NotValid)
                    {
                        indexOfType = Console.ReadLine();
                        if (Valid.IsValidType(indexOfType))
                        {
                            NotValid = false;
                        }
                        else
                        {
                            Console.WriteLine("Invalid Type. Try again");
                        }
                    }
                    Console.WriteLine("Enter name of service:");
                    string name = "";
                    NotValid = true;
                    while (NotValid)
                    {
                        name = Console.ReadLine();
                        if (Valid.IsValidName(name))
                        {
                            NotValid = false;
                        }
                        else
                        {
                            Console.WriteLine("Invalid Name. Try again");
                        }
                    }

                    Console.WriteLine("Enter description of service:");
                    string description = Console.ReadLine();
                    Console.WriteLine("Enter price:");
                    string price = "";
                    NotValid = true;
                    while (NotValid)
                    {
                        price = Console.ReadLine();
                        if (Valid.IsValidPrice(price))
                        {
                            NotValid = false;
                        }
                        else
                        {
                            Console.WriteLine("Invalid Price. Try again");
                        }
                    }
                    try
                    {
                        Advertisement adv = new Advertisement(Advertise.Types[int.Parse(indexOfType) - 1], name, description, int.Parse(price), AutorizedUser);
                        Advertise.Add(adv);
                        Console.WriteLine("Added");
                    }
                    catch
                    {
                        Console.WriteLine("ERROR");
                    }
                    break;

                case 3:      //Delete certain ad
                    Console.WriteLine("Remove: \n Enter ID of service:");
                    if (Advertise.Remove(Advertise.AdvList[Convert.ToInt32(Console.ReadLine()) - 1]))
                    {
                        Console.WriteLine("Removed");
                    }
                    else
                    {
                        Console.WriteLine("Error");
                    }
                    break;

                case 4:      //Delete all ads
                    Console.WriteLine("Are you sure? Press Y for YES / N for NO");
                    if (Console.ReadLine() == "Y")
                    {
                        Advertise.Clear();
                        Console.WriteLine("Removed");
                    }
                    else
                    {
                        Console.WriteLine("Canceled");
                    }
                    break;

                case 5:      //Sort by...
                    Console.WriteLine("Sort: \nChoose an option: press 1 for sorting by NAME / 2 for DESCRIPTION / 3 for PRICE / 4 for PHONE / 5 for PERSON:");
                    Console.WriteLine(Advertise.ToString(Advertise.Sort(Advertise.AdvList, Convert.ToInt32(Console.ReadLine()))));
                    break;

                case 6:      //Search by...
                    Console.WriteLine("Search: \nEnter keyword:");
                    Console.WriteLine(Advertise.ToString(Advertise.Search(Advertise.AdvList, Console.ReadLine())));
                    break;

                case 7:      //Save to...
                    Console.WriteLine("Saving: \nChoose file format: press 1 for XML / 2 for JSON / 3 for database");
                    int k = int.Parse(Console.ReadLine());
                    if (k == 1)      //XML
                    {
                        Advertise.Serialize();
                    }
                    if (k == 2)      //JSON
                    {
                        Advertise.Serialize("jSon");
                    }
                    if (k == 3)      //DB
                    {
                        db.Create(Advertise.AdvList);
                    }
                    break;

                case 8:       //Load from file
                    Console.WriteLine("Loading: \nChoose file format: press 1 for XML / 2 for JSON");
                    int l = int.Parse(Console.ReadLine());
                    if (l == 1)      //XML
                    {
                        Advertise.Deserialize();
                        Console.WriteLine(Advertise.ToString());
                        if (Advertise.AdvList.Count == 0)
                        {
                            Console.WriteLine("File is empty");
                        }
                    }
                    if (l == 2)      //JSON
                    {
                        Advertise.Deserialize("jSon");
                        Console.WriteLine(Advertise.ToString());
                        if (Advertise.AdvList.Count == 0)
                        {
                            Console.WriteLine("File is empty");
                        }
                    }
                    break;

                case 9:      //Show certain type
                    Console.WriteLine("Choose type: press 1 for EDUCATION / 2 for REPAIR");
                    int type = int.Parse(Console.ReadLine());
                    foreach (Advertisement ser in Advertise.AdvList)
                    {
                        if (ser.Type == Advertise.Types[type - 1])
                        {
                            Console.WriteLine(ser.ToString());
                        }
                    }
                    break;

                case 0:      //Exit
                    TimeToExit = true;
                    break;

                default:
                    Console.WriteLine("Invalid input");
                    break;
                }
            }
        }
Пример #23
0
 public abstract void FillSchema(DbDatabase schemaDatabase);
Пример #24
0
 public People()
 {
     db         = new DbDatabase();
     PersonList = db.GetAllPersons();
 }
 public SchemaAnalyzer(ProjectDefinaton project, PatternProject pattern, DbDatabase database)
 {
     _patternProject = pattern;
     _projectDef = project;
     _database = database;
 }
Пример #26
0
        private void UiAction_Generate()
        {
            PleaseWait.ShowPleaseWait("Connecting to database server", true, false);

            using (System.Data.Common.DbConnection conn = _projectDefinition.DbSettions.GetNewConnection())
                using (ExSchemaEngine schemaEngine = _projectDefinition.DbSettions.GetSchemaEngine(conn))
                {
                    // Connection to database
                    conn.Open();

                    // Let application catchup
                    Application.DoEvents();

                    // Reading database
                    PleaseWait.WaitingState = "Reading database schema";

                    // 1 ==========================
                    // Database schema reader
                    var schemaDatabase = new DbDatabase();
                    schemaDatabase.Provider = _projectDefinition.DbSettions.DatabaseProvider;

                    // shcema engine options
                    schemaEngine.SpecificOwner = _projectDefinition.DbSettions.DatabaseProvider == DatabaseProvider.Oracle
                                                 ? _projectDefinition.DbSettions.SqlUsername
                                                 : _projectDefinition.DbSettions.SchemaName;

                    // columns descriptions
                    schemaEngine.ReadColumnsDescription = _projectDefinition.CodeGenSettings.GenerateColumnsDescription;
                    schemaEngine.ReadTablesForeignKeys  = _projectDefinition.CodeGenSettings.GenerateTablesForeignKeys;
                    schemaEngine.ReadConstraintKeys     = _projectDefinition.CodeGenSettings.GenerateConstraintKeys;

                    // only selected tables
                    schemaEngine.OnlyReadSelectedItems = true;
                    schemaEngine.SelectedTables        = _projectDefinition.DbSettions.GetSelectedTablesList();
                    schemaEngine.SelectedViews         = _projectDefinition.DbSettions.GetSelectedViewsList();

                    // read database schema
                    schemaEngine.FillSchema(schemaDatabase);

                    PleaseWait.WaitingState = "Analyzing database schema";
                    // 2 ======================
                    var alanyzer = new SchemaAnalyzer(_projectDefinition, _patternProject, schemaDatabase);
                    alanyzer.AnalyzeAndRename();

                    PleaseWait.WaitingState = "Generating output files";
                    // 3 ==========================
                    // Start the generator
                    var engine = new Generator(_projectDefinition, _patternProject, schemaDatabase, schemaEngine);
                    engine.Generate();

                    // Update last generation
                    _projectDefinition.LastGeneration = DateTime.Now;

                    // 4 ==========================
                    // Reaload the form
                    Refresh_Form();

                    // Abort the please wait
                    PleaseWait.Abort();

                    // Data is modified
                    SetModified(true);

                    // to active tab
                    tabMainProject.SelectedTab = tabGenFiles;
                }
        }
Пример #27
0
        public override bool IsValid(object value)
        {
            DbDatabase db = new DbDatabase();

            return(db.SearchPerson((string)value).Count == 0);
        }
Пример #28
0
 public Advertisements()
 {
     db      = new DbDatabase();
     AdvList = db.GetAllAdvertisements();
 }
 public SchemaAnalyzer(ProjectDefinaton project, PatternProject pattern, DbDatabase database)
 {
     _patternProject = pattern;
     _projectDef     = project;
     _database       = database;
 }