public AddEditSystemReferenceTypeModel()
{
mSystemReferenceType = new SystemReferenceType();
OkButtonCommand = new DelegateCommand<object>(OkButtonHander, CanExecuteOkButtonHandler);
CancelButtonCommand = new DelegateCommand<object>(CancelButtonHander, CanExecuteOkButtonHandler);
}
public void InsertUpdate(CmsEntities cee, ImportWbsProjectObject importWbsProjectObject, int issueId, SystemReferenceType systemReferenceType)
{
foreach (var systemReferenceDataAdapter in importWbsProjectObject.Children)
{
var existing = cee.SystemReferences.FirstOrDefault(x =>
x.IssueId == issueId
&& x.Number == systemReferenceDataAdapter.WbsElement);
if (existing != null) //Exist so lets update
{
mLog.Verbose("Updating SystemReferenceId ='{0}', IssueId ='{1}', SystemReferenceTypeId ='{2}' ({3}) Number ='{4}' to Description ='{5}', FundingType ='{6}', ActualValue ='{7}', EstValue ='{8}'",
existing.Id, existing.IssueId, existing.SystemReferenceTypeId,existing.SystemReferenceType.Name, existing.Number,
existing.Description, existing.FundingType, existing.ActualValue, existing.EstValue);
existing.Description = systemReferenceDataAdapter.WbsElementDescription;
existing.FundingType = systemReferenceDataAdapter.SpendClassification == "CAPEX" ? "CAPEX" : systemReferenceDataAdapter.SpendClassification == "OPEX" ? "OPEX" : "--";
existing.Status = systemReferenceDataAdapter.Status;
existing.ActualValue = systemReferenceDataAdapter.Actuals;
existing.EstValue = systemReferenceDataAdapter.WbsBudget;
}
else //Insert new
{
SystemReference newReference = new SystemReference
{
IssueId = issueId,
Number = systemReferenceDataAdapter.WbsElement,
SystemReferenceTypeId = systemReferenceType.Id,
Description = systemReferenceDataAdapter.WbsElementDescription,
FundingType = systemReferenceDataAdapter.SpendClassification == "CAPEX" ? "CAPEX" : systemReferenceDataAdapter.SpendClassification == "OPEX" ? "OPEX" : "--",
Status = systemReferenceDataAdapter.Status,
ActualValue = systemReferenceDataAdapter.Actuals,
EstValue = systemReferenceDataAdapter.WbsBudget
};
cee.SystemReferences.Add(newReference);
mLog.Verbose("Inserting new SystemReferenceId ='{0}', IssueId ='{1}', SystemReferenceTypeId ='{2}' ({3}) Number ='{4}', Description ='{5}', FundingType ='{6}', ActualValue ='{7}', EstValue ='{8}'",
newReference.Id, newReference.IssueId, newReference.SystemReferenceTypeId, systemReferenceType.Name, newReference.Number,
newReference.Description, newReference.FundingType, newReference.ActualValue, newReference.EstValue);
}
}
}
/// <summary>
/// Save/Update SystemReference
/// </summary>
/// <param name="systemReferenceType"> </param>
/// <returns> </returns>
public SystemReferenceType SaveSystemReferenceType(SystemReferenceType systemReferenceType)
{
using (var cee = new CmsEntities())
{
//Check if the SystemReference exist
SystemReferenceType dbSystemReferenceType = (from x in cee.SystemReferenceTypes where x.Id == systemReferenceType.Id select x).FirstOrDefault();
if (dbSystemReferenceType == null)
{
//Add new SystemReference
systemReferenceType.Code = systemReferenceType.Name.Replace(" ", "");
systemReferenceType.IsActive = true;
systemReferenceType.AllowDuplicates = false;
cee.SystemReferenceTypes.Add(systemReferenceType);
}
else
{
//Update existing SystemReference
dbSystemReferenceType.Name = systemReferenceType.Name;
dbSystemReferenceType.Description = systemReferenceType.Description;
dbSystemReferenceType.Ordinal = systemReferenceType.Ordinal;
dbSystemReferenceType.ShowInTimesheet = systemReferenceType.ShowInTimesheet;
dbSystemReferenceType.AllowDuplicates = systemReferenceType.AllowDuplicates;
}
cee.SaveChanges();
}
return systemReferenceType;
}
private void cmsWebServiceClient_GetSystemReferenceTypeCompleted(object sender, GetSystemReferenceTypeCompletedEventArgs e)
{
mSystemReferenceType = e.Result;
DataLoaded(null);
}
