public static void DeleteWork(InfoId toDel) { using (var dbContext = new QuickToDosEntities()) { bool go = true; List <Break> results = dbContext.Breaks.Where(x => x.ToDoId == toDel.Id).ToList(); if (results != null) { foreach (Break result in results) { dbContext.Breaks.Remove(result); } } toDo job = dbContext.toDos.Find(toDel.Id); if (job == null) { go = false; } if (go) { try { job.DontShow = true; //dbContext.toDos.Remove(job); dbContext.SaveChanges(); } catch (Exception e) { } } } }
public static void DeleteImg(InfoId toDel) { using (var dbContext = new QuickToDosEntities()) { File anImage = dbContext.Files.Find(toDel.Id); if (anImage != null) { string filename = anImage.Filename; string[] items = filename.Split('/'); filename = items[items.Length - 1]; string concern = anImage.Concern; string uploadPath = ConfigurationManager.AppSettings["RootFolder"] + @"\documents\" + concern + @"\"; string UploadPathOldies = uploadPath + @"oldies\"; string sourceFile = System.IO.Path.Combine(uploadPath, filename); string destFile = System.IO.Path.Combine(UploadPathOldies, filename); if (!System.IO.Directory.Exists(UploadPathOldies)) { System.IO.Directory.CreateDirectory(UploadPathOldies); } System.IO.File.Move(sourceFile, destFile); dbContext.Files.Remove(anImage); dbContext.SaveChanges(); } } }
public static PauseInfo DoTogglePause(int jobId) { PauseInfo pauseInfo = new PauseInfo(); pauseInfo.Duration = 0; pauseInfo.Paused = false; using (var dbContext = new QuickToDosEntities()) { List <Break> timeChunks = dbContext.Breaks.Where(x => x.ToDoId == jobId).ToList(); if (timeChunks != null) { timeChunks = timeChunks.OrderByDescending(x => x.Id).ToList(); if (timeChunks[0].End == null) { int Id = timeChunks[0].Id; Break chunk = dbContext.Breaks.Find(Id); if (chunk != null) { chunk.End = DateTime.Now; dbContext.SaveChanges(); pauseInfo.Paused = true; } } else { var chunk = new Break { Start = DateTime.Now, ToDoId = jobId }; dbContext.Breaks.Add(chunk); dbContext.SaveChanges(); } } } pauseInfo.Duration = CalcMinutes(jobId); return(pauseInfo); }
public static string getForecast() { //6942553 Paris 43.200001 -80.383331 CA //3038354 Aix-en-Provence 43.528301 5.449730 FR //6444007 Maisons-Laffitte 48.950001 2.15 FR string output; string data = ""; string paris_id = "6942553"; string key = "0b2c2c31d711fe4ae9048808d3722eeb"; string sURL = "http://api.openweathermap.org/data/2.5/forecast?id=" + paris_id + "&APPID=" + key + "&units=metric"; DateTime someTimeAgo = System.DateTime.Now.AddHours(-2);; using (var dbContext = new QuickToDosEntities()) { List <API> results = dbContext.APIs.Where(x => x.creation > someTimeAgo).ToList(); if (results != null) { data = results[0].content; } else { WebRequest wrGETURL = WebRequest.Create(sURL); Stream objStream = wrGETURL.GetResponse().GetResponseStream(); StreamReader objReader = new StreamReader(objStream); string sLine = ""; int i = 0; while (sLine != null) { i++; output = objReader.ReadLine(); if (sLine != null) { output += sLine + Environment.NewLine; } } var anApi = new API { concern = "weather", content = sLine, creation = DateTime.Now }; data = sLine; dbContext.APIs.Add(anApi); dbContext.SaveChanges(); } } return(data); }
public static void DeleteKnowledge(InfoId toDel) { using (var dbContext = new QuickToDosEntities()) { Knowledge aKnowledge = dbContext.Knowledges.Find(toDel.Id); if (aKnowledge == null) { throw new Exception("Echec mise a jour"); } dbContext.Knowledges.Remove(aKnowledge); dbContext.SaveChanges(); } }
public static int ToggleDone(InfoDone info) { if (info == null) { throw new Exception("Echec mise a jour (1)"); } PauseInfo pauseInfo = new PauseInfo(); int nrMinutes = 0; var jobId = info.Id; using (var dbContext = new QuickToDosEntities()) { toDo job = dbContext.toDos.Find(jobId); if (job == null) { throw new Exception("Echec mise a jour (2)"); } if ((bool)info.Done) // We close { job.End = DateTime.Now; if (job.Begin == null) { job.Begin = job.End; } else { pauseInfo = DoTogglePause(jobId); nrMinutes = pauseInfo.Duration; if (!pauseInfo.Paused) { pauseInfo = DoTogglePause(jobId); nrMinutes = pauseInfo.Duration; } } } else // We open again { job.End = null; } job.Done = info.Done; job.Duration = nrMinutes; dbContext.SaveChanges(); } return(nrMinutes); }
public static int AddKnowledge(KnowAdd Know) { if (Know.Id == -1) { using (var dbContext = new QuickToDosEntities()) { var aKnowledge = new Knowledge { Subject = Know.Subject, Body = Know.Body, Creation = DateTime.Now }; dbContext.Knowledges.Add(aKnowledge); dbContext.SaveChanges(); Know.Id = aKnowledge.Id; } } else { using (var dbContext = new QuickToDosEntities()) { Knowledge aKnowledge = dbContext.Knowledges.Find(Know.Id); if (aKnowledge == null) { throw new Exception("Echec mise a jour"); } aKnowledge.Subject = Know.Subject; aKnowledge.Body = Know.Body; aKnowledge.Modification = DateTime.Now; dbContext.SaveChanges(); } } return(Know.Id); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; System.Diagnostics.Debugger.Launch(); try { if (context.Request.Files.Count > 0) { HttpPostedFile file = context.Request.Files[0]; string fileName = file.FileName; if (!string.IsNullOrEmpty(fileName)) { string Idstr = context.Request.Params["Id"]; int Id = int.Parse(Idstr); string Concern = context.Request.Params["Concern"]; string Description = context.Request.Params["Description"]; if (Description == null) { Description = ""; } int fileId = 0; // string data64 = context.Request.Params["File"]; using (var dbContext = new QuickToDosEntities()) { var aFile = new File { Filename = "temp", Concern = Concern, ExtId = Id, Description = Description }; dbContext.Files.Add(aFile); dbContext.SaveChanges(); fileId = aFile.Id; if (Concern == "people") { if (fileName == "blob") { string type = context.Request.Params["Type"]; if (type == "jpeg") { fileName = "image.jpg"; } else { fileName = "image." + type; } } aFile.Filename = string.Format("/images/{0}_{1}_{2}", Idstr, fileId, fileName); dbContext.SaveChanges(); Person aPerson = dbContext.People.Find(Id); if (aPerson != null) { aPerson.Photo = aFile.Filename; dbContext.SaveChanges(); } } else { aFile.Filename = string.Format("/documents/{0}/{1}_{2}_{3}", Concern, Idstr, fileId, fileName); dbContext.SaveChanges(); } } string documentsPath = ""; if (Concern == "people") { documentsPath = context.Server.MapPath("") + @"\images\"; } else { documentsPath = context.Server.MapPath("") + @"\documents\" + Concern + "\\"; } System.IO.Directory.CreateDirectory(documentsPath); string fileToSave = documentsPath + string.Format("{0}_{1}_{2}", Idstr, fileId, fileName); file.SaveAs(fileToSave); if (Concern == "people") { const int maxHeight = 450; Image original = Image.FromFile(fileToSave); int originalWidth = original.Width; int originalHeight = original.Height; if (originalHeight > maxHeight) { double factor; factor = (double)maxHeight / originalHeight; int newHeight = maxHeight; int newWidth = (int)(originalWidth * factor); Image thumbnail = original.GetThumbnailImage(newWidth, newHeight, null, IntPtr.Zero); original.Dispose(); thumbnail.Save(fileToSave); } } } } } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public static int AddWork(Data toDo) { // transaction à ajouter stp int toDoId; DateTime?toDoStart; DateTime?toDoEnd; toDoId = toDo.Id; bool NoExternalNote = toDo.NoExternalNote; if (toDo.Id == -1) { using (var dbContext = new QuickToDosEntities()) { try { var aJob = new toDo { Description = toDo.Description, Begin = toDo.Begin, End = toDo.End, Duration = toDo.Duration, Reference = toDo.Reference, Done = false, Planned = toDo.Planned, Notes = "", Branch = toDo.Branch, Status = toDo.Appraisal, Status_Note = toDo.AppraisalNote }; if (NoExternalNote) { aJob.Notes = toDo.Notes; } dbContext.toDos.Add(aJob); dbContext.SaveChanges(); toDoId = aJob.Id; toDoStart = aJob.Begin; toDoEnd = aJob.End; var aTimeChunk = new Break { Start = toDoStart, End = toDoEnd, ToDoId = toDoId }; dbContext.Breaks.Add(aTimeChunk); dbContext.SaveChanges(); } catch (Exception e) { // throw new Exception(String.Format("the error is : {0}", e)); } } } else { using (var dbContext = new QuickToDosEntities()) { toDo job = dbContext.toDos.Find(toDo.Id); if (job == null) { throw new Exception("Echec mise a jour"); } job.Description = toDo.Description; job.Begin = toDo.Begin; job.End = toDo.End; job.Duration = toDo.Duration; job.Reference = toDo.Reference; job.Done = toDo.Done; job.Notes = ""; if (NoExternalNote) { job.Notes = toDo.Notes; } job.Planned = toDo.Planned; job.Branch = toDo.Branch; job.Status = toDo.Appraisal; job.Status_Note = toDo.AppraisalNote; dbContext.SaveChanges(); } } if (toDo.Notes != "" && (!NoExternalNote)) { using (var dbContext = new QuickToDosEntities()) { var aNote = new Note { Subject = "", Body = toDo.Notes, Concern = "work", Creation = DateTime.Now, ConcernId = toDoId }; dbContext.Notes.Add(aNote); dbContext.SaveChanges(); } } return(toDoId); }
public static int AddPeople(DataToAddPeople People) { int Id = People.Id; if (People.Position == -1 && People.PositionName != "") { using (var dbContext = new QuickToDosEntities()) { Position role = dbContext.Positions.FirstOrDefault(x => x.Name == People.PositionName); if (role == null) { role = new Position { Name = People.PositionName.ToUpper(), }; dbContext.Positions.Add(role); dbContext.SaveChanges(); People.Position = role.Id; } else { People.Position = role.Id; } } } if (Id == -1) { using (var dbContext = new QuickToDosEntities()) { var aPerson = new Person { Nom = People.Nom, Prenom = People.Prenom, IdPosition = People.Position, Mobile = People.Mobile, Email = People.Email, Photo = "" }; dbContext.People.Add(aPerson); dbContext.SaveChanges(); Id = aPerson.Id; } } else { using (var dbContext = new QuickToDosEntities()) { Person aPerson = dbContext.People.Find(Id); if (aPerson == null) { throw new Exception("Echec mise a jour"); } aPerson.Nom = People.Nom; aPerson.Prenom = People.Prenom; aPerson.IdPosition = People.Position; aPerson.Mobile = People.Mobile; aPerson.Email = People.Email; dbContext.SaveChanges(); } } // if (People.NewNote != "") { // Notes = query3.Where(z => z.ConcernId == x.Id && z.Concern == "people").ToList() using (var dbContext = new QuickToDosEntities()) { var aNote = new Note { Subject = "", Body = People.NewNote, Concern = "people", Creation = DateTime.Now, ConcernId = Id }; dbContext.Notes.Add(aNote); dbContext.SaveChanges(); } } return(Id); }