public IHttpActionResult PostvEmployee(vEmployee vEmployee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.vEmployee.Add(vEmployee);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (vEmployeeExists(vEmployee.FirstName))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = vEmployee.FirstName }, vEmployee));
}
// GET: OrgChart/Details/5
public ActionResult OrgChart(int?id)
{
id = id ?? 1;
OrgStructure orgstructure = new OrgStructure();
//Application Insight Telemetry
var tc = new TelemetryClient();
var eventTel = new EventTelemetry();
var stopwatch = System.Diagnostics.Stopwatch.StartNew();
vEmployee employee = db.vEmployees.SqlQuery("exec [HumanResources].[uspGetEmployeeDetail] @BusinessEntityID", new SqlParameter("@BusinessEntityID", id)).FirstOrDefault();
vEmployee manager = db.vEmployees.SqlQuery("exec [HumanResources].[uspGetDirectManager] @BusinessEntityID", new SqlParameter("@BusinessEntityID", id)).FirstOrDefault();
List <vEmployee> directreports = db.vEmployees.SqlQuery("exec [HumanResources].[uspGetDirectReports] @BusinessEntityID", new SqlParameter("@BusinessEntityID", id)).ToList();
stopwatch.Stop();
eventTel.Name = "SQLQueryPerformance - OrgChart View";
eventTel.Metrics["Query Time"] = stopwatch.Elapsed.TotalMilliseconds;
eventTel.Properties["Query Description"] = "SQL DB query to get a manager and direct reports using the hierarchy id.";
tc.TrackEvent(eventTel);
orgstructure.Employee = employee;
orgstructure.Manager = manager;
orgstructure.DirectReports = directreports;
return(View(orgstructure));
}
public IHttpActionResult PutvEmployee(string id, vEmployee vEmployee)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != vEmployee.FirstName)
{
return(BadRequest());
}
db.Entry(vEmployee).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!vEmployeeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetvEmployee(string id)
{
vEmployee vEmployee = db.vEmployee.Find(id);
if (vEmployee == null)
{
return(NotFound());
}
return(Ok(vEmployee));
}
public IHttpActionResult DeletevEmployee(string id)
{
vEmployee vEmployee = db.vEmployee.Find(id);
if (vEmployee == null)
{
return(NotFound());
}
db.vEmployee.Remove(vEmployee);
db.SaveChanges();
return(Ok(vEmployee));
}
public void Setup()
{
Target = new EmployeeRepository();
Expected = Target.Entities.vEmployees.First(x => x.City == "seattle");
OldFistName = Expected.FirstName;
OldLastName = Expected.LastName;
UpdateEmployee = new EmployeeDto
{
FirstName = "Joe",
LastName = "Bob",
Id = Expected.BusinessEntityID
};
Target.UpdateEmployee(UpdateEmployee);
Actual = Target.Entities.vEmployees.Single(x => x.BusinessEntityID == Expected.BusinessEntityID);
}
public void Setup()
{
Target = new EmployeeRepository();
Expected = Target.Entities.vEmployees.First(x=>x.City=="seattle");
OldFistName = Expected.FirstName;
OldLastName = Expected.LastName;
UpdateEmployee = new EmployeeDto
{
FirstName = "Joe",
LastName = "Bob",
Id = Expected.BusinessEntityID
};
Target.UpdateEmployee(UpdateEmployee);
Actual = Target.Entities.vEmployees.Single(x => x.BusinessEntityID == Expected.BusinessEntityID);
}
public ActionResult EmployeeDetails(string employeeID)
{
vEmployee _emp = _employeesvc.GetEmployeeDetailsByID(Convert.ToInt32(employeeID));
return(PartialView(_emp));
}
/// <summary>
/// There are no comments for vEmployee in the schema.
/// </summary>
public void AddTovEmployee(vEmployee vEmployee)
{
base.AddObject("vEmployee", vEmployee);
}
/// <summary>
/// Create a new vEmployee object.
/// </summary>
/// <param name="employeeID">Initial value of EmployeeID.</param>
/// <param name="firstName">Initial value of FirstName.</param>
/// <param name="lastName">Initial value of LastName.</param>
/// <param name="jobTitle">Initial value of JobTitle.</param>
/// <param name="emailPromotion">Initial value of EmailPromotion.</param>
/// <param name="addressLine1">Initial value of AddressLine1.</param>
/// <param name="city">Initial value of City.</param>
/// <param name="stateProvinceName">Initial value of StateProvinceName.</param>
/// <param name="postalCode">Initial value of PostalCode.</param>
/// <param name="countryRegionName">Initial value of CountryRegionName.</param>
public static vEmployee CreatevEmployee(int employeeID, string firstName, string lastName, string jobTitle, int emailPromotion, string addressLine1, string city, string stateProvinceName, string postalCode, string countryRegionName)
{
vEmployee vEmployee = new vEmployee();
vEmployee.EmployeeID = employeeID;
vEmployee.FirstName = firstName;
vEmployee.LastName = lastName;
vEmployee.JobTitle = jobTitle;
vEmployee.EmailPromotion = emailPromotion;
vEmployee.AddressLine1 = addressLine1;
vEmployee.City = city;
vEmployee.StateProvinceName = stateProvinceName;
vEmployee.PostalCode = postalCode;
vEmployee.CountryRegionName = countryRegionName;
return vEmployee;
}
