public static void addToDataBase(ArrayList<GPSReadingXMLParser.tempGPSReading> list2)
{
var _context = new Context();
//remove all old readings
foreach (GPSReading gpsri in _context.GPSReadings.ToList())
{
_context.GPSReadings.Remove(gpsri);
}
_context.SaveChanges();
foreach (GPSReadingXMLParser.tempGPSReading reading in list2)
{
//add the updated job
var gpsreading = new GPSReading
{
Vin = reading.Vin,
Address = reading.Address,
Lat = reading.Lat,
Lng = reading.Lng,
Speed = reading.Speed,
RouteNumber = reading.RouteNumber,
Time = reading.Time
};
//Trace.WriteLine("gps saving to address " + reading.Address);
_context.GPSReadings.Add(gpsreading);
}
_context.SaveChanges();
}
public String SetIgnore(string ignorelist)
{
Trace.WriteLine("STARTING IGNORE PROCEEDURE");
Trace.WriteLine(ignorelist + " coming in from client");
var _context = new Context();
//List<SMJob> num = _context.SMJobs.ToList();
// Trace.WriteLine("1 from ignore there are "+ num.Count+" jobs in the db");
String[] a = ignorelist.Split(';');
Trace.WriteLine(a.Count());
foreach (string s in a)
{
String[] b = s.Split(':');
SMJob job = _context.getSMJobByName(b[0]);
if (job != null && b[0] != "")
{
if (b[1].Equals("1"))
{
Trace.WriteLine("IGNORESERVICE: turning on ignore for " + job.Name);
job.alertsAllowed = false;
}
else
{
Trace.WriteLine("IGNORESERVICE: turning off ignore for " + job.Name);
job.alertsAllowed = true;
}
//_context.SMJobs.Add(job);
_context.SaveChanges();
}
}
Trace.WriteLine("ENDING IGNORE PROCEEDURE");
return "OK";
}
public static void Start()
{
var _context = new Context();
foreach (Employee e in _context.Employees.ToList())
{
_context.Employees.Remove(e);
}
Employee e1 = new Employee();
e1.Name = "James";
e1.Password = "******";
e1.Organization = "work";
_context.Employees.Add(e1);
Employee e2 = new Employee();
e2.Name = "Phil";
e2.Password = "******";
e2.Organization = "work";
_context.Employees.Add(e2);
Employee e3 = new Employee();
e3.Name = "Michelle ";
e3.Password = "******";
e3.Organization = "work";
_context.Employees.Add(e3);
Employee e4 = new Employee();
e4.Name = "Keith";
e4.Password = "******";
e4.Organization = "work";
_context.Employees.Add(e4);
_context.SaveChanges();
foreach (Employee e in _context.Employees.ToList())
{
Trace.WriteLine(e.Name);
}
}
public JsonResult DeleteArticle(ArticleViewModel article)
{
Thread.Sleep(300);
string r = string.Format("removed '{0}' from article", article.name);
using (var context = new Context())
{
foreach (var at in context.ArticleTags.Where(x => x.Article.Id == article.id ))
{
context.ArticleTags.Remove(at);
}
context.SaveChanges();
context.Articles.Where(x => x.Id == article.id).ToList().ForEach(y => context.Articles.Remove(y));
context.SaveChanges();
}
return Json(this.GetArticlesFromDb(), JsonRequestBehavior.AllowGet); //Content(r);
}
private void RemoveDistricts()
{
using (var context = new Context())
{
foreach (var district in context.Features)
{
context.Features.Remove(district);
}
context.SaveChanges();
}
}
public void Ignore(string jobname, bool ignore)
{
var _context = new Context();
SMJob job = _context.getSMJobByName(jobname);
job.alertsAllowed = !ignore;
_context.SaveChanges();
List<SMJob> smjobs = _context.SMJobs.ToList();
string json2 = JsonConvert.SerializeObject(smjobs);
Clients.update(json2);
}
public void Add()
{
Context context = new Context();
for (int i = 0; i < 5; i++)
{
Customer c = new Customer();
c.Id = i;
c.Name = "Rehan # " + i;
context.Customers.Add(c);
}
context.SaveChanges();
}
public void InsertMunicipailitiesFromShapeFile()
{
RemoveDistricts();
var shapes = new DagiShapeFileReader().Read("..\\..\\..\\data\\KOMMUNE", "KOMNAVN");
using (var context = new Context())
{
foreach (var shape in shapes)
{
context.Features.Add(new Feature { Name = shape.Key, Geography = shape.Value });
}
context.SaveChanges();
}
}
static void Main(string[] args)
{
while (true)
{
using (var context = new Context())
{
var now = DateTime.UtcNow;
if (context.Batches.Any(x =>
x.FetchedAt.Year == now.Year && x.FetchedAt.Month == now.Month))
{
Thread.Sleep(24 * 60 * 60 * 1000);
continue;
}
}
try
{
var batch = new Batch
{
FetchedAt = DateTime.UtcNow,
};
var members = VLGroupScraper.GetMembers();
batch.Members = members.ToList();
using (var context = new Context())
{
context.Batches.Add(batch);
context.SaveChanges();
}
}
catch (Exception exception)
{
using (var smtpClient = new SmtpClient())
{
var emailAddress = ConfigurationManager.AppSettings.Get("logemailaddress");
smtpClient.Send(new MailMessage(
emailAddress, emailAddress, "Problem scraping", exception.ToString()));
}
}
}
}
private static void GetPatentFromPage(IE browser, int year)
{
var inventor = browser.TableCell(x =>
x.PreviousSibling != null && x.PreviousSibling.Text == "Opfinder").Text;
var patentIdAndDate = browser.TableCell(x =>
x.PreviousSibling != null && x.PreviousSibling.Text == "Patent/reg.nr. og dato").Text;
var patentId = patentIdAndDate.Split(',').First();
using (var context = new Context())
{
var patent = new Patent
{
Html = browser.Html,
InventorField = inventor,
PatentId = patentId,
Year = year,
};
context.Patents.Add(patent);
context.SaveChanges();
}
}
public static void Execute()
{
var _context = new Context();
var xp = new XMLParser();
xp.execute();
var readinglist = _context.GPSReadings.ToList();
var smjoblist = _context.SMJobs.ToList();
var now = string.Format("{0:HH:mm:ss tt}", DateTime.Now);
var trucklocation = readinglist.First();
var mh = new MapHelper();
var n = string.Format("{0:HH:mm:ss tt}", DateTime.Now);
var t = n.Split(':');
var nowtime = (Convert.ToInt32(t[0]) * 60) + Convert.ToInt32(t[1]);
foreach (SMJob job in smjoblist)
{
var jobminutes = (Convert.ToInt32(job.Hour) * 60) + Convert.ToInt32(job.Minute);
var drivetime = mh.getDriveTimeinMinutes(job.Lat, job.Lng, trucklocation.Lat, trucklocation.Lng);
if (drivetime < 2)
{
var status = "";
job.isAtLocation = true;
job.hasArrived = true;
status = job.willBeLate ? "late" : "ontime";
var el = new SMEventLog
{
Type = status,
Address = job.Address,
RouteNumber = job.RouteNumber,
Time = now,
Techs = job.Techs,
Company = job.Company,
TimeDifference = jobminutes - nowtime
};
_context.SaveChanges();
}
else
{
if (job.isAtLocation)
{
job.isAtLocation = false;
job.completed = true;
}
}
if (!job.completed && !job.isAtLocation)
{
if (drivetime > (jobminutes - nowtime))
{
job.willBeLate = true;
// send sms here
if (!job.alertSent)
{
//SMSHelper.sendMessage(job);
job.alertSent = true;
job.alertSentTime = now;
}
}
}
// _context.SMJobs.Add(job);
_context.SaveChanges();
}
Trace.WriteLine("UPDATING CLIENT");
Notifier.Update();
}
public JsonResult SaveTag(TagViewModel tag)
{
Thread.Sleep(300);
using (var context = new Context())
{
var article = context.Articles.Find(articleId);
var dbTag = context.Tags.Where(x => x.Name == tag.name).FirstOrDefault();
if (dbTag == null)
{
dbTag = context.Tags.Add(new Tag { Name = tag.name });
}
if (!context.ArticleTags.Any(x => x.Article.Id == articleId && x.Tag.Name == tag.name))
{
context.ArticleTags.Add(new ArticleTag { Article = article, Tag = dbTag });
}
context.SaveChanges();
}
return Json(this.GetTagsFromDb(), JsonRequestBehavior.AllowGet); //Content(r);
}
public JsonResult RemoveTag(TagViewModel tag)
{
Thread.Sleep(300);
string r = string.Format("removed '{0}' from article", tag.name);
using (var context = new Context())
{
foreach (var at in context.ArticleTags.Where(x => x.Article.Id == articleId && x.Tag.Name == tag.name))
{
context.ArticleTags.Remove(at);
}
context.SaveChanges();
if (context.ArticleTags.Where(x => x.Tag.Name == tag.name).Count() == 0)
{
context.Tags.Where(x => x.Name == tag.name).ToList().ForEach(y => context.Tags.Remove(y));
r = string.Format("removed tag '{0}' from article and tag '{0}'", tag.name);
}
context.SaveChanges();
}
return Json(this.GetTagsFromDb(), JsonRequestBehavior.AllowGet); //Content(r);
}
public void Create(Customer c)
{
Context context = new Context();
context.Customers.Add(c);
context.SaveChanges();
}
public static void addToDataBase(ArrayList<SMJobXMLParser.tempJob> list)
{
var _context = new Context();
var ignoreList = new List<String>();
var smssentlist = new Dictionary<String, String>();
//remove old jobs
foreach (SMJob smjobi in _context.SMJobs.ToList())
{
if (!smjobi.alertsAllowed)
{
ignoreList.Add(smjobi.Name);
}
if (smjobi.alertSent)
{
smssentlist.Add(smjobi.Name, smjobi.alertSentTime);
}
_context.SMJobs.Remove(smjobi);
}
_context.SaveChanges();
bool b = true;
bool c = false;
foreach (SMJobXMLParser.tempJob job in list)
{
if (ignoreList.Contains(job.Name))
{
b = false;
}
if (smssentlist.ContainsKey(job.Name))
{
c = true;
}
//add the updated job
var smjob = new SMJob
{
Name = job.Name,
Time = job.Time,
Techs = job.Techs,
Address = job.Address,
Hour = job.Hour,
Minute = job.Minute,
AmPm = job.AmPm,
Lat = job.Lat,
Lng = job.Lng,
hasArrived = false,
isAtLocation = false,
alertsAllowed = b,
alertSent = c,
RouteNumber = job.RouteNumber,
Company = job.Company
};
//sTrace.WriteLine("adding job with name " + smjob.Name);
_context.SMJobs.Add(smjob);
}
_context.SaveChanges();
}