示例#1
0
        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;
        }
示例#2
0
        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;
        }
示例#3
0
        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;
        }
示例#4
0
 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();
    }
 }
示例#5
0
        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();
                }
            }
        }
示例#6
0
 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();
     }
 }
示例#7
0
 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();
     }
 }