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