public Boolean LoadImage(int newUID, int newHhId)
{
initSigFields(newUID, newHhId);
sqlLoadCmd.Parameters["@UID"].Value = newUID;
sqlConn.Open();
SqlDataReader reader = sqlLoadCmd.ExecuteReader();
int count = 0;
while (reader.Read())
{
sigUID = Convert.ToInt32(reader["UID"]);
sigHHId = Convert.ToInt32(reader["HhID"]);
sigDate = Convert.ToDateTime(reader["SigDate"]);
docPath = reader["DocPath"].ToString();
byte[] imgData = (byte[])reader["SigImage"];
sigImage = CCFBGlobal.byteArrayToImage(imgData);
sigStr = reader["SigString"].ToString();
sigCreated = Convert.ToDateTime(reader["Created"]);
sigCreatedBy = reader["CreatedBy"].ToString();
count++;
}
haveSig = (count == 1);
sqlConn.Close();
return(haveSig);
}