public bool RegisterUID(string value)
{
AdminCreds admin = new AdminCreds();
UIDdetails obj = JsonConvert.DeserializeObject <UIDdetails>(value);
var cloudinaryURL = storeUID(obj);
if (!String.IsNullOrEmpty(cloudinaryURL))
{
string user_id = JsonConvert.SerializeObject(obj);
string encoded_user_id = Convert.ToBase64String(Encoding.UTF8.GetBytes(obj.uid));
string councelorEmail = "*****@*****.**";
string emailSubject = "Verification for UID: " + obj.uid;
string emailbody = "<table align='center' cellspacing='0' style='border:none!important;margin: none !important;' width='auto'>" +
"<tr><td colspan='2' bgcolor='#016648' style='text-align: center; padding-top: 10px;'> <img style='border: 2px solid white; border-radius: 5px; width: 130px;' src='https://cdn0.vox-cdn.com/thumbor/nxgcGlGlYmGUiZZzGWDm2nve4Bk=/0x0:547x365/1310x873/cdn0.vox-cdn.com/uploads/chorus_image/image/33573117/Rocky_The_Bull.0.jpg'></td></tr>" +
"<tr><td colspan='2' bgcolor='#016648' style='color: white; font-size: 300%; padding: 10px; text-align:center;'><span style='width: 100%;'>Bulls Allowed to Booze</span></td></tr>" +
"<tr><td style='padding: 5px;'> Hello Councelor, </td><td style='padding: 5px; text-align: center;'> </td></tr>" +
"<tr><td style='padding: 5px;'> </td><td style='padding: 5px; text-align: center;'> </td></tr>" +
"<tr><td style='padding: 5px;'> Please verify the following UID details: </td><td style='padding: 5px; text-align: center;'> </td></tr>" +
"<tr><td style='padding: 5px;'> </td><td style='padding: 5px; text-align: center;'> </td></tr>" +
"<tr><td style='padding: 5px;'> UID: </td><td style='padding: 5px; text-align: center;'>" + obj.uid + "</td></tr>" +
"<tr><td style='padding: 5px;'> Given Name: </td><td style='padding: 5px; text-align: center;'>" + obj.given_name + "</td></tr>" +
"<tr><td style='padding: 5px;'> Last Name: </td><td style='padding: 5px; text-align: center;'>" + obj.last_name + "</td></tr>" +
"<tr><td style='padding: 5px;'> Date of Birth: </td><td style='padding: 5px; text-align: center;'>" + obj.date_of_birth + "</td></tr>" +
"<tr><td style='padding: 5px;'> Photo: </td><td style='padding: 5px; text-align: center;'><img src = '" + cloudinaryURL + "' /></td></tr>" +
"<tr><td style='padding: 5px;'> Click link to Validate / Invalidate: </td><td style='padding: 5px; text-align: center;'><a href='http://localhost:55880/Verify.aspx?id=" + HttpUtility.UrlEncode(encoded_user_id) + "'>Validate / Invalidate</a></td></tr>" +
"<tr><td style='padding: 5px;'> </td><td style='padding: 5px; text-align: center;'> </td></tr>" +
"<tr><td style='padding: 5px;'> </td><td style='padding: 5px; text-align: center;'> </td></tr>" +
"<tr><td style='padding: 5px;'>Thanks,</td><td style='padding: 5px; text-align: center;'> </td></tr>" +
"<tr><td style='padding: 5px;'>Team Bulls Allowed to Booze</td><td style='padding: 5px; text-align: center;'> </td></tr>" +
"<tr><td colspan='2' bgcolor='#016648' style='padding:5px;'></td></tr>" +
"</table> ";
bool checkSendEmail = SendEmail(admin.email, admin.password, councelorEmail, emailSubject, emailbody, true);
if (checkSendEmail == true)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public string storeUID(UIDdetails userInfo)
{
string cloudinaryURL = uploadImage(userInfo.uid_image);
DateTime date_of_birth_obj = DateTime.ParseExact(userInfo.date_of_birth, "MM/dd/yyyy", CultureInfo.InvariantCulture);
Boolean data_stored;
string connectionconfig = ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
SqlConnection con = new SqlConnection(connectionconfig);
con.Open();
SqlCommand cmd = new SqlCommand("insert into register(uid,given_name,last_name,email,date_of_birth,date_of_birth_obj,uid_image,uid_verified) values(@uid,@given_name,@last_name,@email,@date_of_birth,@date_of_birth_obj,@uid_image,@uid_verified)", con);
cmd.Parameters.AddWithValue("@uid", userInfo.uid);
cmd.Parameters.AddWithValue("@given_name", userInfo.given_name);
cmd.Parameters.AddWithValue("@last_name", userInfo.last_name);
cmd.Parameters.AddWithValue("@email", userInfo.email);
cmd.Parameters.AddWithValue("@date_of_birth", userInfo.date_of_birth);
cmd.Parameters.AddWithValue("@date_of_birth_obj", date_of_birth_obj);
cmd.Parameters.AddWithValue("@uid_image", cloudinaryURL);
cmd.Parameters.AddWithValue("@uid_verified", userInfo.uid_verified);
try
{
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
data_stored = true;
}
else
{
data_stored = false;
}
con.Close();
if (data_stored)
{
return(cloudinaryURL);
}
else
{
return("");
}
}
catch (Exception e)
{
return("");
}
}
