public HttpResponseMessage CreateDepartment(Department department)
        {
            var checkName = dbcontext.Departments.Where(d_name => d_name.dept_name == department.dept_name).Any();
            if (!checkName)
            {
                dbcontext.Departments.Add(department);
                try
                {
                    dbcontext.SaveChanges();
                }
                catch (Exception ex)
                {
                    return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
                }

                HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, department);

                response.StatusCode = HttpStatusCode.Created;

                response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");

                return response;
            }
            HttpResponseMessage res = Request.CreateResponse(HttpStatusCode.OK, "Not Found");
            return res;
        }
コード例 #2
0
        public HttpResponseMessage UpdateDepartment(Department department)
        {
            if (department != null)
            {
                db.Entry(department).State = EntityState.Modified;
            }

            try
            {
                db.SaveChanges();
            }
            catch (Exception ex)
            {
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
            }


            HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, department);

            response.StatusCode = HttpStatusCode.Created;

            response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");

            return response;
        }
コード例 #3
0
        public HttpResponseMessage CreateDepartment(Department department)
        {
            db.Departments.Add(department);
            try
            {
                db.SaveChanges();
            }
            catch (Exception ex)
            {
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
            }

            HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, department);

            response.StatusCode = HttpStatusCode.Created;

            response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");

            return response;
        }
        private void LoadDept(HttpPostedFileBase file)
        {
            using (var package = new ExcelPackage(file.InputStream))
            {
                var deptworkSheet = package.Workbook.Worksheets["Depts"];
                var deptnoOfRow = deptworkSheet.Dimension.End.Row;

                for (int rowIterator = 2; rowIterator <= deptnoOfRow; rowIterator++)
                {
                    Department dept = new Department();
                    if (deptworkSheet.Cells[rowIterator, 1].Value != null)
                    {
                        //dept.dept_Id = int.Parse(deptworkSheet.Cells[rowIterator, 1].Value.ToString());
                        dept.dept_name = deptworkSheet.Cells[rowIterator, 1].Value.ToString();
                        dept.room_no = deptworkSheet.Cells[rowIterator, 2].Value.ToString();
                        dept.campus_Id = int.Parse(deptworkSheet.Cells[rowIterator, 3].Value.ToString());
                        dbcontext.Departments.Add(dept);
                        dbcontext.SaveChanges();
                    }
                }
            }
        }