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