Example #1
0
        public static void Insert_PhysicalAddress(Physical_Address physical)

        {
            using (var objUsersDbContext = new UsersDbContext())
            {
                try
                {
                    var objPhysicalAddress = new Physical_Address
                    {
                        StreetLine1 = physical.StreetLine1,
                        StreetLine2 = physical.StreetLine2,
                        StreetLine3 = physical.StreetLine3,
                        FkSuburbId  = physical.FkSuburbId,
                        FkUserId    = physical.FkUserId
                    };
                    objUsersDbContext.PhysicalAddress.Add(objPhysicalAddress);
                    objUsersDbContext.SaveChanges();
                    Console.WriteLine("An Physical Address for User Id " + physical.FkUserId + " has beed added.");
                    Console.ReadKey();
                }
                catch (Exception)
                {
                    Console.WriteLine("Could not add Physical Address");
                }
            }
        }
        public void EnterPhysicalUpdateDetails(Physical_Address physical)
        {
            Console.WriteLine("Please enter AddressId");
            physical.PkPhysicalAddessId = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Please enter StreetLine 1");
            physical.StreetLine1 = Console.ReadLine();

            Console.WriteLine("Please enter StreetLine 2");
            physical.StreetLine2 = Console.ReadLine();

            Console.WriteLine("Please enter StreetLine 3");
            physical.StreetLine3 = Console.ReadLine();

            Console.WriteLine("Please enter Suburb-ID");
            physical.FkSuburbId = Convert.ToInt32(Console.ReadLine());

            Update_Physical(physical);
        }
Example #3
0
        public void EnterPhysicalAddressDetails(Physical_Address physical)
        {
            Console.WriteLine("Please enter User-ID");
            physical.FkUserId = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Please enter StreetLine 1");
            physical.StreetLine1 = Console.ReadLine();

            Console.WriteLine("Please enter StreetLine 2");
            physical.StreetLine2 = Console.ReadLine();

            Console.WriteLine("Please enter StreetLine 3");
            physical.StreetLine3 = Console.ReadLine();

            Console.WriteLine("Please enter Suburb-ID");
            physical.FkSuburbId = Convert.ToInt32(Console.ReadLine());


            Console.WriteLine("\r\n");

            Insert_PhysicalAddress(physical);
        }
        public static void Update_Physical(Physical_Address physical)
        {
            using (var usersDbContext = new UsersDbContext())
            {
                try
                {
                    var objUpdatePhysical = usersDbContext.PhysicalAddress.SingleOrDefault(x => x.PkPhysicalAddessId == physical.PkPhysicalAddessId);

                    objUpdatePhysical.StreetLine1 = physical.StreetLine1;
                    objUpdatePhysical.StreetLine2 = physical.StreetLine2;
                    objUpdatePhysical.StreetLine3 = physical.StreetLine3;

                    objUpdatePhysical.FkSuburbId = physical.FkSuburbId;
                    usersDbContext.SaveChanges();
                    Console.WriteLine("Physical Address Updated");
                    Console.ReadKey();
                }
                catch (Exception)
                {
                    Console.WriteLine("Could not Update Physical Address");
                    Console.ReadKey();
                }
            }
        }
        static void Main(string[] args)
        {
            Console.WriteLine("Main Menu \r\n  \r\n User Operations: \r\n 0. See Registered Users \r\n 1. Register User  \r\n 2. Update User  \r\n ");
            Console.WriteLine("Physical Address Operations: \r\n 3. Enter User Physical Address  \r\n 4. Update User Physical Address  \r\n ");
            Console.WriteLine("Postal Address Operations: \r\n 5. Enter User Postal Address  \r\n 6. Update User Postal Address  \r\n ");
            Console.WriteLine("User Approval Operations: \r\n 7. Press 1 to Approve User");
            Console.WriteLine("User Deletion Operations: \r\n 8. Press 1 to Delete User");



            //Object in use by 2---Methods as Parameter ,thats why is Glabol
            var user     = new _User();
            var physical = new Physical_Address();
            var postal   = new Postal_Address();


            int option = Convert.ToInt32(Console.ReadLine());

            switch (option)
            {
            case 0:
                var objSelectUser = new SelectUser();
                objSelectUser.RetrieveUser();
                break;

            case 1:
                var objInsertUser = new InsertUser();
                objInsertUser.EnterUserDetails(user);

                Console.WriteLine("would you like to add your physical address: Y/N");

                string value = Console.ReadLine();

                string lower = value.ToLower();
                if (lower == "y")
                {
                    var objaddressOption = new InsertPhysical();
                    objaddressOption.EnterPhysicalAddressDetails(physical);
                }
                else if (lower == "n")
                {
                    Console.WriteLine("Thank you");
                }
                break;

            case 2:
                var objUpdateUser = new UpdateUser();
                objUpdateUser.EnterUpdateUserDetails(user);
                break;

            case 3:
                var objInsertPhysical = new InsertPhysical();
                objInsertPhysical.EnterPhysicalAddressDetails(physical);
                break;

            case 4:
                var objUpdatePhysical = new UpdatePhysical();
                objUpdatePhysical.EnterPhysicalUpdateDetails(physical);
                break;

            case 5:
                var objInsertPostal = new InsertPostal();
                objInsertPostal.EnterPostalAddressDetails(postal);
                break;

            case 6:
                var objUpdatePostal = new UpdatePostal();
                objUpdatePostal.EnterPostalUpdateDetails(postal);
                break;

            case 7:
                var objUpdateApprovalStatus = new UpdateApprovalStatus();
                objUpdateApprovalStatus.EnterUpdateStatus();
                break;

            case 8:
                var objSoftDeleteUser = new DeleteUser();
                objSoftDeleteUser.UserIdToDelete();

                break;

            default:
                Console.WriteLine("Opps! Invalid option entered. Retry");
                Console.ReadKey();



                break;
            }
        }