public DataTable getCompositeIsotopics()
{
db.SetConnection();
string sSQL = "Select * FROM composite_isotopics_rec";
return(db.DT(sSQL));
}
public DataTable GetAll()
{
db.SetConnection();
string sSQL = "Select * from LMINCCAppContext";
DataTable dt = db.DT(sSQL);
return(dt);
}
public long Create(ElementList sParams)
{
db.SetConnection();
ArrayList sqlList = new ArrayList();
string sSQL = "Insert into cm_pu_ratio_rec ";
sSQL += sParams.ColumnsValues;
sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID("cm_pu_ratio_rec"));
return(db.ExecuteTransactionID(sqlList));
}
public long Create(ElementList sParams) // all of them and all them's's columns
{
db.SetConnection();
ArrayList sqlList = new ArrayList();
string sSQL = "Insert into test_parms_rec ";
sSQL += sParams.ColumnsValues;
sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID("test_parms_rec"));
return(db.ExecuteTransactionID(sqlList));
}
public long Create(long mid, ElementList resParams)
{
db.SetConnection();
resParams.Add(new Element("mid", mid));
ArrayList sqlList = new ArrayList();
string sSQL1 = "Insert into " + table + "_m" + " ";
string sSQL = sSQL1 + resParams.ColumnsValues;
sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID(table + "_m"));
return(db.ExecuteTransactionID(sqlList));
}
public DataTable getItems()
{
db.SetConnection();
string sSQL = "Select * FROM collar_data_entry";
return(db.DT(sSQL));
}
public DataTable getItems()
{
db.SetConnection();
string sSQL = "Select * FROM items";
return(db.DT(sSQL));
}
public DataTable AllResults(string name = null)
{
if (!String.IsNullOrEmpty(name))
{
return(ResultsForDet(name));
}
else
{
db.SetConnection();
string sSQL = "SELECT * FROM results_rec";
return(db.DT(sSQL));
}
}
public DataTable getIsotopics() // all of them and all them's's columns
{
db.SetConnection();
string sSQL = "Select * FROM isotopics";
return(db.DT(sSQL));
}
public DataTable getItems()
{
db.SetConnection();
string sSQL = "Select * FROM items";
//DbCommand dbcmd = DBMain.DBCmd;
//dbcmd.Connection = db.sql_con;
//DbParameter p = dbcmd.CreateParameter();
//p.ParameterName = "items";
//p.Value = "items";
//dbcmd.CommandType = CommandType.Text;
//dbcmd.Parameters.Add(p);
//dbcmd.CommandText = "Select * FROM";
//DbDataReader dbr = dbcmd.ExecuteReader();
return(db.DT(sSQL));
}
public DataTable Get(string detname, DateTime date)
{
db.SetConnection();
Measurements ms = new Measurements(db);
long l = ms.PrimaryKey(detname, date);
string sSQL = "Select * FROM " + table + " where mid = " + l.ToString();
DataTable dt = db.DT(sSQL);
return(dt);
}
public long CreateMethod(long resid, long mid, ElementList resParams)
{
db.SetConnection();
resParams.Add(new Element("rid", resid));
resParams.Add(new Element("mid", mid));
ArrayList sqlList = new ArrayList();
string sSQL1 = "Insert into " + MethodTableName(resParams.OptTable) + " ";
string sSQL = sSQL1 + resParams.ColumnsValues;
sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID(MethodTableName(resParams.OptTable)));
return(db.ExecuteTransactionID(sqlList));
}
public long Create(ElementList collar, ElementList collar_det, ElementList k5)
{
long success = 0;
db.SetConnection();
ArrayList sqlList = new ArrayList();
// The collar is made of three records. One is in collar_rec, one in collar_detector, and one in collar_k5
string sSQL = "Insert into collar_rec ";
sSQL += collar.ColumnsValues;
sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID("collar_rec"));
success = db.ExecuteTransactionID(sqlList);
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 = "Insert into collar_detector_rec ";
sSQL += collar_det.ColumnsValues;
sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID("collar_detector_rec"));
if (success != -1) //Catch failure at each sql statement
{
success = db.ExecuteTransactionID(sqlList);
}
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 = "Insert into collar_k5_rec ";
sSQL += k5.ColumnsValues;
sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID("collar_k5_rec"));
if (success != -1) //Catch failure at each sql statement
{
success = db.ExecuteTransactionID(sqlList);
}
return(success);
}
// return the stratums only
public DataTable Get()
{
db.SetConnection();
Detectors dets = new Detectors(db);
string sSQL = "Select * FROM stratum_ids";
DataTable dt = db.DT(sSQL);
return(dt);
}
public DataTable AllMeasurements(string name = null)
{
if (!string.IsNullOrEmpty(name))
{
return(MeasurementsForDet(name));
}
else
{
db.SetConnection();
string sSQL = "SELECT * FROM measurements";
return(db.DT(sSQL));
}
}
public DataTable AllHVPlateauResults(string name = null)
{
if (!String.IsNullOrEmpty(name))
{
return(AllHVPlateauResults(name));
}
else
{
db.SetConnection();
string sSQL = "SELECT * FROM HVResult";
return(db.DT(sSQL));
}
}