//Legger employee inn i datatbasen
public bool add(EmployeeModel employeeModel)
{
using (var db = new CustomerContext())
{
try
{
if (!(db.Employees.Find(employeeModel.employeeID) == null))//Hvis employeeModel har personID som finnes fra før
return false;
if (find(employeeModel.username) != null)
return false;
var newEmployee = new Employees()//Opretter ny employee
{
email = employeeModel.username + "@kaffeplaneten.no",
firstName = employeeModel.firstName,
lastName = employeeModel.lastName,
phone = employeeModel.phone,
employeeAdmin = employeeModel.employeeAdmin,
customerAdmin = employeeModel.customerAdmin,
productAdmin = employeeModel.productAdmin,
orderAdmin = employeeModel.orderAdmin,
databaseAdmin = employeeModel.databaseAdmin
};
newEmployee = db.Employees.Add(newEmployee);
db.SaveChanges();
employeeModel.employeeID = newEmployee.personID;//Lagrer personID i modellen for senere bruk
return true;
}
catch (Exception ex)
{
_logging.logToDatabase(ex);
}
}//end using
return false;
}
public void HomeTest()
{
//Arrange
var controller = MockHttpSession.getMoqLayoutController();
var employeeModel = new EmployeeModel();
employeeModel.employeeID = 1;
employeeModel.firstName = "Ola";
employeeModel.lastName = "Nordmann";
employeeModel.phone = "12345678";
employeeModel.customerAdmin = false;
employeeModel.databaseAdmin = false;
employeeModel.orderAdmin = true;
employeeModel.employeeAdmin = false;
employeeModel.password = "******";
employeeModel.productAdmin = false;
employeeModel.username = "******";
//Act
var result = (ViewResult)controller.Home(employeeModel);
var resultModel = (EmployeeModel)result.Model;
//Assert
Assert.AreEqual(result.ViewName, "");
Assert.AreEqual(employeeModel.firstName, resultModel.firstName);
Assert.AreEqual(employeeModel.customerAdmin, resultModel.customerAdmin);
Assert.AreEqual(employeeModel.databaseAdmin, resultModel.databaseAdmin);
Assert.AreEqual(employeeModel.employeeAdmin, resultModel.employeeAdmin);
Assert.AreEqual(employeeModel.employeeID, resultModel.employeeID);
Assert.AreEqual(employeeModel.lastName, resultModel.lastName);
Assert.AreEqual(employeeModel.orderAdmin, resultModel.orderAdmin);
Assert.AreEqual(employeeModel.password, resultModel.password);
Assert.AreEqual(employeeModel.phone, resultModel.phone);
Assert.AreEqual(employeeModel.username, resultModel.username);
}
public ActionResult createEmployee(EmployeeModel employee)
{
if (!ModelState.IsValid)
return View();
string username = employee.username + "@kaffeplaneten.no";
var userModel = _userBLL.get(username);
if (userModel != null)
{
Session["userExists"] = "Brukernavn(Epost) du prøver å registere finnes allerede!";
return View(employee);
}
var personExist = _employeeBLL.find(username);
if (personExist != null)
{
Session["employeeExists"] = "Ansattbrukeren eksisterer allerede!";
return View(employee);
}
if (!_employeeBLL.add(employee))
{
Session["employeeError"] = "Feil ved registrering av ansatt";
return View(employee);
}
userModel = new UserModel();
userModel.username = username;
userModel.passwordHash = base.getHash(employee.password);
userModel.ID = employee.employeeID;
if (!_userBLL.add(userModel)) //registrerer ny bruker
{
Session["userError"] = "Feil ved registrering av bruker";
return View(employee);
}
_loggingBLL.logToUser("La til ny ansatt: " + userModel.username, (EmployeeModel)Session["Employee"]);
return RedirectToAction("AllEmployees", "AdminEmployee");
}
public EmployeeModel find(int id)
{
if (id < 0)
return null;
var employeeModel = new EmployeeModel();
employeeModel.employeeID = 1;
employeeModel.firstName = "Ola";
employeeModel.lastName = "Nordmann";
employeeModel.phone = "12345678";
employeeModel.customerAdmin = false;
employeeModel.databaseAdmin = false;
employeeModel.orderAdmin = true;
employeeModel.employeeAdmin = false;
employeeModel.password = "******";
employeeModel.productAdmin = false;
employeeModel.username = "******";
if (id==2)
{
employeeModel.databaseAdmin = true;
employeeModel.customerAdmin = true;
employeeModel.productAdmin = true;
employeeModel.employeeAdmin = true;
}
if (id == 3)
employeeModel.employeeID = -1;
return employeeModel;
}
public void getActiveUserIDTestOK()
{
//Arrange
var controller = MockHttpSession.getMoqSuperController();
var temp = new EmployeeModel();
temp.employeeID = 1;
controller.Session[SuperController.Employee] = temp;
//Act
var result = controller.getActiveUserID();
//Assert
Assert.AreEqual(result, 1);
}
public EmployeeModel find(string email)
{
if (email.Equals("@kaffeplaneten.no"))
return null;
var employeeModel = new EmployeeModel();
employeeModel.employeeID = 1;
employeeModel.firstName = "Ola";
employeeModel.lastName = "Nordmann";
employeeModel.phone = "12345678";
employeeModel.customerAdmin = false;
employeeModel.databaseAdmin = false;
employeeModel.employeeAdmin = false;
employeeModel.password = "******";
employeeModel.productAdmin = false;
employeeModel.username = "******";
return employeeModel;
}
public void AllEmployeesTest()
{
//Arrange
var controller = new AdminEmployeeController(new EmployeeBLL(new EmployeeDALStub()), new UserBLL(new UserDALStub()), new LoggingBLL(new LoggingDALStub()));
var list = new List<EmployeeModel>();
var employeeModel = new EmployeeModel();
employeeModel.employeeID = 1;
employeeModel.firstName = "Ola";
employeeModel.lastName = "Nordmann";
employeeModel.phone = "12345678";
employeeModel.customerAdmin = false;
employeeModel.orderAdmin = true;
employeeModel.databaseAdmin = false;
employeeModel.employeeAdmin = false;
employeeModel.password = "******";
employeeModel.productAdmin = false;
employeeModel.username = "******";
list.Add(employeeModel);
list.Add(employeeModel);
list.Add(employeeModel);
list.Add(employeeModel);
//Act
var result = (ViewResult)controller.AllEmployees();
var resultList = (List<EmployeeModel>)result.Model;
//Assert
Assert.AreEqual(result.ViewName, "");
Assert.AreEqual(resultList.Count, list.Count);
for(int i = 0; i < resultList.Count; i++)
{
Assert.AreEqual(resultList[i].customerAdmin, list[i].customerAdmin);
Assert.AreEqual(resultList[i].databaseAdmin, list[i].databaseAdmin);
Assert.AreEqual(resultList[i].employeeAdmin, list[i].employeeAdmin);
Assert.AreEqual(resultList[i].employeeID, list[i].employeeID);
Assert.AreEqual(resultList[i].firstName, list[i].firstName);
Assert.AreEqual(resultList[i].lastName, list[i].lastName);
Assert.AreEqual(resultList[i].orderAdmin, list[i].orderAdmin);
Assert.AreEqual(resultList[i].password, list[i].password);
Assert.AreEqual(resultList[i].phone, list[i].phone);
Assert.AreEqual(resultList[i].productAdmin, list[i].productAdmin);
Assert.AreEqual(resultList[i].username, list[i].username);
}
}
public void createEmployeeTestTrue()
{
//Arrange
var context = new Mock<ControllerContext>();
var session = new Mock<HttpSessionStateBase>();
context.Setup(m => m.HttpContext.Session).Returns(session.Object);
var controller = new AdminEmployeeController(new EmployeeBLL(new EmployeeDALStub()), new UserBLL(new UserDALStub()), new LoggingBLL(new LoggingDALStub()));
controller.ControllerContext = context.Object;
var employeeModel = new EmployeeModel();
employeeModel.employeeID = 1;
employeeModel.firstName = "Ola";
employeeModel.lastName = "Nordmann";
employeeModel.phone = "12345678";
employeeModel.customerAdmin = false;
employeeModel.databaseAdmin = false;
employeeModel.orderAdmin = true;
employeeModel.employeeAdmin = false;
employeeModel.password = "******";
employeeModel.productAdmin = false;
employeeModel.username = "";
//Act
var result = (RedirectToRouteResult)controller.createEmployee(employeeModel);
//Assert
Assert.AreEqual(result.RouteName, "");
Assert.AreEqual(result.RouteValues.Values.First(), "AllEmployees");
}
public bool add(EmployeeModel employeeModel)
{
if (!employeeModel.firstName.Equals(""))
return true;
return false;
}
//Henter ut navn på bruker med brukernavn lik email
public EmployeeModel find(string email)
{
var employeeModel = new EmployeeModel();
using (var db = new CustomerContext())
{
try
{
var temp = (from c in db.Employees
where c.email == email
select c).SingleOrDefault();
if (temp == null)
return null;
return find(temp.personID);
}
catch (Exception ex)
{
_logging.logToDatabase(ex);
}
return null;
}
}
public bool logToUser(string action, EmployeeModel model)
{
return _loggingDAL.logToUser(action, model);
}
public List<EmployeeModel> getAllEmployees()
{
using (var db = new CustomerContext())
{
var EmployeeList = new List<EmployeeModel>();
try
{
var employees = (from e in db.Employees select e).ToList();
if (employees != null)
foreach (var e in employees)
{
var empModel = new EmployeeModel();
empModel.employeeID = e.personID;
empModel.firstName = e.firstName;
empModel.lastName = e.lastName;
empModel.phone = e.phone;
EmployeeList.Add(empModel);
}
return EmployeeList;
}
catch (Exception ex)
{
_logging.logToDatabase(ex);
}
return null;
}
}
public ActionResult Home(EmployeeModel emp)
{
return View(emp);
}
public static EmployeeModel createSuperEmployee()
{
var employee = new EmployeeModel();
employee.firstName = "Sjef";
employee.lastName = "Ledersen";
employee.username = "******";
employee.phone = "99887766";
employee.employeeAdmin = true;
employee.orderAdmin = true;
employee.productAdmin = true;
employee.customerAdmin = true;
employee.databaseAdmin = true;
return employee;
}
//Henter ut en EmployeeModel for employee med personID lik id
public EmployeeModel find(int id)
{
var employeeModel = new EmployeeModel();
using (var db = new CustomerContext())
{
try
{
var temp = (from c in db.Employees
where c.personID == id
select c).FirstOrDefault();
if (temp == null)//Tester om employeen finnes
return null;
employeeModel.employeeID = temp.personID;
employeeModel.firstName = temp.firstName;
employeeModel.lastName = temp.lastName;
employeeModel.username = temp.email;
employeeModel.phone = temp.phone;
employeeModel.customerAdmin = temp.customerAdmin;
employeeModel.orderAdmin = temp.orderAdmin;
employeeModel.employeeAdmin = temp.employeeAdmin;
employeeModel.productAdmin = temp.productAdmin;
employeeModel.databaseAdmin = temp.databaseAdmin;
return employeeModel;
}//end try
catch (Exception ex)
{
_logging.logToDatabase(ex);
}
}//end using
return null;
}
public override bool logToUser(string message, EmployeeModel model)
{
createLog(LOG_INTERACTION);
string logLine = "";
if (model == null) // Dersom personen er anonym vil dette skje.
{
string strHostName = System.Net.Dns.GetHostName();
IPHostEntry ipEntry = System.Net.Dns.GetHostEntry(strHostName);
string ipaddress = ipEntry.AddressList[2].ToString();
model = new EmployeeModel()
{
employeeID = 0,
firstName = ipaddress,
lastName = "",
username = "******"
};
}
logLine = ",{ " +
"\"Date\": \"" + DateTime.Now.ToString("h:mm:ss tt") + "\"," +
"\"UserID\": \"" + model.username + "\"," +
"\"User\": \"" + model.firstName + " " + model.lastName + "\"," +
"\"Action\": \"" + message + "\" }";
try
{
using (StreamWriter logWriter = File.AppendText(LOG_INTERACTION))
{
logWriter.WriteLine(logLine);
logWriter.Close();
return true;
}
}
catch (Exception)
{
System.Console.WriteLine("ERROR: COULD NOT LOG ACTION TO USER.");
}
return false;
}
public void deleteEmployeeTestActiveUser()
{
//Arrange
var controller = MockHttpSession.getMoqAdminEmployeeController();
controller.Session["username"] = "******";
var employeeModel = new EmployeeModel();
employeeModel.employeeID = 1;
employeeModel.firstName = "Ola";
employeeModel.lastName = "Nordmann";
employeeModel.phone = "12345678";
employeeModel.customerAdmin = false;
employeeModel.databaseAdmin = false;
employeeModel.employeeAdmin = false;
employeeModel.password = "******";
employeeModel.orderAdmin = true;
employeeModel.productAdmin = false;
employeeModel.username = "";
//Act
var result = (ViewResult)controller.deleteEmployee(employeeModel);
var resultModel = (EmployeeModel)result.Model;
//Assert
Assert.AreEqual(result.ViewName, "");
}
public abstract bool logToUser(string message, EmployeeModel model);
public override bool logToUser(string message, EmployeeModel model)
{
if (message == "")
return false;
return true;
}
public ActionResult deleteEmployee(EmployeeModel employee)
{
Session["cantDelete"] = null;
Session["noUser"] = null;
Session["isDeleted"] = null;
var user = _employeeBLL.find(employee.employeeID);
if (user == null) //sjekker om bruker finnes
{
Session["noUser"] = "******";
return View();
}
if(user.username.Equals(Session["username"])) //Sjekker om det er en selv
{
Session["cantDelete"] = "Ikke lov å slette seg selv fra ansatte";
return View();
}
if(user.employeeAdmin && user.customerAdmin && user.productAdmin && user.orderAdmin && user.databaseAdmin)
{
Session["cantDelete"] = "Du kan ikke slette en hovedadministrator fra systemet. Personen har alle rettigheter.";
return View();
}
bool deleted = _employeeBLL.delete(user.employeeID);
if (deleted)
{
StringBuilder sb = new StringBuilder();
sb.Append("Du har nå fjernet: ");
sb.Append(user.firstName);
sb.Append(" ");
sb.Append(user.lastName);
sb.Append("\n med Brukernavn: ");
sb.Append(user.username);
Session["isDeleted"] = sb.ToString();
_loggingBLL.logToUser("Slettet ansatt: " + employee.username, (EmployeeModel)Session["Employee"]);
return View();
}
Session["cantDelete"] = "Kunne ikke slette brukeren!";
_loggingBLL.logToDatabase("FEIL: Kunne ikke slette ansatt: " + employee.username);
return View();
}
public void createEmployeeTestEmployeeAddFail()
{
//Arrange
var context = new Mock<ControllerContext>();
var session = new Mock<HttpSessionStateBase>();
context.Setup(m => m.HttpContext.Session).Returns(session.Object);
var controller = new AdminEmployeeController(new EmployeeBLL(new EmployeeDALStub()), new UserBLL(new UserDALStub()), new LoggingBLL(new LoggingDALStub()));
controller.ControllerContext = context.Object;
var employeeModel = new EmployeeModel();
employeeModel.employeeID = 1;
employeeModel.firstName = "";
employeeModel.lastName = "Nordmann";
employeeModel.phone = "12345678";
employeeModel.orderAdmin = true;
employeeModel.customerAdmin = false;
employeeModel.databaseAdmin = false;
employeeModel.employeeAdmin = false;
employeeModel.password = "******";
employeeModel.productAdmin = false;
employeeModel.username = "";
//Act
var result = (ViewResult)controller.createEmployee(employeeModel);
var resultModel = (EmployeeModel)result.Model;
//Assert
Assert.AreEqual(result.ViewName, "");
Assert.AreEqual(employeeModel.firstName, resultModel.firstName);
Assert.AreEqual(employeeModel.customerAdmin, resultModel.customerAdmin);
Assert.AreEqual(employeeModel.databaseAdmin, resultModel.databaseAdmin);
Assert.AreEqual(employeeModel.employeeAdmin, resultModel.employeeAdmin);
Assert.AreEqual(employeeModel.employeeID, resultModel.employeeID);
Assert.AreEqual(employeeModel.lastName, resultModel.lastName);
Assert.AreEqual(employeeModel.orderAdmin, resultModel.orderAdmin);
Assert.AreEqual(employeeModel.password, resultModel.password);
Assert.AreEqual(employeeModel.phone, resultModel.phone);
Assert.AreEqual(employeeModel.username, resultModel.username);
}
//Legger employee inn i datatbasen
public bool add(EmployeeModel employeeModel)
{
return _employeeDAL.add(employeeModel);
}
