public static long WriteSettingsToDb(SySal.OperaDb.OperaDbConnection conn, string desc, string exe, int driverlevel, int marks, string settings) { SySal.OperaDb.OperaDbCredentials cred = SySal.OperaDb.OperaDbCredentials.CreateFromRecord(); long authorid = SySal.OperaDb.Convert.ToInt64(new SySal.OperaDb.OperaDbCommand("SELECT ID FROM VW_USERS WHERE UPPER(USERNAME) = UPPER('" + cred.OPERAUserName + "') ", conn, null).ExecuteScalar()); SySal.OperaDb.OperaDbCommand cmd = new SySal.OperaDb.OperaDbCommand("CALL PC_ADD_PROGRAMSETTINGS(:description, :exe, :authorid, :driverlevel, :marks, :settings, :newid)", conn); cmd.Parameters.Add("description", SySal.OperaDb.OperaDbType.String, System.Data.ParameterDirection.Input).Value = desc; cmd.Parameters.Add("exe", SySal.OperaDb.OperaDbType.String, System.Data.ParameterDirection.Input).Value = exe; cmd.Parameters.Add("authorid", SySal.OperaDb.OperaDbType.Long, System.Data.ParameterDirection.Input).Value = authorid; cmd.Parameters.Add("driverlevel", SySal.OperaDb.OperaDbType.Int, System.Data.ParameterDirection.Input).Value = driverlevel; cmd.Parameters.Add("marks", SySal.OperaDb.OperaDbType.Int, System.Data.ParameterDirection.Input).Value = marks; cmd.Parameters.Add("settings", SySal.OperaDb.OperaDbType.CLOB, System.Data.ParameterDirection.Input).Value = settings; cmd.Parameters.Add("newid", SySal.OperaDb.OperaDbType.Long, System.Data.ParameterDirection.Output); try { cmd.ExecuteNonQuery(); return((long)cmd.Parameters["newid"].Value); // return 1; } catch (Exception ex) { MessageBox.Show(ex.Message); return(0); } }
public static string LookupItem(long id, SySal.OperaDb.OperaDbConnection conn) { SySal.OperaDb.OperaDbCommand cmd = new OperaDbCommand("SELECT DESCRIPTION FROM TB_PROGRAMSETTINGS WHERE ID=" + id, conn); object o = cmd.ExecuteScalar(); string name; if (o == null) { name = id.ToString() + " <description not found>"; } else { name = id.ToString() + " (" + o.ToString() + ")"; } return(name); }