ASP.NET

CREATE TABLE [dbo].[employees] (
    [Id]       INT           NOT NULL,
    [username] NVARCHAR (50) NULL,
    [ssn]      NCHAR (10)    NULL,
    [password] NCHAR (10)    NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

CREATE TABLE [dbo].[members] (
    [Id]       INT           NOT NULL,
    [username] NVARCHAR (50) NULL,
    [ssn]      NCHAR (10)    NULL,
    [password] NVARCHAR (50) NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

INSERT INTO [dbo].[members] ([Id], [username], [ssn], [password]) VALUES (1, N'name3', N'123456700 ', N'pass3')
INSERT INTO [dbo].[members] ([Id], [username], [ssn], [password]) VALUES (2, N'nameOne', N'123456789 ', N'passOne')
INSERT INTO [dbo].[members] ([Id], [username], [ssn], [password]) VALUES (3, N'nameTwo', N'987654321 ', N'passTwo')

INSERT INTO [dbo].[employees] ([Id], [username], [ssn], [password]) VALUES (1, N'name1', N'123456789 ', N'pass1     ')
INSERT INTO [dbo].[employees] ([Id], [username], [ssn], [password]) VALUES (2, N'name2', N'987654321 ', N'pass2     ')

Arun Radhakrishnan wrote:

If possible can you share your table data and structure ?

kaushikpathak wrote:

In addition sessions will not work locally or on the server unless you are
running https (note the S on the end of https),

if (user & password match from full query)
      {
          return string = "full status"
      }
      else
      {
          return string = "trial status"
      }

public User trial(string username, string password)
        {
            string[] roles = new string[] { "trial"};
            var query = from s in db.Subs
                        join u in db.Cust on s.sUID equals u.uID
                        where s.sExpiryDate >= DateTime.Now &&
                        u.uUsername == username &&
                        u.uPassword == password
                        select u; 
            return query.FirstOrDefault();
        }
		
		
        public User full(string username, string password)
        {
            string[] roles = new string[] { "full"};
            var query = from s in db.Subs
                        join u in db.Cust on s.sUID equals u.uID
                        u.uUsername == username &&
                        u.uPassword == password
                        select u;
            return query.FirstOrDefault();
        }