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);
}
internal CrimeModel GetCrimeDetailsbyCrimeId(int CrimeId)
{
CrimeModel objCrimeModel = new CrimeModel();
using (SqlConnection con = new SqlConnection(SqlConnect.GetConnection))
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * from tblCrime where CrimeId=@CrimeId order by 1 desc", con);
cmd.Parameters.AddWithValue("@CrimeId", CrimeId);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
CrimeModel FetchCrime = new CrimeModel
{
CrimeId = (int)rdr["CrimeId"],
Crime = rdr["Crime"].ToString(),
Criminal = rdr["Criminal"].ToString(),
Description = rdr["Description"].ToString(),
Location = rdr["Location"].ToString(),
Status = rdr["Status"].ToString(),
StatusCode = DefineStatus(rdr["Status"].ToString()),
Comments = ReadComment(CrimeId)
};
objCrimeModel = FetchCrime;
}
}
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
return(objCrimeModel);
}
internal List <CrimeModel> GetCrimeDetailsByUserId(int Userid)
{
List <CrimeModel> listCrimes = new List <CrimeModel>();
using (SqlConnection con = new SqlConnection(SqlConnect.GetConnection))
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("Select * from tblCrime Where Userid=@Userid order by 1 desc", con);
cmd.Parameters.AddWithValue("@Userid", Userid);
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
CrimeModel objCrimeModel = new CrimeModel
{
CrimeId = (int)rdr["CrimeId"],
Crime = rdr["Crime"].ToString(),
Criminal = rdr["Criminal"].ToString(),
Description = rdr["Description"].ToString(),
Location = rdr["Location"].ToString(),
Status = rdr["Status"].ToString(),
StatusCode = DefineStatus(rdr["Status"].ToString())
};
listCrimes.Add(objCrimeModel);
}
}
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
return(listCrimes);
}
