public static void UpdateHttpRequest(HttpRequestCondition cond)
{
if (cond != null)
{
DLLocalDatabase.HttpRequestConditions.UpdateHttpRequest(cond);
}
}
/// <summary>
/// Get the HttpRequest conditions for a HttpRequest
/// </summary>
/// <param name="requestId">The id of the parent HttpRequest</param>
/// <returns></returns>
public static HttpRequestCondition GetCondition(long id)
{
HttpRequestCondition condition = new HttpRequestCondition();
using (RemindMeDbEntities db = new RemindMeDbEntities())
{
condition = (from g in db.HttpRequestCondition select g).Where(r => r.Id == id).SingleOrDefault();
db.Dispose();
}
return(condition);
}
/// <summary>
/// Insert a new Request condition into the db
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public static long InsertCondition(HttpRequestCondition condition)
{
if (condition != null)
{
condition.Property = condition.Property.Trim(); //remove whitespace
return(DLLocalDatabase.HttpRequestConditions.InsertCondition(condition));
}
else
{
return(-1);
}
}
public static void UpdateHttpRequest(HttpRequestCondition cond)
{
using (RemindMeDbEntities db = new RemindMeDbEntities())
{
var count = db.HttpRequestCondition.Where(o => o.Id >= 0).Count();
if (count > 0)
{
db.HttpRequestCondition.Attach(cond);
var entry = db.Entry(cond);
entry.State = System.Data.Entity.EntityState.Modified; //Mark it for update
db.SaveChanges(); //push to database
db.Dispose();
}
else
{//The settings table is still empty
db.HttpRequestCondition.Add(cond);
db.SaveChanges();
db.Dispose();
}
}
}
/// <summary>
/// Insert a new Request condition into the db
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public static long InsertCondition(HttpRequestCondition condition)
{
using (RemindMeDbEntities db = new RemindMeDbEntities())
{
/*if (db.HttpRequestCondition.Where(r => r.Id == condition.Id).Count() > 0)
* {
* throw new ArgumentException("Could not insert HttpRequestCondition with ID " + condition.Id + " because it already exists");
* }
* else*/
{
if (db.HttpRequestCondition.Count() > 0)
{
condition.Id = db.HttpRequests.Max(i => i.Id) + 1;
}
db.HttpRequestCondition.Add(condition);
db.SaveChanges();
db.Dispose();
}
}
return(condition.Id);
}
public HttpCondition(HttpRequestCondition req, JObject response)
{
this.req = req;
this.response = response;
switch (req.DataType)
{
case "string":
apiValue = response.SelectTokens(req.Property).Select(t => t.Value <string>()).ToList()[0];
compareValue = req.Value;
break;
case "double":
apiValue = response.SelectTokens(req.Property).Select(t => t.Value <double>()).ToList()[0];
compareValue = double.Parse(req.Value.Replace(".", ","));
break;
case "bool":
apiValue = response.SelectTokens(req.Property).Select(t => t.Value <bool>()).ToList()[0];
compareValue = bool.Parse(req.Operator);
break;
}
}
