public class AccountRepository
{
private DataClasses2DataContext data()
{
return DataProvider.DataContextAcount();
}
private Table<Account> Accounts()
{
return data().Account;
}
public bool Check(string name, string pass)
{
bool Check=false;
foreach (Account account in Accounts())
{
if (account.login.ToString().Trim() == name && account.password.ToString().Trim()== pass && account.idPosadu==4)
{
return Check = true;
}
}
return Check;
}
public int IDOper(string name)
{
return (from s in Accounts()
where (s.login == name)
select s.id).Single();
}
public int IDClient(string name)
{
return (from s in Accounts()
where (s.login == name)
select s.idClient).Single().Value;
}
public string Name(int id)
{
return (from s in Accounts()
where (s.id == id)
select s.login).Single().ToString();
}
public string CreateUser(string login, string password, int idclient)
{
Account accounts = new Account();
accounts.login = login;
accounts.password = password;
accounts.idClient = idclient;
accounts.ip = "172.16.25.11";
accounts.idPosadu =5;
Accounts().InsertOnSubmit(accounts);
data().SubmitChanges();
return "Створений коричтувач";
}
}
Комментариев нет:
Отправить комментарий