コード例 #1
0
        // POST: api/M_Employees
        public Responses Post([FromBody] M_EmployeeViewModel entity)
        {
            Responses result = new Responses();

            if (ModelState.IsValid)
            {
                result = M_EmployeeRepo.Update(entity);
            }
            else
            {
                result.Success = false;
            }
            return(result);
        }
コード例 #2
0
        public static Responses Update(M_EmployeeViewModel entity)
        {
            Responses result = new Responses();

            try
            {
                using (var db = new MarcomContext())
                {
                    if (entity.Id != 0)
                    {
                        m_employee employee = db.m_employee.Where(o => o.id == entity.Id).FirstOrDefault();
                        if (employee != null)
                        {
                            employee.id = entity.Id;
                            employee.employee_number = entity.EmployeeNumber;
                            employee.first_name      = entity.FirstName;
                            employee.last_name       = entity.LastName;
                            employee.m_company_id    = entity.MCompanyId;
                            employee.email           = entity.Email;
                            employee.is_delete       = entity.IsDelete;
                            employee.updated_by      = "Ryan";
                            employee.updated_date    = DateTime.Now;
                            db.SaveChanges();
                        }
                    }
                    else
                    {
                        m_employee employee = new m_employee();
                        employee.id = entity.Id;
                        employee.employee_number = GetNewCode();
                        employee.first_name      = entity.FirstName;
                        employee.last_name       = entity.LastName;
                        employee.m_company_id    = entity.MCompanyId;
                        employee.email           = entity.Email;
                        employee.is_delete       = false;
                        employee.created_by      = "Ryan";
                        employee.created_date    = DateTime.Now;
                        db.m_employee.Add(employee);
                        db.SaveChanges();
                    }
                }
            }
            catch (Exception ex)
            {
                result.Message = ex.Message;
                result.Success = false;
            }
            return(result);
        }
コード例 #3
0
        public static M_EmployeeViewModel GetById(int id)
        {
            M_EmployeeViewModel result = new M_EmployeeViewModel();

            using (var db = new MarcomContext())
            {
                result = (from e in db.m_employee
                          join c in db.m_company on
                          e.m_company_id equals c.id
                          where e.id == id
                          select new M_EmployeeViewModel
                {
                    Id = e.id,
                    EmployeeNumber = e.employee_number,
                    FirstName = e.first_name,
                    LastName = e.last_name,
                    MCompanyId = c.id,
                    MCompanyName = c.name,
                    Email = e.email,
                    IsDelete = e.is_delete
                }).FirstOrDefault();
            }
            return(result);
        }