public void Post(int id, String password) { var name = _context.NameItems.Where(x => x.Id == id).FirstOrDefault(); name.isPasswordMatch(password); _context.SaveChanges(); }
//CRUD public void Create(Name name) { names.Names.Add(name); names.SaveChanges(); }
/// <summary> /// Imports name data from <paramref name="source"/>. /// </summary> /// <param name="source"> /// The data source to import name data from. /// </param> public void Import(INameImportSource source) { this.InitContext(); // read from the input source until that's no longer possible while (source.Read()) { // try to load the field values from the current row String nameStr = this.GetField(source, NameProperty.Name); String maleOccsStr = this.GetField(source, NameProperty.MaleOccurrences); String femaleOccsStr = this.GetField(source, NameProperty.FemaleOccurrences); String yearStr = this.GetField(source, NameProperty.Year); String surnameStr = this.GetField(source, NameProperty.Surname); // set some default values Int32 year = this.DefaultYear; Int64 maleOccs = 0; Int64 femaleOccs = 0; // try to parse field data, if available if (!String.IsNullOrWhiteSpace(maleOccsStr)) { maleOccs = Int64.Parse(maleOccsStr, NumberStyles.AllowThousands); } if (!String.IsNullOrWhiteSpace(femaleOccsStr)) { femaleOccs = Int64.Parse(femaleOccsStr, NumberStyles.AllowThousands); } if (!String.IsNullOrWhiteSpace(yearStr)) { year = Convert.ToInt32(yearStr); } if (!String.IsNullOrWhiteSpace(surnameStr)) { surnameStr = surnameStr.Trim(); if (this.onProcessing != null) { this.onProcessing(this.entries, surnameStr); } // try to find an existing entry for this name in the database Name name = this.FindOrCreateName(surnameStr); NameUsage familyUsage = name.UsageFor(this.Culture, true); if (familyUsage == null) { familyUsage = new NameUsage(this.Culture, Sex.NotApplicable); familyUsage.FamilyName = true; familyUsage.NameID = name.ID; familyUsage.Name = name; name.Usage.Add(familyUsage); this.context.Usage.Add(familyUsage); this.Commit(); } } if (!String.IsNullOrWhiteSpace(nameStr)) { nameStr = nameStr.Trim(); if (this.onProcessing != null) { this.onProcessing(this.entries, nameStr); } // try to find an existing entry for this name in the database Name name = this.FindOrCreateName(nameStr); // add usage and frequency data for the current name if (maleOccs > 0) { this.AddFrequency(name, Sex.Male, year, maleOccs); } if (femaleOccs > 0) { this.AddFrequency(name, Sex.Female, year, femaleOccs); } // update the static probabilities for the current name foreach (NameUsage usage in name.Usage) { usage.RecalculateProbability(); } entries++; } } // save all remaining changes context.SaveChanges(); context.Dispose(); context = null; }
public static void Initialize(NameContext Context) { Context.Database.EnsureCreated(); if (Context.Names.Any()) { return; } var names = new Name[] { new Name { Goods = "防盗门", number = 250, EnrollmentDate = DateTime.Parse("2017-01-01"), isOut = true, location = "北京", suplierID = "001", price = 22.9 }, new Name { Goods = "键盘", number = 199, EnrollmentDate = DateTime.Parse("2016-12-02"), isOut = false, location = "哈尔滨", suplierID = "002", price = 11.1 }, new Name { Goods = "大理石", number = 700, EnrollmentDate = DateTime.Parse("2015-10-10"), isOut = false, location = "深圳", suplierID = "005", price = 7.8 }, new Name { Goods = "导航", number = 200, EnrollmentDate = DateTime.Parse("2017-02-01"), isOut = false, location = "海南", suplierID = "004", price = 9.5 }, new Name { Goods = "表", number = 9000, EnrollmentDate = DateTime.Parse("2017-01-25"), isOut = true, location = "贵州", suplierID = "007", price = 1.99 }, new Name { Goods = "手链", number = 2220, EnrollmentDate = DateTime.Parse("2016-11-11"), isOut = false, location = "周口", suplierID = "010", price = 25.0 } }; foreach (Name n in names) { Context.Names.Add(n); } Context.SaveChanges(); var gits = new Git[] { new Git { GitID = 1020, Title = "易燃易爆类", position = "一楼" }, new Git { GitID = 1120, Title = "易碎类", position = "二楼" }, new Git { GitID = 1230, Title = "电子类", position = "三楼" }, new Git { GitID = 1702, Title = "贵重类", position = "四楼" }, new Git { GitID = 1550, Title = "常规物品", position = "五楼" } }; foreach (Git g in gits) { Context.Gits.Add(g); } Context.SaveChanges(); var enrollments = new Enrollment[] { new Enrollment { NameID = 1, GitID = 1550, Address = Address.A }, new Enrollment { NameID = 2, GitID = 1230, Address = Address.B }, new Enrollment { NameID = 3, GitID = 1550, Address = Address.B }, new Enrollment { NameID = 4, GitID = 1230, Address = Address.E }, new Enrollment { NameID = 5, GitID = 1702, Address = Address.D }, new Enrollment { NameID = 6, GitID = 1702, Address = Address.C } }; foreach (Enrollment e in enrollments) { Context.Enrollments.Add(e); } Context.SaveChanges(); var persons = new Person[] { new Person { PersonID = 5527, DepartmentId = "201", PersonName = "江泽鹏", Power = Power.G }, new Person { PersonID = 5526, DepartmentId = "202", PersonName = "张三", Power = Power.H }, new Person { PersonID = 5525, DepartmentId = "203", PersonName = "二狗子", Power = Power.S }, new Person { PersonID = 5524, DepartmentId = "204", PersonName = "狗蛋", Power = Power.X } }; foreach (Person p in persons) { Context.Persons.Add(p); } Context.SaveChanges(); var department = new Department[] { new Department { DepartmentID = 201, type = "大货车组" }, new Department { DepartmentID = 202, type = "空运组" }, new Department { DepartmentID = 203, type = "普通快递小哥组" }, new Department { DepartmentID = 204, type = "仓库后勤组" } }; foreach (Department d in department) { Context.Department.Add(d); } Context.SaveChanges(); }