public void UserRegister(Models.Introduction Introduction)
{
string sql = @" INSERT INTO Introduction (LocationName,IntroductionContents,Lat,Lon) VALUES (@LocationName,@IntroductionContents,@Lat,@Lon)";
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@IntroductionContents", Introduction.IntroductionContents));
cmd.Parameters.Add(new SqlParameter("@LocationName", Introduction.LocationName));
cmd.Parameters.Add(new SqlParameter("@Lat", Introduction.Lat));
cmd.Parameters.Add(new SqlParameter("@Lon", Introduction.Lon));
cmd.ExecuteNonQuery();
conn.Close();
}
}
public ActionResult InsertLocation(Models.Introduction introduce)
{
Models.Introduce Introduce = new Models.Introduce();
Introduce.UserRegister(introduce);
return(RedirectToAction("../Introduction/InsertIndex"));
}
public ActionResult InsertIndex(Models.Introduction introduce)
{
return(View());
}
