public DbOperationResult<IssueTypeMilestoneType> AddIssueTypeMilestoneType(IssueType issueType, IssueMilestoneType milestoneType)
{
var result = new DbOperationResult<IssueTypeMilestoneType>();
//guard against duplicate.
using (var cee = new CmsEntities())
{
int k = (from x in cee.IssueTypeMilestoneTypes where x.IssueTypeId == issueType.Id && x.MilestoneTypeId == milestoneType.Id select x.Id).Count();
if (k > 0)
{
result.ServerErrorMessages.Add(string.Format("Insert Failed. An IssueTypeMilestoneType with the combination IssueType Name: '{0}' and Issue SubType Name: '{1}' already exists.", issueType.Name, milestoneType.Name));
return result;
}
var issueTypeMilestoneType = new IssueTypeMilestoneType
{
MilestoneTypeId = milestoneType.Id,
IssueTypeId = issueType.Id,
Ordinal = 0
};
cee.IssueTypeMilestoneTypes.Add(issueTypeMilestoneType);
cee.SaveChanges();
result.EntityResult = issueTypeMilestoneType;
}
return result;
}
public AddEditMilestoneTypeModel()
{
mMilestoneType = new IssueMilestoneType { IsActive = true };
mMilestoneTypeLoaded = true;
var cmsWebServiceClient = new CmsWebServiceClient(Utils.WcfBinding, Utils.WcfEndPoint);
cmsWebServiceClient.GetAllMilestoneTypesCompleted += (s1, e1) =>
{
ExistingMilestoneTypes = e1.Result;
mExistingMilestoneTypesLoaded = true;
OnDataLoaded();
};
cmsWebServiceClient.GetAllMilestoneTypesAsync();
OkButtonCommand = new DelegateCommand<object>(OkButtonHander, CanExecuteOkButtonHandler);
CancelButtonCommand = new DelegateCommand<object>(CancelButtonHander, CanExecuteOkButtonHandler);
}
private DbOperationResult<IssueMilestoneType> UpdateIssueSubType(IssueMilestoneType milestoneType)
{
var result = new DbOperationResult<IssueMilestoneType>();
using (var cee = new CmsEntities())
{
int k = (from x in cee.IssueMilestoneTypes
where x.Name.Equals(milestoneType.Name, StringComparison.CurrentCultureIgnoreCase)
&& x.Id != milestoneType.Id
select x.Id).Count();
if (k > 0)
{
result.ServerErrorMessages.Add(string.Format("Save Failed. A MilestoneType with the Name '{0}' already exists.", milestoneType.Name));
}
IssueMilestoneType dbMatch = (from x in cee.IssueMilestoneTypes where x.Id == milestoneType.Id select x).FirstOrDefault();
if (dbMatch == null)
{
result.ServerErrorMessages.Add(string.Format("Update Failed. MilestoneType with the Id '{0}' does not exist.", milestoneType.Id));
return result;
}
dbMatch.Name = milestoneType.Name;
dbMatch.Description = milestoneType.Description;
dbMatch.Code = milestoneType.Code;
dbMatch.Ordinal = milestoneType.Ordinal;
dbMatch.IsActive = milestoneType.IsActive;
cee.SaveChanges();
result.EntityResult = dbMatch;
}
return result;
}
private DbOperationResult<IssueMilestoneType> InsertMilestoneType(IssueMilestoneType milestoneType)
{
var result = new DbOperationResult<IssueMilestoneType>();
//guard against duplicate.
using (var cee = new CmsEntities())
{
int k = (from x in cee.IssueMilestoneTypes where x.Name.Equals(milestoneType.Name, StringComparison.CurrentCultureIgnoreCase) select x.Id).Count();
if (k > 0)
{
result.ServerErrorMessages.Add(string.Format("Insert Failed. A MilestoneType with the Name '{0}' already exists.", milestoneType.Name));
}
cee.IssueMilestoneTypes.Add(milestoneType);
cee.SaveChanges();
result.EntityResult = milestoneType;
}
return result;
}
public DbOperationResult<IssueMilestoneType> SaveMilestoneType(IssueMilestoneType milestoneType)
{
try
{
if (milestoneType.Id == 0)
{
return InsertMilestoneType(milestoneType);
}
return UpdateIssueSubType(milestoneType);
}
catch (Exception ex)
{
return BuildOperationalErrorResults<IssueMilestoneType>(ex);
}
}
