public ActionResult Edit(SuspectsModel record)
{
using (SqlConnection con = new SqlConnection(Helper.GetCon()))
{
con.Open();
string query = @"UPDATE Suspects SET
Name=@Name, Face_Shape=@Face_Shape,
Hair_Style=@HairStyle, Prominent_Facial_Feature=@Prominent,
Body_built=@BodyBuilt, Shirt_color=@ShirtColor, Tattoo_Location=@Tattoo,
Type_of_weapon=@TypeOfWeapon, Other_Description=@OtherDescription FROM Suspects
WHERE Suspect_Id= @Suspect_Id";
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.Parameters.AddWithValue("@Name", record.Name);
cmd.Parameters.AddWithValue("@Face_Shape", record.Face_Shape);
cmd.Parameters.AddWithValue("@HairStyle", record.Hair_Style);
cmd.Parameters.AddWithValue("@Prominent", record.Prominent_Facial_Feature);
cmd.Parameters.AddWithValue("@BodyBuilt", "Endomorph");
cmd.Parameters.AddWithValue("@ShirtColor", record.Shirt_Color);
cmd.Parameters.AddWithValue("@Tattoo", record.Tattoo_Location);
cmd.Parameters.AddWithValue("@OtherDescription", record.Other_Description);
cmd.Parameters.AddWithValue("@TypeOfWeapon", record.Type_of_Weapon);
cmd.Parameters.AddWithValue("@Suspect_Id", record.suspect_id);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("Details", "Reports", new { id = record.crime_id }));
}
}
public ActionResult Suspects(int ID)
{
var record = new SuspectsModel();
record.crime_id = ID;
record.HairTypes = GetHairType();
record.WeaponTypes = GetWeaponType();
return(View(record));
}
public ActionResult Edit(int id)
{
var record = new SuspectsModel();
using (SqlConnection con = new SqlConnection(Helper.GetCon()))
{
con.Open();
string query = @"SELECT Suspect_ID, Crime_Id, [Name], Face_Shape, Hair_Style, Prominent_Facial_Feature, Body_built,
Shirt_color, Tattoo_Location, Type_of_weapon, Other_Description FROM Suspects
WHERE Suspect_Id= @Suspect_Id";
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.Parameters.AddWithValue("@Suspect_Id", id);
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
record.suspect_id = int.Parse(sdr["Suspect_ID"].ToString());
record.crime_id = int.Parse(sdr["Crime_Id"].ToString());
record.Name = sdr["Name"].ToString();
record.Face_Shape = sdr["Face_Shape"].ToString();
record.Hair_Style = sdr["Hair_Style"].ToString();
record.Prominent_Facial_Feature = sdr["Prominent_Facial_Feature"].ToString();
record.Body_Built = sdr["Body_built"].ToString();
record.Shirt_Color = sdr["Shirt_color"].ToString();
record.Tattoo_Location = sdr["Tattoo_Location"].ToString();
record.Other_Description = sdr["Other_Description"].ToString();
record.Type_of_Weapon = int.Parse(sdr["Type_of_weapon"].ToString());
}
SuspectsController home = new SuspectsController();
record.HairTypes = home.GetHairType();
record.suspect_id = id;
return(View(record));
}
}
}
}
public ActionResult Suspects(SuspectsModel record, HttpPostedFileBase image)
{
using (SqlConnection con = new SqlConnection(Helper.GetCon()))
{
con.Open();
string query = @"INSERT INTO SUSPECTS VALUES(@Crime_id,@Name,@Face_Shape,
@Hair_Style,@Prominent_Facial_Feature,@Body_Built,
@Shirt_Color,@Tattoo_Location,@Is_Armed,
@Type_of_Weapon,@Other_Description,@Image)";
using (SqlCommand com = new SqlCommand(query, con))
{
com.Parameters.AddWithValue("@Crime_id", record.crime_id);
com.Parameters.AddWithValue("@Name", record.Name == null ? DBNull.Value.ToString() : record.Name);
com.Parameters.AddWithValue("@Face_Shape", record.Face_Shape == null ? DBNull.Value.ToString(): record.Face_Shape);
com.Parameters.AddWithValue("@Hair_Style", record.Hair_Style == null ? DBNull.Value.ToString() : record.Hair_Style);
com.Parameters.AddWithValue("@Prominent_Facial_Feature", record.Prominent_Facial_Feature == null ? DBNull.Value.ToString() : record.Prominent_Facial_Feature);
com.Parameters.AddWithValue("@Body_Built", record.Body_Built == null ? DBNull.Value.ToString() : record.Body_Built);
com.Parameters.AddWithValue("@Image", image == null ? "None" :
DateTime.Now.ToString("yyyyMMddHHmmss-") + image.FileName);
if (image != null)
{
image.SaveAs(Server.MapPath("~/Images/SuspectImages/" +
DateTime.Now.ToString("yyyyMMddHHmmss-") + image.FileName));
}
com.Parameters.AddWithValue("@Shirt_Color", record.Shirt_Color == null ? DBNull.Value.ToString() : record.Shirt_Color);
com.Parameters.AddWithValue("@Tattoo_Location", record.Tattoo_Location == null ? DBNull.Value.ToString() : record.Tattoo_Location);
com.Parameters.AddWithValue("@Is_Armed", 0);
com.Parameters.AddWithValue("@Type_of_Weapon", record.Type_of_Weapon == null ? 0 : record.Type_of_Weapon);
com.Parameters.AddWithValue("@Other_Description", record.Other_Description == null ? DBNull.Value.ToString() : record.Other_Description);
com.ExecuteNonQuery();
}
}
return(RedirectToAction("Index", "Home"));
}
