/// <summary>
/// Get a List of Custom Employees
/// </summary>
/// <returns></returns>
// GET: api/Employees
public List <EmployeeCustom> GetEmployee()
{
List <Employee> employees = repository.GetAll();
// New Employee custom list
List <EmployeeCustom> empCustomList = new List <EmployeeCustom>();
decimal currentSalary;
foreach (Employee emp in employees)
{
if (emp.fk_ContractType == 1) // Hourly Salary
{
currentSalary = _employeeService.CalculateAnnualHourlySalary(emp.hourlySalary ?? 0);
}
else // Monthly Salary
{
currentSalary = _employeeService.CalculateAnnualMonthlySalary(emp.monthlySalary ?? 0);
}
EmployeeCustom empCustom = new EmployeeCustom {
idEmployee = emp.idEmployee,
employeeName = emp.employeeName,
employeePhone = emp.employeePhone,
employeePosition = emp.employeePosition,
contractType = db.ContractType.Where(ct => ct.idContractType == emp.fk_ContractType).FirstOrDefault().contractTypeName,
hourlySalary = emp.hourlySalary,
monthlySalary = emp.monthlySalary,
annualHourlySalary = currentSalary,
//annualMonthlySalary = _employeeService.CalculateAnnualMonthlySalary(emp.monthlySalary ?? 0)
};
empCustomList.Add(empCustom);
}
return(empCustomList);
}
public void GetEmployeeWhereLambda()
{
using (var cn = LocalDb.GetConnection("DapperCX"))
{
string lastName = "Yarga";
var emp = new EmployeeCustom()
{
FirstName = lastName,
LastName = GetLastName(),
IsExempt = true,
HireDate = DateTime.Today,
Value = OtherEnum.Other
};
var provider = GetProvider();
int id = provider.SaveAsync(cn, emp).Result;
emp = provider.GetWhereAsync <EmployeeCustom>(cn,
e => e.FirstName == lastName,
e => e.LastName == GetLastName()).Result;
Assert.IsTrue(emp.Id == id);
}
}
/// <summary>
/// Upload Employee
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public string UploadEmployee(EmployeeCustom data)
{
string result = "";
try
{
SqlConnection con = new SqlConnection(@"Data Source = (localdb)\MSSQLLocalDB; Initial Catalog = Test; Integrated Security = True");
SqlCommand cmd = new SqlCommand("UpdateEmployee", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@employeeName", data.employeeName);
cmd.Parameters.AddWithValue("@employeeNo", data.employeeNo);
cmd.Parameters.AddWithValue("@departmentId", data.departmentId);
cmd.Parameters.AddWithValue("@salary", data.salary);
cmd.Parameters.AddWithValue("@joiningDate", data.joiningDate);
cmd.Parameters.AddWithValue("@id", data.id);
cmd.Parameters.AddWithValue("@modifiedOn", DateTime.Now);
con.Open();
object res = cmd.ExecuteScalar();
con.Close();
return(result = "Updated Successfully");
}
catch (Exception ex)
{
return(result = "Not Updated");
}
}
public ActionResult UpdateEmployee(EmployeeCustom data)
{
EmployeeDAL employeeDAL = new EmployeeDAL();
string result = employeeDAL.UploadEmployee(data);
ViewData["result"] = result;
ModelState.Clear();
return(View());
}
public ActionResult InsertEmployee(EmployeeCustom data)
{
EmployeeDAL employeeDAL = new EmployeeDAL();
string result = employeeDAL.InsertEmployee(data);
ViewData["result"] = result;
ModelState.Clear();
var check = db.Departments.Where(m => m.isDeleted == 0).Select(m => new { m.departmentName, m.Id }).ToList();
ViewBag.departmentList = check;
return(View());
}
public void GetEmployeeWithRelated()
{
using (var cn = LocalDb.GetConnection("DapperCX"))
{
var emp = new EmployeeCustom()
{
FirstName = "Whoever",
LastName = "Nobody",
IsExempt = true,
HireDate = DateTime.Today,
Value = OtherEnum.Other
};
var provider = GetProvider();
int id = provider.SaveAsync(cn, emp).Result;
emp = provider.GetAsync <EmployeeCustom>(cn, id).Result;
Assert.IsTrue(emp.Something.SequenceEqual(new string[] { "this", "that", "other" }));
Assert.IsTrue(emp.SomethingElse.SequenceEqual(new DateTime[] { DateTime.Today }));
}
}
public IHttpActionResult PostEmployee(EmployeeCustom employee)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
// Mapping Employee
Employee _employee = new Employee {
employeeName = employee.employeeName,
employeePhone = employee.employeePhone,
employeePosition = employee.employeePosition,
hourlySalary = employee.hourlySalary,
monthlySalary = employee.monthlySalary,
fk_ContractType = db.ContractType.Where(ct => ct.contractTypeName == employee.contractType).FirstOrDefault().idContractType
};
db.Employee.Add(_employee);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = employee.idEmployee }, employee));
}
public List <EmployeeCustom> GetEmployee(int id)
{
// GetEmployee Employee by ID
Employee emp = repository.GetById(id);
if (emp == null)
{
return(null);
}
decimal currentSalary;
if (emp.fk_ContractType == 1) // Hourly Salary
{
currentSalary = _employeeService.CalculateAnnualHourlySalary(emp.hourlySalary ?? 0);
}
else // Monthly Salary
{
currentSalary = _employeeService.CalculateAnnualMonthlySalary(emp.monthlySalary ?? 0);
}
EmployeeCustom empCustom = new EmployeeCustom
{
idEmployee = emp.idEmployee,
employeeName = emp.employeeName,
employeePhone = emp.employeePhone,
employeePosition = emp.employeePosition,
contractType = db.ContractType.Where(ct => ct.idContractType == emp.fk_ContractType).FirstOrDefault().contractTypeName,
hourlySalary = emp.hourlySalary,
monthlySalary = emp.monthlySalary,
annualHourlySalary = currentSalary,
//annualMonthlySalary = _employeeService.CalculateAnnualMonthlySalary(emp.monthlySalary ?? 0)
};
List <EmployeeCustom> empList = new List <EmployeeCustom>();
empList.Add(empCustom);
return(empList);
}
