public static int UpdateDocumentVersionDB(string documentId, int version, string uploaderName) { WhiteBears.DatabaseHelper dh = new WhiteBears.DatabaseHelper(); return(dh.RunInsertQuery($"INSERT INTO DocumentVersion VALUES('{version}','{documentId.ToString()}','{DateTime.Now}','{uploaderName}')")); }
public static int UpdateDocumentRoleDB(string role, string documentId) { WhiteBears.DatabaseHelper dh = new WhiteBears.DatabaseHelper(); return(dh.RunInsertQuery($"INSERT INTO DocumentRole VALUES('{role}','{documentId}', 1)")); }
public static int InsertDocumentDB(string pID, string fileName, string uploaderName, string fileExt) { WhiteBears.DatabaseHelper dh = new WhiteBears.DatabaseHelper(); return(dh.RunInsertQuery($"INSERT INTO Document(ProjectID,FileName,Uploader,CreationTime,fileExtension) VALUES('{pID}','{fileName}','{uploaderName}','{DateTime.Now}','{fileExt}')")); }