예제 #1
0
        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));
        }
예제 #2
0
        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));
        }
예제 #3
0
 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));
 }
예제 #4
0
        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));
        }
예제 #5
0
        //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());
        }