public string GetEmail(string userID) { string email = ""; try { using (MySqlConnection conn = GetConnection()) { conn.Open(); DocsClass myFile = new DocsClass(); MySqlCommand cmd = new MySqlCommand("SELECT Email FROM users WHERE Id = @userID;", conn); cmd.Parameters.AddWithValue("@userID", userID); using (MySqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { email = reader["Email"].ToString(); } } } return(email); } catch (Exception ex) { System.ArgumentException argEx = new System.ArgumentException("Invalid Email", "User Email", ex); throw argEx; } }
public IActionResult UpdatePublicFile(string OwnerID, string OldFileName) { DocsClass file = new DocsClass { OwnerID = OwnerID, Myfilenames = OldFileName }; return(View(file)); }