public HttpResponseMessage UpdateCampus(Campus campus) { if (campus != null) { dbcontext.Entry(campus).State = EntityState.Modified; } try { dbcontext.SaveChanges(); } catch (Exception ex) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex); } HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, campus); response.StatusCode = HttpStatusCode.Created; response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return response; }
public HttpResponseMessage CreateCampus(Campus campus) { var checkName = dbcontext.Campuses.Where(c_name => c_name.CampusName == campus.CampusName).Any(); if (!checkName) { dbcontext.Campuses.Add(campus); try { dbcontext.SaveChanges(); } catch (Exception ex) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex); } HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, campus); response.StatusCode = HttpStatusCode.Created; response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return response; } HttpResponseMessage res = Request.CreateResponse(HttpStatusCode.OK, "Not Found"); return res; }
public HttpResponseMessage CreateCampus(Campus campus) { dbcontext.Campuses.Add(campus); try { dbcontext.SaveChanges(); } catch (Exception ex) { return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex); } HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, campus); response.StatusCode = HttpStatusCode.Created; response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return response; }
private void LoadCampus(HttpPostedFileBase file) { using (var package = new ExcelPackage(file.InputStream)) { var campusWorkSheet = package.Workbook.Worksheets["campus"]; var campusWorkSheetnoOfRow = campusWorkSheet.Dimension.End.Row; for (int rowIterator = 2; rowIterator <= campusWorkSheetnoOfRow; rowIterator++) { Campus campus = new Campus(); campus.CampusId = int.Parse(campusWorkSheet.Cells[rowIterator, 1].Value.ToString()); campus.CampusName = campusWorkSheet.Cells[rowIterator, 2].Value.ToString(); campus.CampusAddress = campusWorkSheet.Cells[rowIterator, 3].Value.ToString(); campus.City = campusWorkSheet.Cells[rowIterator, 4].Value.ToString(); campus.Province = campusWorkSheet.Cells[rowIterator, 5].Value.ToString(); campus.PostalCode = campusWorkSheet.Cells[rowIterator, 6].Value.ToString(); campus.Phone = campusWorkSheet.Cells[rowIterator, 7].Value.ToString(); dbcontext.Campuses.Add(campus); dbcontext.SaveChanges(); } } }