public List<datalog> getAllLogs() { var myEnt = new tinajaEntities2(); var logset = from datalog in myEnt.datalog orderby datalog.logtime select datalog; return logset.ToList<datalog>(); }
public List<datalog> getLogsByApikey(string apikey) { var myEnt = new tinajaEntities2(); var logset = from datalog in myEnt.datalog where datalog.apikey == apikey orderby datalog.logtime select datalog; return logset.ToList<datalog>(); }
public List<datalog> getLogsByApikeyHours(string apikey, int hours) { // get the negative value of the hours supplied int negHours = hours * -1; DateTime hoursBackTime = DateTime.UtcNow.AddHours(negHours); var myEnt = new tinajaEntities2(); var logset = from datalog in myEnt.datalog where (datalog.apikey == apikey) && (datalog.logtime >= hoursBackTime) orderby datalog.logtime select datalog; return logset.ToList<datalog>(); }
public string insertLog(string apikey, string logval) { tinajaEntities2 myEnt = new tinajaEntities2(); // datalog dl = new datalog { apikey = theKey, logvalue = theValue }; decimal logResult = 0; try { if (string.IsNullOrEmpty(apikey)) throw new Exception("Error: apikey cannot be blank."); if (!decimal.TryParse(logval, out logResult)) throw new Exception("Error: logvalue must be a decimal type with up to 4 decimal places. (e.g., -999999.9999 to 999999.9999)"); } catch (FormatException exFormat) { LogIt("Fail, validation FormatException - insertLog: " + exFormat.Message); return "Fail, validation FormatException - insertLog: " + exFormat.Message; } catch (Exception ex) { LogIt("Fail, validation Exception - insertLog: " + ex.Message); return "Fail, validation Exception - insertLog: " + ex.Message; } decimal logvalue = logResult; datalog myDL = new datalog(); myDL.apikey = apikey; myDL.logvalue = logvalue; myDL.logtime = DateTime.UtcNow; myDL.id = Guid.NewGuid(); try { myEnt.AddTodatalog(myDL); myEnt.SaveChanges(); } catch (FormatException exFormat) { LogIt("Fail, SaveChanges FormatException - insertLog: " + exFormat.Message); return "Fail, SaveChanges FormatException - insertLog: " + exFormat.Message; } catch (Exception ex) { LogIt("Fail, SaveChanges Exception - insertLog: " + ex.Message); return "Fail, SaveChanges Exception - insertLog: " + ex.Message; } return "Inserted"; }