public bool SaveCrime(CrimeModel ObjCrimeObject, int IsWomensCrime) { using (SqlConnection con = new SqlConnection(SqlConnect.GetConnection)) { try { con.Open(); SqlCommand cmd = new SqlCommand("INSERT INTO tblCrime (Crime,Description,Criminal,Location,IsWomensCrime,UserId) VALUES (@Crime,@Description,@Criminal,@Location,@IsWomensCrime,@Userid)", con); cmd.Parameters.AddWithValue("@Crime", ObjCrimeObject.Crime); cmd.Parameters.AddWithValue("@Description", ObjCrimeObject.Description); cmd.Parameters.AddWithValue("@Criminal", ObjCrimeObject.Criminal); cmd.Parameters.AddWithValue("@Location", ObjCrimeObject.Location); cmd.Parameters.AddWithValue("@IsWomensCrime", IsWomensCrime); cmd.Parameters.AddWithValue("@Userid", UserDataLayer.GetUserIdByEmail(System.Web.HttpContext.Current.User.Identity.Name)); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { con.Close(); } } return(true); }
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)); }