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}')"));
}