public bool UpdatePerson(string PersonID, bool PictureChanged = false) { bool ok = true; OleDbConnection cn = new OleDbConnection(); try { cn.ConnectionString = cnString; cn.Open(); if (PictureChanged) { //sqlString = "UPDATE PersonTable SET Title='" + Title + "',FName='" + FullName + "',Gender='" + Gender + "',Img='" + PassportImage + "' WHERE ID=" + PersonID + ""; sqlString = "UPDATE PersonTable SET Img=" + PassportImage.Trim() + " WHERE ID=" + PersonID + ""; } else { sqlString = "UPDATE PersonTable SET Title='" + Title + "',FName='" + FullName + "',Gender='" + Gender + "' WHERE ID=" + PersonID + ""; } OleDbCommand cmd = new OleDbCommand(sqlString, cn); cmd.ExecuteNonQuery(); } catch (Exception n) { ok = false; } finally { cn.Close(); } return(ok); }
async private void LoadJson() { // ReadData IdCard using (System.IO.StreamReader r = new System.IO.StreamReader("mockData\\passport_mock.json")) { passportModelJson = new PassportModel(); var json = r.ReadToEnd(); var jsonModel = JsonConvert.DeserializeObject <PassportModel>(json); if (jsonModel != null) { jsonModelEncode = encodeData(JsonConvert.SerializeObject(jsonModel)); passportModelJson = jsonModel; } } using (System.IO.StreamReader r = new System.IO.StreamReader("mockData\\passport_mock_image.json")) { jsonPassportImage = new PassportImage(); var image = r.ReadToEnd(); var jsonConvert = JsonConvert.DeserializeObject <PassportImage>(image); Debug.WriteLine(jsonConvert); jsonPassportImage = jsonConvert; } await WaitFormAsync(2000); ReturnMessageToClient(); await WaitFormAsync(1000); CloseForm(); }