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 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; } }
public SendMail.Model.BackEndRefCode insertTitolo(SendMail.Model.BackEndRefCode e) { throw new NotImplementedException(); }
public SendMail.Model.BackEndRefCode Update(SendMail.Model.BackEndRefCode e) { throw new NotImplementedException(); }
public void Update(SendMail.Model.BackEndRefCode entity) { try { using (OracleCommand cmd = CurrentConnection.CreateCommand()) { StringBuilder sb = new StringBuilder("UPDATE rubr_backend SET") .Append(" backend_code = :p_code, backend_descr = :p_descr") .Append(", category = :p_cat, descr_plus = :p_descrp") .Append(" WHERE id_backend = :p_id"); cmd.CommandText = sb.ToString(); cmd.BindByName = true; cmd.Parameters.Add(new OracleParameter { Direction = ParameterDirection.Input, OracleDbType = OracleDbType.Varchar2, ParameterName = "p_code", Size = 15, Value = entity.Codice }); cmd.Parameters.Add(new OracleParameter { Direction = ParameterDirection.Input, OracleDbType = OracleDbType.Varchar2, ParameterName = "p_descr", Size = 100, Value = entity.Descrizione }); cmd.Parameters.Add(new OracleParameter { Direction = ParameterDirection.Input, OracleDbType = OracleDbType.NVarchar2, ParameterName = "p_cat", Size = 40, Value = entity.Categoria }); cmd.Parameters.Add(new OracleParameter { Direction = ParameterDirection.Input, OracleDbType = OracleDbType.Varchar2, ParameterName = "p_descrp", Size = 10, Value = entity.DescrizionePlus }); cmd.Parameters.Add(new OracleParameter { Direction = ParameterDirection.Input, OracleDbType = OracleDbType.Decimal, ParameterName = "p_id", Precision = 10, Scale = 0, Value = entity.Id }); int risp = cmd.ExecuteNonQuery(); if (risp != 1) { throw new InvalidOperationException("Oggetto non aggiornato"); } } } catch { throw; } }
public void Insert(SendMail.Model.BackEndRefCode entity) { try { using (OracleCommand cmd = CurrentConnection.CreateCommand()) { StringBuilder sb = new StringBuilder("INSERT INTO rubr_backend") .Append(" (backend_code, backend_descr, category, descr_plus)") .Append(" VALUES") .Append(" (:p_code, :p_descr, :p_cat, :p_descrp)") .Append(" RETURNING id_backend INTO :p_id"); cmd.CommandText = sb.ToString(); cmd.BindByName = true; cmd.Parameters.Add(new OracleParameter { Direction = ParameterDirection.Input, OracleDbType = OracleDbType.Varchar2, ParameterName = "p_code", Size = 15, Value = entity.Codice }); cmd.Parameters.Add(new OracleParameter { Direction = ParameterDirection.Input, OracleDbType = OracleDbType.Varchar2, ParameterName = "p_descr", Size = 100, Value = entity.Descrizione }); cmd.Parameters.Add(new OracleParameter { Direction = ParameterDirection.Input, OracleDbType = OracleDbType.NVarchar2, ParameterName = "p_cat", Size = 40, Value = entity.Categoria }); cmd.Parameters.Add(new OracleParameter { Direction = ParameterDirection.Input, OracleDbType = OracleDbType.Varchar2, ParameterName = "p_descrp", Size = 10, Value = entity.DescrizionePlus }); cmd.Parameters.Add(new OracleParameter { Direction = ParameterDirection.Output, OracleDbType = OracleDbType.Decimal, ParameterName = "p_id", Precision = 10, Scale = 0 }); int risp = cmd.ExecuteNonQuery(); if (risp != 1) { throw new InvalidOperationException("Dato non inserito"); } entity.Id = ((OracleDecimal)cmd.Parameters["p_id"].Value).Value; } } catch (Exception ex) { //Allineamento log - Ciro 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 BackEndRefCode Save(BackEndRefCode e) { return(e); }