public IHttpActionResult SaveModelSalary(ModelSalary salary)
{
EmpDbEntities entity = new EmpDbEntities();
SalaryTable exist = entity.SalaryTables.Where(d => d.EmployeeId == salary.EmployeeId).FirstOrDefault();
if (exist != null)
{
throw new Exception("The salary already added for this employee.");
}
SalaryTable table = new SalaryTable();
table.Salary = salary.Salary;
table.EmployeeId = salary.EmployeeId;
entity.SalaryTables.Add(table);
int result = entity.SaveChanges();
if (result > 0)
{
return(Ok("Successfully save"));
}
else
{
return(BadRequest("Failed to Save"));
}
}
public IHttpActionResult UpdateModelSalary(long employeeId, ModelSalary salary)
{
EmpDbEntities entity = new EmpDbEntities();
SalaryTable exist = entity.SalaryTables.Where(d => d.EmployeeId == employeeId).FirstOrDefault();
if (exist != null)
{
SalaryTable table = new SalaryTable();
table.Salary = salary.Salary;
table.EmployeeId = employeeId;
entity.SalaryTables.AddOrUpdate(table);
int result = entity.SaveChanges();
if (result > 0)
{
return(Ok("Successfully Updated"));
}
else
{
return(BadRequest("Failed to Update"));
}
}
else
{
return(BadRequest("Failed to Update"));
}
}
public IHttpActionResult GetModelSalary(long employeeId)
{
EmpDbEntities entity = new EmpDbEntities();
SalaryTable exist = entity.SalaryTables.Where(d => d.EmployeeId == employeeId).FirstOrDefault();
if (exist != null)
{
ModelSalary model = new ModelSalary();
model.Salary = Convert.ToSingle(exist.Salary);
model.EmployeeId = employeeId;
return(Ok(model));
}
else
{
return(NotFound());
}
}
