public static DataSet GetClientesOffLine(BsCliente c)
{
createConnection();
try
{
BsClientes cs = new BsClientes();
_cm = new SqlCommand("P_GetClientes", _cn);
_cm.CommandType = CommandType.StoredProcedure;
_cm.Parameters.AddWithValue("@id", c.Id);
_cm.Parameters.AddWithValue("@nome", c.Nome);
SqlDataAdapter da = new SqlDataAdapter(_cm);
DataSet ds = new DataSet();
da.Fill(ds);
return(ds);
}
catch (SqlException sqlE)
{
createFile("SQL Error: " + sqlE.Message);
return(null);
}
catch (Exception e)
{
createFile("Error: " + e.Message);
return(null);
}
finally { closeConnection(); }
}
public static BsClientes GetClientes(BsCliente c)
{
createConnection();
try
{
BsClientes cs = new BsClientes();
_cm = new SqlCommand("P_GetClientes", _cn);
_cm.CommandType = CommandType.StoredProcedure;
_cm.Parameters.AddWithValue("@id", c.Id);
_cm.Parameters.AddWithValue("@nome", c.Nome);
_cn.Open();
SqlDataReader dr = _cm.ExecuteReader();
while (dr.Read())
{
cs.Add(new BsCliente(Convert.ToInt32(dr["id"]), dr["nome"].ToString()));
}
return(cs);
}
catch (SqlException sqlE)
{
createFile("SQL Error: " + sqlE.Message);
return(null);
}
catch (Exception e)
{
createFile("Error: " + e.Message);
return(null);
}
finally { closeConnection(); }
}
