A little bit about me...
Hello! I'm Rafael Domiciano, a student currently enrolled in CIS3342. I am deeply interested in database management and web development, and I’m excited to apply my skills in this project.
Project 1 Overview
This website contains all the projects I have worked on for
CIS3342 class.This project helped me to remember some concepts I learned in CIS3309 and CIS3344. I also learned about how to work with aspx and use C# to build the code behind the web page. I really enjoyed it. For this project, I created an American History quiz.
I used HTML concepts for the HomePage and C# for the code behind. You can take a look clicking in the picture below. I hope you enjoy it!
Click Here Below
Project 2 Overview
For this project, we were asked to build a web application using ASP.NET with two ASPX pages. The first page allows the user to input their name, phone number or email, and, if applicable, their rewards ID. If the user has a rewards ID, they receive a 10% discount on their order. This page also displays three GridViews with items sourced from two database tables. The user can select products, specify the type, category, quantity, and size, and then place their order.
Once the order is placed, the application calculates and displays the total in a separate GridView. The user can also navigate to the sales report page by clicking a button. On this second page, there are two GridViews: one that shows the top 10 items from each menu category based on total sales, and another that displays the top 5 customers with rewards IDs who have the highest gross sales. The page also includes buttons to return to the main page.
I truly enjoyed working on this project as it helped me gain knowledge and experience in working with GridView controls and dynamic data display. Before this project, I had little experience with retrieving user input, such as numbers from a GridView or handling controls like checkboxes and dropdown lists. Now, I can confidently say that I have a good understanding of how to implement these functionalities. I look forward to learning even more from upcoming projects. You can view my project by clicking the image below
Click Here Below
Project 3 Overview
In this project, the goal was to create a real estate web application to facilitate buying, selling, and scheduling visits for homes. This was the most complex project I’ve worked on so far, but it was also an invaluable learning experience. I began by designing the database, creating tables and establishing relationships between them, and then moved on to the programming phase.
We implemented new concepts that were unfamiliar to me, such as stored procedures and sessions, which, thankfully, were straightforward to learn. The application includes a login page that allows users to log in with their user ID and password, and if they don’t have an account, they can sign up with their details. Once signed in, users (brokers) can access exclusive content, such as adding and managing the homes they’ve listed. Additionally, all users—whether logged in or not—can view all listed homes, see each home’s profile with detailed information, request a viewing, and place an offer.
Brokers can review offers and view requests made by users. I thoroughly enjoyed working on this project because of its complexity and the valuable experience it provided as a programmer. Although I wasn’t able to implement all the features, I feel proud and accomplished for reaching the milestones I did. The most challenging aspect was managing multiple files, stored procedures, and database tables, which became somewhat overwhelming by the end. I’m looking forward to the next project and to working with APIs.
Click Here Below
Project 4 Overview
Project 4 was an evolution of Project 3, where we updated the real estate web application to use ASP.NET Core MVC and Web APIs. This transition introduced new complexities, but it also provided an excellent opportunity to expand my skill set and better understand modern web development practices.
Like Project 3, this project allows users to browse listed homes, view detailed profiles, request tours, and place offers. Brokers can also manage their listed homes and view offers or requests made by potential buyers. However, in Project 4, we leveraged Web APIs to handle the database for users and homes operations, making the application more modular and scalable. Additionally, the use of Core MVC improved the organization of the code and introduced features like dependency injection, which enhanced the overall architecture.
At the start of the project, I faced challenges in integrating APIs and understanding the nuances of Core MVC. However, as I progressed, these functionalities became more intuitive, and by the end, I was able to implement the required features smoothly. The process of learning and troubleshooting was incredibly rewarding, as I now feel much more confident in building robust web applications using modern frameworks. While the project retains the same features as Project 3, the experience of transitioning to Core MVC and working with Web APIs was transformative. I am proud of the progress I made and the knowledge gained from overcoming these challenges.
Click Here Below