Example #1
0
        /// <summary>
        /// Method to retrieve the entire data from the database in ER Model
        /// </summary>
        public static void RetrieveAllDataFromDatabase()
        {
            /// Creating the ER Diagram repository class's instance
            ERDiagramRepository diagramRepository = new ERDiagramRepository();

            diagramRepository.RetrieveAllTheRecordsFromTheDataBase();
            /// UC10 -- Ensuring the other Test Case Working Properly
            diagramRepository.EnsuringOtherCasesWorkProperly();
        }
Example #2
0
        /// <summary>
        /// Method to define the properties to add the data to the database
        /// </summary>
        public static void AddToDatabaseMethod()
        {
            /// Creating the employee repository class's instance
            EmployeeRepository repository = new EmployeeRepository();
            /// Creating the employee model class's instance
            EmployeeModel employeeModel = new EmployeeModel();
            /// Creating the ER Diagram repository class's instance
            ERDiagramRepository diagramRepository = new ERDiagramRepository();

            employeeModel.EmployeeName = "Rajesh";
            employeeModel.BasicPay     = 40000;
            employeeModel.StartDate    = Convert.ToDateTime("2020-02-03");
            employeeModel.PhoneNumber  = 72061245;
            employeeModel.Address      = "Sec-8";
            employeeModel.Department   = "IT";
            employeeModel.Gender       = "M";
            /// Adding to the unified database
            repository.AddDataToEmployeePayrollDB(employeeModel);
            /// Adding to the ER- Diagram implementing Database Schema
            diagramRepository.AddToMultipleTableAndPayrollTableAtOnce(employeeModel);
        }