public List<Person> getTable(string tablename) { List<Person> ListOfPerson = new List<Person>(); try { using (projektasEntities database = new projektasEntities()) { if (tablename == "registracija") { foreach (var p in database.registracijas) { Person one = new Person(); one.name = p.Name; one.id = p.Id; one.password = p.Password; one.email = p.Email; ListOfPerson.Add(one); } } else if (tablename == "users") { foreach (var p in database.users) { Person one = new Person(); one.name = p.name; one.id = p.Id; one.password = p.password; one.email = p.email; ListOfPerson.Add(one); } } } } catch (Exception e) { Console.WriteLine("Exception in retrieving full table"); } return ListOfPerson; }
public List<string> getAllNames() { List<string> ListOfNames = new List<string>(); try { using (projektasEntities database = new projektasEntities()) { var names = from registracija in database.registracijas select registracija.Name; ListOfNames = names.ToList(); } } catch (Exception e) { Console.WriteLine("Exception in retrieving all names"); } return ListOfNames; }
public Person getPerson(string name) { Person person = new Person(); try { using (projektasEntities database = new projektasEntities()) { var getperson = database.registracijas.First((p) => p.Name == name); person.id = getperson.Id; person.name = getperson.Name; person.email = getperson.Email; person.password = getperson.Password; } } catch (Exception e) { Console.WriteLine("Exception in geting person with name"); } return person; }
public void deletePerson(string name) { using ( projektasEntities database = new projektasEntities()) { var person = new registracija { Name = name }; database.registracijas.Attach(person); database.registracijas.Remove(person); database.SaveChanges(); } }
public void updatePerson(string dbName, string name, string email, string password) { using (projektasEntities database = new projektasEntities()) { var person = database.registracijas.SingleOrDefault(b => b.Name == dbName); if (person != null) { if (name != "") { person.Name = name; } if (email != "") { person.Email = email; } if (password != "") { person.Password = password; } database.SaveChanges(); } } }
public void addPersonToUsers(string name1, string email1, string password1) { using (projektasEntities database = new projektasEntities()) { var person = new user { name = name1, email = email1, password = password1 }; database.users.Add(person); database.SaveChanges(); } }
public void addPersonToRegistration(string name, string email, string password) { using (projektasEntities database = new projektasEntities()) { var person = new registracija { Name = name, Email = email, Password = password }; database.registracijas.Add(person); database.SaveChanges(); } }