public static void ChangeDocument(int id, string name, int docType)
{
Document doc = databaseContext.Documents.Where(a => a.id == id).First();
databaseContext.Entry(doc).State = System.Data.Entity.EntityState.Modified;
if (name != doc.Name)
{
doc.Name = name;
}
else
{
databaseContext.Entry(doc).Property(x => x.Name).IsModified = false;
}
if (doc.DocType != docType)
{
doc.DocType = docType;
}
else
{
databaseContext.Entry(doc).Property(x => x.DocType).IsModified = false;
}
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
}
public static void ChangePoint(int id, string name, int category)
{
Point point = databaseContext.Points.Where(a => a.id == id).First();
databaseContext.Entry(point).State = System.Data.Entity.EntityState.Modified;
if (point.Name != name)
{
point.Name = name;
}
else
{
databaseContext.Entry(point).Property(x => x.Name).IsModified = false;
}
if (point.CategoryID != category)
{
point.CategoryID = category;
}
else
{
databaseContext.Entry(point).Property(x => x.CategoryID).IsModified = false;
}
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
GetPointsList(true);
}
public static void DeletePointDocConnection(int id)
{
PointDocConnection connection = databaseContext.PointDocConnections.Where(a => a.id == id).First();
databaseContext.Entry(connection).State = System.Data.Entity.EntityState.Deleted;
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
}
//==============POINT DOC CONNECTION==============
public static void CreatePointDocConnection(int pointID, int docID)
{
PointDocConnection connection = new PointDocConnection(pointID, docID);
databaseContext.PointDocConnections.Add(connection);
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
}
public static void DeletePoint(int id)
{
Point point = databaseContext.Points.OrderByDescending(a => a.id).First();
databaseContext.Entry(point).State = System.Data.Entity.EntityState.Deleted;
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
GetPointsList(true);
}
public static void DeletePointType(int id)
{
PointType type = databaseContext.PointTypes.Where(a => a.id == id).First();
databaseContext.Entry(type).State = System.Data.Entity.EntityState.Deleted;
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
GetPointTypes(true);
}
//==============DOC TYPE==============
public static void CreateNewDocType(string name)
{
DocumentType type = new DocumentType(name);
databaseContext.DocumentTypes.Add(type);
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
GetDocumentTypes(true);
}
public static void ChangeDocType(int id, string name)
{
DocumentType type = databaseContext.DocumentTypes.Where(a => a.id == id).First();
databaseContext.Entry(type).State = System.Data.Entity.EntityState.Modified;
type.Name = name;
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
GetDocumentTypes(true);
}
public static void RestoreDocumentHistory(int id, DateTime newTime)
{
string userName = System.Environment.UserName;
DocumentHistory history = databaseContext.DocumentHistories.Where(a => a.id == id).FirstOrDefault();
DocumentHistory restoredHistory = new DocumentHistory(history.DocumentID, history.DocumentBinary, newTime, userName, history.UserName);
databaseContext.DocumentHistories.Add(restoredHistory);
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
}
public static void CreateDocumentHistrory(int id, string filePath, DateTime newTime)
{
byte[] file = File.ReadAllBytes(filePath);
string userName = System.Environment.UserName;
string fileName = filePath.Substring(filePath.LastIndexOf("\\") + 1);
DocumentHistory entry = new DocumentHistory(id, file, newTime, userName, fileName);
databaseContext.DocumentHistories.Add(entry);
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
}
public static void DeleteDocument(int id)
{
List <PointDocConnection> connections = databaseContext.PointDocConnections.Where(a => a.DocumentID == id).ToList();
for (int i = 0; i < connections.Count; i++)
{
databaseContext.Entry(connections[i]).State = System.Data.Entity.EntityState.Deleted;
}
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
}
//==============DOCUMENT==============
public static void CreateDocument(string filePath, int type, string name)
{
Document doc = new Document(name, type);
databaseContext.Documents.Add(doc);
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
int latstDocID = GetLatestDocument();
CreateDocumentHistrory(latstDocID, filePath);
}
public static void DeleteDocumentHistory(HashSet <int> ids)
{
List <DocumentHistory> documentHistories = databaseContext.DocumentHistories.Where(a => ids.Contains(a.id)).ToList();
for (int i = 0; i < documentHistories.Count; i++)
{
databaseContext.Entry(documentHistories[i]).State = System.Data.Entity.EntityState.Deleted;
}
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
}
//==============POINT==============
public static void CreatePoint(string name, int category)
{
Point point = new Point(name, category);
PointType t = databaseContext.PointTypes.Where(a => a.id == category).First();
//point.PointType = t;
databaseContext.Points.Add(point);
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
GetPointsList(true);
}
public static void ChangeDocPointConnection(int docID, HashSet <int> pointsID)
{
foreach (var pointID in pointsID)
{
PointDocConnection connection = databaseContext.PointDocConnections.Where(a => a.DocumentID == docID && a.PointID == pointID).FirstOrDefault();
if (connection == null)
{
connection = new PointDocConnection(pointID, docID);
databaseContext.PointDocConnections.Add(connection);
}
else
{
databaseContext.Entry(connection).State = System.Data.Entity.EntityState.Deleted;
}
}
databaseContext.SaveChanges();
databaseContext = new PointDocumentationEntities();
}
public static void Initialize()
{
if (isTested && canConnect && databaseContext == null)
{
databaseContext = new PointDocumentationEntities();
userRole = new UserRole();
string userName = System.Environment.UserDomainName + "\\" + System.Environment.UserName;
for (int j = 0; j < tables.Count; j++)
{
var allPermissions = GetPermissions(userName, tables[j]);
userRole.AddPermissions(tables[j], allPermissions);
//List<string>
/*for (int i = 0; i < allPermissions.Count; i++)
* {
* var results = GetPermission(userName,tables[j], allPermissions[i]);
* }*/
}
#if DEBUG
FillTable();
#endif
}
}