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(); }