public IHttpActionResult Put(int id, [FromBody] Employee emp)
{
try
{
using (WebApiDBEntities entity = new WebApiDBEntities())
{
var updateEmp = entity.Employees.FirstOrDefault(e => e.ID == id);
if (updateEmp != null)
{
updateEmp.FirstName = emp.FirstName;
updateEmp.LastName = emp.LastName;
updateEmp.Gender = emp.Gender;
updateEmp.Salary = emp.Salary;
entity.SaveChanges();
return(Ok(updateEmp));
}
else
{
return(NotFound());
}
}
}
catch (Exception ex)
{
return(BadRequest(ex.ToString()));
}
}
public static bool Login(string username, string password)
{
using (WebApiDBEntities entities = new WebApiDBEntities())
{
return(entities.Users.Any(u => u.Username.Equals(username, StringComparison.OrdinalIgnoreCase) && u.Password == password));
}
}
public void ReInitializeTest()
{
_dbEntities = new Mock <WebApiDBEntities>().Object;
_productRepository = SetUpProductRepository();
var unitOfWork = new Mock <IUnitOfWork>();
unitOfWork.SetupGet(s => s.ProductRepository).Returns(_productRepository);
_unitOfWork = unitOfWork.Object;
_productService = new ProductService(_unitOfWork);
}
public void Setup()
{
_products = SetUpProducts();
_dbEntities = new Mock <WebApiDBEntities>().Object;
_productRepository = SetUpProductRepository();
var unitOfWork = new Mock <IUnitOfWork>();
unitOfWork.SetupGet(s => s.ProductRepository).Returns(_productRepository);
_unitOfWork = unitOfWork.Object;
_productService = new ProductService(_unitOfWork);
_client = new HttpClient {
BaseAddress = new Uri(ServiceBaseURL)
};
}
public IHttpActionResult GetEmployeeSalary(int id)
{
using (WebApiDBEntities entity = new WebApiDBEntities())
{
Employee emp = entity.Employees.FirstOrDefault(e => e.ID == id);
if (emp != null)
{
return(Ok(emp.Salary));
}
else
{
return(NotFound());
}
}
}
public IHttpActionResult GetEmployeeByID(string name)
{
using (WebApiDBEntities entity = new WebApiDBEntities())
{
Employee emp = entity.Employees.FirstOrDefault(e => e.FirstName == name);
if (emp != null)
{
return(Ok(emp));
}
else
{
return(NotFound());
}
}
}
public IHttpActionResult Post([FromBody] Employee emp)
{
try
{
using (WebApiDBEntities entity = new WebApiDBEntities())
{
entity.Employees.Add(emp);
entity.SaveChanges();
return(Created(Request.RequestUri + "/" + emp.ID.ToString(), emp));
}
}
catch (Exception ex)
{
return(BadRequest(ex.ToString()));
}
}
public IHttpActionResult Get(string gender = "All")
{
string username = Thread.CurrentPrincipal.Identity.Name;
using (WebApiDBEntities entity = new WebApiDBEntities())
{
switch (username.ToLower())
{
case "all":
return(Ok(entity.Employees.ToList()));
case "ryan":
return(Ok(entity.Employees.Where(e => e.Gender.ToLower() == "male").ToList()));
case "jenn":
return(Ok(entity.Employees.Where(e => e.Gender.ToLower() == "female").ToList()));
default:
return(Unauthorized());
}
}
}
public IHttpActionResult Delete(int id)
{
try
{
using (WebApiDBEntities entity = new WebApiDBEntities())
{
var emp = entity.Employees.FirstOrDefault(e => e.ID == id);
if (emp == null)
{
return(NotFound());
}
else
{
entity.Employees.Remove(emp);
entity.SaveChanges();
return(Ok());
}
}
}
catch (Exception ex)
{
return(BadRequest(ex.ToString()));
}
}
public UnitOfWork()
{
_context = new WebApiDBEntities();
}
/// <summary>
/// Public Constructor,initializes privately declared local variables.
/// </summary>
/// <param name="context"></param>
public GenericRepository(WebApiDBEntities context)
{
this.Context = context;
this.DbSet = context.Set <TEntity>();
}
