public ActionResult UserAction(List <IndicatorItem> IItems, string actioncase)
{
switch (actioncase.ToLower())
{
case "update":
if (IItems != null)
{
List <IndicatorItem> newitems = new List <IndicatorItem>();
for (int i = 0; i < IItems.Count; i++)
{
IndicatorItem newitem = new IndicatorItem();
newitem.IndicatorID = IItems[i].IndicatorID;
newitem.IndicatorItemID = IItems[i].IndicatorItemID;
newitem.IndicatorLabelID = IItems[i].IndicatorLabelID;
newitem.IndicatorCategoryLabelID = IItems[i].IndicatorCategoryLabelID;
newitem.Baseline = IItems[i].Baseline;
newitem.Benchmark = IItems[i].Benchmark;
newitem.Final = IItems[i].Final;
newitems.Add(newitem);
}
IService.UpdateIndicatorItems(newitems);
}
break;
default: break;
}
return(RedirectToAction("Index"));
}
private static void AddOutcomeHeader(DataTable dataTable, IndicatorItem indicatorItem)
{
dataTable.Columns.Add(indicatorItem.Name + " - Klar");
dataTable.Columns.Add(indicatorItem.Name + " - Result");
dataTable.Columns.Add(indicatorItem.Name + " - Result text");
dataTable.Columns.Add(indicatorItem.Name + " - Krav");
dataTable.Columns.Add(indicatorItem.Name + " - Formulering på utfall");
}
private void xamDataGrid_EditModeEnded(object sender, Infragistics.Windows.DataPresenter.Events.EditModeEndedEventArgs e)
{
// use this method to update a record after one of the cells of the record has been edited
if (((string)e.Cell.Record.Tag) == "AddRecord")
{
return; // not updating the AddRecord here
}
if (e.Cell.Record.DataItem.GetType() == typeof(MethodItem))
{
MethodItem mi = (MethodItem)e.Cell.Record.DataItem;
if (mi.MethodID != 0)
{
MethodContainer mc = new MethodContainer();
mc.MethodID = mi.MethodID;
mc.Description = mi.Description;
mc.BravoMethodFile = mi.BravoMethodFile;
mc.OwnerID = mi.OwnerID;
mc.IsPublic = mi.IsPublic;
bool success = wgDB.UpdateMethod(mc);
}
}
else if (e.Cell.Record.DataItem.GetType() == typeof(IndicatorItem))
{
IndicatorItem ii = (IndicatorItem)e.Cell.Record.DataItem;
if (ii.IndicatorID != 0)
{
IndicatorContainer ic = new IndicatorContainer();
ic.Description = ii.Description;
ic.MethodID = ii.MethodID;
ic.IndicatorID = ii.IndicatorID;
ic.ExcitationFilterPosition = ii.ExcitationFilterPosition;
ic.EmissionsFilterPosition = ii.EmissionsFilterPosition;
ic.SignalType = ii.SignalType;
bool succcess = wgDB.UpdateIndicator(ic);
}
}
else if (e.Cell.Record.DataItem.GetType() == typeof(CompoundPlateItem))
{
CompoundPlateItem cpi = (CompoundPlateItem)e.Cell.Record.DataItem;
if (cpi.CompoundPlateID != 0)
{
CompoundPlateContainer cpc = new CompoundPlateContainer();
cpc.CompoundPlateID = cpi.CompoundPlateID;
cpc.MethodID = cpi.MethodID;
cpc.Description = cpi.Description;
bool success = wgDB.UpdateCompoundPlate(cpc);
}
}
}
public ActionResult Edit(IndicatorItem item)
{
if (Session["ProposalID"] == null)
{
return(RedirectToAction("Search", "ProposalInfo"));
}
IService.UpdateIndicatorItem(item);
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id)
{
if (Session["ProposalID"] == null)
{
return(RedirectToAction("Search", "ProposalInfo"));
}
IndicatorItem item = IService.GetIndicatorItem(id);
return(View(item));
}
private void xamDataGrid_RecordsDeleting(object sender, Infragistics.Windows.DataPresenter.Events.RecordsDeletingEventArgs e)
{
bool success;
foreach (DataRecord record in e.Records)
{
if (record.DataItem.GetType() == typeof(MethodItem))
{
MethodItem mi = (MethodItem)record.DataItem;
foreach (IndicatorItem ii in mi.Indicators)
{
success = wgDB.DeleteIndicator(ii.IndicatorID);
if (!success)
{
break;
}
}
foreach (CompoundPlateItem cpi in mi.CompoundPlates)
{
success = wgDB.DeleteCompoundPlate(cpi.CompoundPlateID);
if (!success)
{
break;
}
}
success = wgDB.DeleteMethod(mi.MethodID);
if (!success)
{
break;
}
}
else if (record.DataItem.GetType() == typeof(IndicatorItem))
{
IndicatorItem ii = (IndicatorItem)record.DataItem;
success = wgDB.DeleteIndicator(ii.IndicatorID);
if (!success)
{
break;
}
}
else if (record.DataItem.GetType() == typeof(CompoundPlateItem))
{
CompoundPlateItem cpi = (CompoundPlateItem)record.DataItem;
success = wgDB.DeleteCompoundPlate(cpi.CompoundPlateID);
if (!success)
{
break;
}
}
}
}
public bool InsertFromTemplate(int ProjectID)
{
bool result = true;
var query = (from t in db.IndicatorTemplateItems
join ic in db.IndicatorCategoryLabels
on t.IndicatorCategoryLabelID equals ic.IndicatorCategoryLabelID
join gt in db.GrantTypes
on ic.GrantTypeCodeID equals gt.GrantTypeCodeID
where gt.ProjectID == ProjectID
select t);
IfIndicatorCreate(ProjectID);
List <IndicatorItem> tosubmit = new List <IndicatorItem>();
if (query != null)
{
if (query.Count() != 0)
{
foreach (var item in query)
{
if (item != null)
{
IndicatorItem newitem = new IndicatorItem();
newitem.Baseline = 0;
newitem.Benchmark = 0;
newitem.Final = 0;
newitem.IndicatorID = ProjectID;
newitem.IndicatorLabelID = item.IndicatorLabelID;
newitem.IndicatorCategoryLabelID = item.IndicatorCategoryLabelID;
tosubmit.Add(newitem);
}
}
}
}
try
{
db.IndicatorItems.InsertAllOnSubmit(tosubmit.AsEnumerable());
db.SubmitChanges();
}
catch (Exception ex)
{
Log.EnsureInitialized();
Log.Error(typeof(IndicatorRepository), "----------------------------------------------", ex);
// result = false;
}
return(result);
}
private void EmissionFilter_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs <object> e)
{
XamComboEditor xce = (XamComboEditor)sender;
DataRecord record = (DataRecord)xce.DataContext;
if (record == null)
{
return;
}
IndicatorItem indItem = (IndicatorItem)record.DataItem;
if (xamDataGrid.ActiveDataItem == null)
{
return;
}
if (xamDataGrid.ActiveDataItem.GetType() == typeof(IndicatorItem))
{
IndicatorItem indicator = (IndicatorItem)xamDataGrid.ActiveDataItem;
if (e.NewValue == null)
{
return;
}
if (e.NewValue.GetType() == typeof(FilterContainer))
{
FilterContainer filter = (FilterContainer)e.NewValue;
if (indicator.IndicatorID != 0 && indicator.IndicatorID == indItem.IndicatorID) // the 2nd condition makes sure the event is for the currently active Indicator
{
IndicatorContainer ic = new IndicatorContainer();
ic.Description = indicator.Description;
ic.EmissionsFilterPosition = filter.PositionNumber;
ic.ExcitationFilterPosition = indicator.ExcitationFilterPosition;
ic.IndicatorID = indicator.IndicatorID;
ic.MethodID = indicator.MethodID;
ic.SignalType = indicator.SignalType;
bool succcess = wgDB.UpdateIndicator(ic);
}
}
}
}
public bool UpdateIndicatorItem(IndicatorItem item)
{
bool result = true;
try
{
db.IndicatorItems.Attach(item);
db.Refresh(RefreshMode.KeepCurrentValues, item);
db.SubmitChanges();
}
catch (Exception ex)
{
Log.EnsureInitialized();
Log.Error(typeof(IndicatorRepository), "----------------------------------------------", ex);
result = false;
// throw ex;
}
return(result);
}
public bool InsertIndicatorItem(IndicatorItem item)
{
bool result = true;
IfIndicatorCreate(item.IndicatorID);
try
{
db.IndicatorItems.InsertOnSubmit(item);
db.SubmitChanges();
}
catch (Exception ex)
{
Log.EnsureInitialized();
Log.Error(typeof(IndicatorRepository), "----------------------------------------------", ex);
result = false;
// throw ex;
}
return(result);
}
private void _chartControl_DragDrop(object sender, DragEventArgs e)
{
if (!e.Data.GetDataPresent(typeof(IndicatorItem)))
{
return;
}
ChartBox cbox = this._chartControl.GetChartPanel(new Point(e.X, e.Y)) as ChartBox;
if (cbox == null)
{
return;
}
IndicatorItem indicatorItem = e.Data.GetData(typeof(IndicatorItem)) as IndicatorItem;
FigureIndicator figure = new FigureIndicator(indicatorItem.IndicatorType);
cbox.Figures.Add(figure);
Global.MainForm.Properties.SetPropertiesObject(figure);
}
public ActionResult NewIndicatorItem(int ddlIndicator, int ddlCategory,
int NewBaseline, int NewBenchmark, int NewFinal)
{
if (Session["ProposalID"] == null)
{
return(RedirectToAction("Search", "ProposalInfo"));
}
IndicatorItem item = new IndicatorItem();
//item.IndicatorID = int.Parse(Session["ProposalID"].ToString());
item.IndicatorLabelID = ddlIndicator;
item.IndicatorCategoryLabelID = ddlCategory;
item.IndicatorID = int.Parse(Session["ProposalID"].ToString());
item.Baseline = NewBaseline;
item.Benchmark = NewBenchmark;
item.Final = NewFinal;
IService.InsertIndicatorItem(item);
return(RedirectToAction("Index"));
}
private void xamDataGrid_RecordUpdated(object sender, Infragistics.Windows.DataPresenter.Events.RecordUpdatedEventArgs e)
{
if (e.Record.Tag == null)
{
return;
}
if (((string)e.Record.Tag).Equals("AddRecord")) // is this the "AddRecord"?
{
if (e.Record.DataItem.GetType() == typeof(MethodItem))
{
DataRecord methodRecord = (DataRecord)e.Record;
MethodItem mi = ((MethodItem)(methodRecord.DataItem));
MethodContainer newMethod = new MethodContainer();
newMethod.Description = mi.Description;
newMethod.OwnerID = mi.OwnerID;
newMethod.BravoMethodFile = mi.BravoMethodFile;
newMethod.IsPublic = mi.IsPublic;
bool success = wgDB.InsertMethod(ref newMethod);
if (success)
{
mi.MethodID = newMethod.MethodID;
UnMarkAddNewRecord(methodRecord);
MethodItem miNew = new MethodItem();
miNew.Description = "";
miNew.MethodID = mi.MethodID;
miNew.OwnerID = mi.OwnerID;
miNew.IsPublic = false;
miNew.BravoMethodFile = "";
VM.Methods.Insert(0, miNew);
// mark the new Method as the AddRecord
RecordCollectionBase coll = e.Record.ParentCollection;
DataRecord newMethodRecord = (DataRecord)coll.ElementAt(0);
MarkAddNewRecord(newMethodRecord);
// add the AddRecord Indicator for this new method
ObservableCollection <FilterContainer> exFilts = VM.ExcitationFilters;
ObservableCollection <FilterContainer> emFilts = VM.EmissionsFilters;
ObservableCollection <SignalTypeContainer> stList = VM.SignalTypeList;
IndicatorItem ii = new IndicatorItem(0, mi.MethodID, "", ref stList, ref exFilts, ref emFilts);
mi.Indicators.Add(ii);
// mark the new Indicator as the AddRecord
ExpandableFieldRecord expRecord = (ExpandableFieldRecord)methodRecord.ChildRecords[0];
DataRecord indicatorRecord = (DataRecord)expRecord.ChildRecords[0];
if (indicatorRecord.DataItem.GetType() == typeof(IndicatorItem))
{
MarkAddNewRecord(indicatorRecord);
}
// add the AddRecord CompoundPlate for this new method
CompoundPlateItem cpi = new CompoundPlateItem();
cpi.CompoundPlateID = 0;
cpi.MethodID = mi.MethodID;
cpi.Description = "";
mi.CompoundPlates.Add(cpi);
// mark the new CompoundPlate as the AddRecord
ExpandableFieldRecord expRecord1 = (ExpandableFieldRecord)methodRecord.ChildRecords[1];
DataRecord compoundPlateRecord = (DataRecord)expRecord1.ChildRecords[0];
if (compoundPlateRecord.DataItem.GetType() == typeof(CompoundPlateItem))
{
MarkAddNewRecord(compoundPlateRecord);
}
}
}
else if (e.Record.DataItem.GetType() == typeof(IndicatorItem))
{
IndicatorItem ii = (IndicatorItem)(e.Record.DataItem);
IndicatorContainer ic = new IndicatorContainer();
ic.Description = ii.Description;
ic.MethodID = ii.MethodID;
ic.IndicatorID = ii.IndicatorID;
ic.ExcitationFilterPosition = ii.ExcitationFilterPosition;
ic.EmissionsFilterPosition = ii.EmissionsFilterPosition;
ic.SignalType = ii.SignalType;
bool success = wgDB.InsertIndicator(ref ic);
if (success)
{
ii.IndicatorID = ic.IndicatorID;
UnMarkAddNewRecord(e.Record);
ObservableCollection <FilterContainer> exFilts = VM.ExcitationFilters;
ObservableCollection <FilterContainer> emFilts = VM.EmissionsFilters;
ObservableCollection <SignalTypeContainer> stList = VM.SignalTypeList;
IndicatorItem iiNew = new IndicatorItem(0, ic.MethodID, "", ref stList, ref exFilts, ref emFilts);
MethodItem mi = (MethodItem)(((DataRecord)e.Record.ParentRecord.ParentRecord).DataItem);
mi.Indicators.Insert(0, iiNew);
DataRecord newIndicatorRecord = (DataRecord)e.Record.ParentCollection[0];
MarkAddNewRecord(newIndicatorRecord);
}
}
else if (e.Record.DataItem.GetType() == typeof(CompoundPlateItem))
{
CompoundPlateItem cpi = (CompoundPlateItem)(e.Record.DataItem);
CompoundPlateContainer cpc = new CompoundPlateContainer();
cpc.CompoundPlateID = cpi.CompoundPlateID;
cpc.Description = cpi.Description;
cpc.MethodID = cpi.MethodID;
bool success = wgDB.InsertCompoundPlate(ref cpc);
if (success)
{
cpi.CompoundPlateID = cpc.CompoundPlateID;
UnMarkAddNewRecord(e.Record);
CompoundPlateItem cpiNew = new CompoundPlateItem();
cpiNew.Description = "";
cpiNew.CompoundPlateID = 0;
cpiNew.MethodID = cpc.MethodID;
MethodItem mi = (MethodItem)(((DataRecord)e.Record.ParentRecord.ParentRecord).DataItem);
mi.CompoundPlates.Insert(0, cpiNew);
DataRecord newCompoundPlateRecord = (DataRecord)e.Record.ParentCollection[0];
MarkAddNewRecord(newCompoundPlateRecord);
}
}
}
}
public MethodManager()
{
InitializeComponent();
wgDB = new WaveguideDB();
VM = new MethodManagerViewModel();
RefreshSignalTypeList();
RefreshFilterList();
//Initialize data in the XamDataGrid - NOTE: A blank record is added FIRST, this is key to this approach for the XamDataGrid
MethodItem blank = new MethodItem();
blank.Description = "";
blank.BravoMethodFile = "";
blank.OwnerID = GlobalVars.UserID;
blank.MethodID = 0;
blank.IsPublic = false;
VM.Methods.Add(blank);
// load all methods for user
bool success = wgDB.GetAllMethodsForUser(GlobalVars.UserID);
if (success)
{
foreach (MethodContainer mc in wgDB.m_methodList)
{
MethodItem mi = new MethodItem();
mi.Description = mc.Description;
mi.BravoMethodFile = mc.BravoMethodFile;
mi.OwnerID = mc.OwnerID;
mi.MethodID = mc.MethodID;
mi.IsPublic = mc.IsPublic;
VM.Methods.Add(mi);
// load all indicators for the method
// add blank Indicator container to hold the AddRecord
ObservableCollection <FilterContainer> exFilts = VM.ExcitationFilters;
ObservableCollection <FilterContainer> emFilts = VM.EmissionsFilters;
ObservableCollection <SignalTypeContainer> stList = VM.SignalTypeList;
IndicatorItem blankInd = new IndicatorItem(0, mi.MethodID, "", ref stList, ref exFilts, ref emFilts);
mi.Indicators.Add(blankInd);
success = wgDB.GetAllIndicatorsForMethod(mc.MethodID);
if (success)
{
foreach (IndicatorContainer ic in wgDB.m_indicatorList)
{
IndicatorItem ii = new IndicatorItem(ic.IndicatorID, ic.MethodID, ic.Description, ic.ExcitationFilterPosition, ic.EmissionsFilterPosition, ic.SignalType, ref stList, ref exFilts, ref emFilts);
mi.Indicators.Add(ii);
}
}
// load all compound plates for the method
// add blank Compound Plate container to hold the AddRecord
CompoundPlateItem blankCP = new CompoundPlateItem();
blankCP.CompoundPlateID = 0;
blankCP.MethodID = mi.MethodID;
blankCP.Description = "";
mi.CompoundPlates.Add(blankCP);
success = wgDB.GetAllCompoundPlatesForMethod(mc.MethodID);
if (success)
{
foreach (CompoundPlateContainer cpc in wgDB.m_compoundPlateList)
{
CompoundPlateItem cpi = new CompoundPlateItem();
cpi.CompoundPlateID = cpc.CompoundPlateID;
cpi.MethodID = cpc.MethodID;
cpi.Description = cpc.Description;
mi.CompoundPlates.Add(cpi);
}
}
}
}
xamDataGrid.DataContext = VM;
}
public bool UpdateIndicatorItem(IndicatorItem item)
{
return(_rep.UpdateIndicatorItem(item));
}
public bool InsertIndicatorItem(IndicatorItem item)
{
return(_rep.InsertIndicatorItem(item));
}