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();
}
