using Ligtas.PH.App_Code;
using Ligtas.PH.Models;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;

namespace Ligtas.PH.Controllers
{
    public class IncidentController : ApiController
    {
        // GET: api/Incident
        public List<IncidentModel> Get()
        {
            var list = new List<IncidentModel>();
            using (SqlConnection con = new SqlConnection(Helper.GetCon()))
            {
                con.Open();
                string query = @"Select incident_type,firstname,lastname,lat,lng,date_added,date_reported,crime_upvote
                     FROM crime_table";
                using (SqlCommand cmd = new SqlCommand(query, con))
                {
                    using (SqlDataReader dr = cmd.ExecuteReader())
                    {
                        while (dr.Read())
                        {
                            list.Add(new IncidentModel
                            {
                                incident_type = int.Parse(dr["incident_type"].ToString()),
                                firstname = dr["firstname"].ToString(),
                                lastname = dr["lastname"].ToString(),
                                lat = float.Parse(dr["lat"].ToString()),
                                lng = float.Parse(dr["lng"].ToString()),
                                date_added = DateTime.Parse(dr["date_added"].ToString()),
                                date_reported = DateTime.Parse(dr["date_reported"].ToString()),
                                crime_upvote = int.Parse(dr["crime_upvote"].ToString())
                            });
                        }
                    }
                    con.Close();
                }
            }
            return list;
        }

        // GET: api/Incident/5
        public IncidentModel Get(int id)
        {
            var record = new IncidentModel();


            using (SqlConnection con = new SqlConnection(Helper.GetCon()))
            {
                con.Open();

                string query = @"Select incident_type,firstname,lastname,lat,lng,date_added,date_reported,incident_upvote
                     FROM crime_table where crime_ID = @crime_ID";

                using (SqlCommand cmd = new SqlCommand(query, con))
                {
                    cmd.Parameters.AddWithValue("@user_ID", id);
                    using (SqlDataReader dr = cmd.ExecuteReader())
                    {
                        if (dr.HasRows)
                        {
                            while (dr.Read())
                            {
                                record.crime_ID = int.Parse(dr["incident_ID"].ToString());
                                record.firstname = dr["firstname"].ToString();
                                record.lastname = dr["lastname"].ToString();
                                record.lat = float.Parse(dr["lat"].ToString());
                                record.lng = float.Parse(dr["lng"].ToString());
                                record.date_added = DateTime.Parse(dr["date_added"].ToString());
                                record.date_reported = DateTime.Parse(dr["date_reported"].ToString());
                                record.crime_upvote = int.Parse(dr["crime_upvote"].ToString());
                            }
                        }

                    }
                }
            }
            return record;
        }

        // POST: api/Incident
        public string Post(IncidentModel record)
        {

                using (SqlConnection con = new SqlConnection(Helper.GetCon()))
                {
                    con.Open();
                    string query = "INSERT INTO crime_table VALUES (@incident_type,@firstname,@lastname,@lat,@lng,@date_added,@date_reported," +
                    "@crime_upvote)";
                    using (SqlCommand cmd = new SqlCommand(query, con))
                    {

                        cmd.Parameters.AddWithValue("@incident_type", record.incident_type);
                        cmd.Parameters.AddWithValue("@firstname", record.firstname);
                        cmd.Parameters.AddWithValue("@lastname", record.lastname);
                        cmd.Parameters.AddWithValue("@lat", record.lat);
                        cmd.Parameters.AddWithValue("@lng", record.lng);
                        record.date_added = DateTime.Now;
                        cmd.Parameters.AddWithValue("@date_added", record.date_added);
                        record.date_reported = DateTime.Now;
                        cmd.Parameters.AddWithValue("@date_reported", record.date_reported);
                        cmd.Parameters.AddWithValue("@crime_upvote", record.crime_upvote);
                        cmd.ExecuteNonQuery();
                        con.Close();
                        return "Added Sucessfully";
                    }
                }
            }





    }
}