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