public void Insert(SendMail.Model.BackEndRefCode entity) { try { using (var dbcontext = new FAXPECContext()) { RUBR_BACKEND r = AutoMapperConfiguration.FromRubrBackendToDto(entity); dbcontext.RUBR_BACKEND.Add(r); int risp = dbcontext.SaveChanges(); if (risp != 1) { throw new InvalidOperationException("Dato non inserito"); } } } catch (Exception ex) { if (ex.GetType() != typeof(ManagedException)) { ManagedException mEx = new ManagedException(ex.Message, "ERR_ORADB111", string.Empty, string.Empty, ex); ErrorLogInfo er = new ErrorLogInfo(mEx); log.Error(er); throw mEx; } else { throw; } } }
public SendMail.Model.BackEndRefCode GetById(decimal id) { BackEndRefCode entity = null; try { using (var dbcontext = new FAXPECContext()) { RUBR_BACKEND b = dbcontext.RUBR_BACKEND.Where(x => x.ID_BACKEND == id).First(); if (b != null && b.ID_BACKEND != 0) { entity = AutoMapperConfiguration.FromRubrBackendToSingleModel(b); } else { return(null); } } } catch (Exception e0) { if (e0.GetType() != typeof(ManagedException)) { ManagedException me = new ManagedException(e0.Message, "ORA_ERR002", string.Empty, string.Empty, e0); ErrorLogInfo err = new ErrorLogInfo(me); log.Error(err); } return(null); } return(entity); }
public void Delete(decimal id) { try { using (var dbcontext = new FAXPECContext()) { RUBR_BACKEND r = dbcontext.RUBR_BACKEND.Where(x => x.ID_BACKEND == id).First(); dbcontext.RUBR_BACKEND.Remove(r); int resp = dbcontext.SaveChanges(); if (resp != 1) { throw new InvalidOperationException("Oggetto non cancellato"); } } } catch (Exception ex) { if (!ex.GetType().Equals(typeof(ManagedException))) { ManagedException mEx = new ManagedException(ex.Message, "ORA_ERR006", string.Empty, string.Empty, ex); ErrorLogInfo err = new ErrorLogInfo(mEx); log.Error(err); throw mEx; } else { throw ex; } } }
public BackEndRefCode GetByCode(string backendCode) { BackEndRefCode entity = null; try { using (var dbcontext = new FAXPECContext()) { RUBR_BACKEND b = dbcontext.RUBR_BACKEND.Where(x => x.BACKEND_CODE.ToUpper() == backendCode.ToUpper()).First(); if (b != null && b.ID_BACKEND != 0) { entity = AutoMapperConfiguration.FromRubrBackendToSingleModel(b); } else { return(null); } } } catch { return(null); } return(entity); }
public void Update(SendMail.Model.BackEndRefCode entity) { try { using (var dbcontext = new FAXPECContext()) { RUBR_BACKEND b = dbcontext.RUBR_BACKEND.Where(x => x.ID_BACKEND == entity.Id).First(); b = AutoMapperConfiguration.FromModelToRubrBackendDto(entity, b); int risp = dbcontext.SaveChanges(); if (risp != 1) { throw new InvalidOperationException("Oggetto non aggiornato"); } } } catch (Exception e0) { if (e0.GetType() != typeof(ManagedException)) { ManagedException me = new ManagedException(e0.Message, "ORA_ERR022", string.Empty, string.Empty, e0); ErrorLogInfo err = new ErrorLogInfo(me); log.Error(err); } throw; } }