public bool Update() { using (var trans = _db.BeginTransaction()) { var data = new Breed { BreedId = 24, BreedName = "DDDDABCaaa" }; _db.Breed.Update(data, trans); data = new Breed { BreedId = 25, BreedName = "ddd" }; _db.Breed.Update(data, trans); trans.Commit(); } return(true); }
public bool Insert() { using (var trans = _db.BeginTransaction()) { var data = new Breed { BreedName = "Insert AT " + DateTime.UtcNow.ToShortDateString() }; _db.Breed.Insert(data, trans); data = new Breed { BreedName = "Insert2 AT " + DateTime.UtcNow.ToShortDateString() }; _db.Breed.Insert(data, trans); trans.Commit(); } return(true); }
protected override void Seed(DataContext context) { //------------роли---------------- Role r1 = new Role { Name = "Пользователь" }; context.Roles.Add(r1); Role r2 = new Role { Name = "Доктор" }; context.Roles.Add(r2); //---------------пользователи-------- User u1 = new User { FirstName = "Иван", MiddleName = "Юрьевич", LastName = "Михайлушкин", Email = "*****@*****.**", Login = "******", PhoneNumber = "89008008080", Password = "******", Role = r1 }; context.Users.Add(u1); User u2 = new User { FirstName = "Кирилл", MiddleName = "Геннадьевич", LastName = "Виноградов", Email = "*****@*****.**", Login = "******", PhoneNumber = "88005553535", Password = "******", Role = r1 }; context.Users.Add(u2); User u3 = new User { FirstName = "Олег", MiddleName = "Петрович", LastName = "Шумилин", Email = "*****@*****.**", Login = "******", PhoneNumber = "89008008888", Password = "******", Role = r2 }; context.Users.Add(u3); //-------------виды животных-------- Kind k1 = new Kind { Name = "Птица" }; context.Kinds.Add(k1); Kind k2 = new Kind { Name = "Собака" }; context.Kinds.Add(k2); Kind k3 = new Kind { Name = "Кот" }; context.Kinds.Add(k3); //-------------породы животных------------ Breed b1 = new Breed { Name = "Петух" }; context.Breeds.Add(b1); Breed b2 = new Breed { Name = "Бигль" }; context.Breeds.Add(b2); Breed b3 = new Breed { Name = "Сфинкс" }; //-------------окрас животных----------- Color c1 = new Color { Name = "Черный" }; context.Colors.Add(c1); Color c2 = new Color { Name = "Бело-рыже-черный" }; context.Colors.Add(c2); Color c3 = new Color { Name = "Серый" }; context.Colors.Add(c3); //--------------интервалы времени---------- Time t1 = new Time { Interval = "8:00 - 9:00" }; context.Times.Add(t1); Time t2 = new Time { Interval = "9:00 - 10:00" }; context.Times.Add(t2); Time t3 = new Time { Interval = "10:00 - 11:00" }; context.Times.Add(t3); Time t4 = new Time { Interval = "11:00 - 12:00" }; context.Times.Add(t4); Time t5 = new Time { Interval = "12:00 - 13:00" }; context.Times.Add(t5); Time t6 = new Time { Interval = "13:00 - 14:00" }; context.Times.Add(t6); Time t7 = new Time { Interval = "14:00 - 15:00" }; context.Times.Add(t7); Time t8 = new Time { Interval = "15:00 - 16:00" }; context.Times.Add(t8); Time t9 = new Time { Interval = "16:00 - 17:00" }; context.Times.Add(t9); Time t10 = new Time { Interval = "17:00 - 18:00" }; context.Times.Add(t10); //--------------типы услуг----------------------- TypeOfService ts1 = new TypeOfService { Name = "Клинический осмотр" }; context.TypesOfServices.Add(ts1); TypeOfService ts2 = new TypeOfService { Name = "Вакцинация" }; context.TypesOfServices.Add(ts2); TypeOfService ts3 = new TypeOfService { Name = "Блокада" }; context.TypesOfServices.Add(ts3); TypeOfService ts4 = new TypeOfService { Name = "Купирование" }; context.TypesOfServices.Add(ts4); TypeOfService ts5 = new TypeOfService { Name = "Обрезка" }; context.TypesOfServices.Add(ts5); //---------------------услуги----------------------------- Service ser1 = new Service { Name = "Обрезка рогов", TypeOfService = ts5, Price = 500 }; context.Services.Add(ser1); Service ser2 = new Service { Name = "Обрезка когтей", TypeOfService = ts5, Price = 500 }; context.Services.Add(ser2); Service ser3 = new Service { Name = "Обрезка клюва", TypeOfService = ts5, Price = 500 }; context.Services.Add(ser3); Service ser4 = new Service { Name = "Вакцинация от бешенства", TypeOfService = ts2, Price = 300 }; context.Services.Add(ser4); Service ser5 = new Service { Name = "Вакцинация от чумы", TypeOfService = ts2, Price = 400 }; context.Services.Add(ser5); Service ser6 = new Service { Name = "Простой осмотр", TypeOfService = ts1, Price = 150 }; context.Services.Add(ser6); Service ser7 = new Service { Name = "Углубленный осмотр", TypeOfService = ts1, Price = 220 }; context.Services.Add(ser7); Service ser8 = new Service { Name = "Стандартная блокада пятки", TypeOfService = ts3, Price = 350 }; context.Services.Add(ser8); Service ser9 = new Service { Name = "Купирование ушей", TypeOfService = ts4, Price = 650 }; context.Services.Add(ser9); //-----------------животные------------------ Pet p1 = new Pet { Name = "Шарик", Birthday = new DateTime(2015, 01, 30), User = u1, Kind = k3, Breed = b3, Color = c3 }; context.Pets.Add(p1); Pet p2 = new Pet { Name = "Бобик", Birthday = new DateTime(2016, 11, 10), User = u2, Kind = k1, Breed = b1, Color = c1 }; context.Pets.Add(p2); Pet p3 = new Pet { Name = "Василий", Birthday = new DateTime(2014, 05, 04), User = u2, Kind = k2, Breed = b2, Color = c2 }; context.Pets.Add(p3); //---------------карточки животных------------------------- Card card1 = new Card { Pet = p1, Height = 20, Weight = 10 }; context.Cards.Add(card1); Card card2 = new Card { Pet = p2, Height = 25, Weight = 15 }; context.Cards.Add(card2); //---------------------заявки------------------- Application app1 = new Application { Date = new DateTime(2017, 03, 16), User = u1, Pet = p1, Time = t6, Service = ser5 }; context.Applications.Add(app1); Application app2 = new Application { Date = new DateTime(2017, 03, 18), User = u2, Pet = p2, Time = t5, Service = ser1 }; context.Applications.Add(app2); //------------записи----------------- Record rec1 = new Record { Date = new DateTime(2017, 03, 16), User = u3, Time = t6, Service = ser5, Card = card1 }; context.Records.Add(rec1); base.Seed(context); }