//EMAIL VERIFICATION
public void SendVerificationEmail(string name, string email, string id)
{
string url = Environment.GetEnvironmentVariable("EMAIL_VERIFICATION_URL") + id; //YOUR FRONTEND URL, MAKE SURE TO PASS THE API SUBSCRIPTION KEY AS HEADER AS WELL
SendgridEmailProvider sendgridEmailProvider = new SendgridEmailProvider();
sendgridEmailProvider.Send("*****@*****.**", "Shanty", email, name, "Shanty - Verification", "Confirmation Email for Your Shanty Account", "<strong>Confirm Your Email Address: <u><a href=" + url + " target=\"_blank\">Click Here</a></u></strong>");
}
public void SendArtistVerificationEmail(string name, string email, string id, string pass)
{
string url = Environment.GetEnvironmentVariable("EMAIL_VERIFICATION_URL") + id; //YOUR FRONTEND URL, MAKE SURE TO PASS THE API SUBSCRIPTION KEY AS HEADER AS WELL
SendgridEmailProvider sendgridEmailProvider = new SendgridEmailProvider();
sendgridEmailProvider.Send("*****@*****.**", "Shanty", email, name, "Shanty - Artist Verification", "Confirmation Email for Your Shanty Artist Account", "<strong>Your Email: " + email + "</strong><br><strong>Your Password: "******"</strong><br><strong>Confirm Your Email Address: <u><a href=" + url + " target=\"_blank\">Click Here</a></u></strong><br><strong>Note: Please Reset Your Password after Verifaction!</strong>");
}
//RESET OR CHANGE PASSWORD
public string SendOtpForPassReset(string otp, string email)
{
bool IsEmailTaken(string email)
{
MysqlConnectionProvider dbConnection = new MysqlConnectionProvider();
dbConnection.CreateQuery("SELECT COUNT(*) AS \"COUNTER\" FROM users WHERE email='" + email + "'");
MySqlDataReader reader = dbConnection.DoQuery();
string counter = "";
while (reader.Read())
{
counter = reader["COUNTER"].ToString();
}
dbConnection.Dispose();
return(!counter.Equals("0"));
}
if (!IsEmailTaken(email))
{
return("Email Not Found");
}
SendgridEmailProvider sendgridEmailProvider = new SendgridEmailProvider();
sendgridEmailProvider.Send("*****@*****.**", "Shanty", email, "User", "Shanty - OTP", "OTP for Password Reset", "<strong>OTP: " + otp + "</strong>");
MysqlConnectionProvider dbConnection = new MysqlConnectionProvider();
dbConnection.CreateQuery("SELECT id,isemailverified FROM users WHERE email='" + email + "'");
UserLoginResponseModel userLoginResponseModel = null;
string isEmailVerified = "";
MySqlDataReader reader = dbConnection.DoQuery();
while (reader.Read())
{
userLoginResponseModel = new UserLoginResponseModel();
userLoginResponseModel.Id = reader["id"].ToString();
isEmailVerified = reader["isemailverified"].ToString();
}
dbConnection.Dispose();
dbConnection = null;
if (userLoginResponseModel != null)
{
if (isEmailVerified == "false")
{
return("Email Not Verified");
}
return(new JwtAuthenticationProvider().GenerateJsonWebToken(userLoginResponseModel));
}
return("");
}
