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));
}
