public void Get_ReturnsAllOrderedByName()
{
// Arrange
var dbContextMock = new Mock <IPayrollEstimatorContext>();
var employees = new List <Employee> {
new Employee {
EmployeeId = 1, FirstName = "Able", LastName = "Gable"
},
new Employee {
EmployeeId = 2, FirstName = "Zelda", LastName = "Link"
},
new Employee {
EmployeeId = 3, FirstName = "Leroy", LastName = "Jenkins"
},
new Employee {
EmployeeId = 4, FirstName = "Zoo", LastName = "Zebra"
},
new Employee {
EmployeeId = 5, FirstName = "Alice", LastName = "Wonderland"
},
}.AsQueryable();
var dbSetMock = EntityFrameworkHelper.GetMockDbSet(employees);
dbContextMock.Setup(x => x.Employees).Returns(dbSetMock.Object);
// Act
var results = new EmployeeCrud(dbContextMock.Object).Get()
.Result;
// Assert
CollectionAssert.AreEqual(employees.Select(e => e.FirstName).OrderBy(x => x),
results.Select(x => x.FirstName));
}
public void TestGetEmployeesReturnTwoEmployees()
{
EmployeeCrud _sut = new EmployeeCrud();
var employees = _sut.GetEmployees();
Assert.AreEqual(2, employees.Count);
}
public static void RunEmployeeQueries(Employee employee, string v)
{
EmployeeCrud create = CreateEmployee;
EmployeeCrud read = ReadEmployee;
EmployeeCrud update = UpdateEmployee;
EmployeeCrud delete = DeleteEmployee;
switch (v)
{
case "create":
create(employee);
break;
case "read":
read(employee);
break;
case "update":
update(employee);
break;
case "delete":
delete(employee);
break;
default:
throw new Exception();
}
}
// DI ideally uses interfaces for the minimum sake of super easy unit test mocking
// Pretend these are interfaces *waves magic hands*
public EmployeeApiController(EmployeeCrud employeeCrud, EmployeeCostCalculator costCalculator,
EmployeeValidator employeeValidator)
{
_employeeCrud = employeeCrud;
_costCalculator = costCalculator;
_employeeValidator = employeeValidator;
}
public void TestEmployeeCrudVedInitializationDbEmployeeIsNotNull()
{
EmployeeCrud _sut = new EmployeeCrud();
var o = _sut._dbEmployee;
Assert.IsNotNull(o);
}
public void TestCloseEmployeeReturnOne()
{
EmployeeCrud _sut = new EmployeeCrud();
int expected = 1;
int actual = _sut.CloseEmployee(1);
Assert.AreEqual(expected, actual);
}
public void DeleteSubjectFromEmployeeReturnOne()
{
EmployeeCrud _sut = new EmployeeCrud();
int expected = 1;
int actual = _sut.DeleteSubjectFromEmployee(1, 2);
Assert.AreEqual(expected, actual);
}
public static void SearchEmployeemain()
{
int empno;
Console.WriteLine("Enter the employee id :");
empno = Convert.ToInt32(Console.ReadLine());
EmployeeCrud employeecrud = new EmployeeCrud();
}
public void TestAddSubjectToEmployeeReturnOne()
{
EmployeeCrud _sut = new EmployeeCrud();
int expected = 1;
int actual = _sut.AddSubjectToEmployee(2, 3);
Assert.AreEqual(expected, actual);
}
/// <summary>
/// Initializes a new instance of the <see cref="SqliteBookingCrud"/> class.
/// </summary>
/// <param name="connection">The connection.</param>
/// <param name="roomCrud">The room crud.</param>
/// <param name="customerCrud">The customer crud.</param>
/// <param name="employeeCrud">The employee crud.</param>
public SqliteBookingCrud(DatabaseConnection connection, RoomCrud roomCrud, CustomerCrud customerCrud, EmployeeCrud employeeCrud)
{
this.DBConnection = connection;
RoomCrud = roomCrud;
CustomerCrud = customerCrud;
EmployeeCrud = employeeCrud;
}
public void TestGetEmployeesReturnListOfEmployees()
{
EmployeeCrud _sut = new EmployeeCrud();
var employees = _sut.GetEmployees();
Type actual = employees[0].GetType();
Type expected = typeof(EmployeeM);
Assert.AreEqual(expected, actual);
}
public void TestNewEmployeeReturnOne()
{
EmployeeCrud _sut = new EmployeeCrud();
int expected = 1;
int actual = _sut.NewEmployee("1234567890", "Karin", "Olsen", "Florasvej 1",
6000, "*****@*****.**", "22222222",
DateTime.Now, "Advokat", 750);
Assert.AreEqual(expected, actual);
}
public void TestUpdateEmployeeReturnOne()
{
EmployeeCrud _sut = new EmployeeCrud();
int expected = 1;
int actual = _sut.UpdateEmployee(2, "Karine", "Olsen", "Florasvej 1",
6000, "*****@*****.**", "22222222",
"Advokat", 1000);
Assert.AreEqual(expected, actual);
}
public static void ShowEmployeeMain()
{
EmployeeCrud employeecrud = new EmployeeCrud();
employeelist = employeecrud.Show();
foreach (Employee employee in employeelist)
{
Console.WriteLine(employee);
}
}
private void DisplayData(string criteria, string value, int startPage, int endPage)
{
DataTable dt = new EmployeeCrud().GetEmployeeAsTable(criteria, value, startPage, endPage);
gvEmploye.DataSource = dt;
gvEmploye.DataBind();
GetTotalRecord(criteria, value);
GetTotalPage(criteria, value, Int32.Parse(listPerPage));
ControlComponent();
}
public static void AddEmployeeMain()
{
Employee employee = new Employee();
Console.WriteLine("Enter Employee Id: ");
employee.Empno = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Enter Name: ");
employee.Name = Console.ReadLine();
Console.WriteLine("Enter the Basic: ");
employee.Basic = Convert.ToDouble(Console.ReadLine());
EmployeeCrud employeecrud = new EmployeeCrud();
Console.WriteLine(employeecrud.AddEmployee(employee));
}
public CreateEdit(string createEdit, ObservableCollection<Booking> bookings, Booking booking = null)
{
InitializeComponent();
string filePath = Properties.Settings.Default.Postgaarden;
var sqliteInstance = SqliteDatabaseConnection.GetInstance(filePath);
empCrud = new SqliteEmployeeCrud(sqliteInstance);
cusCrud = new SqliteCustomerCrud(sqliteInstance);
equiCrud = new SqliteEquipmentCrud(sqliteInstance);
roomCrud = new SqliteRoomCrud(sqliteInstance, equiCrud);
bookingCrud = new SqliteBookingCrud(sqliteInstance, roomCrud, cusCrud, empCrud);
this.createEdit = createEdit;
Bookings = bookings;
if (booking != null)
Booking = booking;
}
public void Create_DoesNotThrowOnNulls()
{
// Arrange
var dbContextMock = new Mock <IPayrollEstimatorContext>();
var employees = EntityFrameworkHelper.GetMockDbSet(new List <Employee>().AsQueryable());
dbContextMock.Setup(x => x.Employees).Returns(employees.Object);
var employeeData = new Mock <IEmployeeData>();
employeeData.Setup(d => d.Dependents).Returns((List <IDependentData>)null);
// Act
var result = new EmployeeCrud(dbContextMock.Object).Create(employeeData.Object);
// Assert
dbContextMock.Verify(d => d.SaveChangesAsync(), Times.Once);
employees.Verify(x => x.Add(It.Is <Employee>(p => p.Dependents.Count == 0)), Times.Once);
}
protected void btnSearchNik_Click(object sender, EventArgs e)
{
string nik = txtNik.Text;
Employee oEmploye = new Employee();
oEmploye = new EmployeeCrud().GetEmployeeByNik(nik);
if (oEmploye == null)
{
string script = string.Format("alert('{0}')", "NIK " + nik + " Not found!!");
ScriptManager.RegisterStartupScript(this, typeof(string), "onClick", script, true);
txtNik.Text = "";
txtNik.Focus();
ClearControl();
return;
}
SaveEmployeToMeal(oEmploye);
}
private void GetTotalPage(string criteria, string value, int listPerPage)
{
int totalPage = new EmployeeCrud().GetTotalPage(criteria, value, listPerPage);
lblTotalPage.Text = totalPage.ToString();
}
private void GetTotalRecord(string criteria, string value)
{
int ttlRecord = new EmployeeCrud().GetTotalRecord(criteria, value);
lblTotalRecord.Text = ttlRecord.ToString();
}
