public ActionResult Collect(FormCollection form)
{
string Url = C.APP + "/Survey/Finish?Thankyou";
try
{
foreach (var f in form.AllKeys)
{
string value = Request.Form[f];
if (!string.IsNullOrEmpty(value))
{
if (Regex.IsMatch(value, @"^\d+$") && value.Length < 10)
{
var p = new SurveyRecordsInt();
p.ItemID = Convert.ToInt32(f);
p.ItemValue = Convert.ToInt32(value);
DAL.Update.Survey(p);
}
else
{
var p = new SurveyRecordsText();
p.ItemID = Convert.ToInt32(f);
p.ItemValue = value;
DAL.Update.Survey(p);
}
}
}
}
catch (Exception ex)
{
log.Warn("{0},{1}", ex.Message, ex.StackTrace);
Url = C.APP + "/Survey/Finish?Thankyou_";
}
Response.Redirect(Url);
return Content(string.Empty);
}
public static R Survey(SurveyRecordsText p)
{
var m = new R();
try
{
SqlParameter[] param =
{
new SqlParameter("@UserID",p.UserID),
new SqlParameter("@ItemID",p.ItemID),
new SqlParameter("@ItemValue",p.ItemValue)
};
var r = SqlHelper.ExecuteNonQuery(C.conn, CommandType.StoredProcedure, "Update_SurveyRecordsText", param);
m.Code = 0;
m.Message = "success";
}
catch (Exception ex)
{
m.Code = 300;
m.Message = ex.Message;
log.Fatal(ex.Message);
log.FatalException(ex.Message, ex);
}
return m;
}
