public void insertarRazon(RazonesEliminacion cli)
{
this.configConex();
this.cnn._esSelect = true;
this.cnn._sentenciaSQL = "insert into " + this.cnn._nombreTabla + " values('" +
cli._Razon + "')";
this.cnn.conectar();
this.cnn.cerrarConexion();
}
public void modificarRazon(RazonesEliminacion cli)
{
this.configConex();
this.cnn._sentenciaSQL = "update " + cnn._nombreTabla +
" set Razon='" + cli._Razon + "'" +
" where Razon=" + cli._Razon;
this.cnn._esSelect = false;
this.cnn.conectar();
this.cnn.cerrarConexion();
}
public System.Collections.ArrayList getRazones()
{
System.Collections.ArrayList lista = new System.Collections.ArrayList();
this.configConex();
this.cnn._sentenciaSQL = "Select * from " + cnn._nombreTabla;
this.cnn._esSelect = true;
this.cnn.conectar();
foreach (System.Data.DataRow dr in
this.cnn._dbDataSet.Tables[this.cnn._nombreTabla].Rows)
{
RazonesEliminacion ca = new RazonesEliminacion();
ca._Razon = (string)dr["Razon"].ToString();
lista.Add(ca);
}
this.cnn.cerrarConexion();
return(lista);
}
public RazonesEliminacion buscarRazon(string idCliente)
{
RazonesEliminacion cli = new RazonesEliminacion();
this.configConex();
this.cnn._sentenciaSQL = "Select * from " + cnn._nombreTabla + " where Razon =' " + idCliente + "'";
this.cnn._esSelect = true;
this.cnn.conectar();
System.Data.DataTable dt = new System.Data.DataTable();
dt = cnn._dbDataSet.Tables[0];
try
{
cli._Razon = (string)dt.Rows[0][0].ToString();
}
catch (Exception e)
{
cli._Razon = "";
}
this.cnn.cerrarConexion();
return(cli);
}
