//======================================================== // This is for User Login public usr(string Login, string Psw) { Hashtable HT = DBFc.getDataHashtable("dbo.Users_getByLoginAndPassword@uLogin='******', @u_Password='******', @u_Flags", Glob.cnn); if (HT != null) { this.id = Convert.ToInt32(HT["id"]); this.uFlag = Convert.ToInt32(HT["u_flags"]); this.uName = HT["u_Name"].ToString(); this.uLogin = HT["u_Login"].ToString(); this.uEmail = HT["u_Email"].ToString(); this.uPassword = Psw; } }
//======================================================== not used private void getUserData() { string sql = ""; sql = sql + "SELECT * FROM Users WHERE"; if (uLogin != "") { sql += "u_Login = '******'"; } else if (uEmail != "") { sql += "u_Email = '" + uEmail + "'"; } Hashtable HT = DBFc.getDataHashtable(sql, Glob.cnn); }
//======================================================== public usr(int id) { if (id == 0) { init(); } else { Hashtable HT = DBFc.getDataHashtable( "SELECT * FROM dbo.Users WHERE u_ID='" + id.ToString() + "'", Glob.cnn); this.id = id; this.uFlag = Convert.ToInt32(HT["u_flags"]); this.uName = HT["u_Name"].ToString(); this.uLogin = HT["u_Login"].ToString(); this.uPassword = HT["u_Password"].ToString(); } }
protected void btnLogin_Click(object sender, EventArgs e) { string login = tblogin.Text; string pass = tbPass.Value; string sql = "SELECT * FROM Users WHERE u_Login = '******' AND u_Password = '******'"; Hashtable HT = DBFc.getDataHashtable(sql, Glob.cnn); if (HT != null) { usr U = new usr(); U.uLogin = HT["u_Login"].ToString(); U.uEmail = HT["u_Email"].ToString(); U.id = Convert.ToInt32(HT["u_ID"]); Session["usr"] = U; lblMessage.Text = "Logged in"; huName.Value = HT["u_Name"].ToString(); } else { lblMessage.Text = "Wrong login or password."; } }