public bool AddEmployee(EmployeeViewModel employee)
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <EmployeeViewModel, Employee>());
var mapper = new Mapper(config);
Employee emp = mapper.Map <Employee>(employee);
_dataConext.Employees.Add(emp);
return(_dataConext.SaveChanges() > 0 ? true : false);
}
public bool them(phongban them)
{
phongban temp = mydatabase.phongbans.Where(p => p.Name == them.Name).SingleOrDefault();
if (temp != null)
{
return(false);
}
mydatabase.phongbans.Add(them);
mydatabase.SaveChanges();
return(true);
}
public bool them(User them)
{
User temp = mydatabase.Users.Where(p => p.account == them.account).SingleOrDefault();
if (temp != null)
{
return(false);
}
mydatabase.Users.Add(them);
mydatabase.SaveChanges();
return(true);
}
public bool them(Nhanvien them)
{
Nhanvien temp = mydatabase.Nhanviens.Where(p => p.MaNV == them.MaNV).SingleOrDefault();
if (temp != null)
{
return(false);
}
mydatabase.Nhanviens.Add(them);
mydatabase.SaveChanges();
return(true);
}
public async void TestGetProjectsWithUserId()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test7")
.Options;
using (var context = new Databasecontext(options))
{
var project = new Project("user", DateTime.Now, DateTime.Now, 1.00, "test", "test")
{
ProjectId = 3,
UserId = "1",
StartDate = DateTime.Now,
EndDate = DateTime.Now,
PaymentOffered = 1.00,
ProjectName = "test",
Description = "test"
};
context.Add(project);
context.SaveChanges();
ProjectsController projectController = new ProjectsController(context);
var actionresult = await projectController.GetProjectByUser("1");
var result = (OkObjectResult)actionresult.Result;
List <Project> result2 = (List <Project>)result.Value;
Assert.Equal(3, result2.Last().ProjectId);
}
}
public IActionResult RegisterUser(string TocompareFingerPrint, FingerprintModel model)
{
var errors = ModelState.Values.SelectMany(v => v.Errors);
if (ModelState != null)
{
MD5 md5 = new MD5CryptoServiceProvider();
Byte[] originalBytes = ASCIIEncoding.Default.GetBytes(model.Password + model.EmailID);
Byte[] encodedBytes = md5.ComputeHash(originalBytes);
string hashedPassword = BitConverter.ToString(encodedBytes).Replace("-", "");
//var nouser = db.fingerPrintModel.Where(u => u.EmailID == model.EmailID && u.Password != hashedPassword).Any();
//var newudb = db.fingerPrisntModel.Where(u => u.EmailID == model.EmailID && u.Password == hashedPassword).FirstOrDefault();
model.Password = hashedPassword;
model.TemplateFormatDB = TocompareFingerPrint;
db.fingerPrintModel.Add(model);
db.SaveChanges();
ModelState.Clear();
TempData["Success"] = model.Username + " successfully registered.";
ModelState.Clear();
return(RedirectToAction("Login", "Fingerprint"));
}
return(View());
}
public async void TestReturnProjectsFromDb()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test2")
.Options;
using (var context = new Databasecontext(options))
{
context.Projects.Add(new Project("user", DateTime.Now, DateTime.Now, 1.00, "test", "test")
{
ProjectId = 2,
UserId = "1",
StartDate = DateTime.Now,
EndDate = DateTime.Now,
PaymentOffered = 1.00,
ProjectName = "test",
Description = "test"
});
context.SaveChanges();
ProjectsController projectController = new ProjectsController(context);
var project = await projectController.GetProjects();
var result = project.Value;
Assert.Single(result);
}
}
public async void TestReturnSkills()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test1")
.Options;
using (var context = new Databasecontext(options))
{
var skill = new Skill()
{
SkillId = 1,
SkillName = "test",
Description = "test"
};
context.Add(skill);
context.SaveChanges();
SkillsController Skills = new SkillsController(context);
var skills = await Skills.GetSkills();
IEnumerable <Skill> result = skills.Value;
Assert.Equal("test", result.Last().Description);
Assert.Single(result);
}
}
public async void TestReturnContractorId()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test2")
.Options;
using (var context = new Databasecontext(options))
{
var contractor = new Contractor("test1", "test2", "test3", "test4", "test5");
context.Add(contractor);
context.SaveChanges();
ContractorsController ContractorPositions = new ContractorsController(context);
var contractors = await ContractorPositions.GetContractor(1);
Contractor result = contractors.Value;
Assert.Equal("test1", result.Username);
}
}
public async void TestDeleteNeedsSkill()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test3")
.Options;
using (var context = new Databasecontext(options))
{
var needskills = new PositionNeedsSkill(1, 1);
PositionNeedsSkillsController posskill = new PositionNeedsSkillsController(context);
context.Add(needskills);
context.SaveChanges();
await posskill.DeletePositionNeedsSkill(1);
var result = context.PositionNeedsSkills.Find(1);
Assert.Null(result);
}
}
public async void TestDeleteRequests()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test7")
.Options;
using (var context = new Databasecontext(options))
{
var hireRequest = new HireRequest(1, "1", "1");
HireRequestsController HireRequests = new HireRequestsController(context);
context.Add(hireRequest);
context.SaveChanges();
await HireRequests.DeleteHireRequest(1);
var result = context.HireRequests.Find(1);
Assert.Null(result);
}
}
public async void TestDeleteContractor()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test4")
.Options;
using (var context = new Databasecontext(options))
{
var contractor = new Contractor("test1", "test2", "test3", "test4", "test5");
ContractorsController ContractorPositions = new ContractorsController(context);
context.Add(contractor);
context.SaveChanges();
await ContractorPositions.DeleteContractor(1);
var result = context.Contractors.Find(1);
Assert.Null(result);
}
}
public async void TestGetLatestProjectsWithUserId()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test3")
.Options;
using (var context = new Databasecontext(options))
{
var project = new Project("user", DateTime.Now, DateTime.Now, 1.00, "test", "test")
{
ProjectId = 3,
UserId = "1",
StartDate = DateTime.Now,
EndDate = DateTime.Now,
PaymentOffered = 1.00,
ProjectName = "test",
Description = "test"
};
var project2 = new Project("user", DateTime.Now, DateTime.Now, 1.00, "test", "test")
{
ProjectId = 4,
UserId = "2",
StartDate = DateTime.Now,
EndDate = DateTime.Now,
PaymentOffered = 1.00,
ProjectName = "test",
Description = "test"
};
context.Add(project);
context.Add(project2);
context.SaveChanges();
ProjectsController projectController = new ProjectsController(context);
var actionresult = await projectController.GetLatestProjectByUser("2");
var result = (OkObjectResult)actionresult.Result;
Project result2 = (Project)result.Value;
// ActionResult okObjectResult = Assert.IsAssignableFrom<ActionResult>(actionresult);
// Project result = Assert.IsType<Project>(okObjectResult.);
Assert.Equal(4, result2.ProjectId);
}
}
public async void TestReturnProjectPositions()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test2")
.Options;
using (var context = new Databasecontext(options))
{
var projectPositions = new ProjectPositions();
context.Add(projectPositions);
context.SaveChanges();
ProjectPositionsController ProjectPositions = new ProjectPositionsController(context);
var projectpos = await ProjectPositions.GetProjectPositions();
IEnumerable <ProjectPositions> result = projectpos.Value;
Assert.Single(result);
}
}
public async void TestReturnProjectPositionsWithId()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test")
.Options;
using (var context = new Databasecontext(options))
{
var projectPositions = new ProjectPositions();
context.Add(projectPositions);
context.SaveChanges();
ProjectPositionsController ProjectPositions = new ProjectPositionsController(context);
var project = await ProjectPositions.GetProjectPositions(1);
ProjectPositions result = project.Value;
Assert.Equal(1, result.ProjectPositionsId);
}
}
public async void TestReturnClient()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test2")
.Options;
using (var context = new Databasecontext(options))
{
var Client = new Client("test1", "test2", "test3", "test4", "test5");
context.Clients.Add(Client);
context.SaveChanges();
ClientsController client = new ClientsController(context);
var clients = await client.GetClient(1);
Client result = clients.Value;
Assert.Equal("test1", result.Username);
}
}
public async void TestNeedSkill()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test1")
.Options;
using (var context = new Databasecontext(options))
{
var needskills = new PositionNeedsSkill(1, 1);
PositionNeedsSkillsController posskill = new PositionNeedsSkillsController(context);
context.Add(needskills);
context.SaveChanges();
var result = await posskill.GetPositionNeedsSkill(1);
PositionNeedsSkill results = result.Value;
Assert.Equal(1, results.PositionId);
Assert.IsType <PositionNeedsSkill>(results);
}
}
public async void TestContractorRequests()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test5")
.Options;
using (var context = new Databasecontext(options))
{
var hireRequest = new HireRequest(1, "1", "1");
HireRequestsController HireRequests = new HireRequestsController(context);
context.Add(hireRequest);
context.SaveChanges();
var actionresult = await HireRequests.GetContractorRequest("1");
var result = (OkObjectResult)actionresult.Result;
List <HireRequest> result2 = (List <HireRequest>)result.Value;
Assert.Equal("1", result2.Last().ContractorId);
}
}
public async void TestHireRequestsid()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test2")
.Options;
using (var context = new Databasecontext(options))
{
var hireRequest = new HireRequest(1, "1", "1");
HireRequestsController HireRequests = new HireRequestsController(context);
context.Add(hireRequest);
context.SaveChanges();
var hire = await HireRequests.GetHireRequest(1);
HireRequest result = hire.Value;
Assert.Equal("1", result.ClientId);
}
}
public async void TestGetProjectPositionsByProjectId()
{
var options = new DbContextOptionsBuilder <Databasecontext
>().UseInMemoryDatabase(databaseName: "Test3")
.Options;
using (var context = new Databasecontext(options))
{
var projectPositions = new ProjectPositions()
{
ProjectId = 1
};
context.Add(projectPositions);
context.SaveChanges();
ProjectPositionsController ProjectPositions = new ProjectPositionsController(context);
var actionresult = await ProjectPositions.GetPositionsByProjectId(1);
var result = (OkObjectResult)actionresult.Result;
List <ProjectPositions> result2 = (List <ProjectPositions>)result.Value;
Assert.Equal(1, result2.Last().ProjectId);
}
}