public ContactsBackendMap GetById(int id) { ContactsBackendMap m = null; try { using (FAXPECContext dbcontext = new FAXPECContext()) { var r = dbcontext.RUBR_CONTATTI_BACKEND.Where(x => x.ID_MAP == id).OrderBy(x => x.REF_ID_BACKEND).OrderBy(x => x.REF_ID_TITOLO).FirstOrDefault(); if (r != null) { var ListTitoli = (from t in dbcontext.RUBR_CONTATTI_BACKEND where t.REF_ID_CONTATTO == r.REF_ID_CONTATTO select t.COMUNICAZIONI_TITOLI.ID_TITOLO).ToList(); var rubrcontatti = dbcontext.RUBR_CONTATTI.Where(x => x.ID_CONTACT == r.REF_ID_CONTATTO).First(); var rubrentita = dbcontext.RUBR_ENTITA.Where(x => x.ID_REFERRAL == r.REF_ID_ENTITA).First(); m = AutoMapperConfiguration.MapToContactsBackendMap(r, rubrcontatti, rubrentita, ListTitoli); } } } catch { throw; } return(m); }
private static OracleParameter[] MapToParams(ContactsBackendMap c) { OracleParameter[] pars = new OracleParameter[4]; pars[0] = new OracleParameter("pID_CANALE", OracleDbType.Decimal, System.Data.ParameterDirection.Input); if (c.Canale != SendMail.Model.TipoCanale.UNKNOWN) { pars[0].Value = (int)c.Canale; } pars[1] = new OracleParameter("pID_BACKEND", OracleDbType.Decimal, System.Data.ParameterDirection.Input); if (c.Backend.Id != -1) { pars[1].Value = c.Backend.Id; } pars[2] = new OracleParameter("pID_CONTATTO", OracleDbType.Decimal, System.Data.ParameterDirection.Input); if (c.Contatto.IdContact.Value != -1) { pars[2].Value = c.Contatto.IdContact.Value; } pars[3] = new OracleParameter("pID_TITOLO", OracleDbType.Decimal, System.Data.ParameterDirection.Input); if (c.Titolo.Id != -1) { pars[3].Value = c.Titolo.Id; } return(pars); }
public ContactsBackendMap GetById(int id) { StringBuilder sb = new StringBuilder(selectCmdBase); sb.Append(" WHERE ID_MAP = :pID_MAP"); try { using (OracleCommand cmd = CurrentConnection.CreateCommand()) { cmd.CommandText = sb.ToString(); cmd.BindByName = true; cmd.Parameters.Add("pID_MAP", OracleDbType.Decimal, id, System.Data.ParameterDirection.Input); ContactsBackendMap contact = DaoOracleDbHelper <ContactsBackendMap> .ExecSelectCommand(cmd, DaoOracleDbHelper.MapToContactsBackendMap).FirstOrDefault(); if (contact != null) { Complete(contact); } return(contact); } } catch { throw; } }
private void Complete(ContactsBackendMap contact) { if (contact == null) { return; } if (contact.Backend != null) { contact.Backend = Context.DaoImpl.BackEndCodeDao.GetById(contact.Backend.Id); } if (contact.Contatto != null) { contact.Contatto = Context.DaoImpl.ContattoDao.GetById(contact.Contatto.IdContact.Value); } if (contact.Titolo != null) { contact.Titolo = Context.DaoImpl.TitoloDao.GetById(contact.Titolo.Id); } }
internal static ContactsBackendMap MapToContactsBackendMap(IDataRecord dr) { ContactsBackendMap cbm = new ContactsBackendMap(); if (dr.IsDBNull("ID_MAP") == false) { cbm.Id = (int)dr.GetDecimal("ID_MAP"); } else { cbm.Id = -1; } cbm.Canale = TipoCanale.UNKNOWN; if (dr.IsDBNull("REF_ID_CANALE") == false) { cbm.Canale = (TipoCanale)(int)dr.GetDecimal("REF_ID_CANALE"); } if (dr.IsDBNull("REF_ID_BACKEND") == false) { cbm.Backend = new BackEndRefCode { Id = dr.GetDecimal("REF_ID_BACKEND") } } ; cbm.Contatto = new RubricaContatti(); if (dr.IsDBNull("REF_ID_CONTATTO") == false) { cbm.Contatto.IdContact = (long)dr.GetDecimal("REF_ID_CONTATTO"); } else { cbm.Contatto.IdContact = -1; } if (dr.IsDBNull("REF_ID_TITOLO") == false) { cbm.Titolo = new Titolo { Id = dr.GetDecimal("REF_ID_TITOLO") } } ; return(cbm); }
public void Insert(ContactsBackendMap entity) { try { using (FAXPECContext dbcontext = new FAXPECContext()) { RUBR_CONTATTI_BACKEND b = DaoSQLServerDBHelper.MapToRubrContattiBackend(entity); dbcontext.RUBR_CONTATTI_BACKEND.Add(b); int risp = dbcontext.SaveChanges(); if (risp == 1) { entity.Id = (int)b.ID_MAP; } } } catch { throw; } }
public HttpResponseMessage PutMapping(EntiMappings mapping) { Response <EntiMappings> response = new Response <EntiMappings>(); try { ContactsBackendMap bMap = (ContactsBackendMap)mapping; s.UpdateMapping(bMap); List <EntiMappings> list = new List <EntiMappings>(); list.Add(mapping); response.Totale = 1; response.Message = "Operazione effettuata"; response.Data = list; } catch { response.Totale = 0; response.Message = "Errore nell'aggiornamento del contatto"; } return(this.Request.CreateResponse <Response <EntiMappings> >(HttpStatusCode.OK, response)); }
public HttpResponseMessage CreateMapping(EntiMappings mapping) { Response <EntiMappings> resp = new Response <EntiMappings>(); try { ContactsBackendMap bMap = (ContactsBackendMap)mapping; s.CreateMapping(bMap); mapping.EnteMapping.ElementAt(0).Mapping.ElementAt(0).Id = bMap.Id; List <EntiMappings> list = new List <EntiMappings>(); list.Add(mapping); resp.Totale = 1; resp.Message = "Operazione effettuata"; resp.Data = list; } catch { resp.Totale = 0; resp.Message = "Errore nell'inserimento del contatto"; } return(this.Request.CreateResponse <Response <EntiMappings> >(HttpStatusCode.OK, resp)); }
public void Update(ContactsBackendMap entity) { try { using (FAXPECContext dbcontext = new FAXPECContext()) { var oldentities = dbcontext.RUBR_CONTATTI_BACKEND.Where(x => x.ID_MAP == entity.Id).First(); if (oldentities != null) { oldentities.REF_ID_CANALE = (int)entity.Canale; oldentities.REF_ID_CONTATTO = (int)entity.Contatto.IdContact; oldentities.REF_ID_BACKEND = (int)entity.Backend.Id; oldentities.REF_ID_TITOLO = (int)entity.Titolo.Id; int risp = dbcontext.SaveChanges(); if (risp != 1) { throw new InvalidOperationException("Errore nell'aggiornamento"); } } } } catch (Exception ex) { if (!ex.GetType().Equals(typeof(ManagedException))) { ManagedException mEx = new ManagedException(ex.Message, "ORA_ERR009", string.Empty, string.Empty, ex); ErrorLogInfo err = new ErrorLogInfo(mEx); err.objectID = Convert.ToString(entity.Id); _log.Error(err); throw mEx; } else { throw ex; } } }
public void Insert(ContactsBackendMap entity) { try { using (OracleCommand cmd = CurrentConnection.CreateCommand()) { cmd.CommandText = insertCmdBase; cmd.BindByName = true; cmd.Parameters.AddRange(MapToParams(entity)); cmd.Parameters.Add("pID_MAP", OracleDbType.Decimal, System.Data.ParameterDirection.Output); int risp = cmd.ExecuteNonQuery(); if (risp == 1) { entity.Id = Convert.ToInt32(cmd.Parameters["pID_MAP"].Value.ToString()); } } } catch { throw; } }
public void Update(ContactsBackendMap entity) { try { using (OracleCommand cmd = CurrentConnection.CreateCommand()) { cmd.CommandText = updateCmdBase; cmd.BindByName = true; cmd.Parameters.AddRange(MapToParams(entity)); cmd.Parameters.Add("pID_MAP", OracleDbType.Decimal, entity.Id, System.Data.ParameterDirection.InputOutput); int risp = cmd.ExecuteNonQuery(); if (risp != 1) { throw new InvalidOperationException("Errore nell'aggiornamento"); } } } catch (Exception ex) { //TASK: Allineamento log - Ciro if (!ex.GetType().Equals(typeof(ManagedException))) { ManagedException mEx = new ManagedException(ex.Message, "ORA_ERR009", string.Empty, string.Empty, ex); ErrorLogInfo err = new ErrorLogInfo(mEx); err.objectID = Convert.ToString(entity.Id); _log.Error(err); throw mEx; } else { throw ex; } } }