public async Task <String> removeuser(String allusernames) { ARAVIND_DBEntities records = new ARAVIND_DBEntities(); if (allusernames == null) { return("0"); } else { string [] usernames = allusernames.Split('$'); for (int i = 0; i < usernames.Length; i++) { if (usernames[i] != null) { try { string temp = usernames[i]; System_Users user = await records.System_Users.FindAsync(temp); records.System_Users.Remove(user); await records.SaveChangesAsync(); } catch (Exception e) { return("1"); } } } return("1"); } }
public string getpermissions(string _username, string _password) { ARAVIND_DBEntities records = new ARAVIND_DBEntities(); foreach (var record in records.System_Users) { if ((record.Username.Equals(_username)) && (record.Password.Equals(_password))) { return(record.Questions_Update + " " + record.View_Results + " " + record.New_Signup); } } return(null); }
public bool IsValid(string _username, string _password) { ARAVIND_DBEntities records = new ARAVIND_DBEntities(); bool b = false; foreach (var record in records.System_Users) { //var pass = SHA1.Encode(_password); if ((record.Username.Equals(_username)) && (record.Password.Equals(_password))) { b = true; break; } else { b = false; } } return(b); }
public async Task <String> adduser(String username, String password, String questionsupdate, String getresults, String newsignup) { int flag = 0; ARAVIND_DBEntities record = new ARAVIND_DBEntities(); System_Users user = new System_Users(); user.Username = username; user.Password = SHA1.Encode(password); user.Questions_Update = questionsupdate; user.View_Results = getresults; user.New_Signup = newsignup; try { record.System_Users.Add(user); await record.SaveChangesAsync(); return("1"); } catch (Exception e) { return("0"); } }
public IQueryable <System_Users> getallusernames() { ARAVIND_DBEntities records = new ARAVIND_DBEntities(); return(records.System_Users); }