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