public IActionResult Index(long?id = 0) { ViewBag.CityList = _lookUps.GetCity(); ViewBag.FamilyStatusList = _lookUps.GetFamilyStatus(); ViewBag.GenderList = _lookUps.GetGender(); if (id > 0) { // this is the call for update } TblPool tblPool = new TblPool(); tblPool.Participant = 20; return(View(tblPool)); }
public string DeletePool(long Id) { try { TblPool tblPool = GetPoolById(Id); if (tblPool != null) { _context.Remove(tblPool); _context.SaveChanges(); } return(""); } catch (Exception ex) { return(ex.Message); } }
public IActionResult Index(TblPool tblPool) { if (!string.IsNullOrEmpty(tblPool.Gender)) { tblPool.Gender = tblPool.Gender.Trim(); } if (!string.IsNullOrEmpty(tblPool.FamilyStatus)) { tblPool.FamilyStatus = tblPool.FamilyStatus.Trim(); } string error = _pool.Save(tblPool); if (string.IsNullOrEmpty(error)) { return(RedirectToAction("Poolstemplates")); } return(View()); }
public JsonResult GetPool(long Id = 0) { TblPool tblPool = _pool.GetPoolById(Id); if (tblPool != null) { return(Json(new { status = "success", data = tblPool })); } return(Json(new { status = "fail", data = "" })); }
public string Save(TblPool tblPool) { try { if (tblPool.Id > 0) { _context.Update(tblPool); _context.SaveChanges(); } else { _context.TblPool.Add(tblPool); _context.SaveChanges(); } return(""); } catch (Exception ex) { return(ex.Message); } }
public string SendSurveyFromPool(long surveyId, long PoolId, string ids, TblPool tblPool) { TblPoolSurvey poolSurvey = new TblPoolSurvey(); poolSurvey.Id = 0; poolSurvey.SurveyId = surveyId; poolSurvey.PoolTemplateId = PoolId; poolSurvey.CreatedDate = DateTime.Now; long poolSurveyId = addJunctionEntery(poolSurvey); List <TblUser> tblUsers; if (tblPool.AgeMin == null) { tblUsers = _context.TblUser.FromSqlRaw("SearchUserSurvey @p0, @p1, @p2, @p3, @p4, @p5, @p6", tblPool.Participant, "", "", tblPool.CityIds, tblPool.Gender, tblPool.FamilyStatus, ids).ToList(); } else { tblUsers = _context.TblUser.FromSqlRaw("SearchUserSurvey @p0, @p1, @p2, @p3, @p4, @p5, @p6", tblPool.Participant, tblPool.AgeMin, tblPool.AgeMax, tblPool.CityIds, tblPool.Gender, tblPool.FamilyStatus, ids).ToList(); } foreach (var item in tblUsers) { SendToUser(surveyId, poolSurveyId, item.Id); } string htmlString = ESS.SFS.Helper.Common.SendToSurveyHtml; var tblSurvey = _context.TblSurvey.Find(surveyId); htmlString = htmlString.Replace("[SurveyName]", tblSurvey.Title); string body = ""; foreach (var item in tblUsers) { body = htmlString.Replace("[Name]", item.FullName); ESS.SFS.Helper.Common.sendEmailFromAWS(body, "New Smart Family Survey Received", item.Username, ""); } return(""); }