Esempio n. 1
0
        public void AddClient(string mobile_, string pass_, string email_, string food_, string lastName_, string firstName_)
        {
            //Добавление клиента в БД
            using (context = new ClientContext())
            {
                Mobile_Table mobile = new Mobile_Table();
                mobile.Nuber = mobile_;
                context.Mobiles.Add(mobile);
                context.SaveChanges();

                Password_Table pass   = new Password_Table();
                byte[]         data   = Encoding.Default.GetBytes(pass_);
                var            result = new SHA256Managed().ComputeHash(data);
                pass.Pass = Encoding.Default.GetString(result);
                context.Passwords.Add(pass);
                context.SaveChanges();


                Email_Table Email = new Email_Table();
                Email.Info_Email = email_;
                context.Emails.Add(Email);
                context.SaveChanges();


                Car_Table Car = new Car_Table();
                Car.Info_Car = true;
                context.Cars.Add(Car);
                context.SaveChanges();

                Food_Table food = new Food_Table();
                food.Info_Food = food_;
                context.Foods.Add(food);
                context.SaveChanges();

                Client_Tenant Client_Tenant = new Client_Tenant();
                Client_Tenant.LastName  = lastName_;
                Client_Tenant.FirstName = firstName_;

                Client_Tenant.Mobile = mobile;
                Client_Tenant.Car    = Car;
                Client_Tenant.Email  = Email;
                Client_Tenant.Food   = food;
                Client_Tenant.Passw  = pass;
                context.Client_Tenants.Add(Client_Tenant);
                context.SaveChanges();
            }
        }
Esempio n. 2
0
        protected override void Seed(Hotel.DataModel.ClientContext context)
        {
            Mobile_Table mobile = new Mobile_Table();

            mobile.Nuber = "+380-93-37-20-606";
            context.Mobiles.Add(mobile);
            context.SaveChanges();

            Password_Table pass    = new Password_Table();
            string         pas_sha = "+380-93-37-20-606";

            byte[] data   = Encoding.Default.GetBytes(pas_sha);
            var    result = new SHA256Managed().ComputeHash(data);

            pass.Pass = Encoding.Default.GetString(result);
            context.Passwords.Add(pass);
            context.SaveChanges();


            Email_Table Email = new Email_Table();

            Email.Info_Email = "*****@*****.**";
            context.Emails.Add(Email);
            context.SaveChanges();


            Car_Table Car = new Car_Table();

            Car.Info_Car = true;
            context.Cars.Add(Car);
            context.SaveChanges();

            Food_Table food = new Food_Table();

            food.Info_Food = "Нужен завтрак и ужен";
            context.Foods.Add(food);
            context.SaveChanges();

            Client_Tenant Client_Tenant = new Client_Tenant();

            Client_Tenant.LastName  = "Владимир";
            Client_Tenant.FirstName = "Петров";

            Client_Tenant.Mobile = mobile;
            Client_Tenant.Car    = Car;
            Client_Tenant.Email  = Email;
            Client_Tenant.Food   = food;
            Client_Tenant.Passw  = pass;
            context.Client_Tenants.Add(Client_Tenant);
            context.SaveChanges();



            //////////////////////////////1 комната////////////////////////
            Room_Table Room_Table = new Room_Table();

            Room_Table.Images          = File.ReadAllBytes(Path.Combine(directoryInfo.FullName, @"Image\1.jpg"));
            Room_Table.Info_Room       = "2 кровати(двухспальные), 2 тумбочки, отдельный санузел кондиционер, холодилькник, телевизор, WI-FI";
            Room_Table.col_peopls_Room = 3;
            context.Rooms.Add(Room_Table);
            context.SaveChanges();

            Time_Arrival Time_Arrival = new Time_Arrival();

            Time_Arrival.Room_ID = 1;
            DateTime date = new DateTime(2018, 6, 5);

            Time_Arrival.Time_Arri_begin = date;
            date = new DateTime(2018, 6, 22);
            Time_Arrival.Time_Arri_end = date;
            context.Time_Ar.Add(Time_Arrival);
            context.SaveChanges();
            //////////////////////////////2 комната////////////////////////

            Room_Table                 = new Room_Table();
            Room_Table.Images          = File.ReadAllBytes(Path.Combine(directoryInfo.FullName, @"Image\2.jpg"));
            Room_Table.Info_Room       = "2 кровати(1 двухспальная, 1 односпальная), 2 тумбочки, кондиционер, холодилькник, телевизор, WI-FI";
            Room_Table.col_peopls_Room = 5;
            context.Rooms.Add(Room_Table);
            context.SaveChanges();

            Time_Arrival         = new Time_Arrival();
            Time_Arrival.Room_ID = 2;
            date = new DateTime(2018, 12, 15);
            Time_Arrival.Time_Arri_begin = date;
            date = new DateTime(2018, 12, 20);
            Time_Arrival.Time_Arri_end = date;
            context.Time_Ar.Add(Time_Arrival);
            context.SaveChanges();
            //////////////////////////////3 комната////////////////////////
            Room_Table                 = new Room_Table();
            Room_Table.Images          = File.ReadAllBytes(Path.Combine(directoryInfo.FullName, @"Image\3.jpg"));
            Room_Table.Info_Room       = "22 кровати(1 двухспальная, 1 односпальная), 2 тумбочки, кондиционер, холодилькник, телевизор, WI-FI";
            Room_Table.col_peopls_Room = 5;
            context.Rooms.Add(Room_Table);
            context.SaveChanges();

            Time_Arrival         = new Time_Arrival();
            Time_Arrival.Room_ID = 3;
            date = new DateTime(2018, 6, 22);
            Time_Arrival.Time_Arri_begin = date;
            date = new DateTime(2018, 6, 22);
            Time_Arrival.Time_Arri_end = date;
            context.Time_Ar.Add(Time_Arrival);
            context.SaveChanges();
            ////////////////////////////4 комната////////////////////////
            Room_Table                 = new Room_Table();
            Room_Table.Images          = File.ReadAllBytes(Path.Combine(directoryInfo.FullName, @"Image\4.jpg"));
            Room_Table.Info_Room       = "3 кровати(1 двухспальная,2 односпальная), 2 тумбочки, кондиционер, холодилькник, телевизор, WI-FI";
            Room_Table.col_peopls_Room = 3;
            context.Rooms.Add(Room_Table);
            context.SaveChanges();

            Time_Arrival         = new Time_Arrival();
            Time_Arrival.Room_ID = 4;
            date = new DateTime(2018, 6, 12);
            Time_Arrival.Time_Arri_begin = date;
            date = new DateTime(2018, 6, 19);
            Time_Arrival.Time_Arri_end = date;
            context.Time_Ar.Add(Time_Arrival);
            context.SaveChanges();
            ////////////////////////////5 комната////////////////////////
            Room_Table                 = new Room_Table();
            Room_Table.Images          = File.ReadAllBytes(Path.Combine(directoryInfo.FullName, @"Image\5.jpg"));
            Room_Table.Info_Room       = "4 кровати(4 односпальных), 2 тумбочки, кондиционер, холодилькник, телевизор, WI-FI";
            Room_Table.col_peopls_Room = 5;
            context.Rooms.Add(Room_Table);
            context.SaveChanges();

            Time_Arrival         = new Time_Arrival();
            Time_Arrival.Room_ID = 5;
            date = new DateTime(2018, 6, 22);
            Time_Arrival.Time_Arri_begin = date;
            date = new DateTime(2018, 6, 22);
            Time_Arrival.Time_Arri_end = date;
            context.Time_Ar.Add(Time_Arrival);
            context.SaveChanges();
            //////////////////////////////6 комната////////////////////////

            Room_Table                 = new Room_Table();
            Room_Table.Images          = File.ReadAllBytes(Path.Combine(directoryInfo.FullName, @"Image\6.jpg"));
            Room_Table.Info_Room       = "25 кровати(1 двухспальная, 1 односпальная), 2 тумбочки, кондиционер, холодилькник, телевизор, WI-FI";
            Room_Table.col_peopls_Room = 5;
            context.Rooms.Add(Room_Table);
            context.SaveChanges();

            Time_Arrival         = new Time_Arrival();
            Time_Arrival.Room_ID = 6;
            date = new DateTime(2018, 6, 22);
            Time_Arrival.Time_Arri_begin = date;
            date = new DateTime(2018, 6, 22);
            Time_Arrival.Time_Arri_end = date;
            context.Time_Ar.Add(Time_Arrival);
            context.SaveChanges();
            //////////////////////////////7 комната////////////////////////
            Room_Table                 = new Room_Table();
            Room_Table.Images          = File.ReadAllBytes(Path.Combine(directoryInfo.FullName, @"Image\7.jpg"));
            Room_Table.Info_Room       = "26 кровати(1 двухспальная, 1 односпальная), 2 тумбочки, кондиционер, холодилькник, телевизор, WI-FI";
            Room_Table.col_peopls_Room = 5;
            context.Rooms.Add(Room_Table);
            context.SaveChanges();

            Time_Arrival         = new Time_Arrival();
            Time_Arrival.Room_ID = 7;
            date = new DateTime(2018, 6, 22);
            Time_Arrival.Time_Arri_begin = date;
            date = new DateTime(2018, 6, 22);
            Time_Arrival.Time_Arri_end = date;
            context.Time_Ar.Add(Time_Arrival);
            context.SaveChanges();
        }