public DataSet sp_UpdateDeleteRequestBondsAutomatic(requests_bonds_Automatic requests_bonds_Automatic)
{
DataSet ds = new DataSet();
List <SqlParameter> listparameters = new List <SqlParameter>();
Datos data = new Datos();
listparameters.Add(new SqlParameter()
{
ParameterName = "@IDBONO", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.Id_request_bond_automatic
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@pDelete_comments", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.Delete_comments
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@Employee_number", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.Employee_number
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@DeleteBy", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.UpdateDelete_By
});
try
{
ds = data.enviar("sp_UpdateDeleteRequestBondsAutomatic", listparameters, false, 4);
}
catch (Exception ex)
{
throw ex;
}
return(ds);
}
public DataSet sp_UpdateResquestBondsAutomatic(requests_bonds_Automatic requests_bonds_Automatic)
{
DataSet ds = new DataSet();
List <SqlParameter> listparameters = new List <SqlParameter>();
Datos data = new Datos();
listparameters.Add(new SqlParameter()
{
ParameterName = "@Id_request_bond_automatic", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.Id_request_bond_automatic
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@IdBonds", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.IdBonds
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@NameBonds", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.NameBonds
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@Id_Periodicity", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.Id_Periodicity
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@Occurrences", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.Occurrences
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@CC_Cargo", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.CC_Cargo
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@InitialDate", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.InitialDate
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@FinalDate", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.FinalDate
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@observations", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.observations
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@PendingOccurrences", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.PendingOccurrences
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@Amount", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.Amount
});
listparameters.Add(new SqlParameter()
{
ParameterName = "@Update_by", SqlDbType = SqlDbType.Int, Value = requests_bonds_Automatic.Update_by
});
try
{
ds = data.enviar("sp_UpdateResquestBondsAutomatic", listparameters, false, 4);
}
catch (Exception ex)
{
throw ex;
}
return(ds);
}
