public bool Save(CurriculumModel objCurriculum) { using (var con = new PortalEntities()) { tb_curriculum objDbCurriculum = new tb_curriculum { idUsuario = objCurriculum.idUsuario, xAtividadesComplementares = objCurriculum.xAtividadesComplementares, xBairro = objCurriculum.xBairro, xCelular = objCurriculum.xCelular, xCidade = objCurriculum.xCidade, xCompetencias = objCurriculum.xCompetencias, xEmail = objCurriculum.xEmail, xEndereco = objCurriculum.xEndereco, xEstado = objCurriculum.xEstado, xExperiencia = objCurriculum.xExperiencia, xFormacao = objCurriculum.xFormacao, xInformacoesComplementares = objCurriculum.xInformacoesComplementares, xNome = objCurriculum.xNome, xObjetivo = objCurriculum.xObjetivo, xSobreMim = objCurriculum.xSobreMim, xTelefone = objCurriculum.xTelefone }; if (objCurriculum.idCurriculumVitae == 0) { con.tb_curriculum.Add(entity: objDbCurriculum); } else { con.tb_curriculum.Attach(entity: objDbCurriculum); con.Entry(entity: objDbCurriculum).State = System.Data.EntityState.Modified; } try { con.SaveChanges(); objCurriculum.idCurriculumVitae = objDbCurriculum.idCurriculumVitae; return true; } catch (Exception ex) { throw ex; } } }
public bool Save(SoliciteContatoModel obj) { using (var con = new PortalEntities()) { tb_solicitecontato objTbSolicitacao = new tb_solicitecontato { stObjetivo = obj.stObjetivo, xCelular = obj.xCelular, xEmail = obj.xEmail, xMessage = obj.xMessage, xTelefone = obj.xTelefone, xNomeEmpresa = obj.xNomeEmpresa, stContatoPreferencial = obj.stContatoPreferencial }; con.tb_solicitecontato.Add(entity: objTbSolicitacao); try { con.SaveChanges(); obj.idSolicitacao = objTbSolicitacao.idSoliciteContato; return true; } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } }
public bool Save(UserModel user) { try { using (var db = new PortalEntities()) { tb_usuario u = new tb_usuario(); if (user.idUsuario == null) { SetPassword(user, u); u.xUserName = user.xUserName; u.xFullName = user.xFullName; db.tb_usuario.Add(u); foreach (var prov in user.providers) { u.tb_providers.Add(new tb_providers { idUsuario = u.idUsuario, Provider = prov.Provider, ProviderUserId = prov.ProviderUserId }); } } else { u = db.tb_usuario.FirstOrDefault(c => c.xUserName == user.xUserName); SetPassword(user, u); u.xUserName = user.xUserName; u.xFullName = user.xFullName; foreach (var prov in user.providers) { tb_providers provider = null; if (u.tb_providers.Where(c => c.ProviderUserId == prov.ProviderUserId).Count() > 0) { provider = u.tb_providers.FirstOrDefault(c => c.ProviderUserId == prov.ProviderUserId); provider.ProviderUserId = prov.ProviderUserId; provider.Provider = prov.Provider; provider.idUsuario = prov.idUsuario; } else { provider = new tb_providers(); provider.ProviderUserId = prov.ProviderUserId; provider.Provider = prov.Provider; provider.idUsuario = prov.idUsuario; u.tb_providers.Add(provider); } } } db.SaveChanges(); } return true; } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } }