public IHttpActionResult SaveModelSalarys(List <ModelSalary> salary)
{
EmpDbEntities entity = new EmpDbEntities();
salary.ForEach(d =>
{
SalaryTable exist = entity.SalaryTables.Where(k => k.EmployeeId == d.EmployeeId).FirstOrDefault();
if (exist != null)
{
throw new Exception("Record is Already exist");
}
SalaryTable table = new SalaryTable();
table.Salary = d.Salary;
table.EmployeeId = d.EmployeeId;
entity.SalaryTables.Add(table);
});
int result = entity.SaveChanges();
if (result > 0)
{
return(Ok("Successfully Saved"));
}
else
{
return(BadRequest("Failed to Save"));
}
}
public IHttpActionResult SaveModelPhoto(ModelPhoto photo)
{
EmpDbEntities entity = new EmpDbEntities();
PhotoTable exist = entity.PhotoTables.Where(d => d.EmployeeId == photo.EmployeeId).FirstOrDefault();
if (exist != null)
{
throw new Exception("Photo already exist");
}
PhotoTable newData = new PhotoTable();
newData.Photo = photo.Photo;
newData.EmployeeId = photo.EmployeeId;
entity.PhotoTables.Add(newData);
bool result = entity.SaveChanges() > 0;
if (result)
{
return(Ok("Successfully Saved"));
}
else
{
return(BadRequest("Failed to Save"));
}
}
public IHttpActionResult UpdateEmployee(string employeeName, Employee employee)
{
EmpDbEntities entity = new EmpDbEntities();
EmployeeTable exist =
entity.EmployeeTables.Where(d => d.EmployeeName == employeeName).FirstOrDefault();
if (exist != null)
{
exist.EmployeeName = employee.EmployeeName;
exist.EmployeeAddress = employee.EmployeeAddress;
exist.EmployeeEmail = employee.EmployeeEmail;
exist.EmployeePhoneNo = employee.EmployeePhoneNo;
exist.IsActive = employee.IsActive;
entity.EmployeeTables.Add(exist);
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 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 SaveEmployees(List <Employee> employee)
{
EmpDbEntities entity = new EmpDbEntities();
employee.ForEach(d =>
{
EmployeeTable exist =
entity.EmployeeTables.Where(k => k.EmployeeName == d.EmployeeName).FirstOrDefault();
if (exist != null)
{
throw new Exception("Record is Already exist");
}
EmployeeTable table = new EmployeeTable();
table.EmployeeName = d.EmployeeName;
table.EmployeeAddress = d.EmployeeAddress;
table.EmployeeEmail = d.EmployeeEmail;
table.EmployeePhoneNo = d.EmployeePhoneNo;
entity.EmployeeTables.Add(table);
});
int result = entity.SaveChanges();
if (result > 0)
{
return(Ok("Successfully Ssaved"));
}
else
{
return(BadRequest("Failed to Save"));
}
}
public IHttpActionResult SaveEmployee(Employee employee)
{
EmpDbEntities entity = new EmpDbEntities();
EmployeeTable exist = entity.EmployeeTables.Where(d => d.EmployeeName == employee.EmployeeName).FirstOrDefault();
if (exist != null)
{
throw new Exception("Record is already exist");
}
EmployeeTable table = new EmployeeTable();
table.EmployeeName = employee.EmployeeName;
table.EmployeeAddress = employee.EmployeeAddress;
table.EmployeePhoneNo = employee.EmployeePhoneNo;
table.EmployeeEmail = employee.EmployeeEmail;
table.IsActive = employee.IsActive;
entity.EmployeeTables.Add(table);
int result = entity.SaveChanges();
long empId = table.EmployeeId;
if (result > 0)
{
return(Ok(empId));
}
else
{
return(BadRequest("Failed to Save"));
}
}
public IHttpActionResult GetPhoto(long employeeId)
{
EmpDbEntities entity = new EmpDbEntities();
PhotoTable exist = entity.PhotoTables.Where(d => d.EmployeeId == employeeId).FirstOrDefault();
if (exist != null)
{
ModelPhoto model = new ModelPhoto();
model.Photo = exist.Photo;
model.EmployeeId = employeeId;
return(Ok(model));
}
else
{
return(NotFound());
}
}
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());
}
}
public IHttpActionResult GetEmployee(string employeeName)
{
EmpDbEntities entity = new EmpDbEntities();
EmployeeTable exist = entity.EmployeeTables.Where(d => d.EmployeeName == employeeName).FirstOrDefault();
if (exist != null)
{
Employee employee = new Employee();
employee.EmployeeName = exist.EmployeeName;
employee.EmployeeAddress = exist.EmployeeAddress;
employee.EmployeeEmail = exist.EmployeeEmail;
employee.EmployeePhoneNo = exist.EmployeePhoneNo;
employee.IsActive = exist.IsActive;
return(Ok(employee));
}
else
{
return(NotFound());
}
}
public IHttpActionResult GetmodelSalarys()
{
EmpDbEntities entity = new EmpDbEntities();
List <SalaryTable> salarys = entity.SalaryTables.ToList();
if (salarys.Count > 0)
{
List <SalaryTable> result = new List <SalaryTable>();
salarys.ForEach(d =>
{
SalaryTable table = new SalaryTable();
table.Salary = d.Salary;
table.EmployeeId = d.EmployeeId;
result.Add(table);
});
return(Ok(result));
}
else
{
return(NotFound());
}
}
public IHttpActionResult DeleteModelSalary(long employeeId)
{
EmpDbEntities entity = new EmpDbEntities();
SalaryTable exist = entity.SalaryTables.Where(k => k.EmployeeId == employeeId).FirstOrDefault();
if (exist != null)
{
entity.SalaryTables.Remove(exist);
int result = entity.SaveChanges();
if (result > 0)
{
return(Ok("Successfully Deleted"));
}
else
{
return(BadRequest("Failed to Delete"));
}
}
else
{
return(BadRequest("Failed to Delete"));
}
}
public IHttpActionResult DeleteEmployee(string EmployeeName)
{
EmpDbEntities entity = new EmpDbEntities();
EmployeeTable exist = entity.EmployeeTables.Where(d => d.EmployeeName == EmployeeName).FirstOrDefault();
if (exist != null)
{
entity.EmployeeTables.Remove(exist);
int res = entity.SaveChanges();
if (res > 0)
{
return(Ok("Successfully Deleted"));
}
else
{
return(BadRequest("Failed to Delete"));
}
}
else
{
return(BadRequest("Failed to Delete"));
}
}
public IHttpActionResult GetEmployees()
{
EmpDbEntities entity = new EmpDbEntities();
List <EmployeeTable> employees = entity.EmployeeTables.ToList();
if (employees.Count > 0)
{
List <Employee> result = new List <Employee>();
employees.ForEach(d =>
{
Employee employee = new Employee();
employee.EmployeeName = d.EmployeeName;
employee.EmployeeAddress = d.EmployeeAddress;
employee.EmployeeEmail = d.EmployeeEmail;
employee.EmployeePhoneNo = d.EmployeePhoneNo;
result.Add(employee);
});
return(Ok());
}
else
{
return(NotFound());
}
}
