public JsonResult CreateVisitorQuery(VisitorQuery model)
{
if (ModelState.IsValid)
{
try
{
model.DatePosted = DateTime.Now;
model.Status = ApplicationWideData.VisitorQueryNotViewed;
db.VisitorQueries.Add(model);
db.SaveChanges();
//return RedirectToAction("Index");
return(Json(new
{
status = "success",
exceptionOccurred = false,
data = $"Visitor Query id: {model.Id}"
}, JsonRequestBehavior.AllowGet));
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors.SelectMany(x => x.ValidationErrors).Select(x => x.ErrorMessage);
var errors = new List <string>();
foreach (var error in errorMessages)
{
errors.Add(error);
}
//ViewBag.VisitorQueryErrors = errors;
return(Json(new
{
status = "error",
exceptionOccurred = true,
exceptionMessage = ex.Message,
data = errors
}, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var errors = new List <string>
{
ex.Message
};
return(Json(new
{
status = "error",
exceptionOccurred = true,
exceptionMessage = ex.Message,
data = errors
}, JsonRequestBehavior.AllowGet));
}
}
return(Json(new
{
status = "error",
exceptionOccurred = false,
data = "Model state is invalid"
}, JsonRequestBehavior.AllowGet));
//return View(model);
}
public ActionResult SubmitMessage(VisitorQuery log)
{
//create the object of the class to pass the value to the database by using the insert query
String query = "insert into Message(Name,Email,Contact,Message) values('" + log.txtName + "','" + log.txtEmail + "','" + log.txtContact + "','" + log.txtMsg + "')";
obj_Feed.sendfeedback(query);
return(View("FeedBack"));
}