//check UserName is exist or not and check secquestion and answer exits or not
public int checkUser(DAUsers dausr)
{
con.Open();
SqlCommand cmd = new SqlCommand("select count(*) from Login where Username=@Username and SecQuestion=@SecQuestion and Answer=@Answer ", con);
cmd.Parameters.AddWithValue("@Username", dausr.Username);
cmd.Parameters.AddWithValue("@SecQuestion", dausr.SecQuestion);
cmd.Parameters.AddWithValue("@Answer", dausr.Answer);
int countUserCheck = (int)cmd.ExecuteScalar();
con.Close();
return countUserCheck;
}
//validate the user credentials and status should be Enable
public int LoginUserAuthentication(DAUsers dausr)
{
SqlCommand cmd = new SqlCommand("select count(*) from Login where Username=@Username and Password=@Password and Status=@Status", con);
con.Open();
cmd.Parameters.AddWithValue("@Username", dausr.Username);
cmd.Parameters.AddWithValue("@Password", dausr.Password);
cmd.Parameters.AddWithValue("@Status", "Enabled");
int i = (int)cmd.ExecuteScalar();
con.Close();
return i;
}
//if three user inputs are matched with users table and password is sent to user registerd email address.
private void SendPasswordtoEmail(DAUsers usrs)
{
string email=usrs.GetEmailId(usrs);
string HostAdd = ConfigurationManager.AppSettings["Host"].ToString(); //host name is gmail or yahoo or outlook
string FromMailId = ConfigurationManager.AppSettings["FromMail "].ToString(); //sender email addresss
string Password = ConfigurationManager.AppSettings["Password"].ToString(); //sender email password
MailMessage mail = new MailMessage();
mail.From = new MailAddress(FromMailId);
mail.Subject = "Login password"; //subject of email
mail.Body = "Hello " + usrs.Name + Environment.NewLine + "Your Login password:"******"Click here go to Login Page"+"http://localhost:1033/Login.aspx";
mail.IsBodyHtml = true;
mail.To.Add(new MailAddress(email));
SmtpClient smtp = new SmtpClient();
smtp.Host = HostAdd;
smtp.EnableSsl = true;
NetworkCredential networkcred = new NetworkCredential();
networkcred.UserName = mail.From.Address;
networkcred.Password = Password;
smtp.UseDefaultCredentials = true;
smtp.Credentials = networkcred;
smtp.Port = 587;
try
{
smtp.Send(mail);
lblmsg.Text = "your password is send to Registerd email";
lblmsg.ForeColor = Color.Green;
ClearControlsData(Page.Controls);
}
catch(Exception ex)
{
lblmsg.Text = "your password is not sent to registerd email address";
lblmsg.ForeColor = Color.Red;
ClearControlsData(Page.Controls);
}
}
//insert the user details in Login Table
public int insertUserDetails(DAUsers dausrs)
{
SqlCommand cmd = new SqlCommand("insert into Login(LoginId,Name,Phno,email,Username,Password,SecQuestion,Answer) values(@LoginId,@Name,@Phno,@email,@Username,@Password,@SecQuestion,@Answer)", con);
cmd.Parameters.AddWithValue("@LoginId",(int)dausrs.LoginId);
cmd.Parameters.AddWithValue("@Name",dausrs.Name);
cmd.Parameters.AddWithValue("@Phno",dausrs.Phno);
cmd.Parameters.AddWithValue("@email", dausrs.Email);
cmd.Parameters.AddWithValue("@Username", dausrs.Username);
cmd.Parameters.AddWithValue("@Password", dausrs.Password);
cmd.Parameters.AddWithValue("@SecQuestion", dausrs.SecQuestion);
cmd.Parameters.AddWithValue("@Answer", dausrs.Answer);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
return i;
}
//Retrive the password from table based on username,security question and answer.
public string GetPassword(DAUsers dausr)
{
SqlCommand cmd = new SqlCommand("Select Password from Login where Username=@Username and SecQuestion=@SecQuestion and Answer=@Answer", con);
con.Open();
cmd.Parameters.AddWithValue("@Username", dausr.Username);
cmd.Parameters.AddWithValue("SecQuestion", dausr.SecQuestion);
cmd.Parameters.AddWithValue("@Answer", Answer);
SqlDataReader dr = cmd.ExecuteReader();
string password="";
if (dr.Read())
password = dr[0].ToString();
con.Close();
return password;
}
public int GetLoginId(DAUsers dausr)
{
con.Open();
SqlCommand cmd = new SqlCommand("Select LoginId from Login where Username=@Username", con);
cmd.Parameters.AddWithValue("@Username", dausr.Username);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
LoginId =Convert.ToInt32(dr[0]);
con.Close();
return LoginId;
}
//retrive the imageapath from users table
public string getImage(DAUsers dausr)
{
con.Open();
SqlCommand cmd = new SqlCommand("Select PhotoPath from Login where Username=@Username", con);
cmd.Parameters.AddWithValue("@Username", dausr.Username);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
Imagepath = dr[0].ToString();
con.Close();
return Imagepath;
}
//Retrive email address from users table
public string GetEmailId(DAUsers dausr)
{
string EmailId="";
con.Open();
SqlCommand cmd = new SqlCommand("Select email from Login where Username=@Username", con);
cmd.Parameters.AddWithValue("@Username", dausr.Username);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
EmailId = dr[0].ToString();
con.Close();
return EmailId;
}
