public void RefreshProjectList()
{
bool success;
// load project list
ObservableCollection <ProjectContainer> projectList;
if (GlobalVars.Instance.UserRole == GlobalVars.USER_ROLE_ENUM.ADMIN)
{
success = m_wgDB.GetAllProjects(VM.IncludeArchivedProjects);
projectList = m_wgDB.m_projectList;
}
else
{
success = m_wgDB.GetAllProjectsForUser(GlobalVars.Instance.UserID, out projectList);
}
if (success && projectList != null)
{
VM.ProjectList.Clear();
VM.CurrentProject = null;
foreach (ProjectContainer project in projectList)
{
if (!project.Archived || (project.Archived && VM.IncludeArchivedProjects))
{
PlateExplorer_ViewModel.ProjectListItem pli = new PlateExplorer_ViewModel.ProjectListItem();
pli.Description = project.Description;
pli.ProjectID = project.ProjectID;
VM.ProjectList.Add(pli);
}
}
}
}
public void Refresh()
{
WaveguideDB wgDB = new WaveguideDB();
bool success = wgDB.GetAllProjects(ShowArchivedProjects);
if (success)
{
Projects.Clear();
for (int i = 0; i < wgDB.m_projectList.Count(); i++)
{
ProjectItem pitem = new ProjectItem();
pitem.ProjectName = wgDB.m_projectList[i].Description;
pitem.ProjectID = wgDB.m_projectList[i].ProjectID;
pitem.Archived = wgDB.m_projectList[i].Archived;
pitem.TimeStamp = wgDB.m_projectList[i].TimeStamp;
bool IsAssigned = new bool();
IsAssigned = false;
success = wgDB.IsUserAssignedToProject(User.UserID, pitem.ProjectID, ref IsAssigned);
if (success)
{
pitem.AssignedToProject = IsAssigned;
}
Projects.Add(pitem);
}
}
}
public void Refresh()
{
Projects.Clear();
bool success = wgDB.GetAllProjects(ShowArchivedProjects);
if (success)
{
for (int i = 0; i < wgDB.m_projectList.Count(); i++)
{
ProjectSimple project = new ProjectSimple();
project.Description = wgDB.m_projectList[i].Description;
project.ProjectID = wgDB.m_projectList[i].ProjectID;
project.Archived = wgDB.m_projectList[i].Archived;
project.TimeStamp = wgDB.m_projectList[i].TimeStamp;
Projects.Add(project);
List <UserContainer> users;
success = wgDB.GetAllUsersForProject(project.ProjectID, out users);
if (success)
{
for (int j = 0; j < users.Count(); j++)
{
UserFullname ufn = new UserFullname();
ufn.Fullname = users[j].Lastname + ", " + users[j].Firstname;
project.Users.Add(ufn);
}
}
}
}
}
private void SavePB_Click(object sender, RoutedEventArgs e)
{
bool goodData = true;
string errStr = "No Error";
WaveguideDB wgDB = new WaveguideDB();
bool success = wgDB.GetAllProjects(true);
bool ProjectNameUnique = true;
// if creating a new project, make sure project name isn't already used in database
if (m_addingNew)
{
for (int i = 0; i < wgDB.m_projectList.Count(); i++)
{
if (wgDB.m_projectList[i].Description.Equals(ProjectVM.ProjectDescription, StringComparison.OrdinalIgnoreCase))
{
ProjectNameUnique = false;
break;
}
}
}
if (ProjectVM.ProjectDescription.Length < 1)
{
goodData = false;
errStr = "Project must have a Name";
}
else if (!ProjectNameUnique)
{
goodData = false;
errStr = "Project Name: " + ProjectVM.ProjectDescription + " is already in use by another project (Includes Archived Projects).";
}
if (goodData)
{
ProjectContainer pc = new ProjectContainer();
if (m_addingNew) // creating a new project
{
pc.Description = ProjectVM.ProjectDescription;
pc.Archived = ProjectVM.Archived;
pc.TimeStamp = ProjectVM.TimeStamp;
success = wgDB.InsertProject(ref pc);
}
else // updating current project instead of creating a new one
{
pc.Description = ProjectVM.ProjectDescription;
pc.ProjectID = ProjectVM.ProjectID;
pc.Archived = ProjectVM.Archived;
pc.TimeStamp = ProjectVM.TimeStamp;
success = wgDB.UpdateProject(pc);
}
if (success)
{
ProjectVM.ProjectDescription = pc.Description;
ProjectVM.ProjectID = pc.ProjectID;
ProjectVM.Archived = pc.Archived;
ProjectVM.TimeStamp = pc.TimeStamp;
// delete all current UserProject records for this Project
success = wgDB.RemoveProjectFromUserProjectTable(pc.ProjectID);
if (success)
{
// add UserProject records as designed by ProjectVM.Users list
for (int i = 0; i < ProjectVM.Users.Count(); i++)
{
if (ProjectVM.Users[i].AssignedToProject)
{
success = wgDB.AddUserToProject(ProjectVM.Users[i].UserID, ProjectVM.ProjectID);
if (!success)
{
errStr = wgDB.GetLastErrorMsg();
MessageBox.Show(errStr, "Database Error", MessageBoxButton.OK, MessageBoxImage.Error);
break;
}
}
}
}
}
if (success)
{
m_OK = true;
Close();
}
}
if (!goodData)
{
MessageBox.Show(errStr, "Error in Project Data", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
void LoadSimulationConfiguration()
{
// m_iParams = iParams;
// m_project = project;
// m_experimentPlate = plate;
// m_method = method;
// m_mask = mask;
// m_plateType = plateType;
// m_indicatorList = indicatorList;
// m_compoundPlateList = compoundPlateList;
// m_controlSubtractionWellList = controlSubtractionWellList;
//m_numFoFrames = numFoFrames;
//m_dynamicRatioNumerator = dynamicRatioNumerator;
//m_dynamicRatioDenominator = dynamicRatioDenominator;
//ChartArray.BuildChartArray(mask.Rows, mask.Cols, m_indicatorList);
////////////////////////
// set up project
m_project = null;
bool success = m_wgDB.GetAllProjects(false);
foreach (ProjectContainer project in m_wgDB.m_projectList)
{
if (project.Description.Equals("Debug", StringComparison.OrdinalIgnoreCase))
{
m_project = project;
break;
}
}
if (m_project == null) // not found in database, so create it
{
m_project = new ProjectContainer();
m_project.Description = "Debug";
m_project.TimeStamp = DateTime.Now;
m_project.Archived = false;
success = m_wgDB.InsertProject(ref m_project);
}
////////////////////////
// set up plateType
m_plateType = null;
success = m_wgDB.GetAllPlateTypes();
if (m_wgDB.m_plateTypeList.Count() > 0)
{
m_plateType = m_wgDB.m_plateTypeList.ElementAt(0);
}
else
{
// create a new plateType
m_plateType = new PlateTypeContainer();
m_plateType.Cols = 24;
m_plateType.Description = "Debug";
m_plateType.IsDefault = false;
m_plateType.Rows = 16;
success = m_wgDB.InsertPlateType(ref m_plateType);
}
////////////////////////
// set up experiment plate
m_experimentPlate = null;
success = m_wgDB.GetAllPlatesForProject(m_project.ProjectID);
if (m_wgDB.m_plateList.Count() > 0)
{
m_experimentPlate = m_wgDB.m_plateList.ElementAt(0);
}
else
{
// create a new plate
m_experimentPlate = new PlateContainer();
m_experimentPlate.Barcode = "12345678";
m_experimentPlate.Description = "Debug";
m_experimentPlate.IsPublic = true;
m_experimentPlate.OwnerID = GlobalVars.UserID;
m_experimentPlate.PlateTypeID = m_plateType.PlateTypeID;
m_experimentPlate.ProjectID = m_project.ProjectID;
success = m_wgDB.InsertPlate(ref m_experimentPlate);
}
////////////////////////
// set up method
m_method = null;
success = m_wgDB.GetAllMethodsForUser(GlobalVars.UserID);
foreach (MethodContainer method in m_wgDB.m_methodList)
{
if (method.Description.Equals("Debug", StringComparison.OrdinalIgnoreCase))
{
m_method = method;
break;
}
}
if (m_method == null)
{
m_method = new MethodContainer();
m_method.BravoMethodFile = "";
m_method.Description = "Debug";
m_method.IsPublic = true;
m_method.OwnerID = GlobalVars.UserID;
success = m_wgDB.InsertMethod(ref m_method);
}
success = m_wgDB.GetAllIndicatorsForMethod(m_method.MethodID);
if (m_wgDB.m_indicatorList.Count < 1)
{
// create indicators for this new method
IndicatorContainer ind = new IndicatorContainer();
ind.Description = "Debug";
ind.EmissionsFilterPosition = 6;
ind.ExcitationFilterPosition = 4;
ind.MethodID = m_method.MethodID;
ind.SignalType = SIGNAL_TYPE.UP;
success = m_wgDB.InsertIndicator(ref ind);
}
////////////////////////
// set up experiment
m_experiment = null;
ObservableCollection <ExperimentContainer> expList;
success = m_wgDB.GetAllExperimentsForPlate(m_experimentPlate.PlateID, out expList);
if (expList.Count() > 0)
{
m_experiment = expList.ElementAt(0);
}
else
{
m_experiment = new ExperimentContainer();
m_experiment.Description = "Debug";
m_experiment.HorzBinning = 1;
m_experiment.MethodID = m_method.MethodID;
m_experiment.PlateID = m_experimentPlate.PlateID;
m_experiment.ROI_Height = GlobalVars.PixelHeight;
m_experiment.ROI_Width = GlobalVars.PixelWidth;
m_experiment.ROI_Origin_X = 1;
m_experiment.ROI_Origin_Y = 1;
m_experiment.TimeStamp = DateTime.Now;
m_experiment.VertBinning = 1;
success = m_wgDB.InsertExperiment(ref m_experiment);
}
////////////////////////
// set up mask
m_mask = null;
success = m_wgDB.GetAllMasksForPlateType(m_experimentPlate.PlateTypeID);
if (m_wgDB.m_maskList.Count() > 0)
{
m_mask = m_wgDB.m_maskList.ElementAt(0);
}
else
{
// create a new mask
m_mask = new MaskContainer();
m_mask.Angle = 0.0;
m_mask.Cols = 24;
m_mask.Description = "Debug";
m_mask.IsDefault = false;
m_mask.NumEllipseVertices = 24;
m_mask.PlateTypeID = m_experimentPlate.PlateTypeID;
m_mask.ReferenceImageID = 0;
m_mask.Rows = 16;
m_mask.Shape = 0;
m_mask.XOffset = 28;
m_mask.XSize = 28;
m_mask.XStep = 41.522;
m_mask.YOffset = 190;
m_mask.YSize = 28;
m_mask.YStep = 41.467;
success = m_wgDB.InsertMask(ref m_mask);
}
////////////////////////////////////
// setup test indicator(s)
m_indicatorList = new ObservableCollection <ExperimentIndicatorContainer>();
ObservableCollection <ExperimentIndicatorContainer> expIndList;
success = m_wgDB.GetAllExperimentIndicatorsForExperiment(m_experiment.ExperimentID, out expIndList);
if (expIndList.Count > 0)
{
foreach (ExperimentIndicatorContainer ex in expIndList)
{
m_indicatorList.Add(ex);
}
}
else
{
success = m_wgDB.GetAllIndicatorsForMethod(m_method.MethodID);
foreach (IndicatorContainer ind in m_wgDB.m_indicatorList)
{
ExperimentIndicatorContainer exInd = new ExperimentIndicatorContainer();
exInd.Description = ind.Description;
FilterContainer filter;
success = m_wgDB.GetExcitationFilterAtPosition(ind.ExcitationFilterPosition, out filter);
exInd.ExcitationFilterDesc = filter.Description;
success = m_wgDB.GetEmissionFilterAtPosition(ind.EmissionsFilterPosition, out filter);
exInd.EmissionFilterDesc = filter.Description;
exInd.EmissionFilterPos = ind.EmissionsFilterPosition;
exInd.ExcitationFilterPos = ind.ExcitationFilterPosition;
exInd.ExperimentID = m_experiment.ExperimentID;
exInd.Exposure = 150;
exInd.Gain = 5;
exInd.MaskID = m_mask.MaskID;
exInd.SignalType = SIGNAL_TYPE.UP;
exInd.Verified = true;
success = m_wgDB.InsertExperimentIndicator(ref exInd);
m_indicatorList.Add(exInd);
}
}
////////////////////////////////////
// compound plates
m_compoundPlateList = new ObservableCollection <ExperimentCompoundPlateContainer>();
////////////////////////////////////
// control subtraction well list
m_controlSubtractionWellList = new ObservableCollection <Tuple <int, int> >();
// all wells in last row = control wells
for (int c = 0; c < m_mask.Cols; c++)
{
m_controlSubtractionWellList.Add(Tuple.Create(m_mask.Rows - 1, c));
}
////////////////////////////////////
//m_numFoFrames = numFoFrames;
m_numFoFrames = 5;
if (m_indicatorList.Count() > 1)
{
////////////////////////////////////
//m_dynamicRatioNumerator = dynamicRatioNumerator;
m_dynamicRatioNumerator = m_indicatorList.ElementAt(0);
////////////////////////////////////
//m_dynamicRatioDenominator = dynamicRatioDenominator;
m_dynamicRatioDenominator = m_indicatorList.ElementAt(1);
}
else
{
m_dynamicRatioNumerator = new ExperimentIndicatorContainer();
m_dynamicRatioNumerator.ExperimentIndicatorID = 0;
m_dynamicRatioDenominator = new ExperimentIndicatorContainer();
m_dynamicRatioDenominator.ExperimentIndicatorID = 0;
}
if (m_iParams == null)
{
m_iParams = new ImagingParameters();
}
m_iParams.maxPixelValue = GlobalVars.MaxPixelValue;
m_iParams.imageWidth = GlobalVars.PixelWidth;
m_iParams.imageHeight = GlobalVars.PixelHeight;
m_iParams.Image_StartCol = 1;
m_iParams.Image_EndCol = GlobalVars.PixelWidth;
m_iParams.Image_StartRow = 1;
m_iParams.Image_EndRow = GlobalVars.PixelHeight;
m_iParams.BravoMethodFilename = "";
m_iParams.CameraTemperature = GlobalVars.CameraTargetTemperature;
m_iParams.HorzBinning = 1;
m_iParams.VertBinning = 1;
m_iParams.EmissionFilterChangeSpeed = GlobalVars.FilterChangeSpeed;
m_iParams.ExcitationFilterChangeSpeed = GlobalVars.FilterChangeSpeed;
m_iParams.LightIntensity = 100;
m_iParams.NumImages = 1000000; // artificial limit on number of images
m_iParams.NumIndicators = m_indicatorList.Count;
m_iParams.SyncExcitationFilterWithImaging = true;
m_iParams.CycleTime = new int[m_indicatorList.Count];
m_iParams.EmissionFilter = new byte[m_indicatorList.Count];
m_iParams.ExcitationFilter = new byte[m_indicatorList.Count];
m_iParams.Exposure = new float[m_indicatorList.Count];
m_iParams.Gain = new int[m_indicatorList.Count];
m_iParams.ExperimentIndicatorID = new int[m_indicatorList.Count];
m_iParams.IndicatorName = new string[m_indicatorList.Count];
m_iParams.LampShutterIsOpen = new bool[m_indicatorList.Count];
int i = 0;
foreach (ExperimentIndicatorContainer ind in m_indicatorList)
{
m_iParams.CycleTime[i] = 1000;
m_iParams.EmissionFilter[i] = (byte)ind.EmissionFilterPos;
m_iParams.ExcitationFilter[i] = (byte)ind.ExcitationFilterPos;
m_iParams.Exposure[i] = (float)ind.Exposure / 1000;
m_iParams.Gain[i] = ind.Gain;
m_iParams.ExperimentIndicatorID[i] = 0; // created by the RunExperiment object when the experiment is run
m_iParams.IndicatorName[i] = ind.Description;
m_iParams.LampShutterIsOpen[i] = true;
m_iParams.ExperimentIndicatorID[i] = ind.ExperimentIndicatorID;
i++;
}
}