/// <summary> /// /// </summary> /// <param name="Member"></param> /// <returns></returns> public static ErrorCode Add(Family Member) { ErrorCode code = ErrorCode.Unknown_Error; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { if (dbContext.Family.Find(Member.FamilyName) != null) { code = ErrorCode.DataAlreadyExist; } else { dbContext.Family.Add(Member); int rows = dbContext.SaveChanges(); if (rows <= 0) { code = ErrorCode.DataAddError; } else { code = ErrorCode.Success; } } } return(code); }
private void btInit_Click(object sender, EventArgs e) { FRSDbContext = new FamilyRelationshipContext(); bool flag = FRSDbContext.Database.CreateIfNotExists(); if (flag == true) { CertificateType type = new CertificateType(); type.CertificateTypeName = "二代身份证"; type.Description = "二代身份证"; FRSDbContext.CertificateType.Add(type); Role role = new Role(); role.RoleName = "System admin"; role.Description = "System admin"; FRSDbContext.Role.Add(role); User user = new User(); user.UserName = "******"; user.Password = "******"; user.UserTrueName = "admin"; user.RoleId = 1; FRSDbContext.User.Add(user); FRSDbContext.SaveChanges(); MessageBox.Show("数据库创建成功!"); } else { //MessageBox.Show("数据库创建失败!"); } }
/// <summary> /// /// </summary> /// <param name="Member"></param> /// <returns></returns> public static int Remove(Family Member) { int rows = 0; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { Family rem = dbContext.Family.Where <Family>(c => c.FamilyId == Member.FamilyId).FirstOrDefault(); dbContext.Family.Remove(rem); rows = dbContext.SaveChanges(); } return(rows); }
/// <summary> /// /// </summary> /// <param name="CertificateTypeId"></param> /// <returns></returns> public static int Remove(int CertificateTypeId) { int rows = 0; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { CertificateType rem = dbContext.CertificateType.Where <CertificateType>(c => c.CertificateTypeId == CertificateTypeId).FirstOrDefault(); dbContext.CertificateType.Remove(rem); rows = dbContext.SaveChanges(); } return(rows); }
/// <summary> /// /// </summary> /// <param name="Member"></param> /// <returns></returns> public static int Update(CertificateType Member) { int rows = 0; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { CertificateType up = dbContext.CertificateType.Where <CertificateType>(c => c.CertificateTypeId == Member.CertificateTypeId).FirstOrDefault(); up.CertificateTypeName = Member.CertificateTypeName; up.Description = Member.Description; rows = dbContext.SaveChanges(); } return(rows); }
/// <summary> /// /// </summary> /// <param name="Member"></param> /// <returns></returns> public static int Update(Family Member) { int rows = 0; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { Family up = dbContext.Family.Where <Family>(c => c.FamilyId == Member.FamilyId).FirstOrDefault(); up.FamilyName = Member.FamilyName; up.FamilyOrigin = Member.FamilyOrigin; up.FamilyHistory = Member.FamilyHistory; up.GenerationInfo = Member.GenerationInfo; up.Other1 = Member.Other1; up.Other2 = Member.Other2; rows = dbContext.SaveChanges(); } return(rows); }
/// <summary> /// /// </summary> /// <param name="Member"></param> /// <returns></returns> public static int Update(FamilyMember Member) { int rows = 0; using (FamilyRelationshipContext dbContext = new FamilyRelationshipContext()) { FamilyMember up = dbContext.FamilyMember.Where <FamilyMember>(c => c.FamilyId == Member.FamilyId).FirstOrDefault(); up.GenerationIndex = Member.GenerationIndex; up.Address = Member.Address; up.Age = Member.Age; up.Birthday = Member.Birthday; up.CertificateNumber = Member.CertificateNumber; up.CertificateTypeId = Member.CertificateTypeId; up.Country = Member.Country; up.Deathday = Member.Deathday; up.Description = Member.Description; up.Education = Member.Education; up.LastName = Member.LastName; up.Father_FamilyMemberId = Member.Father_FamilyMemberId; up.Father = Member.Father; up.File = Member.File; up.GivenName = Member.GivenName; up.Hometown = Member.Hometown; up.Job = Member.Job; up.MiddleName = Member.MiddleName; up.Mother_FamilyMemberId = Member.Mother_FamilyMemberId; up.Mother = Member.Mother; up.Nationality = Member.Nationality; up.OtherName1 = Member.OtherName1; up.OtherName2 = Member.OtherName2; up.PhotoImage = Member.PhotoImage; up.Ranking = Member.Ranking; up.CertificateType = Member.CertificateType; up.Sex = Member.Sex; up.Spouse_FamilyMemberId = Member.Spouse_FamilyMemberId; up.Spouse = Member.Spouse; up.FamilyId = Member.FamilyId; up.Family = Member.Family; rows = dbContext.SaveChanges(); } return(rows); }