public JsonResult Submit(string name, string email) { try { if (ModelState.IsValid) { //Check user info in database var data = StayUpToDateData.GetByEmail(email); if (data != null) { return(Json(new { code = "0" }, JsonRequestBehavior.AllowGet)); } //Save subscriber infor into database var subscriberInfo = new StayUpToDateData { Name = name, Email = email }; subscriberInfo.Save(); return(Json(new { code = "1" }, JsonRequestBehavior.AllowGet)); } return(Json(new { fail = "failed" }, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new { fail = "failed" }, JsonRequestBehavior.AllowGet)); } }
private DataTable DataForNewsLetter() { var dataTable = new DataTable(); var CSV_ROW = "{0}*{1}"; foreach (string column in _newsletterFormColumn) { var dcol = new DataColumn(column, typeof(String)); dataTable.Columns.Add(dcol); } var contacts = StayUpToDateData.GetAll(); foreach (var contact in contacts) { DataRow dr = dataTable.NewRow(); int i = 0; try { string data = string.Format(CSV_ROW, contact.Name, contact.Email); char[] delimiter = { '*' }; string[] rows = data.Split(delimiter); while (i < _newsletterFormColumn.Count()) { dr[_newsletterFormColumn[i]] = rows[i]; i++; } } catch (Exception ex) { string what = "ever"; } dataTable.Rows.Add(dr); } return(dataTable); }