public IHttpActionResult GetEmaployeeById(string employeeId) { employee_role objEmp = new employee_role(); /*int ID = Convert.ToInt32(employeeId);*/ try { objEmp = objEntity.employee_role.Where(e => e.Type_EmpCode == employeeId).FirstOrDefault(); /*var studentName = objEntity.employee_role.ToList();*/ /*if (objEmp == null) * { * return Ok(; * }*/ /*return Ok(studentName);*/ } catch (Exception) { return(NotFound()); /* throw;*/ } return(Ok(objEmp)); }
public IHttpActionResult DeleteEmaployeeDelete(string emp_code) { //int empId = Convert.ToInt32(id); employee_role emaployee = objEntity.employee_role.Where(e => e.Type_EmpCode == emp_code).FirstOrDefault <employee_role>(); if (emaployee == null) { return(NotFound()); } objEntity.employee_role.Remove(emaployee); objEntity.SaveChanges(); return(Ok(emaployee)); }
public IHttpActionResult PostEmaployee(employee_role data) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { objEntity.employee_role.Add(data); objEntity.SaveChanges(); } catch (Exception) { throw; } return(Ok(data)); }
public IHttpActionResult PutEmaployeeMaster(employee_role employee) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { //employee_role objEmp = new employee_role(); var objEmp = objEntity.employee_role.Where(e => e.Type_EmpCode == employee.Type_EmpCode).FirstOrDefault <employee_role>(); if (objEmp != null) { if (objEmp.IsActive != employee.IsActive || (objEmp.RoleCode != employee.RoleCode && objEmp.RoleCode == 4)) { var objticket = objEntity.tickets.Where(m => m.AssignedTo == employee.Type_EmpCode).ToList(); if (objticket.Count() != 0) { return(Ok(0)); } } objEmp.EmployeeName = employee.EmployeeName; objEmp.MobileNumber = employee.MobileNumber; objEmp.EmailId = employee.EmailId; objEmp.Password = employee.Password; objEmp.RoleCode = employee.RoleCode; objEmp.RightsCode = employee.RightsCode; objEmp.ModifiedDate = now; } int i = this.objEntity.SaveChanges(); } catch (Exception) { throw; } return(Ok(employee)); }
//Get action methods of the previous section public IHttpActionResult PostNewEmployee(employee_role emp) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } DateTime now = DateTime.Now; using (var ctx = new RMSAutomation_UATEntities2()) { ctx.employee_role.Add(new employee_role() { Type_EmpCode = emp.Type_EmpCode, EmployeeName = emp.EmployeeName, MobileNumber = emp.MobileNumber, Type = "Employees", Password = EPassword, EmailId = emp.EmailId, RoleCode = emp.RoleCode, RightsCode = emp.RightsCode, CreatedDate = now, FromDate = now, IsActive = true, MspCategory = emp.MspCategory }); ctx.SaveChanges(); if (emp.RoleCode == 4 || emp.RoleCode == 6) { /*atmmaster amm = objEntity.atmmasters.Where(e => e.HubLocationCode);*/ var result = objEntity.atmmasters.Select(m => new { m.RoCode, m.RoName, m.LocationCode, m.LocationName, m.HubLocationCode, m.HubLocationName }).Distinct().Where(i => emp.Hub.Contains(i.HubLocationCode)).ToList(); foreach (var value in result) { Console.WriteLine(value); ctx.employee_hierarchy.Add(new employee_hierarchy() { EmployeeCode = emp.Type_EmpCode, Region_Code = value.RoCode, Loc_Code = value.LocationCode, Hub_Location_Code = value.HubLocationCode, CreatedDate = now, FromDate = now, IsActive = 1 }); ctx.SaveChanges(); } } } return(Ok()); }