public bool IsValidUser(MyLogin lg) { if (_sqlconn.State == System.Data.ConnectionState.Closed) { _sqlconn.Open(); } SqlCommand _cmd = new SqlCommand("SELECT COUNT(*) FROM TBLOGIN WHERE UNAME =@UNAME AND UPASS =@UPASS", _sqlconn); _cmd.Parameters.Add("@UNAME", lg.UserName); _cmd.Parameters.Add("@UPASS", lg.UserPassword); int i = int.Parse(_cmd.ExecuteScalar().ToString()); _sqlconn.Close(); return(i > 0?true:false); }
public void InsertLoginUser(MyLogin lg) { if (_sqlconn.State == System.Data.ConnectionState.Closed) { _sqlconn.Open(); } SqlCommand _cmd = new SqlCommand("INSERT INTO tbLogin VALUES(@RID,@USERNAME,@UPASS)", _sqlconn); _cmd.Parameters.AddWithValue("@ID", lg.UserRole); _cmd.Parameters.AddWithValue("@UNAME", lg.UserName); _cmd.Parameters.AddWithValue("@UPASS", lg.UserPassword); _cmd.ExecuteNonQuery(); _sqlconn.Close(); }