public DataSet GetData()
{
SqlConnection con;
SqlDataAdapter da;
DataSet ds;
string cs, sql;
cs = ConfigurationSettings.AppSettings["ConnectionString"];
sql = "SELECT * FROM authors";
try
{
con = new SqlConnection(cs);
da = new SqlDataAdapter(sql, con);
ds = new DataSet();
da.Fill(ds);
return ds;
}
catch (SqlException ex)
{
InworxException ex2;
ex2 = new InworxException("Error en DataLayer.GetData",
ex, true);
throw ex2;
}
finally
{
}
}
// Devuelve un dataset con los datos de la base
public DataSet GetData()
{
SqlConnection con;
SqlDataAdapter da;
DataSet ds;
string cs, sql;
// String de conexion a la base de datos
//cs = "Data Source=.; Initial catalog=pubs; User ID=sa; Password=inworx";
cs = ConfigurationSettings.AppSettings["ConnectionString"];
// SQL a ejecutar
sql = "SELECT * FROM authors";
try
{
con = new SqlConnection(cs);
da = new SqlDataAdapter(sql, con);
ds = new DataSet();
da.Fill(ds); //Aca se abre la conexion implicitamente
return ds;
}
catch (SqlException ex)
{
InworxException ie = new InworxException("Error en DataLayer - " + ex.Message + " - " + ex.StackTrace, ex, true);
throw ie;
return null;
}
finally
{
}
}
public void Update(string Id, string LastName, string FirstName)
{
SqlConnection con = null;
SqlCommand cmd;
string cs, sql;
cs = ConfigurationSettings.AppSettings["ConnectionString"];
sql = "UPDATE authors SET au_lname='{1}', au_fname='{2}' WHERE au_id='{0}'";
sql = string.Format(sql, Id, FirstName, LastName);
try
{
con = new SqlConnection(cs);
cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
InworxException ex2;
ex2 = new InworxException("Error en DataLayer.AuthorDALC.Update",
ex, true);
throw ex2;
}
finally
{
con.Close();
}
}
public void GetData(string Id, out string LastName, out string FirstName)
{
SqlConnection con;
SqlDataAdapter da;
DataSet ds;
string cs, sql;
cs = ConfigurationSettings.AppSettings["ConnectionString"];
sql = "SELECT * FROM authors WHERE au_id='{0}'";
sql = string.Format(sql, Id);
try
{
con = new SqlConnection(cs);
da = new SqlDataAdapter(sql, con);
ds = new DataSet();
da.Fill(ds);
FirstName = ds.Tables[0].Rows[0]["au_fname"].ToString();
LastName = ds.Tables[0].Rows[0]["au_lname"].ToString();
}
catch (SqlException ex)
{
InworxException ex2;
ex2 = new InworxException("Error en DataLayer.GetData",
ex, true);
throw ex2;
}
finally
{
}
}
public DataSet GetData()
{
try
{
DataClass data = new DataClass();
return data.GetData();
}
catch(InworxException e)
{
InworxException ex = new InworxException("Error en Business Layer - " + e.Message + " - " + e.StackTrace, e);
throw ex;
}
}
public DataSet GetData()
{
DataClass data;
try
{
data = new DataClass();
return data.GetData();
}
catch(InworxException ex)
{
InworxException ex2;
ex2 = new InworxException("Error en BusinessLayer.GetData", ex);
return null;
}
}
public DataSet GetData()
{
SqlConnection con;
SqlDataAdapter da;
DataSet ds;
string cs;
//Data Source=. : mi maquina
//Conexion fija
//cs = "Data Source=.; Initial Catalog=pubs; User ID=sa; Password=inworx";
//Conexion por settings
cs = ConfigurationSettings.AppSettings["ConnectionString"];
//XmlDocument doc = new XmlDocument();
try
{
//Conexión
con = new SqlConnection(cs);
//Adapter
da = new SqlDataAdapter("select * from authors", con);
//Dataset & Fill
//Fill hace open, tira el comando, llena el dataset y luego hace close
ds = new DataSet();
da.Fill(ds);
return ds;
}
catch (SqlException ex)
{
InworxException ex2;
ex2 = new InworxException("Error en GetData", ex, true);
throw ex2;
}
finally
{
}
}