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