public void ImportIssueClassification()
{
mForm.AddMessage(MessageType.Info, "-------------------- Importing Issue Classification --------------------");
List<Classification> classifications = (from x in mOldIssuesDataContext.Classifications select x).ToList();
foreach (var classification in classifications)
{
IssueClassification newClassification = new IssueClassification()
{
Name = classification.Name,
Ordinal = classification.Ordinal
};
var classificationExist = (from x in mCee.IssueClassifications where x.Name == newClassification.Name select x).FirstOrDefault();
if (classificationExist == null)
{
string message = String.Format("Adding Issue Classification '{0}'", newClassification.Name);
mForm.AddMessage(MessageType.Info, message);
mCee.IssueClassifications.AddObject(newClassification);
}
else
{
string message = String.Format("Issue Classification '{0}' already exist, skipping", classificationExist.Name);
mForm.AddMessage(MessageType.Warning, message);
}
}
mCee.SaveChanges();
}
public IssueClassification SaveIssueClassification(IssueClassification issueClassification)
{
using (var cee = new CmsEntities())
{
//Check if the pipe area exist
IssueClassification originalObject =
(from x in cee.IssueClassifications where x.Id == issueClassification.Id select x).FirstOrDefault();
if (originalObject == null)
{
//Add new Issue Classification
issueClassification.Code = issueClassification.Name.Replace(" ", "");
issueClassification.IsActive = true;
cee.IssueClassifications.Add(issueClassification);
}
else
{
//Update existing Classification
originalObject.Name = issueClassification.Name;
originalObject.Description = issueClassification.Description;
originalObject.IsActive = issueClassification.IsActive;
originalObject.Ordinal = issueClassification.Ordinal;
}
cee.SaveChanges();
}
return issueClassification;
}