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