public ActionResult feedback(managerModel mm, FormCollection form)
{
headdisplay();
IRecaptcha <RecaptchaV2Result> recaptcha = new RecaptchaV2(new RecaptchaV2Data()
{
Secret = "6LfBriQTAAAAANGF9w6CrSl_8yksdNy9dNi7Xp9R"
});
// Verify the captcha
var result = recaptcha.Verify();
if (mm.FBName_p != "" && mm.FBcontent_p != "" && mm.FBmail_p != null &&
mm.FBName_p != null && mm.FBcontent_p != null && result.Success == true)
{
int count = 0;
try
{
string sqlstr = @"INSERT INTO localsql.feedback(
idfeedback,Name,content,phone,mail
)VALUES(
@idfeedback,@Name,@content,@phone,@mail)",
sqlstrselect = @"SELECT idfeedback FROM localsql.feedback";
count = selectCount(count, sqlstrselect);
MySqlConnection con = new MySqlConnection(sqlconStr);
MySqlCommand link;
con.Open();
link = con.CreateCommand();
link.CommandText = sqlstr;
link.Parameters.Clear();
link.Parameters.AddWithValue("idfeedback", count + 1);
link.Parameters.AddWithValue("Name", mm.FBName_p);
link.Parameters.AddWithValue("content", mm.FBcontent_p);
link.Parameters.AddWithValue("phone", mm.FBphone_p);
link.Parameters.AddWithValue("mail", mm.FBmail_p);
link.ExecuteNonQuery();
con.Close();
}
catch (Exception ex) { }
TempData["message"] = "送出成功";
return(RedirectToAction("index"));
}
else
{
ViewBag.msg = "0";
return(View());
}
}
public ActionResult Index()
{
string[] imgpath = { "" };
headdisplay();
managerModel mm = new managerModel();
ViewBag.noticeTitle = selectsql("SELECT * FROM localsql.notice order by date desc", new[] { "type", "title" }, 0, 5);
ViewBag.link = selectsql("SELECT * FROM localsql.link ", new[] { "Img", "linkweb" }, 0, 5);
int count = 0, rows = 0;
MySqlConnection con = new MySqlConnection(sqlconStr);
MySqlCommand link;
con.Open();
link = con.CreateCommand();
link.CommandText = "SELECT * FROM localsql.album_address";
MySqlDataReader read = link.ExecuteReader();
count = 0;
Array.Resize(ref imgpath, imgpath.Length);
while (read.Read())
{
if (count != int.Parse(read["album_AlbumCount"].ToString()))
{
imgpath[count] = (read["album_AlbumCount"]).ToString() + "/" + read["ImgAddress"].ToString();
count++;
Array.Resize(ref imgpath, imgpath.Length + 1);
}
if (count > 4)
{
break;
}
}
Array.Resize(ref imgpath, imgpath.Length - 1);
con.Close();
ViewBag.albumImg = imgpath;
ViewBag.headTurnImg = selectTurnImg();
return(View());
}
