public static string CheckUploadDocumentID(string fileName) { string id; WhiteBears.DatabaseHelper dh = new WhiteBears.DatabaseHelper(); DataRow[] a = dh.RunSelectQuery($"SELECT DocumentId FROM Document WHERE FileName = '{fileName}'"); return(a[0][0].ToString()); }
public static int CheckDocumentVersionDB(string fileName) { WhiteBears.DatabaseHelper dh = new WhiteBears.DatabaseHelper(); DataRow[] a = dh.RunSelectQuery($"SELECT MAX(version) FROM DocumentVersion JOIN Document ON Document.DocumentID = DocumentVersion.DocumentID WHERE FileName ='{fileName}'"); try { return(Convert.ToInt32(a[0][0])); } catch { return(0); } }