public List <DBObjChanges> getUniqueGITCommittablesByFolder(LocalRepoFolder locfldr)
{
using (var db = new DBChangesAuditEntities())
{
return(db.DBObjChanges.Where(q => q.BatchID == null).Where(q => q.BatchID == null &&
q.DBObjType == locfldr.DBObjType && q.DatabaseName == locfldr.DatabaseName &&
q.SchemaName == locfldr.SchemaName)
.OrderBy(o => o.ObjectName).ThenBy(o => o.ID)
.ToList());
}
}
public List <LocalRepoFolder> getUniqueFolders()
{
using (var db = new DBChangesAuditEntities())
{
return(db.DBObjChanges.Where(q => q.BatchID == null)
.GroupBy(g => new { g.DBObjType, g.DatabaseName, g.SchemaName })
.Select(s => new LocalRepoFolder
{
DBObjType = s.Key.DBObjType, DatabaseName = s.Key.DatabaseName, SchemaName = s.Key.SchemaName
})
.ToList());
}
}
public void saveGITCommittable(DBObjChanges doc)
{
using (var db = new DBChangesAuditEntities())
{
var result = db.DBObjChanges.SingleOrDefault(q => q.ID == doc.ID);
if (result != null)
{
result.WritingToGIT = doc.WritingToGIT;
result.BatchID = doc.BatchID;
result.GitLink = doc.GitLink;
db.SaveChanges();
}
}
}
