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()); } }