public void actualizar(ReciclaPeru.EN.Entidad oEntidad, string stabla)
{
SqlCommand cmd = null;
SqlParameter param;
try
{
cmd = con.CreateCommand();
cmd.CommandText = "usp" + stabla + "Actualizar";
cmd.CommandType = CommandType.StoredProcedure;
foreach (string var in oEntidad.vars)
{
param = cmd.CreateParameter();
param.ParameterName = "@" + var;
param.SqlDbType = tipo(var[0]);
param.Value = oEntidad[var];
cmd.Parameters.Add(param);
}
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
catch (Exception)
{
cmd.Dispose();
throw;
}
}
public System.Collections.Generic.List<ReciclaPeru.EN.Entidad> listar(ReciclaPeru.EN.Entidad oEntidad, string stabla)
{
SqlCommand cmd = null;
SqlParameter param;
SqlDataAdapter da;
DataTable dt;
try
{
System.Collections.Generic.List<ReciclaPeru.EN.Entidad> oListaEntidad;
cmd = con.CreateCommand();
cmd.CommandText = "usp" + stabla + "Listar";
cmd.CommandType = CommandType.StoredProcedure;
if (oEntidad != null)
foreach (string var in oEntidad.vars)
{
param = cmd.CreateParameter();
param.ParameterName = "@" + var;
param.SqlDbType = tipo(var[0]);
param.Value = oEntidad[var];
cmd.Parameters.Add(param);
}
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
oListaEntidad = new System.Collections.Generic.List<ReciclaPeru.EN.Entidad>();
for (int i = 0; i < dt.Rows.Count; ++i)
{
oEntidad = new ReciclaPeru.EN.Entidad();
for (int j = 0; j < dt.Columns.Count; ++j)
oEntidad[dt.Columns[j].ToString()] = dt.Rows[i][j];
oListaEntidad.Add(oEntidad);
}
cmd.Dispose();
return oListaEntidad;
}
catch (Exception)
{
cmd.Dispose();
throw;
}
}
public int insertar(ReciclaPeru.EN.Entidad oEntidad, string stabla)
{
SqlCommand cmd = null;
SqlParameter param;
try
{
cmd = con.CreateCommand();
cmd.CommandText = "usp" + stabla + "Insertar";
cmd.CommandType = CommandType.StoredProcedure;
foreach (string var in oEntidad.vars)
{
param = cmd.CreateParameter();
param.ParameterName = "@" + var;
param.SqlDbType = tipo(var[0]);
param.Value = oEntidad[var];
cmd.Parameters.Add(param);
}
param = cmd.CreateParameter();
param.SqlDbType = SqlDbType.Int;
param.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(param);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
return Convert.ToInt32(param.Value);
}
catch (Exception)
{
cmd.Dispose();
throw;
}
}
