public CompetitionVM() { var connstr = ConfigurationManager.ConnectionStrings["Connection"].ConnectionString; Messenger = App.Container.GetInstance <Messenger>(); SportTypes = new List <SportType>(); Categories = new List <SportType>(); using (var connection = new SqlConnection(connstr)) { connection.Open(); var query = "SELECT*FROM SportTypes WHERE SportType_Id = NULL SET ANSI_NULLS OFF"; connection.Execute(query); var querySportTypeList = connection.Query <SportType>(query); SportTypes = querySportTypeList.ToList(); var cquery = "SELECT*FROM Countries"; connection.Execute(cquery); var queryCountryList = connection.Query <Country>(cquery); Countries = queryCountryList.ToList(); SelectionChangedCmd = new RelayCommand(() => { MessageBox.Show("Salam"); var query1 = "SELECT*FROM SportTypes WHERE SportType_Id=@Id"; var q = connection.Query <SportType>(query1, new { ID = 674 }); Categories = q.ToList(); }); } SaveBtn = new RelayCommand(() => { using (var db = new OlimpicDBContext()) { } }); }
static void Main(string[] args) { using (var db = new OlimpicDBContext()) { db.SportTypes.Add(new Models.SportType() { Name = "Archery", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Individual", LengthLimite = new Models.LengthLimite() { MaxLength = 70 } }, new Models.SportType() { Name = "Team", LengthLimite = new Models.LengthLimite() { MaxLength = 70 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Badminton", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Doubles men", }, new Models.SportType() { Name = "Doubles women" }, new Models.SportType() { Name = "Singles men" }, new Models.SportType() { Name = "Singles men" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Basketball", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Basketball 3x3" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Boxing", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Super heavyweight", WeightLimite = new Models.WeightLimite() { MaxWeight = 92 } }, new Models.SportType() { Name = "Light flyweight", WeightLimite = new Models.WeightLimite() { MaxWeight = 49, MinWeight = 46 } }, new Models.SportType() { Name = "Flyweight", WeightLimite = new Models.WeightLimite() { MaxWeight = 52 } }, new Models.SportType() { Name = "Bantam weight", WeightLimite = new Models.WeightLimite() { MaxWeight = 56 } }, new Models.SportType() { Name = "Light weight", WeightLimite = new Models.WeightLimite() { MaxWeight = 60 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Cycling", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "BMX" }, new Models.SportType() { Name = "Mountain bike" }, new Models.SportType() { Name = "Road" }, new Models.SportType() { Name = "Track" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Diving", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Platform", LengthLimite = new Models.LengthLimite() { MaxLength = 10 } }, new Models.SportType() { Name = "SPRINGBOARD", LengthLimite = new Models.LengthLimite() { MaxLength = 3 } }, new Models.SportType() { Name = "SYNCHRONIZED DIVING PLATFORM ", LengthLimite = new Models.LengthLimite() { MaxLength = 10 } }, new Models.SportType() { Name = "SYNCHRONIZED DIVING SPRINGBOARD", LengthLimite = new Models.LengthLimite() { MaxLength = 3 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Equestrian", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Dressage" }, new Models.SportType() { Name = "Eventing" }, new Models.SportType() { Name = "Jumping" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Fencing", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "ÉPÉE INDIVIDUAL" }, new Models.SportType() { Name = "ÉPÉE TEAM" }, new Models.SportType() { Name = "FOIL INDIVIDUAL" }, new Models.SportType() { Name = "SABRE INDIVIDUAL" }, new Models.SportType() { Name = "SABRE TEAM" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Football" }); db.SportTypes.Add(new Models.SportType() { Name = "Golf" }); db.SportTypes.Add(new Models.SportType() { Name = "Gymnastics", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "FLOOR EXERCISES" }, new Models.SportType() { Name = "HORIZONTAL BAR" }, new Models.SportType() { Name = "INDIVIDUAL ALL-ROUND", }, new Models.SportType() { Name = "PARALLEL BARS" }, new Models.SportType() { Name = "POMMEL HORSE" }, new Models.SportType() { Name = "TEAM COMPETITION" }, new Models.SportType() { Name = "BEAM" }, new Models.SportType() { Name = "FLOOR EXERCISES" }, new Models.SportType() { Name = "RHYTHMIC" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Handball" }); db.SportTypes.Add(new Models.SportType() { Name = "Hockey" }); db.SportTypes.Add(new Models.SportType() { Name = "Judo", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Normally", WeightLimite = new Models.WeightLimite() { MaxWeight = 60 } }, new Models.SportType() { Name = "HEAVYWEIGHT", WeightLimite = new Models.WeightLimite() { MaxWeight = 100 } }, new Models.SportType() { Name = "HALF-LIGHTWEIGHT", WeightLimite = new Models.WeightLimite() { MaxWeight = 66, MinWeight = 60 } }, new Models.SportType() { Name = "LIGHTWEIGHT", WeightLimite = new Models.WeightLimite() { MinWeight = 66, MaxWeight = 73 } }, new Models.SportType() { Name = "HALF-HEAVYWEIGHT", WeightLimite = new Models.WeightLimite() { MaxWeight = 100, MinWeight = 90 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Karate", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "KATA" }, new Models.SportType() { Name = "KUMITE", WeightLimite = new Models.WeightLimite() { MaxWeight = 75, MinWeight = 67 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Rowing", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "LIGHTWEIGHT COXLESS FOUR (4-)" }, new Models.SportType() { Name = "PAIRS" }, new Models.SportType() { Name = "SINGLE SCULLS" }, new Models.SportType() { Name = "DOUBLE SCULLS" }, new Models.SportType() { Name = "EIGHT" }, new Models.SportType() { Name = "FOUR" }, new Models.SportType() { Name = "LIGHTWEIGHT DOUBLE SCULLS" }, new Models.SportType() { Name = "QUADRUPLE SCULLS" }, } }); db.SportTypes.Add(new Models.SportType() { Name = "Rugby", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "RUGBY-7" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Sailing", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "470 - TWO PERSON DINGHY" }, new Models.SportType() { Name = "49ER - SKIFF" }, new Models.SportType() { Name = "FINN - ONE PERSON DINGHY (HEAVYWEIGHT)" }, new Models.SportType() { Name = "LASER - ONE PERSON DINGHY" }, new Models.SportType() { Name = "RS:X - WINDSURFER MEN" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Shooting", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "AIR PISTOL", LengthLimite = new Models.LengthLimite() { MaxLength = 10 } }, new Models.SportType() { Name = "AIR RIFLE", LengthLimite = new Models.LengthLimite() { MaxLength = 10 } }, new Models.SportType() { Name = "RAPID FIRE PISTOL", LengthLimite = new Models.LengthLimite() { MaxLength = 25 } }, new Models.SportType() { Name = "RIFLE 3 POSITIONS", LengthLimite = new Models.LengthLimite() { MaxLength = 50 } }, new Models.SportType() { Name = "SHOT GUN SKEET" }, new Models.SportType() { Name = "SHOT GUN TRAP" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Skateboarding", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "PARK" }, new Models.SportType() { Name = "STREET" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Sport climbing" }); db.SportTypes.Add(new Models.SportType() { Name = "Surfing" }); db.SportTypes.Add(new Models.SportType() { Name = "Swimming", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "BACKSTROKE", LengthLimite = new Models.LengthLimite() { MaxLength = 100 } }, new Models.SportType() { Name = "BREASTSTROKE", LengthLimite = new Models.LengthLimite() { MaxLength = 100 } }, new Models.SportType() { Name = "BUTTERFLY", LengthLimite = new Models.LengthLimite() { MaxLength = 100 } }, new Models.SportType() { Name = " FREESTYLE", LengthLimite = new Models.LengthLimite() { MaxLength = 100 } }, new Models.SportType() { Name = "INDIVIDUAL MEDLEY", LengthLimite = new Models.LengthLimite() { MaxLength = 200 } }, new Models.SportType() { Name = "MEDLEY RELAY", LengthLimite = new Models.LengthLimite() { MaxLength = 400 } }, new Models.SportType() { Name = "MARATHON", LengthLimite = new Models.LengthLimite() { MaxLength = 10000 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Taekwondo", SportTypes = new List <Models.SportType>() { new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 80 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 58, MaxWeight = 68 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 58 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 68, MaxWeight = 80 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Tennis", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Table tennis" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Trampoline" }); db.SportTypes.Add(new Models.SportType() { Name = "Triathlon" }); db.SportTypes.Add(new Models.SportType() { Name = "Volleyball", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Beach volleyball" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Water polo" }); db.SportTypes.Add(new Models.SportType() { Name = "Weightlifting", SportTypes = new List <Models.SportType>() { new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 106 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 105 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 94 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 85 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 77 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 69 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 62 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 56 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Wrestling freestyle", SportTypes = new List <Models.SportType>() { new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 55 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 55, MaxWeight = 60 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 60, MaxWeight = 66 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 66, MaxWeight = 74 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 74, MaxWeight = 84 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 84, MaxWeight = 96 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 96, MaxWeight = 120 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Wrestling Greco-Roman", SportTypes = new List <Models.SportType>() { new Models.SportType() { WeightLimite = new Models.WeightLimite() { MaxWeight = 55 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 55, MaxWeight = 60 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 60, MaxWeight = 66 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 66, MaxWeight = 74 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 74, MaxWeight = 84 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 84, MaxWeight = 96 } }, new Models.SportType() { WeightLimite = new Models.WeightLimite() { MinWeight = 96, MaxWeight = 120 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Alpine sking", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "ALPINE COMBINED" }, new Models.SportType() { Name = "DOWNHILL" }, new Models.SportType() { Name = "GIANT SLALOM" }, new Models.SportType() { Name = "SLALOM" }, new Models.SportType() { Name = "SUPER-G" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Biathlon", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Sprint", LengthLimite = new Models.LengthLimite() { MaxLength = 10000 } }, new Models.SportType() { Name = "Pursuit", LengthLimite = new Models.LengthLimite() { MaxLength = 12500 } }, new Models.SportType() { Name = "Mass start", LengthLimite = new Models.LengthLimite() { MaxLength = 15000 } }, new Models.SportType() { Name = "Individual", LengthLimite = new Models.LengthLimite() { MaxLength = 20000 } }, new Models.SportType() { Name = "Relay", LengthLimite = new Models.LengthLimite() { MaxLength = 30000 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Bobsleigh" }); db.SportTypes.Add(new Models.SportType() { Name = "Cross country skiing", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "Free", LengthLimite = new Models.LengthLimite() { MaxLength = 15000 } }, new Models.SportType() { Name = "SKIATHLON", LengthLimite = new Models.LengthLimite() { MaxLength = 30000 } }, new Models.SportType() { Name = "RELAY", LengthLimite = new Models.LengthLimite() { MaxLength = 40000 } }, new Models.SportType() { Name = "MASS START CLASSIC", LengthLimite = new Models.LengthLimite() { MaxLength = 50000 } }, new Models.SportType() { Name = "SPRINT CLASSIC" }, new Models.SportType() { Name = "TEAM SPRINT FREE" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Curling" }); db.SportTypes.Add(new Models.SportType() { Name = "Figure skating" }); db.SportTypes.Add(new Models.SportType() { Name = "Freestyle skiing", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "AERIALS" }, new Models.SportType() { Name = "MOGULS" }, new Models.SportType() { Name = "SKI CROSS" }, new Models.SportType() { Name = "SKI HALFPIPE" }, new Models.SportType() { Name = "SKI SLOPESTYLE" }, } }); db.SportTypes.Add(new Models.SportType() { Name = "Ice hockey" }); db.SportTypes.Add(new Models.SportType() { Name = "Luge" }); db.SportTypes.Add(new Models.SportType() { Name = "Nordic Combined", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "INDIVIDUAL GUNDERSEN LARGE HILL", LengthLimite = new Models.LengthLimite() { MaxLength = 10000 } }, new Models.SportType() { Name = "INDIVIDUAL GUNDERSEN NORMAL HILL", LengthLimite = new Models.LengthLimite() { MaxLength = 10000 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Short track speed skating", SportTypes = new List <Models.SportType>() { new Models.SportType() { LengthLimite = new Models.LengthLimite() { MaxLength = 1000 } }, new Models.SportType() { LengthLimite = new Models.LengthLimite() { MaxLength = 1500 } }, new Models.SportType() { Name = "Relay", LengthLimite = new Models.LengthLimite() { MaxLength = 5000 } }, new Models.SportType() { LengthLimite = new Models.LengthLimite() { MaxLength = 500 } } } }); db.SportTypes.Add(new Models.SportType() { Name = "Skeleton" }); db.SportTypes.Add(new Models.SportType() { Name = "Ski jumping", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "LARGE HILL INDIVIDUAL" }, new Models.SportType() { Name = "NORMAL HILL INDIVIDUAL" }, new Models.SportType() { Name = "TEAM" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Snowboard", SportTypes = new List <Models.SportType>() { new Models.SportType() { Name = "BIG AIR" }, new Models.SportType() { Name = "HALFPIPE" }, new Models.SportType() { Name = "PARALLEL GIANT SLALOM" }, new Models.SportType() { Name = "SLOPESTYLE" }, new Models.SportType() { Name = "SNOWBOARD CROSS" } } }); db.SportTypes.Add(new Models.SportType() { Name = "Speed skating", SportTypes = new List <Models.SportType>() { new Models.SportType() { LengthLimite = new Models.LengthLimite() { MaxLength = 10000 } }, new Models.SportType() { LengthLimite = new Models.LengthLimite() { MaxLength = 1000 } }, new Models.SportType() { LengthLimite = new Models.LengthLimite() { MaxLength = 1500 } }, new Models.SportType() { LengthLimite = new Models.LengthLimite() { MaxLength = 5000 } }, new Models.SportType() { LengthLimite = new Models.LengthLimite() { MaxLength = 500 } }, new Models.SportType() { Name = "MASS START" }, new Models.SportType() { Name = "TEAM PURSUIT" } } }); //db.SaveChanges(); }; var csvTable = new DataTable(); using (var csvReader = new CsvReader(new StreamReader(System.IO.File.OpenRead(@"C:\Users\Samsung PC\Desktop\OlympicProject\Turkey.csv")), true)) { csvTable.Load(csvReader); using (var db = new OlimpicDBContext()) { for (int i = 0; i < csvTable.Rows.Count; i++) { db.Athlets.Add(new Models.Athlet() { Id = int.Parse(csvTable.Rows[i][0].ToString()), FirstName = csvTable.Rows[i][1].ToString(), LastName = csvTable.Rows[i][2].ToString(), BirthDate = DateTime.Parse(csvTable.Rows[i][3].ToString()), Weight = double.Parse(csvTable.Rows[i][4].ToString()), Score = int.Parse(csvTable.Rows[i][5].ToString()), //Gender = db.Genders.FirstOrDefault(x => x.Id == ((csvTable.Rows[i][6]) as Gender).Id) }); } //db.SaveChanges(); } } }