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;
}
