public List <SqlParameter> SetParameters(ClassSupply datos)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@p1", SqlDbType = SqlDbType.NVarChar, Value = datos.Supply_ID
},
new SqlParameter()
{
ParameterName = "@p2", SqlDbType = SqlDbType.NVarChar, Value = datos.Supply_Name
},
new SqlParameter()
{
ParameterName = "@p3", SqlDbType = SqlDbType.NVarChar, Value = datos.Supply_Direcc
},
new SqlParameter()
{
ParameterName = "@p4", SqlDbType = SqlDbType.NVarChar, Value = datos.Supply_Phone
},
new SqlParameter()
{
ParameterName = "@p5", SqlDbType = SqlDbType.NVarChar, Value = datos.Supply_Email
},
new SqlParameter()
{
ParameterName = "@p6", SqlDbType = SqlDbType.Bit, Value = datos.Anulado
},
new SqlParameter()
{
ParameterName = "@p7", SqlDbType = SqlDbType.Bit, Value = datos.unid_master_1
},
new SqlParameter()
{
ParameterName = "@p8", SqlDbType = SqlDbType.Bit, Value = datos.unid_master_2
}
};
return(sp);
}
public void Update(ClassSupply datos)
{
CommandSqlGeneric(R.SQL.DATABASE.NAME,
R.SQL.QUERY_SQL.PROVIDERS.SQL_QUERY_UPDATE_PROVEEDORES, SetParameters(datos));
}
public void Add(ClassSupply datos)
{
//llamo al comando sql generico.
CommandSqlGeneric(R.SQL.DATABASE.NAME,
R.SQL.QUERY_SQL.PROVIDERS.SQL_QUERY_INSERT_PROVEEDORES, SetParameters(datos));
}
