Example #1
0
        private static void AddUser()                  // method for defined add new User to the database
        {
            ServerKernel ser = new ServerKernel();     // create instance about class ServerKernel

            ser.SendingData("introduce User's Name");  // call method SendingData for send current string
            var    userName = ser.ReceivingData();     // call method Receiving for got data from client part
            string userN    = userName.ToString();     // convert get data to the type string

            ser.SendingData("introduce User's Age");   // call method SendingData for send current string
            var userAge = ser.ReceivingData();         // call method ReceivingData for get all data from client part
            int userA   = Int32.Parse(userAge);        // convert get data in the int type

            using (UserContext db = new UserContext()) // defined variable about class UserContext
            {
                User newUser = new User {
                    Name = userN, Age = userA
                };                                                   // defined instance with got data

                db.Users.Add(newUser);                               // choice current object and add to the database
                db.SaveChanges();                                    // save new data in the database
                ser.SendingData("command performed");                // call method SendingData for send current string

                var users = db.Users;                                // got all users from the database
                ser.SendingData("list all users from database ->>"); // call method SendingData for send current string to the client part
                foreach (User u in users)                            // got access to the every object(user) in the database
                {
                    ser.SendingData($"{u.Id}.{u.Name} - {u.Age}");   // call method SendingData for send got data from database to the client part
                }
            }
        }
Example #2
0
        private static void AddUser()                  // method for defined add new User to the database
        {
            ServerKernel ser = new ServerKernel();     // create instance about class ServerKernel

            ser.SendingData("introduce User's Name");  // call method SendingData for send current string
            var    userName = ser.ReceivingData();     // call method Receiving for got data from client part
            string userN    = userName.ToString();     // convert get data to the type string

            ser.SendingData("introduce User's Age");   // call method SendingData for send current string
            var userAge = ser.ReceivingData();         // call method ReceivingData for get all data from client part
            int userA   = Int32.Parse(userAge);        // convert get data in the int type

            using (UserContext db = new UserContext()) // defined variable about class UserContext
            {
                User newUser = new User {
                    Name = userN, Age = userA
                };                                           // defined instance with got data

                db.Users.Add(newUser);                       // choice current object and add to the database
                db.SaveChanges();                            // save new data in the database
                ser.SendingData("command performed");        // call method SendingData for send current string

                var users = db.Users;                        // got all users from the database

                StartPoint showUsers = new StartPoint();     // instance for description event about showing all users
                showUsers.UsersEvent += showUsers.ShowUsers; // defined current method 'ShowUsers' for event - 'UsersEvent'
                if (showUsers.UsersEvent != null)            // if event have method for performing
                {
                    showUsers.UsersEvent(users);             // call current event
                }
            }
        }
Example #3
0
        private static void DeleteUser()               // method for deleting certain user in the database
        {
            ServerKernel ser2 = new ServerKernel();    // create instance class ServerKernel

            ser2.SendingData("introduce User's Id");   // call method SendingData for send current string
            var userId = ser2.ReceivingData();         // call method ReceivingData for get all data from client part
            int userI  = Int32.Parse(userId);          // convert get clients data to the int type

            using (UserContext db = new UserContext()) // defined instance about class UserContext
            {
                var users = db.Users;                  // got all users from database
                foreach (User u in users)              // get access about each user in the database
                {
                    if (u.Id == userI)                 // if id will searched in the database then
                    {
                        db.Users.Remove(u);            // delete current user from database
                        break;                         // and will stop current increment
                    }
                }
                db.SaveChanges();                                   // save database after delete certain user
                ser2.SendingData("command performed");              // call method SendingData for send current string
                var usersAll = db.Users;                            // got data about all users from database
                ser2.SendingData("all Users from database");        // call method SendingData for send current string
                foreach (User u in usersAll)                        // will got access to the every user in the database
                {
                    ser2.SendingData($"{u.Id}.{u.Name} - {u.Age}"); // will call method SendingData for send certain data about current user
                }
            }
        }