public int AddImage(Image toAdd, AstroPhotoDataDataContext dc) { bool fileExists = ImageFileExistsInDb(toAdd.FilePath, dc); if ((!fileExists) && (toAdd.ImageTypeId != -1)) { try { dc.Images.InsertOnSubmit(toAdd); dc.SubmitChanges(); LogWriter.WriteLog("Successfully added new Image entry to database"); LogWriter.WriteLog("ImagePath : " + toAdd.FilePath); return(toAdd.ImageId); } catch (Exception ex) { LogWriter.WriteLog("------ERROR------\n" + ex.Message); return(-1); } } else { return(0); } }
public int AddProject(String name, AstroPhotoDataDataContext dc) { int idExists = ProjectExists(name, dc); if (idExists == -1) { try { Project toAdd = new Project() { Name = name, DateCreated = DateTime.Now }; dc.Projects.InsertOnSubmit(toAdd); dc.SubmitChanges(); LogWriter.WriteLog("Successfully added new Project entry to database"); LogWriter.WriteLog("Project Name: " + name); return(toAdd.ProjectId); } catch (Exception ex) { LogWriter.WriteLog("------ERROR------\n" + ex.Message); return(-1); } } else { return(idExists); } }
public int AddSessionDate(DateTime seshToAdd, AstroPhotoDataDataContext dc) { int idExists = SessionExists(seshToAdd, dc); if (idExists == -1) { try { Session toAdd = new Session() { DateOfSession = seshToAdd, SessionLabel = seshToAdd.ToShortDateString() }; dc.Sessions.InsertOnSubmit(toAdd); dc.SubmitChanges(); LogWriter.WriteLog("Successfully added new Session entry to database"); LogWriter.WriteLog("Session Date : " + seshToAdd.ToShortDateString()); return(toAdd.SessionId); } catch (Exception ex) { LogWriter.WriteLog("------ERROR------\n" + ex.Message); return(-1); } } else { return(idExists); } }
private void AddProjectByName(String name, AstroPhotoDataDataContext dc) { try { Project projectToAdd = new Project() { Name = name, DateCreated = DateTime.Now }; dc.Projects.InsertOnSubmit(projectToAdd); dc.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Add Project Error", ex.Message); } }
private void AutoAddSessionNow(AstroPhotoDataDataContext dc) { try { Session newSession = new Session() { SessionLabel = DateTime.Now.ToShortDateString(), DateOfSession = DateTime.Now }; dc.Sessions.InsertOnSubmit(newSession); dc.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Add Session Error", ex.Message); } }
private void AddImageFile(String path, int imageTypeId, int projectId, int sessionId, AstroPhotoDataDataContext dc) { try { Image imageToAdd = new Image() { ProjectId = projectId, SessionId = sessionId, FilePath = path, ImageTypeId = imageTypeId, DateAdded = DateTime.Now }; dc.Images.InsertOnSubmit(imageToAdd); dc.SubmitChanges(); } catch (Exception ex) { MessageBox.Show("Add Image Error", ex.Message); } }