Ejemplo n.º 1
0
 public long getItemID(string item_name)
 {
     //Check item name against current entries
     db.CreateCommand("Select item_id from items where item_name=" + SQLSpecific.QVal(item_name));
     db.SetConnection();
     return(db.ScalarIntx());
 }
Ejemplo n.º 2
0
        public bool Delete(String Id)
        {
            db.SetConnection();
            string s = "DELETE FROM collar_data_entry where item_name = " + SQLSpecific.QVal(Id);;

            return(db.Execute(s));
        }
Ejemplo n.º 3
0
        public int ScalarIntx()
        {
            int iData = -1;

            try
            {
                SQLSpecific.OpenConn(sql_con);
                var wht = sql_cmd.ExecuteScalar();
                if (wht == null)
                {
                    iData = 0;
                }
                else
                {
                    iData = Convert.ToInt32(wht.ToString());
                }
            } catch (Exception caught)
            {
                try
                {
                    DBMain.AltLog(LogLevels.Warning, 70105, "ScalarIntx  '" + caught.Message + "' " + sql_cmd.CommandText);
                    sql_con.Close();
                    return(-1);
                } catch { }
            }
            sql_con.Close();
            return(iData);
        }
Ejemplo n.º 4
0
        // assumes DB is there, but might need to build it before we get here
        public bool Execute(string sSQL)
        {
            bool needDb = false;

            try
            {
                sql_cmd             = sql_con.CreateCommand();
                sql_cmd.CommandText = sSQL;
                SQLSpecific.OpenConn(sql_con);
                try
                {
                    int i = sql_cmd.ExecuteNonQuery();
                }
                catch (System.Data.Common.DbException dbx)
                {
                    needDb = DBMain.DBExceptionHandler(dbx, sSQL);
                }
            }
            catch (Exception caught)
            {
                try
                {
                    DBMain.AltLog(LogLevels.Warning, 70101, "Execute '" + caught.Message + "' " + sSQL);
                    sql_con.Close();
                    return(false);
                }
                catch { }
            }
            if (sql_con != null)
            {
                sql_con.Close();
            }

            return(true);
        }
Ejemplo n.º 5
0
        public bool Update(ElementList collar, ElementList collar_det, ElementList k5)
        {
            bool success = false;

            db.SetConnection();
            ArrayList sqlList = new ArrayList();
            string    sSQL    = "UPDATE collar_rec SET ";

            sSQL += collar.ColumnsValues;
            sqlList.Add(sSQL);
            sqlList.Add(SQLSpecific.getLastID("collar_rec"));
            success = db.Execute(sqlList) == -1?false:true;

            sqlList = new ArrayList();
            // The collar is made of three records. One is in collar_rec, one in collar_detector, and one in collar_k5
            sSQL  = "UPDATE collar_detector_rec SET ";
            sSQL += collar_det.ColumnsValues;
            sqlList.Add(sSQL);
            sqlList.Add(SQLSpecific.getLastID("collar_detector_rec"));
            success = success || db.Execute(sqlList) == -1 ? false : true;

            sqlList = new ArrayList();
            // The collar is made of three records. One is in collar_rec, one in collar_detector, and one in collar_k5
            sSQL  = "UPDATE collar_k5_rec SET";
            sSQL += k5.ColumnsValues;
            sqlList.Add(sSQL);
            sqlList.Add(SQLSpecific.getLastID("collar_k5_rec"));
            success = success || db.Execute(sqlList) == -1 ? false : true;

            return(success);
        }
Ejemplo n.º 6
0
        public DataTable HVPlateauResultsForDet(string name, bool includeRuns)
        {
            db.SetConnection();
            string sSQL = "SELECT * FROM HVResult where detector_id=" + SQLSpecific.QVal(name);

            return(db.DT(sSQL));
        }
Ejemplo n.º 7
0
        //Return a DataTable based on SQL query
        public DataTable DT(string sSQL)
        {
            DataTable DT = new DataTable();

            try
            {
                SQLSpecific.OpenConn(sql_con);

                sql_cmd              = sql_con.CreateCommand();
                sql_cmd.CommandText  = sSQL;
                sql_da.SelectCommand = sql_cmd;
                //DS.Reset();
                int i = sql_da.Fill(DT); // hangs here during transfer operations
                //DT = DS.Tables[0];
            }
            catch (Exception caught)
            {
                try
                {
                    DBMain.AltLog(LogLevels.Warning, 70103, "DT '" + caught.Message + "' " + sSQL);
                }
                catch { }
            }
            //Return DataTable
            if (sql_con != null)
            {
                sql_con.Close();
            }
            return(DT);
        }
Ejemplo n.º 8
0
        public bool Delete(string Id)
        {
            db.SetConnection();
            string s = "DELETE FROM " + table + " where " + SQLSpecific.QValCompare("name", Id, true);

            return(db.Execute(s));
        }
Ejemplo n.º 9
0
        public DataTable DBProbe(string sSQL)
        {
            DataTable DT = new DataTable();

            try
            {
                SQLSpecific.OpenConn(sql_con);
                sql_cmd              = sql_con.CreateCommand();
                sql_cmd.CommandText  = sSQL;
                sql_da.SelectCommand = sql_cmd;
                int    i = sql_da.Fill(DT);
                string s = "Database:" + sql_con.Database + ", DataSource:" + sql_con.DataSource.ToString() + ", ServerVersion:" + sql_con.ServerVersion;
                DBDescStr = sql_da.GetType().FullName + "; " + s + " (" + sql_con.ConnectionString + ")";
            }
            catch (Exception caught)
            {
                DT         = null;
                DBErrorStr = caught.Message;
                DBMain.AltLog(LogLevels.Warning, 70193, "DBProbe '" + caught.Message + "'");
            }
            if (sql_con != null)
            {
                sql_con.Close();
            }
            return(DT);
        }
Ejemplo n.º 10
0
        public long Update(string Id, ElementList sParams)
        {
            db.SetConnection();

            DataTable dt = GetRows(Id); // must be unknown or at least one with same name because unique did not fire

            if (dt != null)
            {
                string wh   = " where " + "isotopics_id = " + SQLSpecific.QVal(Id);
                string sSQL = "UPDATE isotopics SET ";
                sSQL += sParams.ColumnEqValueList + wh;
                if (db.Execute(sSQL))
                {
                    return(PrimaryKey(Id));
                }
                else
                {
                    return(-1);
                }
            }
            else  // totally new
            {
                ArrayList sqlList = new ArrayList();
                string    sSQL    = "Insert into isotopics ";
                sSQL += sParams.ColumnsValues;
                sqlList.Add(sSQL);
                sqlList.Add(SQLSpecific.getLastID("isotopics"));
                return(db.ExecuteTransactionID(sqlList));
            }
        }
Ejemplo n.º 11
0
        public bool Delete(string Id)
        {
            db.SetConnection();
            string s = "DELETE FROM composite_isotopics_rec where isotopics_id = " + SQLSpecific.QVal(Id);

            return(db.Execute(s));
        }
Ejemplo n.º 12
0
        public string Scalar(string sSQL)
        {
            string sData = "";

            try
            {
                SQLSpecific.OpenConn(sql_con);
                sql_cmd             = sql_con.CreateCommand();
                sql_cmd.CommandText = sSQL;
                var o = sql_cmd.ExecuteScalar();
                if (o != null)
                {
                    sData = o.ToString();
                }
            }
            catch (System.Data.Common.DbException dbx)
            {
                DBMain.DBExceptionHandler(dbx, sSQL);
            }
            catch (Exception caught)
            {
                try
                {
                    DBMain.AltLog(LogLevels.Warning, 70104, "Scalar  '" + caught.Message + "' " + sSQL);
                    sql_con.Close();
                    return(null);
                }
                catch { }
            }
            sql_con.Close();
            return(sData);
        }
Ejemplo n.º 13
0
        public bool Delete(long DetectorId, string CounterType, ElementList sParams)
        {
            DataRow dr = null;

            string table = "CountingParams";

            if (CounterType.Equals("Multiplicity") || CounterType.Equals("Coincidence"))
            {
                table = "LMMultiplicity";
            }

            if (table.Equals("LMMultiplicity"))
            {
                dr = HasRow(DetectorId, CounterType, table, sParams, sParams[faidx].Value); // the FA parameter
            }
            else
            {
                dr = HasRow(DetectorId, CounterType, table, sParams);
            }
            if (dr != null)
            {
                string sSQL = "DELETE FROM " + table + " where counter_type=" + SQLSpecific.QVal(CounterType) + " AND detector_id=" + DetectorId.ToString();
                if (table.Equals("LMMultiplicity"))
                {
                    sSQL += " AND " + sParams[faidx].Name + "=" + sParams[faidx].Value;
                }
                return(db.Execute(sSQL));
            }
            else
            {
                return(true);
            }
        }
Ejemplo n.º 14
0
        public bool Update(string Name, string Description)
        {
            db.SetConnection();
            string sSQL    = "";
            bool   updated = false;

            if (Unique(Name, Description))
            {
                return(false);
            }

            DataTable dt = GetRows(Name);     // must be unknown or at least one with same name because unique did not fire

            if (dt != null)
            {
                DataRow[] dr = dt.Select("description = " + SQLSpecific.QVal(Description));
                if (dr.Length < 1)     // desc changed for an existing type
                {
                    sSQL = "UPDATE " + table + " SET "
                           + "[description] = " + SQLSpecific.QVal(Description)
                           + " WHERE " + SQLSpecific.QValCompare("name", Name, true);
                    updated = db.Execute(sSQL);
                }
            }
            else      // totally new type name
            {
                sSQL = "Insert into " + table + " ([name], [description]) "
                       + " Values (" + SQLSpecific.QVal(Name) + "," + SQLSpecific.QVal(Description) + ")";
                updated = db.Execute(sSQL);
            }
            return(updated);
        }
Ejemplo n.º 15
0
        public DataTable MeasurementsForInspection(string number)
        {
            db.SetConnection();
            string sSQL = "SELECT * FROM measurements where detector_id=" + SQLSpecific.QVal(number) + " ORDER BY DateTime DESC";

            return(db.DT(sSQL));
        }
Ejemplo n.º 16
0
        public bool UpdateFileName(string fileName, long Meas_ID)
        {
            db.SetConnection();
            string wh    = " where id = " + Meas_ID.ToString();
            string sSQL1 = "UPDATE measurements SET FileName = " + SQLSpecific.QVal(fileName) + wh;

            return(db.Execute(sSQL1));
        }
Ejemplo n.º 17
0
        public bool DefinitionExists(string DetectorName)
        {
            db.SetConnection();
            string    sSQL = "Select * FROM detector Where detector_name = " + SQLSpecific.QVal(DetectorName);
            DataTable dt   = db.DT(sSQL);

            return(dt.Rows.Count > 0);
        }
Ejemplo n.º 18
0
        public bool UpdateEndingComment(long mid, string ec)
        {
            db.SetConnection();
            string wh    = " where mid=" + mid.ToString();
            string sSQL1 = "UPDATE results_rec SET ending_comment=" + SQLSpecific.QVal(ec) + wh;

            return(db.Execute(sSQL1));
        }
Ejemplo n.º 19
0
        public bool UpdateNote(string notes, long Meas_ID)
        {
            db.SetConnection();
            string wh    = " where id = " + Meas_ID.ToString();
            string sSQL1 = "UPDATE measurements SET Notes = " + SQLSpecific.QVal(notes) + wh;

            return(db.Execute(sSQL1));
        }
Ejemplo n.º 20
0
        // return the stratum
        public DataTable Get(string stratumId)
        {
            db.SetConnection();
            string    sSQL = "Select * FROM stratum_ids where name=" + SQLSpecific.QVal(stratumId);
            DataTable dt   = db.DT(sSQL);

            return(dt);
        }
Ejemplo n.º 21
0
        public DataTable MeasurementsForDet(string name)
        {
            db.SetConnection();
            //Changed SQL to display measurements w/newest first hn 9.10.2015
            string sSQL = "SELECT * FROM measurements where detector_id=" + SQLSpecific.QVal(name) + " ORDER BY DateTime DESC";

            return(db.DT(sSQL));
        }
Ejemplo n.º 22
0
        public bool Update(long Id, string NewId)
        {
            db.SetConnection();
            string wh    = " where id = " + Id.ToString();
            string sSQL1 = "UPDATE isotopics SET isotopics_id=" + SQLSpecific.QVal(NewId);
            string sSQL  = sSQL1 + wh;

            return(db.Execute(sSQL));
        }
Ejemplo n.º 23
0
        // NEXT: figure out difference between use of meas_detector_id and detector_id
        public bool Has(DateTimeOffset measDatetime, string measDetId, string item_type)
        {
            db.SetConnection();
            string sSQL = "select * from acquire_parms_rec where meas_detector_id=" + SQLSpecific.Value(measDetId, true) +
                          " and item_type=" + SQLSpecific.Value(item_type, true);
            DataTable dt = db.DT(sSQL);

            return(dt.Rows.Count > 0);
        }
Ejemplo n.º 24
0
        public bool Update(string name, DateTime dt, ElementList sParams)
        {
            db.SetConnection();
            string sSQL1 = "UPDATE HVResult SET ";
            string wh    = " where detector_id=" + SQLSpecific.QVal(name) + " AND HVPDateTime=" + SQLSpecific.getDate(dt);
            string sSQL  = sSQL1 + sParams.ColumnEqValueList + wh;

            return(db.Execute(sSQL));
        }
Ejemplo n.º 25
0
        public bool Update(DateTimeOffset measDatetime, string measDetId, string itemId, ElementList sParams)
        {
            db.SetConnection();
            string wh    = " where item_type = " + SQLSpecific.Value(itemId, true) + " AND meas_detector_id = " + SQLSpecific.Value(measDetId, true);
            string sSQL1 = "UPDATE acquire_parms_rec SET ";
            string sSQL  = sSQL1 + sParams.ColumnEqValueList + wh;

            return(db.Execute(sSQL));
        }
Ejemplo n.º 26
0
        public bool Update(long Id, string NewId)
        {
            db.SetConnection();
            string wh    = " where id = " + Id.ToString();
            string sSQL1 = "UPDATE poison_rod_type_rec SET poison_rod_type=" + SQLSpecific.QVal(NewId);
            string sSQL  = sSQL1 + wh;

            return(db.Execute(sSQL));
        }
Ejemplo n.º 27
0
        public bool Update(long Id, string NewId)
        {
            db.SetConnection();
            string wh    = " where " + "item_id = " + Id.ToString();
            string sSQL1 = "UPDATE collar_data_entry SET item_name=" + SQLSpecific.QVal(NewId);
            string sSQL  = sSQL1 + wh;

            return(db.Execute(sSQL));
        }
Ejemplo n.º 28
0
        public bool Update(long Id, string NewId)
        {
            db.SetConnection();
            string wh    = " where glovebox_id = " + Id.ToString();
            string sSQL1 = "UPDATE holdup_config_rec SET glovebox_id=" + SQLSpecific.QVal(NewId);
            string sSQL  = sSQL1 + wh;

            return(db.Execute(sSQL));
        }
Ejemplo n.º 29
0
        private DataTable BasicSelect(string ItemName)
        {
            db.SetConnection();
            string sSQL = "SELECT item_name "
                          + " FROM collar_data_entry"
                          + " Where item_name = " + SQLSpecific.QVal(ItemName);
            DataTable dt = db.DT(sSQL);

            return(dt);
        }
Ejemplo n.º 30
0
        private DataTable BasicSelect(string IsoName)
        {
            db.SetConnection();
            string sSQL = "SELECT ci_isotopics_id "
                          + " FROM composite_isotopics_rec"
                          + " Where ci_isotopics_id = " + SQLSpecific.QVal(IsoName);
            DataTable dt = db.DT(sSQL);

            return(dt);
        }