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);
}
