private void SetKnownGPCRProperty(int sheetIndex)
{
WorkSheetProperty property = new WorkSheetProperty();
property.sheetIndex = sheetIndex;
property.name = "Known GPCR";
property.viewName = "DiscoveRxTotalGPCRProductOfferingList";
property.headerBackColor = "#FF0000";
property.headerFirstRow = new List <string>()
{
"Family", "Common\r\nName", "GPCR Gene", "Coupling", "PATHUNTER® Arrestin Cell Line\r\n(Ca^2+ mode indicated)", "", "PATHUNTER® Arrestin eXpress Kits*", "", "cAMP Hunter®\r\nCell Lines", "", "cAMP Hunter®\r\neXpress Kits*", "", "Calcium\r\nCell Lines", "Internalization\r\nCell Lines", "Internalization\r\neXpress Kits*", "PathHunter®\r\nBioassay Kits", "LeadHunter Service", ""
};
property.headerSecondRow = new List <string>()
{
"", "", "", "", "Human", "Ortholog", "Human", "Ortholog", "Human", "Ortholog", "Human", "Ortholog", "Human", "Human", "Human", "", "gpcrMAX", "Profiling**"
};
property.columnWidth = new List <int>()
{
35, 35, 20, 20, 20, 20, 20, 25, 20, 20, 20, 20, 20, 20, 20, 20, 20, 20
};
property.sectionHeader = new List <string>()
{
"PATHUNTER® Known GPCR Assay"
};
property.footerNotes = "* Small (S) and Large (L) Assay Kit formats are also available. For complete catalog listings, please visit www.discoverx.com/gpcrs/assay-ready\r\n** Profiling Service: C = Available in cAMP only; F = Available in Calcium Flux only";
workSheetPropertyList.Add(property);
}
private void SetOrphanGPCRProperty(int sheetIndex)
{
WorkSheetProperty property = new WorkSheetProperty();
property.sheetIndex = sheetIndex;
property.name = "Orphan GPCRs";
property.viewName = "PathHunterArrestinOrphanGPCRTotalOfferingList";
property.headerBackColor = "#FF00FF";
property.headerFirstRow = new List <string>()
{
"TARGET", "GENBANK ACCESION NUMBER", "CELL TYPE", "PATHUNTER® CELL LINE\r\n(ORPHAN)", "PATHUNTER® CELL\r\nLINE (LIGAND-BASED)", "PATHUNTER® ORPHAN\r\nEXPRESS KITS*", "LeadHunter SERVICE", ""
};
property.headerSecondRow = new List <string>()
{
"", "", "", "", "", "", "orphanMAX", "Profiling**"
};
property.columnWidth = new List <int>()
{
20, 40, 20, 20, 30, 20, 15, 15
};
property.sectionHeader = new List <string>()
{
"PATHUNTER® Orphan GPCR Assay"
};
property.footerNotes = "± Liganded orphans that have a demonstrated Arrestin response are generally run as part of the gpcrMAX panel.\r\n* Small (S) and Large (L) Assay Kit formats are also available. For complete catalog listings, please visit www.discoverx.com/gpcrs/assay-ready. \r\n** When two different cell backgrounds are available for the same target, the CHO-K1 background is used for profiling requests but the alternate background can be requested if necessary. Alternate backgrounds cannot be requested for the panel.";
workSheetPropertyList.Add(property);
}
private void SetPharmacotraffickingProperty(int sheetIndex)
{
WorkSheetProperty property = new WorkSheetProperty();
property.sheetIndex = sheetIndex;
property.name = "Pharmacotrafficking Assays";
property.viewName = "PathHunterPharmacotraffickingAssayList";
property.headerBackColor = "#FFC000";
property.headerFirstRow = new List <string>()
{
"TARGET", "PRODUCTION DESCRIPTION", "PATHUNTER® \r\nCELL LINE", "LeadHunter SERVICE"
};
property.headerSecondRow = new List <string>()
{
"", "", "", "Profiling"
};
property.columnWidth = new List <int>()
{
20, 65, 30, 30
};
property.sectionHeader = new List <string>()
{
"PATHUNTER® Pharmacotrafficking Assay"
};
workSheetPropertyList.Add(property);
}
private void SetInCellHunterProperty(int sheetIndex)
{
WorkSheetProperty property = new WorkSheetProperty();
property.sheetIndex = sheetIndex;
property.name = "InCell Hunter Assays";
property.viewName = "DiscoveRxInCELLHunterAssaysList";
property.headerBackColor = "#93990F";
property.headerFirstRow = new List <string>()
{
"TARGET", "PRODUCTION DESCRIPTION", "INCELL HUNTER™\r\nCELL POOL", "INCELL HUNTER™\r\nCell Line", "INCELL HUNTER™\r\nXpress Kits", "LeadHunter Service"
};
property.headerSecondRow = new List <string>()
{
"", "", "", "", "", "Profiling"
};
property.columnWidth = new List <int>()
{
20, 65, 20, 20, 20, 25
};
property.sectionHeader = new List <string>()
{
"InCell Hunter™ Compound Binding Assays - Bromodomain", "InCell Hunter™ Compound Binding - Kinase", "InCell Hunter™ Compound Binding Assays - Methyltransferase", "InCell Hunter™ Protein Binding Assays"
};
property.footerNotes = "* Small (S) and Large (L) Assay Kit formats are also available. For complete catalog listings, please visit www.discoverx.com.";
workSheetPropertyList.Add(property);
}
private void SetPathwayProperty(int sheetIndex)
{
WorkSheetProperty property = new WorkSheetProperty();
property.sheetIndex = sheetIndex;
property.name = "Pathway Assays";
property.viewName = "PathHunterPathwayAssaysList";
property.headerBackColor = "#0060A8";
property.headerFirstRow = new List <string>()
{
"TARGET", "PRODUCTION DESCRIPTION", "ASSAY MEASUREMENT", "PATHUNTER® \r\nCELL LINE", "PATHUNTER®\r\nXpress Kits", "LeadHunter SERVICE"
};
property.headerSecondRow = new List <string>()
{
"", "", "", "", "", "Profiling"
};
property.columnWidth = new List <int>()
{
20, 65, 30, 30, 20, 25
};
property.sectionHeader = new List <string>()
{
"PathHunter® Pathway Assays"
};
property.footerNotes = "* Small (S) and Large (L) Assay Kit formats are also available. For complete catalog listings, please visit www.discoverx.com.";
workSheetPropertyList.Add(property);
}
private void SetCellBasedKinaseProperty(int sheetIndex)
{
WorkSheetProperty property = new WorkSheetProperty();
property.sheetIndex = sheetIndex;
property.name = "Cell-Based Kinases";
property.viewName = "PathHunterCellBasedKinaseAssaysList";
property.headerBackColor = "#800080";
property.headerFirstRow = new List <string>()
{
"TARGET", "PRODUCTION NAME", "PARTNER\r\nPROTEIN", "PATHUNTER®\r\nCell Line", "PATHUNTER®\r\neXpress Kits", "INTERNALIZATION\r\nCell Lines", "INTERNALIZATION\r\neXpress Kits", "PathHunter®\r\nBioAssay Kits", "LeadHunter Service", ""
};
property.headerSecondRow = new List <string>()
{
"", "", "", "", "", "", "", "", "gpcrMAX", "Profiling"
};
property.columnWidth = new List <int>()
{
20, 50, 15, 20, 20, 20, 20, 20, 15, 15
};
property.sectionHeader = new List <string>()
{
"Receptor Tyrosine Kinase Assays", "Cytosolic Tyrosine Kinase Assays"
};
property.footerNotes = "* Small (S) and Large (L) Assay Kit formats are also available. For complete catalog listings, please visit www.discoverx.com.";
workSheetPropertyList.Add(property);
}
private void SetNHRProperty(int sheetIndex)
{
WorkSheetProperty property = new WorkSheetProperty();
property.sheetIndex = sheetIndex;
property.name = "NHR";
property.viewName = "NuclearHormoneReceptorActivationAssaysList";
property.headerBackColor = "#008000";
property.headerFirstRow = new List <string>()
{
"TARGET", "PRODUCTION NAME", "CELL\r\nBACKGROUND", "PATHUNTER® NHR\r\nCELL LINE", "PATHUNTER® NHR\r\nEXPRESS KITS", "LeadHunter SERVICE", ""
};
property.headerSecondRow = new List <string>()
{
"", "", "", "", "", "nhrMax", "Profiling"
};
property.columnWidth = new List <int>()
{
20, 60, 20, 20, 20, 15, 15
};
property.sectionHeader = new List <string>()
{
"Nuclear translacation Assays", "Protein Interaction Assays"
};
property.footerNotes = "* Small (S) and Large (L) Assay Kit formats are also available. For complete catalog listings, please visit www.discoverx.com.";
workSheetPropertyList.Add(property);
}
private void SetSynergyProperty(int sheetIndex)
{
WorkSheetProperty property = new WorkSheetProperty();
property.sheetIndex = sheetIndex;
property.name = "Synergy Table";
property.viewName = "SynergyTable";
property.headerBackColor = "#0070C0";
property.headerFirstRow = new List <string>()
{
"Part#", "Core#", "Target", "Product Category", "Ligand Part#", "Ligand Description", "AssayComplete™\r\nCell Culture Kit"
, "AssayComplete™\r\nCell Plating Reagent", "Detection\r\nReagents", "AssayComplete™\r\nRevive Media", "AssayComplete™\r\nPreserve Freezing Reagent", "CytoTracker™\r\nCell Proliferation Kit",
"CytoTracker™\r\nLDH Quantification Kit", "CytoTracker™\r\nGlutathione\r\nQuantification Kit", "CytoTracker™\r\nDNA Damage \r\nQuantification Kit"
};
property.columnWidth = new List <int>()
{
25, 15, 20, 70, 15, 25, 18, 18, 15, 18, 25, 20, 20, 20, 20
};
workSheetPropertyList.Add(property);
}
private void FillWorkSheetData(ExcelWorksheet ws, WorkSheetProperty property, int rowIndex)
{
if (viewModel.isPrimaryScreen)
{
if (property.name == "Primary Data")
{
rowIndex = PopulateDataFromPrimaryAssayData(rowIndex, viewModel.PrimaryAssayData.Where(p => p.CompoundName != null).ToList(), property.viewName, ws);
}
else if (property.name == "Plate Controls")
{
rowIndex = PopulateDataFromAssayReportSummaryPlateControl(rowIndex, viewModel.PrimaryAssayData.Where(p => p.CompoundName == null).GroupBy(p => p.ContainerID).Select(grp => grp.First()).ToList(), property.viewName, ws);
}
}
if (property.name == "Summary")
{
rowIndex = PopulateDataFromAssayReportSummary(rowIndex, viewModel.AssayReportSummary, property.viewName, ws);
}
else if (property.name == "Graph")
{
rowIndex = PopulateDataFromAssayReportSummaryGraph(rowIndex, viewModel.AssayReportSummary, property.viewName, ws);
}
}
private void FillWorkSheetData(ExcelWorksheet ws, WorkSheetProperty property, int rowIndex)
{
int sectionHeaderIndex = 0;
TargetListViewModel model = new TargetListViewModel();
model.GetAssayList(property.viewName);
if (property.sectionHeader != null && property.sectionHeader.Count > 0)
{
CreateSectionHeader(ws, rowIndex, property, sectionHeaderIndex);
sectionHeaderIndex++;
}
if (property.name == "Known GPCR")
{
rowIndex = PopulateDataFromAssayListTotalGPCR(rowIndex, model.TotalGPCRList, property.viewName, ws);
}
else if (property.name == "Cell-Based Kinases")
{
rowIndex = PopulateDataFromAssayListCellBasedKinases(rowIndex, model.RECEPTORList, ws);
if (property.sectionHeader != null && property.sectionHeader.Count > 1)
{
CreateSectionHeader(ws, rowIndex, property, sectionHeaderIndex);
sectionHeaderIndex++;
}
rowIndex = PopulateDataFromAssayListCellBasedKinases(rowIndex, model.CYTOSOLICList, ws);
}
else if (property.name == "Synergy Table")
{
rowIndex = PopulateDataFromSynergyList(rowIndex, model.SynergyList, property.viewName, ws);
}
else
{
rowIndex = PopulateDataFromAssayList(rowIndex, model.AssayList1, property.viewName, ws);
if (property.sectionHeader != null && property.sectionHeader.Count > 1)
{
CreateSectionHeader(ws, rowIndex, property, sectionHeaderIndex);
sectionHeaderIndex++;
}
rowIndex = PopulateDataFromAssayList(rowIndex, model.AssayList2, property.viewName, ws);
if (property.sectionHeader != null && property.sectionHeader.Count > 2)
{
CreateSectionHeader(ws, rowIndex, property, sectionHeaderIndex);
sectionHeaderIndex++;
}
rowIndex = PopulateDataFromAssayList(rowIndex, model.AssayList3, property.viewName, ws);
if (property.sectionHeader != null && property.sectionHeader.Count > 3)
{
CreateSectionHeader(ws, rowIndex, property, sectionHeaderIndex);
sectionHeaderIndex++;
}
rowIndex = PopulateDataFromAssayList(rowIndex, model.AssayList4, property.viewName, ws);
}
if (property.footerNotes != null)
{
CreateFooter(rowIndex, ws, property);
}
}
