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