public ActionResult forgot_password(login_model forgot_password)
{
if (ModelState.IsValid)
{
MailMessage msg = new MailMessage();
msg.From = new MailAddress("*****@*****.**");
msg.To.Add("*****@*****.**");
msg.Subject = "Recover your Password";
msg.Body = ("Your Username is:" + "rihad789" + "<br/><br/>" + "Your Password is:" + "password");
msg.IsBodyHtml = true;
SmtpClient smt = new SmtpClient();
smt.Host = "smtp.gmail.com";
NetworkCredential ntwd = new NetworkCredential();
ntwd.UserName = "******"; //Your Email ID
ntwd.Password = "******"; // Your Password
smt.UseDefaultCredentials = true;
smt.Credentials = ntwd;
smt.Port = 587;
smt.EnableSsl = true;
smt.Send(msg);
}
return(View());
}
public ActionResult login(login_model login_model)
{
var key = "b14ca5898a4e4133bbce2ea2315a1916";
string email = login_model.email;
string password = login_model.password;
string connStr = ConfigurationManager.ConnectionStrings["QBDDBContex"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = conn.CreateCommand();
SqlCommand cmd2 = conn.CreateCommand();
SqlCommand cmd3 = conn.CreateCommand();
cmd.CommandText = "SELECT Name,Email FROM users where UserID=@userID and Password=@password";
cmd.Parameters.Add("@userID", SqlDbType.VarChar).Value = email;
cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = password;
cmd2.CommandText = "SELECT COUNT(*) FROM users where UserID=@userID and Password=@password";
cmd2.Parameters.Add("@userID", SqlDbType.VarChar).Value = email;
cmd2.Parameters.Add("@password", SqlDbType.VarChar).Value = password;
cmd3.CommandText = "SELECT COUNT(*) FROM users where UserID=@userID";
cmd3.Parameters.Add("@userID", SqlDbType.VarChar).Value = email;
cmd3.Parameters.Add("@password", SqlDbType.VarChar).Value = password;
SqlDataReader myreader;
if (ModelState.IsValid == true)
{
conn.Open();
int email_count = (int)cmd3.ExecuteScalar();
int user_count = (int)cmd2.ExecuteScalar();
if (email_count == 1)
{
if (user_count == 1)
{
try
{
myreader = cmd.ExecuteReader();
while (myreader.Read())
{
string name = myreader["Name"].ToString();
string userID = myreader["Email"].ToString();
Session["DisplayName"] = name;
Session["userID"] = EncryptString(key, userID);
}
return(RedirectToAction("Index", "Home"));
}
catch (Exception)
{
ModelState.AddModelError("password", "Somethingt is wrong.Please try again");
}
}
else
{
ModelState.AddModelError("password", "Password don;t match");
}
}
else
{
ModelState.AddModelError("Email", "Email not found.Please register");
}
}
return(View());
}
