public static EmployeePayroll CreateFromClientToServer(this EmployeePayrollModel source, string userid) { var payroll = new EmployeePayroll { Id = source.Id, EmployeeId = source.EmployeeId, Amount = source.Amount, AllowanceTypeId = source.AllowanceTypeId, AllowanceMonth = source.AllowanceMonth, RecCreatedBy = source.RecCreatedBy, RecCreatedDate = source.RecCreatedDate, RecLastUpdatedBy = source.RecLastUpdatedBy, RecLastUpdatedDate = source.RecLastUpdatedDate }; if (string.IsNullOrEmpty(source.RecCreatedBy)) { payroll.RecCreatedBy = userid; payroll.RecCreatedDate = DateTime.UtcNow; } payroll.RecLastUpdatedBy = userid; payroll.RecLastUpdatedDate = DateTime.UtcNow; return(payroll); }
public async Task <IActionResult> Edit(int id, [Bind("employeeId,FirstName,LastName,Address,PhoneNumber,Wage,HoursWorked")] EmployeePayrollModel employeePayrollModel) { if (id != employeePayrollModel.employeeId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(employeePayrollModel); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!EmployeePayrollModelExists(employeePayrollModel.employeeId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(employeePayrollModel)); }
public async Task <IActionResult> Create([Bind("employeeId,FirstName,LastName,Address,PhoneNumber,Wage,HoursWorked")] EmployeePayrollModel employeePayrollModel) { if (ModelState.IsValid) { _context.Add(employeePayrollModel); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(employeePayrollModel)); }
public void GivenListANdDB_WhenInsert_ShouldRecordExecutionTime() { List <EmployeePayrollModel> employeeList = new List <EmployeePayrollModel>(); employeeList.Add(new EmployeePayrollModel(employee_id: 101, employee_name: "Simran", job_description: "Tech", salary: 300000.00, new DateTime(2019 - 10 - 11), geneder: "F", companyId: 1, departmentId: 2, is_employee_active: true)); employeeList.Add(new EmployeePayrollModel(employee_id: 102, employee_name: "Adesh", job_description: "Support", salary: 400000.00, new DateTime(2019 - 11 - 11), geneder: "M", companyId: 3, departmentId: 3, is_employee_active: true)); employeeList.Add(new EmployeePayrollModel(employee_id: 103, employee_name: "Sandesh", job_description: "Production", salary: 300000.00, new DateTime(2019 - 10 - 11), geneder: "M", companyId: 3, departmentId: 1, is_employee_active: true)); employeeList.Add(new EmployeePayrollModel(employee_id: 104, employee_name: "Ruchita", job_description: "Management", salary: 400000.00, new DateTime(2019 - 10 - 11), geneder: "F", companyId: 2, departmentId: 3, is_employee_active: true)); employeeList.Add(new EmployeePayrollModel(employee_id: 105, employee_name: "Suchita", job_description: "Management", salary: 400000.00, new DateTime(2019 - 10 - 11), geneder: "F", companyId: 1, departmentId: 2, is_employee_active: true)); employeeList.Add(new EmployeePayrollModel(employee_id: 106, employee_name: "Shital", job_description: "Tech", salary: 300000.00, new DateTime(2019 - 10 - 11), geneder: "F", companyId: 1, departmentId: 2, is_employee_active: true)); employeeList.Add(new EmployeePayrollModel(employee_id: 107, employee_name: "Akash", job_description: "Support", salary: 400000.00, new DateTime(2019 - 11 - 11), geneder: "M", companyId: 3, departmentId: 3, is_employee_active: true)); employeeList.Add(new EmployeePayrollModel(employee_id: 108, employee_name: "Lalit", job_description: "Production", salary: 300000.00, new DateTime(2019 - 10 - 11), geneder: "M", companyId: 3, departmentId: 1, is_employee_active: true)); employeeList.Add(new EmployeePayrollModel(employee_id: 109, employee_name: "Rekha", job_description: "Management", salary: 400000.00, new DateTime(2019 - 10 - 11), geneder: "F", companyId: 2, departmentId: 3, is_employee_active: true)); employeeList.Add(new EmployeePayrollModel(employee_id: 110, employee_name: "Rani", job_description: "Finance", salary: 400000.00, new DateTime(2019 - 10 - 11), geneder: "F", companyId: 1, departmentId: 1, is_employee_active: true)); EmployeePayrollOperations employeePayrollOperations = new EmployeePayrollOperations(); DateTime startDataTime = DateTime.Now; employeePayrollOperations.addEmplyeeToPayroll(employeeList); DateTime stopDateTime = DateTime.Now; var DurationWithoutThreading = stopDateTime - startDataTime; Console.WriteLine("Duration of Insertion without threading for List " + DurationWithoutThreading); EmployeePayroll employeePayroll = new EmployeePayroll(); EmployeePayrollModel model = new EmployeePayrollModel() { employee_id = 21, employee_name = "Mahishwari", job_description = "Finance", joining_date = new DateTime(2019, 02, 22), salary = 450000.00, geneder = "F", companyId = 2, departmentId = 1, is_employee_active = true }; DateTime startDataTimeforDB = DateTime.Now; employeePayroll.AddNewEmployee(model); DateTime stopDateTimeforDB = DateTime.Now; var DurationWithoutThreadingForDB = stopDateTimeforDB - startDataTimeforDB; Console.WriteLine("Duration of Insertion without threading for DB " + DurationWithoutThreadingForDB); DateTime startDataTimeThread = DateTime.Now; employeePayrollOperations.addEmplyeeToPayrollWithThread(employeeList); DateTime stopDateTimeThread = DateTime.Now; var DurationInThreading = stopDateTimeThread - startDataTimeThread; Console.WriteLine("Duration of Insertion with threading for List " + DurationInThreading); }
public void GivenQuery_WhenEmpIdSetToFalse_ReturnOnlyActiveEmployee() { int expectedResult = 16; EmployeePayroll employeePayroll = new EmployeePayroll(); EmployeePayrollModel model = new EmployeePayrollModel() { employee_id = 8 }; int result = employeePayroll.CheckEmployeeISActive(model); Assert.AreEqual(expectedResult, result); }
public void GivenQuery_ShouldUpdateSalary() { double expectedResult = 400000.00; EmployeePayroll employeePayroll = new EmployeePayroll(); EmployeePayrollModel model = new EmployeePayrollModel() { employee_name = "Samir", salary = 400000.00 }; double salary = employeePayroll.UpdateEmployeeSalary(model); Assert.AreEqual(expectedResult, salary); }
public void GivenQuery_ShouldUpdateSalary() { EmployeePayroll employeePayroll = new EmployeePayroll(); EmployeePayrollModel model = new EmployeePayrollModel() { employee_name = "Saket", salary = 450000.00 }; DateTime startDataTimeforDB = DateTime.Now; employeePayroll.UpdateEmployeeSalary(model); DateTime stopDateTimeforDB = DateTime.Now; Console.WriteLine("Duration for Updatation in DB : " + (stopDateTimeforDB - startDataTimeforDB)); }
public void GivenQuery_WhenInsertInto_ShouldAbleToInsertIntoTwoTable() { bool expectedResult = true; EmployeePayroll employeePayroll = new EmployeePayroll(); EmployeePayrollModel model = new EmployeePayrollModel() { employee_id = 12, employee_name = "Prakhar", job_description = "DevOps", joining_date = new DateTime(2019, 09, 17), salary = 450000.00, geneder = "M" }; bool result = employeePayroll.AddNewEmployee(model); Assert.AreEqual(expectedResult, result); }
public void GivenQuery_WhenInsertInto_ShouldAbleToInsertValue() { bool expectedResult = true; EmployeePayroll employeePayroll = new EmployeePayroll(); EmployeePayrollModel model = new EmployeePayrollModel() { employee_id = 8, employee_name = "Rohit", job_description = "Support", joining_date = new DateTime(2018, 10, 22), salary = 240000.00, geneder = "M" }; bool result = employeePayroll.AddNewEmployee(model); Assert.AreEqual(expectedResult, result); }
public void GiveQuery_WhenInsert_ShouldPerformInsertionASInNewDBStructure() { bool expectedInsertResult = true; EmployeePayroll employeePayroll = new EmployeePayroll(); EmployeePayrollModel model = new EmployeePayrollModel() { employee_id = 18, employee_name = "Mohit", job_description = "Support", joining_date = new DateTime(2019, 02, 22), salary = 350000.00, geneder = "M", companyId = 1, departmentId = 3 }; bool insertResult = employeePayroll.AddNewEmployee(model); Assert.AreEqual(expectedInsertResult, insertResult); }
public void GiveQuery_WhenInsert_ShouldPerformInsertion() { bool expectedInsertResult = true; EmployeePayroll employeePayroll = new EmployeePayroll(); EmployeePayrollModel model = new EmployeePayrollModel() { employee_id = 17, employee_name = "Juili", job_description = "Finance", joining_date = new DateTime(2019, 11, 22), salary = 240000.00, geneder = "F", companyId = 2, departmentId = 3 }; bool insertResult = employeePayroll.AddNewEmployee(model); Assert.AreEqual(expectedInsertResult, insertResult); }
public void GivenQuery_WhenInsert_ShouldRecordExecutionTime() { EmployeePayroll employeePayroll = new EmployeePayroll(); EmployeePayrollModel model = new EmployeePayrollModel() { employee_id = 22, employee_name = "Saket", job_description = "Tech", joining_date = new DateTime(2009, 12, 12), salary = 350000.00, geneder = "M", companyId = 3, departmentId = 2, is_employee_active = true }; DateTime startDataTimeforDB = DateTime.Now; employeePayroll.AddNewEmployee(model); DateTime stopDateTimeforDB = DateTime.Now; var DurationWithoutThreadingForDB = stopDateTimeforDB - startDataTimeforDB; Console.WriteLine("Duration of Insertion for DB " + DurationWithoutThreadingForDB); }
public void GivenQuery_WhenRetrieve_ShouldRetrieveAllData() { EmployeePayrollModel model = new EmployeePayrollModel(); }