private List <SqlParameter> SetParametersAutorizeOc(AutorizeDocOc item)
{
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@p1", SqlDbType = SqlDbType.NVarChar, Value = item.Oc
},
new SqlParameter()
{
ParameterName = "@p2", SqlDbType = SqlDbType.DateTime, Value = item.Fecha
},
new SqlParameter()
{
ParameterName = "@p3", SqlDbType = SqlDbType.NVarChar, Value = item.ToAutorize
},
new SqlParameter()
{
ParameterName = "@p4", SqlDbType = SqlDbType.Text, Value = item.Notes
},
new SqlParameter()
{
ParameterName = "@p5", SqlDbType = SqlDbType.Bit, Value = item.CloseDocument
},
};
return(sp);
}
public Boolean SaveAutorizeOc(AutorizeDocOc doc)
{
try
{
CommandSqlGeneric(R.DATABASES.RITRAMA,
R.SQL.QUERY_SQL.PRODUCCION.SQL_UPDATE_AUTHORIZE_OC,
SetParametersAutorizeOc(doc), false,
R.ERROR_MESSAGES.PRODUCCION.MESSAGE_ERROR_AUTHORIZE_OC);
return(true);
}
catch (Exception)
{
return(false);
}
}
