/// <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(); }
/// <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); }