public ModeloNegocio.Sesion getSesionId(int sesion_id) { Cmd = new SqlCommand(); Cmd.Connection = Conn; ModeloNegocio.Sesion sesion = new ModeloNegocio.Sesion(); try { Cmd.CommandType = CommandType.StoredProcedure; Cmd.CommandText = "PA_GET_SESIONES_ID"; Cmd.Parameters.Add("@sesion_id", SqlDbType.Int).Value = sesion_id; Dtr = Cmd.ExecuteReader(); while (Dtr.Read()) { sesion.Id = Convert.ToInt32(Dtr["id"]); sesion.NumSesion = Dtr["nrosesion"].ToString(); sesion.Tema_id = Convert.ToInt32(Dtr["tema_id"]); // if (DBNull.Value.Equals(Dtr["created_at"])) sesion.Created_at = DateTime.Now; else sesion.Created_at = DateTime.Parse(Dtr["created_at"].ToString()); // if (DBNull.Value.Equals(Dtr["updated_at"])) sesion.Updated_at = DateTime.Now; else sesion.Updated_at = DateTime.Parse(Dtr["updated_at"].ToString()); } Conn.Close(); return sesion; } catch (Exception e) { Console.WriteLine("{0} Exception caught.", e); return sesion; } }
public ModeloNegocio.Sesion getSesionId(int sesion_id) { Cmd = new SqlCommand(); Cmd.Connection = Conn; ModeloNegocio.Sesion sesion = new ModeloNegocio.Sesion(); try { Cmd.CommandType = CommandType.StoredProcedure; Cmd.CommandText = "PA_GET_SESIONES_ID"; Cmd.Parameters.Add("@sesion_id", SqlDbType.Int).Value = sesion_id; Dtr = Cmd.ExecuteReader(); while (Dtr.Read()) { sesion.Id = Convert.ToInt32(Dtr["id"]); sesion.NumSesion = Dtr["nrosesion"].ToString(); sesion.Tema_id = Convert.ToInt32(Dtr["tema_id"]); // if (DBNull.Value.Equals(Dtr["created_at"])) sesion.Created_at = DateTime.Now; else sesion.Created_at = DateTime.Parse(Dtr["created_at"].ToString()); // if (DBNull.Value.Equals(Dtr["updated_at"])) sesion.Updated_at = DateTime.Now; else sesion.Updated_at = DateTime.Parse(Dtr["updated_at"].ToString()); } Conn.Close(); return(sesion); } catch (Exception e) { Console.WriteLine("{0} Exception caught.", e); return(sesion); } }