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(); }
}
public static int Gravar(BsCliente c)
{
createConnection();
try
{
_cm = new SqlCommand("P_GravaCliente", _cn);
_cm.CommandType = CommandType.StoredProcedure;
_cm.Parameters.AddWithValue("@nome", c.Nome);
SqlParameter pr = new SqlParameter("@id", SqlDbType.Int);
pr.Direction = ParameterDirection.Output;
_cm.Parameters.Add(pr);
_cn.Open();
_cm.ExecuteNonQuery();
return(Convert.ToInt32(_cm.Parameters["@id"].Value));
}
catch (SqlException sqlE)
{
createFile("SQL Error: " + sqlE.Message);
return(0);
}
catch (Exception e)
{
createFile("Error: " + e.Message);
return(0);
}
finally{ closeConnection(); }
}
protected void Button1_Click(object sender, EventArgs e)
{
/*gvClientesOffLine.DataSource = new BsCliente().GetClientes();
* gvClientesOffLine.DataBind();*/
BsClientes cs = new BsCliente().GetClientes();
foreach (BsCliente c in cs)
{
lblClientes.Text += "<BR>Id: " + c.Id;
lblClientes.Text += "<BR>Nome: " + c.Nome;
}
}
protected void cmdGravar_Click(object sender, EventArgs e)
{
lblId.Text = "0";
int x = new BsCliente(Convert.ToInt32("0" + lblId.Text), txtNome.Text).Gravar();
if (x > 0)
{
lblMensagem.Text = "Gravado com sucesso !!";
lblId.Text = x + "";
}
else
{
lblMensagem.Text = "Erro ao gravar !!";
}
gvClientesOffLine.DataSource = new BsCliente().GetClientesOffLine();
gvClientesOffLine.DataBind();
}
