public string Login()
{
SqlConnection con = new SqlConnection("Data Source=KUTTYCHATTAN-PC;Integrated Security=True");
string str;
con.Open();
str = "select * from Userlogin";
SqlCommand cmd = con.CreateCommand();
// cmd.Dispose();
//con.Close();
SqlDataReader rdr=cmd.ExecuteReader();
Logginuser logg =new Logginuser();
while(rdr.Read())
{
if(((logg.LoginID.Equals(rdr["LoginID"].ToString()))&&(((logg.Password.Equals(rdr["Password"].ToString())))
{
logg.LoginID=rdr["LoginID"].ToString();
logg.Password=rdr["Password"].ToString();
}
}
}
public string Login(string X_uname, string X_passwd)
{
SqlConnection con = new SqlConnection("Data Source=KUTTYCHATTAN-PC\\SQLEXPRESS;Initial Catalog=facebooklogin;Integrated Security=True");
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "select * from Userlogin";
// cmd.Dispose();
//con.Close();
SqlDataReader rdr = cmd.ExecuteReader();
Logginuser logg = new Logginuser();
logg.Username = X_uname;
logg.Password = X_passwd;
while (rdr.Read())
{
if ((logg.Username.Equals(rdr["username"].ToString())) && (logg.Password.Equals(rdr["Password"].ToString())))
{
logg.Firstname = rdr["Firstname"].ToString();
logg.Lastname = rdr["Lastname"].ToString();
logg.Username = rdr["Username"].ToString();
logg.LoginID = Convert.ToInt32(rdr["LogginId"].ToString());
logg.X_LoginID = logg.LoginID.ToString();
logg.Profilepic = rdr["Profilepic"].ToString();
string str = "LoginId:" + logg.LoginID + "Firstname:" + logg.Firstname + "Lastname:" + logg.Lastname + "Profilpic:" + logg.Profilepic + "Responsecode;200 Message;success";
return(str);
}
else if ((logg.Username.Equals(rdr["username"].ToString())) && (!(logg.Password.Equals(rdr["password"].ToString()))))
{
logg.Firstname = rdr["Firstname"].ToString();
logg.Lastname = rdr["Lastname"].ToString();
logg.Username = rdr["Username"].ToString();
logg.LoginID = Convert.ToInt32(rdr["LogginId"].ToString());
logg.X_LoginID = logg.LoginID.ToString();
logg.Profilepic = rdr["Profilepic"].ToString();
string str = "Responsecode;404 Message;Password incorrect";
return(str);
}
else if (!(logg.Username.Equals(rdr["Username"].ToString())) && (!(logg.Password.Equals(rdr["Password"].ToString()))))
{
logg.Firstname = rdr["Firstname"].ToString();
logg.Lastname = rdr["Lastname"].ToString();
logg.Username = rdr["Username"].ToString();
logg.LoginID = Convert.ToInt32(rdr["LogginId"].ToString());
logg.X_LoginID = logg.LoginID.ToString();
logg.Profilepic = rdr["Profilepic"].ToString();
string str = "Username:"******"Responsecode;500 Message;Email id doesnot exist";
return(str);
}
}
return(null);
}
