public ActionResult ViewStatus(int CrimeId) { CrimeDataLayer objCrimeDataLayer = new CrimeDataLayer(); CrimeModel objCrimeModel = objCrimeDataLayer.GetCrimeDetailsbyCrimeId(CrimeId); return(View(objCrimeModel)); }
public ActionResult Index() { CrimeDataLayer objCrimeDataLayer = new CrimeDataLayer(); List <CrimeModel> listCrime = objCrimeDataLayer.GetCrimeDetails(); return(View(listCrime)); }
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)); }
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()); }
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)); }
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()); }