public long Create(long mid, ElementList resParams)
{
db.SetConnection();
resParams.Add(new Element("mid", mid));
ArrayList sqlList = new ArrayList();
string sSQL1 = "Insert into " + this.table + " ";
string sSQL = sSQL1 + resParams.ColumnsValues;
sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID(table));
return(db.ExecuteTransactionID(sqlList));
}
public long Create(long measid, ElementList sParams)
{
db.SetConnection();
ArrayList sqlList = new ArrayList();
string sSQL1 = "Insert into results_rec ";
sParams.Add(new Element("mid", measid));
string sSQL = sSQL1 + sParams.ColumnsValues; sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID("results_rec"));
return(db.ExecuteTransactionID(sqlList));
}
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));
}
// create a stratum and detector stratum association
public bool Create(string measDetId, ElementList sParams)
{
db.SetConnection();
Detectors dets = new Detectors(db);
long l = dets.PrimaryKey(measDetId);
string sSQL = InsertStratum(sParams);
ArrayList sqlList = new ArrayList();
sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID("stratum_ids"));
long newID = db.ExecuteTransactionID(sqlList);
string saSQL = "insert into stratum_id_detector VALUES(" + l.ToString() + "," + newID.ToString() + ")";
return(db.Execute(saSQL));
}
// i think this was meant to insert new types as well as new sets of SR params
public long Insert(string DetectorName, string DetectorAlias, Int32 DetectorType, string DetectorElectronics, string DetectorDesc)
{
long DetectorID = -1;
DataRow dr = HasRow(DetectorName, DetectorType, DetectorElectronics); // sets the connection
if (dr == null) // a new entry!
{
ArrayList sqlList = new ArrayList();
string sSQL = "insert into detectors (detector_name,detector_alias,detector_type_id,electronics_id,detector_type_freeform)";
string sv = " values (" + SQLSpecific.QVal(DetectorName) + "," + SQLSpecific.QVal(DetectorAlias) + "," + DetectorType.ToString() +
"," + SQLSpecific.QVal(DetectorElectronics) + "," + SQLSpecific.QVal(DetectorDesc) + ")";
sqlList.Add(sSQL + sv);
sqlList.Add(SQLSpecific.getLastID("detectors"));
DetectorID = db.ExecuteTransactionID(sqlList);
}
else // already there, just return the id
{
DetectorID = PrimaryKey(DetectorName);
}
return(DetectorID);
}
public long Update(string Name, ElementList sParams)
{
db.SetConnection();
DataTable dt = GetRows(Name); // must be unknown or at least one with same name because unique did not fire
if (dt != null)
{
string wh = " where item_name = " + SQLSpecific.QVal(Name);
string sSQL = "UPDATE collar_data_entry SET ";
sSQL += sParams.ColumnEqValueList + wh;
return(db.Execute(sSQL) ? 0 : -1);
}
else // totally new
{
ArrayList sqlList = new ArrayList();
string sSQL = "Insert into collar_data_entry ";
sSQL += sParams.ColumnsValues;
sqlList.Add(sSQL);
sqlList.Add(SQLSpecific.getLastID("collar_data_entry"));
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);
}
