public void SetDataUrl_with_no_data_tag()
{
var target = new PetitionResult();
target.sign_image_dataurl1 = @"iVBORw0KGgoAAAANSUhEUgAAASwAAABkCAYAAAA8AQ3AAAAGxElEQVR4Xu2cu6olRRSG5+odjUVBTAwVfAETAwPFwFAMBCPfQAwGAx9CEETEyEhMDHwGQQMDExERTEQU7zPOzFqwe9jTeE5X167qXn+tb0MxB3Z31VrfX+eb7j77nIsXeEEAAhAQIXBRpE7KhAAEIHABYbEJIAABGQIISyYqCoUABBAWewACEJAhgLBkoqJQCEAAYbEHIAABGQIISyYqCoUABHoJ678D2ssghgAEINCKAMJqRZJ5IACB7gR6CqvX3N2hsMBdBC7BAwJRCPSUyq0oTVLHyQR67pOTi2OCPATYiHmyrunUn0X6FRb7pIYe5zQnwEZsjnSoCa9bN1cQ1lCZSjeDsKTj6178D7bC4wirO2cWKCSAsApBJT7Mn0X+ZOPRxAxoPQgBhBUkiMBluLBu2LgauEZKS0IAYSUJ+oQ2XVg3bfAh4BMgcmobAgirDceRZ3Fh+eDzWCOnLNIbwhIJascy+TWrHeGz9N0EEBY7YokAwloixPubEUBYm6GWXQhhyUY3XuEIa7xMW3eEsFoTZb5qAgirGl2aExFWmqjjN4qw4me0d4UIa+8EWP8OAYTFZlgigLCWCPH+ZgQQ1maoZRdCWLLRjVc4whov09YdIazWRJmvmgDCqkaX5kSElSbq+I0irPgZ7V0hwto7AdbnoTt7oJgAwipGxYG9CXCF1Zuw/vwISz/DYTpAWMNE2a0RhNUNLROvJYCw1hLLdzzCypd52I4RVthowhSGsMJEQSEIiz2wRABhLRHi/c0IIKzNUMsuhLBkoxuvcIQ1XqatO0JYrYkyXzUBhFWNLs2JCCtN1PEbRVjxM9q7QoS1dwKsf4cAwmIzLBFAWEuEeH8zAghrM9SyCyEs2ejGKxxhjZdp644QVmuizFdNAGFVo0tzIsJKE3X8RhFW/Iz2rhBh7Z0A6/PQnT1QTABhFaPiwN4EuMLqTVh/fo
Sln+EwHSCsYaLs1gjC6oaWidcSQFhrieU7HmHlyzxsxwgrbDRhCrtllfi4FKYiCklLAGGljb64cZfVvzbuLT6DAyHQiQDC6gR2kGn/PohKaZ+4XK8U8OeKsQBStEOUNmI0dhnquWlN+h6Juk++tNqeqahxus29nCHEkXqMuhFHYqzcS7TnV78ZzIfOEKjL9SsbzxYA5wcJBZAiHoKwIqYSp6a9n1+9byhetzG/ffO6bti4pxIVwqoEt/dpCGvvBOKuv9fzKxeRC+p4b54qqDllhBV3351bGcISDW6Dsrd6fjU9JJ/vRZdKycPzGhQIq4ZagHOUhPW28XrJxlNH3O47fP1AAJajleBXNS6tHg+mXRjz2zxf6wMbb2wEsmd/G7WQb5mownrVonjBxos2Hj5sbt/Q/tD1uOZJWP4ZoT9tfGjjzXwxNu/YWd4/Y91ikemqzedyYfx+yLfF3DVzeA3T6/jr8+byHnpd+dX0kOqcSML6xsg/YcOvlvwb5vuDoD6zf98tSGW+4f6wc/wnSrzWE2h9O3gsKn9GdXV9SU3PeMxme9nG0zb8iv05G2s/l1UquNrC19ZTu47UeZGE9ZGR+9zGxycSfM/Of82GXyFML+S1Dqp/M/5l45Rb7U/s/FdsTHvsH/t6uiI+r5pr9ubzNp608YgNv3r229Jpnkh7dh3VdUdn6XMVlQxQ/LbjQeRVvC+m50s1e8Nl89ZBMtOCx1ciNXPOCz/rysav4nz4+9dtuCD9P6pfbPxs41sbX9v41MaPxTQ4MBSBFhsoVEMLxczl1fuyXonNVKvvif/j0mKvTPP6vy5Gl8qvNr6z8YWNdxSBUfN2BFpswu2qbbvSXF5tZx9vtrlsps9KHf/qDn/VYbzcQ3WUWVihgghSzHQ7uPYKq9fHH4JgoYwoBBBWlCTi1HHWbfL0e4X+Uz7+1EycvFJVgrBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2
zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQicBuPn5xlL8sr7wAAAABJRU5ErkJggg==";
Assert.NotEmpty(target.sign_image_bytes1);
Assert.NotEmpty(target.sign_image1);
}
public void SetDataUrl_with_no_data_tag()
{
var target = new PetitionResult();
target.sign_image_dataurl1 = @"iVBORw0KGgoAAAANSUhEUgAAASwAAABkCAYAAAA8AQ3AAAAGxElEQVR4Xu2cu6olRRSG5+odjUVBTAwVfAETAwPFwFAMBCPfQAwGAx9CEETEyEhMDHwGQQMDExERTEQU7zPOzFqwe9jTeE5X167qXn+tb0MxB3Z31VrfX+eb7j77nIsXeEEAAhAQIXBRpE7KhAAEIHABYbEJIAABGQIISyYqCoUABBAWewACEJAhgLBkoqJQCEAAYbEHIAABGQIISyYqCoUABHoJ678D2ssghgAEINCKAMJqRZJ5IACB7gR6CqvX3N2hsMBdBC7BAwJRCPSUyq0oTVLHyQR67pOTi2OCPATYiHmyrunUn0X6FRb7pIYe5zQnwEZsjnSoCa9bN1cQ1lCZSjeDsKTj6178D7bC4wirO2cWKCSAsApBJT7Mn0X+ZOPRxAxoPQgBhBUkiMBluLBu2LgauEZKS0IAYSUJ+oQ2XVg3bfAh4BMgcmobAgirDceRZ3Fh+eDzWCOnLNIbwhIJascy+TWrHeGz9N0EEBY7YokAwloixPubEUBYm6GWXQhhyUY3XuEIa7xMW3eEsFoTZb5qAgirGl2aExFWmqjjN4qw4me0d4UIa+8EWP8OAYTFZlgigLCWCPH+ZgQQ1maoZRdCWLLRjVc4whov09YdIazWRJmvmgDCqkaX5kSElSbq+I0irPgZ7V0hwto7AdbnoTt7oJgAwipGxYG9CXCF1Zuw/vwISz/DYTpAWMNE2a0RhNUNLROvJYCw1hLLdzzCypd52I4RVthowhSGsMJEQSEIiz2wRABhLRHi/c0IIKzNUMsuhLBkoxuvcIQ1XqatO0JYrYkyXzUBhFWNLs2JCCtN1PEbRVjxM9q7QoS1dwKsf4cAwmIzLBFAWEuEeH8zAghrM9SyCyEs2ejGKxxhjZdp644QVmuizFdNAGFVo0tzIsJKE3X8RhFW/Iz2rhBh7Z0A6/PQnT1QTABhFaPiwN4EuMLqTVh/fo
Sln+EwHSCsYaLs1gjC6oaWidcSQFhrieU7HmHlyzxsxwgrbDRhCrtllfi4FKYiCklLAGGljb64cZfVvzbuLT6DAyHQiQDC6gR2kGn/PohKaZ+4XK8U8OeKsQBStEOUNmI0dhnquWlN+h6Juk++tNqeqahxus29nCHEkXqMuhFHYqzcS7TnV78ZzIfOEKjL9SsbzxYA5wcJBZAiHoKwIqYSp6a9n1+9byhetzG/ffO6bti4pxIVwqoEt/dpCGvvBOKuv9fzKxeRC+p4b54qqDllhBV3351bGcISDW6Dsrd6fjU9JJ/vRZdKycPzGhQIq4ZagHOUhPW28XrJxlNH3O47fP1AAJajleBXNS6tHg+mXRjz2zxf6wMbb2wEsmd/G7WQb5mownrVonjBxos2Hj5sbt/Q/tD1uOZJWP4ZoT9tfGjjzXwxNu/YWd4/Y91ikemqzedyYfx+yLfF3DVzeA3T6/jr8+byHnpd+dX0kOqcSML6xsg/YcOvlvwb5vuDoD6zf98tSGW+4f6wc/wnSrzWE2h9O3gsKn9GdXV9SU3PeMxme9nG0zb8iv05G2s/l1UquNrC19ZTu47UeZGE9ZGR+9zGxycSfM/Of82GXyFML+S1Dqp/M/5l45Rb7U/s/FdsTHvsH/t6uiI+r5pr9ubzNp608YgNv3r229Jpnkh7dh3VdUdn6XMVlQxQ/LbjQeRVvC+m50s1e8Nl89ZBMtOCx1ciNXPOCz/rysav4nz4+9dtuCD9P6pfbPxs41sbX9v41MaPxTQ4MBSBFhsoVEMLxczl1fuyXonNVKvvif/j0mKvTPP6vy5Gl8qvNr6z8YWNdxSBUfN2BFpswu2qbbvSXF5tZx9vtrlsps9KHf/qDn/VYbzcQ3WUWVihgghSzHQ7uPYKq9fHH4JgoYwoBBBWlCTi1HHWbfL0e4X+Uz7+1EycvFJVgrBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2
zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQigLBSxU2zENAmgLC086N6CKQicBuPn5xlL8sr7wAAAABJRU5ErkJggg==";
Assert.NotEmpty(target.sign_image_bytes1);
Assert.NotEmpty(target.sign_image1);
}
public string InsertPetitionResult(PetitionResult pr)
{
var ret = "";
using (var conn = new NpgsqlConnection(connStr.Value))
{
conn.Open();
using (var cmd = new NpgsqlCommand("insert into rn_results (email, name, phone_no, daum_id, work_place, client_ip, sign_image1, sign_image2, insert_dt, sign_radio1, sign_radio2) values (:email, :name, :phone_no, :daum_id, :work_place, :client_ip, :sign_image1, :sign_image2, :insert_dt, :sign_radio1, :sign_radio2)", conn))
{
cmd.Parameters.Add(new NpgsqlParameter("email", pr.email));
cmd.Parameters.Add(new NpgsqlParameter("name", pr.name));
cmd.Parameters.Add(new NpgsqlParameter("phone_no", pr.phone_no));
cmd.Parameters.Add(new NpgsqlParameter("daum_id", ""));
cmd.Parameters.Add(new NpgsqlParameter("work_place", pr.work_place));
cmd.Parameters.Add(new NpgsqlParameter("client_ip", pr.client_ip));
cmd.Parameters.Add(new NpgsqlParameter("sign_image1", pr.sign_image1 ?? ""));
cmd.Parameters.Add(new NpgsqlParameter("sign_image2", pr.sign_image2 ?? ""));
cmd.Parameters.Add(new NpgsqlParameter("insert_dt", pr.insert_dt));
cmd.Parameters.Add(new NpgsqlParameter("sign_radio1", pr.sign_radio1));
cmd.Parameters.Add(new NpgsqlParameter("sign_radio2", pr.sign_radio2));
try
{
cmd.ExecuteNonQuery();
}
catch (NpgsqlException ex)
{
if (ex.Code == "23505")
{
ret = "email already exists";
}
else { throw; }
}
}
}
return ret;
}