Exemplo n.º 1
0
        public JsonResult addNewEmployee(Employeedata emp)
        {
            tbl_employees employee = new tbl_employees()
            {
                emp_first_name = emp.firstName,
                emp_last_name  = emp.lastName,
                emp_email      = emp.email,
                emp_gender     = emp.gender,
                emp_password   = emp.password,
                emp_dob        = emp.dob,
                emp_status     = 1
            };

            db.tbl_employees.Add(employee);
            int a = db.SaveChanges();

            if (a > 0)
            {
                my_response res = new my_response()
                {
                    message = "Employee created successfully",
                    status  = "success"
                };
                return(Json(res, JsonRequestBehavior.AllowGet));
            }
            else
            {
                my_response res = new my_response()
                {
                    message = "Employee creation failed.",
                    status  = "error"
                };
                return(Json(res, JsonRequestBehavior.AllowGet));
            }
        }
Exemplo n.º 2
0
        public IHttpActionResult Puttbl_employees(int id, tbl_employees tbl_employees)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != tbl_employees.id)
            {
                return(BadRequest());
            }

            db.Entry(tbl_employees).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!tbl_employeesExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Exemplo n.º 3
0
        public IHttpActionResult Gettbl_employees(int id)
        {
            tbl_employees tbl_employees = db.tbl_employees.Find(id);

            if (tbl_employees == null)
            {
                return(NotFound());
            }

            return(Ok(tbl_employees));
        }
Exemplo n.º 4
0
        public IHttpActionResult Posttbl_employees(tbl_employees tbl_employees)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.tbl_employees.Add(tbl_employees);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = tbl_employees.id }, tbl_employees));
        }
Exemplo n.º 5
0
        public IHttpActionResult Deletetbl_employees(int id)
        {
            tbl_employees tbl_employees = db.tbl_employees.Find(id);

            if (tbl_employees == null)
            {
                return(NotFound());
            }

            db.tbl_employees.Remove(tbl_employees);
            db.SaveChanges();

            return(Ok(tbl_employees));
        }