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 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 bool ImageFileExistsInDb(String fullName, AstroPhotoDataDataContext dc) { try { var result = (from x in dc.Images where x.FilePath == fullName select x).FirstOrDefault(); if (result == null) { LogWriter.WriteLog("Checking for existince of Image: " + fullName); LogWriter.WriteLog("Image exists returned false"); return(false); } else { LogWriter.WriteLog("Checking for existince of Image: " + fullName); LogWriter.WriteLog("Image exists returned true"); return(true); } } catch (Exception ex) { LogWriter.WriteLog("------ERROR------\n" + ex.Message); return(false); } }
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); } }
public int ProjectExists(String name, AstroPhotoDataDataContext dc) { try { var result = (from x in dc.Projects where x.Name == name select x).FirstOrDefault(); if (result == null) { LogWriter.WriteLog("Checking for existince of Project: " + name); LogWriter.WriteLog("Session Exists check returned false"); return(-1); } else { LogWriter.WriteLog("Checking for existince of Project: " + name); LogWriter.WriteLog("Session Exists check returned true"); return(result.ProjectId); } } catch (Exception ex) { LogWriter.WriteLog(ex.Message); return(-1); } }
public int SessionExists(DateTime seshToCheck, AstroPhotoDataDataContext dc) { try { var result = (from x in dc.Sessions where x.SessionLabel == seshToCheck.ToShortDateString() select x).FirstOrDefault(); if (result == null) { LogWriter.WriteLog("Checking for existince of Session: " + seshToCheck.ToShortDateString()); LogWriter.WriteLog("Session Exists check returned false"); return(-1); } else { LogWriter.WriteLog("Checking for existince of Session: " + seshToCheck.ToShortDateString()); LogWriter.WriteLog("Session Exists check returned true"); return(result.SessionId); } } catch (Exception ex) { LogWriter.WriteLog(ex.Message); return(-1); } }
private void buttonConnectToDb_Click(object sender, EventArgs e) { apdc = new AstroPhotoDataDataContext(); try { LoadProps(apdc); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
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); } }
public Image ParseFileNameToImageInfo(String filename, AstroPhotoDataDataContext dc) { this.LogWriter.WriteLog("In parseFileNameToImage. Data: " + filename); try { List <KeyValuePair <String, String> > infosInFileName = new List <KeyValuePair <string, string> >(); FileInfo inputFileName = new FileInfo(filename); if ((inputFileName.Name.StartsWith("Incomplete")) || (inputFileName.Name.Length < 7)) { return(null); } char[] splitters = new char[2]; splitters[0] = '_'; splitters[1] = '.'; List <String> attribs = inputFileName.Name.Split(splitters).ToList(); ///Match resultMatch = Regex.Match(filename, (patternStartImageType + targetPattern + DurationPattern + ISOPattern + sequencePatter + TempPattern)); foreach (String x in attribs) { KeyValuePair <String, String> newInfoItem = EvaluateNamePart(x); if (newInfoItem.Value != null) { infosInFileName.Add(newInfoItem); } } DateTime sesssionDate = this.DetermineSessionDate(inputFileName.CreationTime); infosInFileName.Add(new KeyValuePair <string, string>(SESSIONDATE, sesssionDate.ToShortDateString())); infosInFileName.Add(new KeyValuePair <string, string>(CREATEDDATETIME, (inputFileName.CreationTime.ToShortDateString() + " " + inputFileName.CreationTime.ToShortTimeString()))); infosInFileName.Add(new KeyValuePair <string, string>("FilePath", filename)); Image imgStub = GenerateImageStubFromInfos(infosInFileName, dc); return(imgStub); } catch (Exception ex) { LogWriter.WriteLog("Error in ParseFileNameForInfo"); LogWriter.WriteLog(ex.Message); return(null); } }
public FormAddData(AstroPhotoDataDataContext adc) { InitializeComponent(); ADC = adc; var itypes = (from x in adc.ImageTypes select x).ToList(); comboBoxImageType.DataSource = itypes; comboBoxImageType.DisplayMember = "Name"; var projects = (from x in adc.Projects select x).ToList(); var sessions = (from x in adc.Sessions select x).ToList(); comboBoxProjects.DataSource = projects; comboBoxProjects.DisplayMember = "Name"; comboBoxSession.DataSource = sessions; comboBoxSession.DisplayMember = "SessionLabel"; APData = new AstroData(); }
private void LoadProps(AstroPhotoDataDataContext dc) { APImageTypes = (from x in dc.ImageTypes select x).ToList(); dataGridViewImageTypes.DataSource = APImageTypes; //comboBoxImageTypes.DataSource = APImageTypes; //comboBoxImageTypes.DisplayMember = "Name"; //APImages = (from x in dc.Images // select x).ToList(); IV = dc.ImagesViews.ToList(); dataGridViewImages.DataSource = IV; APProjects = (from x in dc.Projects select x).ToList(); dataGridViewProjects.DataSource = APProjects; //comboBoxSelectProject.DataSource = APProjects; //comboBoxSelectProject.DisplayMember = "Name"; APSessions = (from x in dc.Sessions select x).ToList(); dataGridViewSessions.DataSource = APSessions; //comboBoxSelectSession.DataSource = APSessions; //comboBoxSelectSession.DisplayMember = "SessionLabel"; }
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); } }
public Image GenerateImageStubFromInfos(List <KeyValuePair <String, String> > infos, AstroPhotoDataDataContext dc) { var x = infos.Where(ky => ky.Key == "FilePath").FirstOrDefault(); string filepath = x.Value; var y = infos.Where(ky => ky.Key == CREATEDDATETIME).FirstOrDefault(); string createdDataTime = y.Value; var z = infos.Where(ky => ky.Key == SESSIONDATE).FirstOrDefault(); string sessionData = z.Value; var a = infos.Where(ky => ky.Key == SEQUENCENUMBER).FirstOrDefault(); string sequenceNumber = a.Value; var b = infos.Where(ky => ky.Key == TEMP).FirstOrDefault(); string temperature = b.Value; var c = infos.Where(ky => ky.Key == DURATION).FirstOrDefault(); string duration = c.Value; var d = infos.Where(ky => ky.Key == ISO).FirstOrDefault(); string iso = d.Value; var e = infos.Where(ky => ky.Key == TARGET).FirstOrDefault(); string target = e.Value; var f = infos.Where(ky => ky.Key == IMAGETYPE).FirstOrDefault(); string imageType = f.Value; LogWriter.WriteLog("Before Create Image"); String dateToParse = (sessionData.Split(' '))[0]; DateTime sessionDate = DateTime.Parse(sessionData); LogWriter.WriteLog("SessionData :" + dateToParse); if (target == null) { target = "Unassigned"; } Image retVal = new Image() { FilePath = filepath, DateAdded = DateTime.Parse(createdDataTime), ImageTypeId = GetIdForImageType(imageType), ProjectId = AddProject(target, dc), SessionId = AddSessionDate(sessionDate, dc) }; logImage(retVal, LogWriter); return(retVal); }