private static ResultadoTransaccion GuardaNuevaNave(PaperlessNave nave, SqlConnection connparam, SqlTransaction tranparam) { Int64 idnave = 0; resTransaccion = new ResultadoTransaccion(); try { objParams = SqlHelperParameterCache.GetSpParameterSet(connparam, "SP_N_PAPERLESS_NAVE"); objParams[0].Value = nave.Nombre; objParams[1].Value = nave.Activo; SqlCommand command = new SqlCommand("SP_N_PAPERLESS_NAVE", connparam); command.Transaction = tranparam; command.Parameters.AddRange(objParams); command.CommandType = CommandType.StoredProcedure; idnave = Convert.ToInt64(command.ExecuteScalar()); resTransaccion.Estado = Enums.EstadoTransaccion.Aceptada; resTransaccion.ObjetoTransaccion = idnave; } catch (Exception ex) { resTransaccion.Estado = Enums.EstadoTransaccion.Rechazada; resTransaccion.Descripcion = ex.Message; Log.EscribirLog(ex.Message); } return resTransaccion; }
public static IList<PaperlessNave> ObtenerNaves(Enums.Estado estado) { PaperlessNave nave = null; IList<PaperlessNave> listnaves = new List<PaperlessNave>(); try { //Abrir Conexion conn = BaseDatos.NuevaConexion(); objParams = SqlHelperParameterCache.GetSpParameterSet(conn, "SP_L_PAPERLESS_NAVE"); objParams[0].Value = estado; SqlCommand command = new SqlCommand("SP_L_PAPERLESS_NAVE", conn); command.Parameters.AddRange(objParams); command.CommandType = CommandType.StoredProcedure; dreader = command.ExecuteReader(); while (dreader.Read()) { nave = new PaperlessNave(); nave.Id = Convert.ToInt64(dreader["Id"]); nave.Nombre = dreader["Descripcion"].ToString(); // nave.FechaCreacion = Convert.ToDateTime(dreader["FechaCreacion"]); listnaves.Add(nave); } } catch (Exception ex) { Base.Log.Log.EscribirLog(ex.Message); } finally { conn.Close(); } return listnaves; }