Esempio n. 1
0
        public ActionResult ViewStatus(int CrimeId)
        {
            CrimeDataLayer objCrimeDataLayer = new CrimeDataLayer();
            CrimeModel     objCrimeModel     = objCrimeDataLayer.GetCrimeDetailsbyCrimeId(CrimeId);

            return(View(objCrimeModel));
        }
Esempio n. 2
0
        public ActionResult Index()
        {
            CrimeDataLayer    objCrimeDataLayer = new CrimeDataLayer();
            List <CrimeModel> listCrime         = objCrimeDataLayer.GetCrimeDetails();

            return(View(listCrime));
        }
Esempio n. 3
0
        public ActionResult Index()
        {
            string            CurrentUser       = System.Web.HttpContext.Current.User.Identity.Name;
            CrimeDataLayer    objCrimeDataLayer = new CrimeDataLayer();
            List <CrimeModel> listCrime         = objCrimeDataLayer.GetCrimeDetailsByUserId(UserDataLayer.GetUserIdByEmail(CurrentUser));

            return(View(listCrime));
        }
Esempio n. 4
0
        public ActionResult Index()
        {
            CrimeDataLayer obj = new CrimeDataLayer();


            List <string> Queries = new List <string>
            {
                "sELECT COUNT(*) FROM tblCrime Where Location='Trivandrum'",
                "sELECT COUNT(*) FROM tblCrime Where Location='Kollam'",
                "sELECT COUNT(*) FROM tblCrime Where Location='Alappuzha'",
                "sELECT COUNT(*) FROM tblCrime Where Location='Thrissur'"
            };

            Location Location = obj.getCrimeRates(Queries);

            return(View(Location));
        }
        public ActionResult Index(FormCollection frmCollection)
        {
            string Crime = frmCollection["Crime"];

            CrimeModel objCrimeModel = new CrimeModel();

            objCrimeModel.Crime       = frmCollection["Crime"];
            objCrimeModel.Description = frmCollection["Description"];
            objCrimeModel.Criminal    = frmCollection["CriminalName"];
            objCrimeModel.Location    = frmCollection["Location"];
            CrimeDataLayer objDatalayer = new CrimeDataLayer();
            bool           Response     = objDatalayer.SaveCrime(objCrimeModel, 1);

            ViewBag.Status  = "success";
            ViewBag.Message = "Your crime details has been successfully sent to the department";

            return(View());
        }
Esempio n. 6
0
        public ActionResult UpdateStatus(int CrimeId, FormCollection frmCollection)
        {
            string         Status            = frmCollection["Status"].ToString();
            string         Comment           = frmCollection["Comment"].ToString();
            CrimeDataLayer objCrimeDataLayer = new CrimeDataLayer();
            bool           Result            = objCrimeDataLayer.UpdateCrimeStatus(CrimeId, Status, Comment);
            CrimeModel     objCrimeModel     = objCrimeDataLayer.GetCrimeDetailsbyCrimeId(CrimeId);

            if (Result)
            {
                ViewBag.Status  = "success";
                ViewBag.Message = "Your status and comments has been updated successfully";
            }
            else
            {
                ViewBag.Status  = "error";
                ViewBag.Message = "internal error occured";
            }

            return(View(objCrimeModel));
        }
Esempio n. 7
0
        public ActionResult Index(FormCollection frmCollection)
        {
            string Crime = frmCollection["Crime"];

            CrimeModel objCrimeModel = new CrimeModel();

            objCrimeModel.Crime       = frmCollection["Crime"];
            objCrimeModel.Description = frmCollection["Description"];
            objCrimeModel.Criminal    = frmCollection["CriminalName"];
            objCrimeModel.Location    = frmCollection["Location"];
            CrimeDataLayer objDatalayer = new CrimeDataLayer();
            bool           Response     = objDatalayer.SaveCrime(objCrimeModel, 0);

            //string PoliceEmail = WebConfigurationManager.AppSettings["Trivandrum"].ToString();
            //string Message =string.Format("This is to notify that a crime has been registered \n Details :{0} \n Name:{1}",objCrimeModel.Description,"username");
            //SMTPProtocol.NotifyPolice(string.Format("Crime Registered {0}", DateTime.Now.ToShortDateString()), Message, PoliceEmail);

            ViewBag.Status  = "success";
            ViewBag.Message = "Your crime details has been successfully sent to the department";

            return(View());
        }