public void DeleteLabel(ProjectLabelDomain label)
{
if (label != null)
{
using (var ctx = new smbimContext())
{
ProjectLabels deleteLabel = ctx.ProjectLabels.FirstOrDefault(l => l.Id == label.Id);
if (deleteLabel != null)
{
ctx.ProjectLabels.Remove(deleteLabel);
ctx.SaveChanges();
}
}
}
}
public void DeleteClaimedObject(int claimedObjectId)
{
using (var ctx = new smbimContext())
{
try
{
var claimedObject = ctx.ClaimedObjects.Single(x => x.Id == claimedObjectId);
ctx.ClaimedObjects.Remove(claimedObject);
ctx.SaveChanges();
}
catch (InvalidOperationException)
{
throw new ApplicationException("Claimed Object does not exist");
}
}
}
public void DeleteIgnoredDatabaseObject(int id)
{
using (var ctx = new smbimContext())
{
try
{
var ignoredObjectRecord = ctx.IgnoredObjects.Single(x => x.Id == id);
ctx.IgnoredObjects.Remove(ignoredObjectRecord);
ctx.SaveChanges();
}
catch (InvalidOperationException)
{
throw new ApplicationException("Ignored Object Record Not Found.");
}
}
}
public void AddLabel(ProjectLabelDomain label)
{
if (label == null)
{
return;
}
using (var ctx = new smbimContext())
{
var insertLabel = new ProjectLabels
{
Name = label.Name,
ReleaseDate = label.ReleaseDate,
IsJunk = label.IsJunk
};
ctx.ProjectLabels.Add(insertLabel);
ctx.SaveChanges();
}
}
public void AddIgnoredDatabaseObject(string objectName, string objectSchema, string objectDatabase,
string userName)
{
using (var ctx = new smbimContext())
{
var ignoredObjectRecord = new IgnoredObjects
{
IgnoredByTime = DateTime.Now,
IgnoredByUser = userName,
ObjectName = objectName,
ObjectSchema = objectSchema,
ObjectDatabase = objectDatabase
};
ctx.IgnoredObjects.Add(ignoredObjectRecord);
ctx.SaveChanges();
}
}
public void UpdateLabel(ProjectLabelDomain label)
{
if (label == null)
{
return;
}
using (var ctx = new smbimContext())
{
var editLabel = ctx.ProjectLabels.FirstOrDefault(l => l.Id == label.Id);
if (editLabel == null)
{
return;
}
editLabel.Name = label.Name;
editLabel.ReleaseDate = label.ReleaseDate;
editLabel.IsJunk = label.IsJunk;
ctx.SaveChanges();
}
}
public void ClaimAuditRecord(string userName, DateTime?releaseDate, string objectName, string objectSchema,
string objectDatabase, string objectType, string notes, int projectLabelId)
{
if (releaseDate == null && projectLabelId == 0)
{
throw new ArgumentException("Either a release date or project label is needed.");
}
if (string.IsNullOrEmpty(userName))
{
throw new ArgumentException("User is required.");
}
if (string.IsNullOrEmpty(objectName))
{
throw new ArgumentException("Object Name is required.");
}
if (string.IsNullOrEmpty(objectSchema))
{
throw new ArgumentException("Object Schema is required.");
}
if (string.IsNullOrEmpty(objectDatabase))
{
throw new ArgumentException("Object Database is required.");
}
using (var ctx = new smbimContext())
{
var claimedObject = new ClaimedObjects
{
Username = userName,
ReleaseDate = releaseDate?.Date,
ObjectName = objectName,
ObjectSchema = objectSchema,
ObjectDatabase = objectDatabase,
ObjectType = objectType,
Notes = notes,
ProjectLabelId = projectLabelId == 0 ? (int?)null : projectLabelId
};
ctx.ClaimedObjects.Add(claimedObject);
ctx.SaveChanges();
}
}
