public override async Task GrantResourceOwnerCredentials(OAuthGrantResourceOwnerCredentialsContext context)
{
var identity = new ClaimsIdentity(context.Options.AuthenticationType);
using (var db = new UserLoginEntities())
{
if (db != null)
{
var user = db.Login.Where(o => o.Email == context.UserName && o.Password == context.Password).FirstOrDefault();
if (user != null)
{
identity.AddClaim(new Claim(ClaimTypes.Role, user.UserRole));
identity.AddClaim(new Claim(ClaimTypes.Email, user.Email));
identity.AddClaim(new Claim("LoggedOn", DateTime.Now.ToString()));
await Task.Run(() => context.Validated(identity));
}
else
{
context.SetError("Wrong Crendtials", "Provided username and password is incorrect");
}
}
else
{
context.SetError("Wrong Crendtials", "Provided username and password is incorrect");
}
return;
}
}
protected void btn1_click(object sender, EventArgs e)
{
UserLoginManager userLoginManager = new UserLoginManager();
UserLoginEntities user = userLoginManager.loginuser(txtuname.Text, txtpassword.Text);
if (user != null)
{
hfUserID.Value = user.id.ToString();
namehide.Value = user.Name.ToString();
familyhide.Value = user.Family.ToString();
phonehide.Value = user.Phone.ToString();
emailhise.Value = user.Email.ToString();
addresshide.Value = user.Address.ToString();
genderhide.Value = user.Gender.ToString();
Response.Cookies["Cookies3"]["id"] = hfUserID.Value;
Response.Cookies["Cookies3"]["name"] = namehide.Value;
Response.Cookies["Cookies3"]["family"] = familyhide.Value;
Response.Cookies["Cookies3"]["phone"] = phonehide.Value;
Response.Cookies["Cookies3"]["email"] = emailhise.Value;
Response.Cookies["Cookies3"]["address"] = addresshide.Value;
Response.Cookies["Cookies3"]["gender"] = genderhide.Value;
Response.Cookies["Cookies3"]["username"] = txtuname.Text;
Response.Cookies["Cookies3"]["password"] = txtpassword.Text;
Response.Cookies["StudentCookies"].Expires = DateTime.Now.AddDays(1);
Response.Redirect("Profile.aspx");
}
UserLoginManager userLoginManager1 = new UserLoginManager();
UserLoginEntities user1 = userLoginManager1.loginuser1(txtuname.Text, txtpassword.Text);
if (user1 != null)
{
Response.Cookies["Cookies4"]["id"] = user1.id.ToString();
Response.Cookies["Cookies4"]["Email"] = user1.Email.ToString();
Response.Cookies["Cookies4"]["password"] = user1.Password.ToString();
Response.Cookies["DCookies"].Expires = DateTime.Now.AddDays(1);
Response.Redirect("AccessPart.aspx");
}
UserLoginManager userLoginManager2 = new UserLoginManager();
UserLoginEntities user2 = userLoginManager2.loginuser2(txtuname.Text, txtpassword.Text);
if (user2 != null)
{
Response.Cookies["Cookies5"]["id"] = user2.id.ToString();
Response.Cookies["Cookies5"]["Email"] = user2.Email.ToString();
Response.Cookies["Cookies5"]["password"] = user2.Password.ToString();
Response.Cookies["ACookies"].Expires = DateTime.Now.AddDays(1);
Response.Redirect("LabManage.aspx");
}
else
{
Response.Write("<script>alert('اطلاعات شما صحیح نیست');</script>");
}
}
public UserLoginEntities loginuser1(string p1, string p2)
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog = DigiService;Integrated Security = False ;User ID = Digiservice ; Password = fereshte7835;");
SqlCommand com = new SqlCommand("select id, Email , Password from HeadNameLaB where Email='" + p1 + "' and Password ='******'", con);
SqlParameter lanquageParameter = com.Parameters.Add("@p1", System.Data.SqlDbType.NVarChar);
lanquageParameter.Value = p1;
SqlParameter lanquageParameter1 = com.Parameters.Add("@p2", System.Data.SqlDbType.NVarChar);
lanquageParameter1.Value = p2;
UserLoginEntities tmpuser = null;
try
{
con.Open();
//3. Read Data
SqlDataReader sqlDataReader = com.ExecuteReader();
while (sqlDataReader.Read())
{
tmpuser = new UserLoginEntities();
tmpuser.id = sqlDataReader.GetInt32(0);
if (sqlDataReader.IsDBNull(1) == false)
{
tmpuser.Email = sqlDataReader.GetString(1);
}
if (sqlDataReader.IsDBNull(2) == false)
{
tmpuser.Password = sqlDataReader.GetString(2);
}
}
con.Close();
}
catch (SqlException sqlException)
{
con.Close();
return(null);
}
return(tmpuser);
}
public ActionResult Index(LoginInfo u)
{
//this action is for handle post (login)
if (ModelState.IsValid)
{
using (UserLoginEntities dc = new UserLoginEntities())
{
var v = dc.LoginInfoes.Where(a => a.Username.Equals(u.Username) && a.Userpw.Equals(u.Userpw)).FirstOrDefault();
if (v != null)
{
Session["logedUserID"] = v.Id.ToString();
Session["LogedUsername"] = v.Username.ToString();
return(RedirectToAction("Chart"));
}
}
}
ViewBag.Message = "Invalid User and Password Combination";
return(View(u));
}
public UserLoginEntities loginuser(string username, string password)
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog = DigiService;Integrated Security = False ;User ID = Digiservice ; Password = fereshte7835;");
SqlCommand com = new SqlCommand("select * from UserRegistration where Username='******' and Password ='******'", con);
SqlParameter lanquageParameter = com.Parameters.Add("@username", System.Data.SqlDbType.NVarChar);
lanquageParameter.Value = username;
SqlParameter lanquageParameter1 = com.Parameters.Add("@password", System.Data.SqlDbType.NVarChar);
lanquageParameter1.Value = password;
UserLoginEntities tmpuser = null;
try
{
con.Open();
//3. Read Data
SqlDataReader sqlDataReader = com.ExecuteReader();
while (sqlDataReader.Read())
{
tmpuser = new UserLoginEntities();
tmpuser.id = sqlDataReader.GetInt32(0);
if (sqlDataReader.IsDBNull(1) == false)
{
tmpuser.Name = sqlDataReader.GetString(1);
}
if (sqlDataReader.IsDBNull(2) == false)
{
tmpuser.Family = sqlDataReader.GetString(2);
}
if (sqlDataReader.IsDBNull(3) == false)
{
tmpuser.Phone = sqlDataReader.GetString(3);
}
if (sqlDataReader.IsDBNull(4) == false)
{
tmpuser.Email = sqlDataReader.GetString(4);
}
if (sqlDataReader.IsDBNull(5) == false)
{
tmpuser.Address = sqlDataReader.GetString(5);
}
if (sqlDataReader.IsDBNull(6) == false)
{
tmpuser.Gender = sqlDataReader.GetString(6);
}
if (sqlDataReader.IsDBNull(7) == false)
{
tmpuser.Username = sqlDataReader.GetString(7);
}
if (sqlDataReader.IsDBNull(8) == false)
{
tmpuser.Password = sqlDataReader.GetString(8);
}
}
con.Close();
}
catch (SqlException sqlException)
{
con.Close();
return(null);
}
return(tmpuser);
}
