Example #1
0
        protected void ReportSubmit_Click(object sender, EventArgs e)
        {
            DateTime?my_date;
            float?   c_lat, c_long;

            try {
                my_date = DateTime.Parse(c_date.Value);
            }
            catch
            {
                my_date = null;
            }
            try
            {
                c_lat  = float.Parse(latMap.Value);
                c_long = float.Parse(lngMap.Value);
            }
            catch
            {
            }

            using (CrimeDBEntities CE = new CrimeDBEntities())
            {
                var ci = new CrimeInstance
                {
                    detail   = c_detail.Value,
                    date     = my_date,
                    category = Int32.Parse(c_category.Value)
                };
                CE.CrimeInstances.Add(ci);
                CE.SaveChanges();
            }
        }
        // PUT api/CI/5
        public IHttpActionResult PutCrimeInstance(int id, CrimeInstance crimeinstance)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

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

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

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

            return StatusCode(HttpStatusCode.NoContent);
        }
        protected void ReportSubmit_Click(object sender, EventArgs e)
        {
            DateTime? my_date;
            float? c_lat, c_long;
            try {
                my_date = DateTime.Parse(c_date.Value);
            }
            catch
            {
                my_date = null;
            }
            try
            {
                c_lat = float.Parse(latMap.Value);
                c_long = float.Parse(lngMap.Value);
            }
            catch
            {

            }

            using (CrimeDBEntities CE = new CrimeDBEntities())
            {
                var ci = new CrimeInstance
                {
                    detail = c_detail.Value,
                    date = my_date,
                    category = Int32.Parse(c_category.Value)
                };
                CE.CrimeInstances.Add(ci);
                CE.SaveChanges();
            }
        }
        // PUT api/CI/5
        public IHttpActionResult PutCrimeInstance(int id, CrimeInstance crimeinstance)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

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

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

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

            return(StatusCode(HttpStatusCode.NoContent));
        }
        public IHttpActionResult GetCrimeInstance(int id)
        {
            CrimeInstance crimeinstance = db.CrimeInstances.Find(id);

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

            return(Ok(crimeinstance));
        }
        public IHttpActionResult PostCrimeInstance(CrimeInstance crimeinstance)
        {
            if (!ModelState.IsValid)
            {
                return BadRequest(ModelState);
            }

            db.CrimeInstances.Add(crimeinstance);
            db.SaveChanges();

            return CreatedAtRoute("DefaultApi", new { id = crimeinstance.Id }, crimeinstance);
        }
        public IHttpActionResult PostCrimeInstance(CrimeInstance crimeinstance)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.CrimeInstances.Add(crimeinstance);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = crimeinstance.Id }, crimeinstance));
        }
        public IHttpActionResult DeleteCrimeInstance(int id)
        {
            CrimeInstance crimeinstance = db.CrimeInstances.Find(id);

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

            db.CrimeInstances.Remove(crimeinstance);
            db.SaveChanges();

            return(Ok(crimeinstance));
        }