public void DeleteLabel(ProjectLabelDomain label) { if (label != null) { using (var ctx = new smbimAuditEntities()) { ProjectLabel 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 smbimAuditEntities()) { 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 smbimAuditEntities()) { 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 AddIgnoredDatabaseObject(string objectName, string objectSchema, string objectDatabase, string userName) { using (var ctx = new smbimAuditEntities()) { var ignoredObjectRecord = new IgnoredObject { IgnoredByTime = DateTime.Now, IgnoredByUser = userName, ObjectName = objectName, ObjectSchema = objectSchema, ObjectDatabase = objectDatabase }; ctx.IgnoredObjects.Add(ignoredObjectRecord); ctx.SaveChanges(); } }
public void AddLabel(ProjectLabelDomain label) { if (label == null) { return; } using (var ctx = new smbimAuditEntities()) { var insertLabel = new ProjectLabel { Name = label.Name, ReleaseDate = label.ReleaseDate, IsJunk = label.IsJunk }; ctx.ProjectLabels.Add(insertLabel); ctx.SaveChanges(); } }
public void UpdateLabel(ProjectLabelDomain label) { if (label == null) { return; } using (var ctx = new smbimAuditEntities()) { 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 smbimAuditEntities()) { var claimedObject = new ClaimedObject { 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(); } }