public EmployeeController(EmployeeRepositry EmployeeRepositry) { context = EmployeeRepositry; }
public EmployeeService() { _repositry = new EmployeeRepositry(new EmployeeContext()); }
public UnitOfWork(ApplicationDbContext context) { Context = context; Employees = new EmployeeRepositry(context); Departments = new DepartmentRepositry(context); }
//public IConfiguration _configuration { get; } // private readonly IConfiguration _configuration; //static IConfiguration _configuration; static void Main(string[] args) { //// private readonly string context = "Persist Security Info = false; Integrated Security = true; Initial Catalog = devDatabase; server = HAMZAPC"; //var host = CreateHostBuilder(args).Build(); // host.Run(); // add the framework services //var services = new ServiceCollection() // .AddLogging(); //// add StructureMap //var container = new Container(); //container.Configure(config => //{ // // Register stuff in container, using the StructureMap APIs... // config.Scan(_ => // { // _.AssemblyContainingType(typeof(Program)); // _.WithDefaultConventions(); // }); // // Populate the container using the service collection // config.Populate(services); //}); //var serviceProvider = container.GetInstance<IServiceProvider>(); // rest of method as before var _context = new EmployeeContext("Persist Security Info = false; Integrated Security = true; Initial Catalog = devDatabase; server = HAMZAPC"); Startup startup = new Startup(_configuration); // //var service = new EmployeeService(_context); // var genService = new EmployeeService(); // EmployeeRepositry employeeRepositry = new EmployeeRepositry(_context); // var existingEmployee = new Employee(); //var _context = new EmployeeContext("Persist Security Info = false; Integrated Security = true; Initial Catalog = devDatabase; server = HAMZAPC"); //var service = new EmployeeService(_context); var genService = new EmployeeService(); // EmployeeRepositry employeeRepositry = new EmployeeRepositry(_context); EmployeeRepositry employeeRepositry1 = new EmployeeRepositry(_context, _configuration); var existingEmployee = new Employee(); //#region GetById //var employee = genService.GetById(1); //Console.WriteLine($"Welcome first emplyoee details are " + employee.Name + " Your Salary is : " + employee.Salary); //#endregion //#region Create Employee //Employee newEmployee = new Employee(); //newEmployee.Name = "John"; //newEmployee.Salary = 45000; //Employee employeeDTO = genService.Create(newEmployee); //Console.WriteLine("New Employee is "); //{ // Console.WriteLine($"Welcome " + employeeDTO.Name + " Your Salary is : " + employeeDTO.Salary); //} //#endregion //#region Update Employee //existingEmployee = genService.GetById(4); //existingEmployee.Name = "Murphy"; //existingEmployee.Salary = 45000; //Employee updatedEmployee = genService.Update(existingEmployee); //Console.WriteLine("Updated Employee is "); //{ // Console.WriteLine($"Welcome " + updatedEmployee.Name + " Your Salary is : " + updatedEmployee.Salary); //} //#endregion //#region Delete Employee //int id = 8; ////string Name = "Mareena"; //var result = genService.Delete(id); //{ // Console.WriteLine(result); //} //#endregion //#region GetAll //var employeesList = genService.Get(); //Console.WriteLine("Employee Details are below as"); //foreach (var emp in employeesList) //{ // Console.WriteLine($"Welcome " + emp.Name + " Your Salary is : " + emp.Salary); //} //#endregion #region Dapper with SP Console.WriteLine("Duplicate Records"); var duplicateRows = employeeRepositry1.DuplicateRecords(); if (duplicateRows.Count > 0) { foreach (var dr in duplicateRows) { Console.WriteLine($"Welcome " + dr.Name + " Your Salary is : " + dr.Salary + " \tCount : " + dr.count); } } else { Console.WriteLine("No Duplicate Records Found"); } #endregion #region Enums Console.WriteLine("Read values of the Color enum"); //foreach (string i in Enums.Days) // Console.WriteLine(i); //foreach (int i in Enums.GetValues(typeof())) // Console.WriteLine(i); Console.WriteLine(Enums.Days.Friday); //output: Friday int day = (int)Enums.Days.Friday; // enum to int conversion Console.WriteLine(day); //output: 5 var wd = (Enums.Days) 5; // int to enum conversion Console.WriteLine(wd); //output: Friday #endregion }