//author:Hiennv public int Insert(FamilyMembers aFamilyMembers) { try { aDatabaseDA.FamilyMembers.Add(aFamilyMembers); return aDatabaseDA.SaveChanges(); } catch (Exception ex) { throw new Exception(string.Format("FamilyMembersBO.Insert :"+ ex.Message.ToString())); } }
//Author : Hiennv public void UpdateSystemUserInformation(SystemUsersEN aSystemUsersEN) { int status = -1; SystemUsersBO aSystemUsersBO = new SystemUsersBO(); SystemUsers aSystemUsers_Old = new SystemUsers(); SystemUsers aSystemUsers = new SystemUsers(); SystemUserExtsBO aSystemUserExtsBO = new SystemUserExtsBO(); //SystemUserExts aSystemUserExts = new SystemUserExts(); SystemUserExts aSystemUserExts_Old = new SystemUserExts(); try { aSystemUsers = aSystemUsersBO.Select_ByID(aSystemUsersEN.ID); aSystemUsers_Old = aSystemUsers; aSystemUsers.UserGroup = aSystemUsersEN.UserGroup; aSystemUsers.Email = aSystemUsersEN.Email; aSystemUsers.Username = aSystemUsersEN.Username; aSystemUsers.Name = aSystemUsersEN.Name; aSystemUsers.Password = aSystemUsersEN.Password; aSystemUsers.Birthday = aSystemUsersEN.Birthday; aSystemUsers.Identifier1 = aSystemUsersEN.Identifier1; aSystemUsers.Identifier2 = aSystemUsersEN.Identifier2; aSystemUsers.Identifier3 = aSystemUsersEN.Identifier3; aSystemUsers.Image = aSystemUsersEN.Image; aSystemUsers.Gender = aSystemUsersEN.Gender; aSystemUsers.IDRefAnotherSystem = aSystemUsersEN.IDRefAnotherSystem; aSystemUsers.IDRefMailSystem = aSystemUsersEN.IDRefMailSystem; aSystemUsers.Type = aSystemUsersEN.Type; aSystemUsers.Status = aSystemUsersEN.Status; aSystemUsers.Disable = aSystemUsersEN.Disable; aSystemUsers.Identifier1CreatedDate = aSystemUsersEN.Identifier1CreatedDate; aSystemUsers.Identifier2CreatedDate = aSystemUsersEN.Identifier2CreatedDate; aSystemUsers.Identifier3CreatedDate = aSystemUsersEN.Identifier3CreatedDate; aSystemUsers.PlaceOfIssue1 = aSystemUsersEN.PlaceOfIssue1; aSystemUsers.PlaceOfIssue2 = aSystemUsersEN.PlaceOfIssue2; aSystemUsers.PlaceOfIssue3 = aSystemUsersEN.PlaceOfIssue3; status = aSystemUsersBO.Update(aSystemUsers); if (status > 0) { SystemUserExts aSystemUserExts = aSystemUserExtsBO.Select_ByID(aSystemUsersEN.aSystemUserExts.ID); //aSystemUserExts_Old = aSystemUserExts; if (aSystemUserExts != null) { aSystemUserExts.BirthPlace = aSystemUsersEN.aSystemUserExts.BirthPlace; aSystemUserExts.Hometown = aSystemUsersEN.aSystemUserExts.Hometown; aSystemUserExts.Address = aSystemUsersEN.aSystemUserExts.Address; aSystemUserExts.InsuranceNumber = aSystemUsersEN.aSystemUserExts.InsuranceNumber; aSystemUserExts.YearJob = aSystemUsersEN.aSystemUserExts.YearJob; aSystemUserExts.YearDepartment = aSystemUsersEN.aSystemUserExts.YearDepartment; aSystemUserExts.YearPayroll = aSystemUsersEN.aSystemUserExts.YearPayroll; aSystemUserExts.YearUnemploymentInsurance = aSystemUsersEN.aSystemUserExts.YearUnemploymentInsurance; aSystemUserExts.DifferenceContact = aSystemUsersEN.aSystemUserExts.DifferenceContact; aSystemUserExts.Type = aSystemUsersEN.aSystemUserExts.Type; aSystemUserExts.Status = aSystemUsersEN.aSystemUserExts.Status; aSystemUserExts.Disable = aSystemUsersEN.aSystemUserExts.Disable; aSystemUserExts.IDSystemUser = aSystemUsers.ID; aSystemUserExts.Recruitment = aSystemUsersEN.aSystemUserExts.Recruitment; aSystemUserExts.PermanentResidence = aSystemUsersEN.aSystemUserExts.PermanentResidence; aSystemUserExts.CommunistPartyDate = aSystemUsersEN.aSystemUserExts.CommunistPartyDate; aSystemUserExts.YouthUnionDate = aSystemUsersEN.aSystemUserExts.YouthUnionDate; aSystemUserExts.EnlistmentDate = aSystemUsersEN.aSystemUserExts.EnlistmentDate; aSystemUserExts.DemobilizedDate = aSystemUsersEN.aSystemUserExts.DemobilizedDate; aSystemUserExts.MartyrsFamily = aSystemUsersEN.aSystemUserExts.MartyrsFamily; aSystemUserExts.WoundedFamily = aSystemUsersEN.aSystemUserExts.WoundedFamily; aSystemUserExts.LaborFamily = aSystemUsersEN.aSystemUserExts.LaborFamily; aSystemUserExts.HightestAppellation = aSystemUsersEN.aSystemUserExts.HightestAppellation; status = aSystemUserExtsBO.Update(aSystemUserExts); } else { aSystemUserExts = new SystemUserExts(); aSystemUserExts.BirthPlace = aSystemUsersEN.aSystemUserExts.BirthPlace; aSystemUserExts.Hometown = aSystemUsersEN.aSystemUserExts.Hometown; aSystemUserExts.Address = aSystemUsersEN.aSystemUserExts.Address; aSystemUserExts.InsuranceNumber = aSystemUsersEN.aSystemUserExts.InsuranceNumber; aSystemUserExts.YearJob = aSystemUsersEN.aSystemUserExts.YearJob; aSystemUserExts.YearDepartment = aSystemUsersEN.aSystemUserExts.YearDepartment; aSystemUserExts.YearPayroll = aSystemUsersEN.aSystemUserExts.YearPayroll; aSystemUserExts.YearUnemploymentInsurance = aSystemUsersEN.aSystemUserExts.YearUnemploymentInsurance; aSystemUserExts.DifferenceContact = aSystemUsersEN.aSystemUserExts.DifferenceContact; aSystemUserExts.Type = aSystemUsersEN.aSystemUserExts.Type; aSystemUserExts.Status = aSystemUsersEN.aSystemUserExts.Status; aSystemUserExts.Disable = aSystemUsersEN.aSystemUserExts.Disable; aSystemUserExts.IDSystemUser = aSystemUsers.ID; aSystemUserExts.Recruitment = aSystemUsersEN.aSystemUserExts.Recruitment; aSystemUserExts.PermanentResidence = aSystemUsersEN.aSystemUserExts.PermanentResidence; aSystemUserExts.CommunistPartyDate = aSystemUsersEN.aSystemUserExts.CommunistPartyDate; aSystemUserExts.YouthUnionDate = aSystemUsersEN.aSystemUserExts.YouthUnionDate; aSystemUserExts.EnlistmentDate = aSystemUsersEN.aSystemUserExts.EnlistmentDate; aSystemUserExts.DemobilizedDate = aSystemUsersEN.aSystemUserExts.DemobilizedDate; aSystemUserExts.MartyrsFamily = aSystemUsersEN.aSystemUserExts.MartyrsFamily; aSystemUserExts.WoundedFamily = aSystemUsersEN.aSystemUserExts.WoundedFamily; aSystemUserExts.LaborFamily = aSystemUsersEN.aSystemUserExts.LaborFamily; aSystemUserExts.HightestAppellation = aSystemUsersEN.aSystemUserExts.HightestAppellation; status = aSystemUserExtsBO.Insert(aSystemUserExts); } FamilyMembersBO aFamilyMembersBO = new FamilyMembersBO(); foreach (FamilyMembers familyMembers in aSystemUsersEN.aListFamilyMembersExtEN) { FamilyMembers aFamilyMembers = aFamilyMembersBO.Select_ByID(familyMembers.ID); if (aFamilyMembers == null) { aFamilyMembers = new FamilyMembers(); aFamilyMembers.Name = familyMembers.Name; aFamilyMembers.Birthday = familyMembers.Birthday; aFamilyMembers.RelationType = familyMembers.RelationType; aFamilyMembers.Info = familyMembers.Info; aFamilyMembers.IDSystemUser = aSystemUsers.ID; int a = aFamilyMembersBO.Insert(aFamilyMembers); if (a <= 0) { throw new Exception("Lỗi khi thêm dữ liệu thành viên gia đình"); } } else { aFamilyMembers.Name = familyMembers.Name; aFamilyMembers.Birthday = familyMembers.Birthday; aFamilyMembers.RelationType = familyMembers.RelationType; aFamilyMembers.Info = familyMembers.Info; aFamilyMembers.IDSystemUser = familyMembers.IDSystemUser; aFamilyMembersBO.Update(aFamilyMembers); } } SystemUsers_CertificatesBO aSystemUsers_CertificatesBO = new SystemUsers_CertificatesBO(); foreach (SystemUsers_Certificates systemUsers_Certificates in aSystemUsersEN.aListSystemUsers_CertificatesEN) { SystemUsers_Certificates aSystemUsers_Certificates = aSystemUsers_CertificatesBO.Select_ByID(systemUsers_Certificates.ID); if (aSystemUsers_Certificates == null) { aSystemUsers_Certificates = new SystemUsers_Certificates(); aSystemUsers_Certificates.Level = systemUsers_Certificates.Level; aSystemUsers_Certificates.CreatedDate = systemUsers_Certificates.CreatedDate; aSystemUsers_Certificates.ExpirationDate = systemUsers_Certificates.ExpirationDate; aSystemUsers_Certificates.Organization = systemUsers_Certificates.Organization; aSystemUsers_Certificates.TrainingType = systemUsers_Certificates.TrainingType; aSystemUsers_Certificates.IDCertificate = systemUsers_Certificates.IDCertificate; aSystemUsers_Certificates.IDSystemUser = aSystemUsers.ID; aSystemUsers_CertificatesBO.Insert(aSystemUsers_Certificates); } else { aSystemUsers_Certificates.Level = systemUsers_Certificates.Level; aSystemUsers_Certificates.CreatedDate = systemUsers_Certificates.CreatedDate; aSystemUsers_Certificates.ExpirationDate = systemUsers_Certificates.ExpirationDate; aSystemUsers_Certificates.Organization = systemUsers_Certificates.Organization; aSystemUsers_Certificates.TrainingType = systemUsers_Certificates.TrainingType; aSystemUsers_Certificates.IDCertificate = systemUsers_Certificates.IDCertificate; aSystemUsers_Certificates.IDSystemUser = systemUsers_Certificates.IDSystemUser; aSystemUsers_CertificatesBO.Update(aSystemUsers_Certificates); } } AuditHistoriesBO aAuditHistoriesBO = new AuditHistoriesBO(); foreach (AuditHistories auditHistories in aSystemUsersEN.aListAuditHistories) { AuditHistories aAuditHistories = aAuditHistoriesBO.Select_ByID(auditHistories.ID); if (aAuditHistories == null) { aAuditHistories = new AuditHistories(); aAuditHistories.From = auditHistories.From; aAuditHistories.To = auditHistories.To; aAuditHistories.Note = auditHistories.Note; aAuditHistories.Type = auditHistories.Type; aAuditHistories.IDSystemUser = aSystemUsers.ID; aAuditHistoriesBO.Insert(aAuditHistories); } else { aAuditHistories.From = auditHistories.From; aAuditHistories.To = auditHistories.To; aAuditHistories.Note = auditHistories.Note; aAuditHistories.Type = auditHistories.Type; aAuditHistories.IDSystemUser = auditHistories.IDSystemUser; aAuditHistoriesBO.Update(aAuditHistories); } } RewardAndPunishmentsBO aRewardAndPunishmentsBO = new RewardAndPunishmentsBO(); foreach (RewardAndPunishments rewardAndPunishments in aSystemUsersEN.aListRewardAndPunishments) { RewardAndPunishments aRewardAndPunishments = aRewardAndPunishmentsBO.Select_ByID(rewardAndPunishments.ID); if (aRewardAndPunishments == null) { aRewardAndPunishments = new RewardAndPunishments(); aRewardAndPunishments.Type = rewardAndPunishments.Type; aRewardAndPunishments.Subject = rewardAndPunishments.Subject; aRewardAndPunishments.Description = rewardAndPunishments.Description; aRewardAndPunishments.CreatedDate = rewardAndPunishments.CreatedDate; aRewardAndPunishments.DecisionDate = rewardAndPunishments.DecisionDate; aRewardAndPunishments.NumberDecision = rewardAndPunishments.NumberDecision; aRewardAndPunishments.DecisionLevel = rewardAndPunishments.DecisionLevel; aRewardAndPunishments.Status = rewardAndPunishments.Status; aRewardAndPunishments.Disable = rewardAndPunishments.Disable; aRewardAndPunishments.IDSystemUser = aSystemUsers.ID; aRewardAndPunishmentsBO.Insert(aRewardAndPunishments); } else { aRewardAndPunishments.Type = rewardAndPunishments.Type; aRewardAndPunishments.Subject = rewardAndPunishments.Subject; aRewardAndPunishments.Description = rewardAndPunishments.Description; aRewardAndPunishments.CreatedDate = rewardAndPunishments.CreatedDate; aRewardAndPunishments.DecisionDate = rewardAndPunishments.DecisionDate; aRewardAndPunishments.NumberDecision = rewardAndPunishments.NumberDecision; aRewardAndPunishments.DecisionLevel = rewardAndPunishments.DecisionLevel; aRewardAndPunishments.Status = rewardAndPunishments.Status; aRewardAndPunishments.Disable = rewardAndPunishments.Disable; aRewardAndPunishments.IDSystemUser = rewardAndPunishments.IDSystemUser; aRewardAndPunishmentsBO.Update(aRewardAndPunishments); } } DocumentSystemUsersBO aDocumentSystemUsersBO = new DocumentSystemUsersBO(); foreach (DocumentSystemUsers documentSystemUsers in aSystemUsersEN.aListDocumentSystemUsers) { DocumentSystemUsers aDocumentSystemUsers = aDocumentSystemUsersBO.Select_ByID(documentSystemUsers.ID); if (aDocumentSystemUsers == null) { aDocumentSystemUsers = new DocumentSystemUsers(); aDocumentSystemUsers.Name = documentSystemUsers.Name; aDocumentSystemUsers.FileData = documentSystemUsers.FileData; aDocumentSystemUsers.Note = documentSystemUsers.Note; aDocumentSystemUsers.Type = documentSystemUsers.Type; aDocumentSystemUsers.Status = documentSystemUsers.Status; aDocumentSystemUsers.Disable = documentSystemUsers.Disable; aDocumentSystemUsers.IDSystemUser = aSystemUsers.ID; aDocumentSystemUsersBO.Insert(aDocumentSystemUsers); } else { aDocumentSystemUsers.Name = documentSystemUsers.Name; aDocumentSystemUsers.FileData = documentSystemUsers.FileData; aDocumentSystemUsers.Note = documentSystemUsers.Note; aDocumentSystemUsers.Type = documentSystemUsers.Type; aDocumentSystemUsers.Status = documentSystemUsers.Status; aDocumentSystemUsers.Disable = documentSystemUsers.Disable; aDocumentSystemUsers.IDSystemUser = documentSystemUsers.IDSystemUser; aDocumentSystemUsersBO.Update(aDocumentSystemUsers); } } } } catch (Exception ex) { aSystemUsersBO.Update(aSystemUsers_Old); aSystemUserExtsBO.Update(aSystemUserExts_Old); throw new Exception(string.Format("ReceptionTaskBO.UpdateSystemUserInformation :" + ex.Message.ToString())); } }