public IHttpActionResult PostAResponse([FromBody] sur_response res) { try { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (CITIZENPULSEEntities3 dc = new CITIZENPULSEEntities3()) { // var mn = res.SurveyId; //var ny = res.Respondon; dc.sur_response.Add(res); dc.SaveChanges(); } } catch (DbUpdateException /* ex */) { //Log the error (uncomment ex variable name and write a log. ModelState.AddModelError("", "Unable to save changes. " + "Try again, and if the problem persists " + "see your system administrator."); } return(CreatedAtRoute("DefaultApi", new { id = res.responseId }, res)); }
public IHttpActionResult Postuser([FromBody] User user) { try { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } using (CITIZENPULSEEntities3 dc = new CITIZENPULSEEntities3()) { dc.Users.Add(user); dc.SaveChanges(); } } catch (DbUpdateException /* ex */) { //Log the error (uncomment ex variable name and write a log. ModelState.AddModelError("", "Unable to save changes. " + "Try again, and if the problem persists " + "see your system administrator."); } return(CreatedAtRoute("DefaultApi", new { id = user.userid }, user)); }
public bool IsEmailExist(String emailId) { using (CITIZENPULSEEntities3 dc = new CITIZENPULSEEntities3()) { var v = dc.Users.Where(a => a.email == emailId).FirstOrDefault(); return(v != null); } }
public ActionResult survey(Survey sur) { try { // sur.status = "completed"; //sur.Duration_days_ = 7; #region save to database using (CITIZENPULSEEntities3 dc = new CITIZENPULSEEntities3()) { if (ModelState.IsValid) { sur.status = "completed"; sur.Duration_days_ = 7; dc.Surveys.Add(sur); dc.SaveChanges(); TempData["survey"] = sur; return(RedirectToAction("displaySur")); } } ViewBag.categoryId = new SelectList(db.Categories, "categoryId", "categoryId", sur.categoryId); ViewBag.customerId = new SelectList(db.Customers, "customerId", "customerId", sur.customerId); return(View(sur)); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } #endregion }
public ActionResult Questions(Question ques) { try { #region save to database using (CITIZENPULSEEntities3 dc = new CITIZENPULSEEntities3()) { if (ModelState.IsValid) { ques.Isdeleted = false; ques.typeId = 1; dc.Questions.Add(ques); dc.SaveChanges(); TempData["Questions"] = ques; return(RedirectToAction("Optionn")); } } ViewBag.SurveyId = new SelectList(db.Surveys, "SurveyId", "surveyId"); ViewBag.customerId = new SelectList(db.Customers, "customerId", "customerId"); return(View(ques)); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } #endregion }
public ActionResult login(Userlogin login, string ReturnUrl) { string Message = ""; using (CITIZENPULSEEntities3 dc = new CITIZENPULSEEntities3()) { var v = dc.Users.Where(a => a.email == login.email).FirstOrDefault(); if (v != null) { if (string.Compare(Crypto.hash(login.password), v.password) == 0) { int timeout = login.RememberMe ? 525600 : 20; var ticket = new FormsAuthenticationTicket(login.email, login.RememberMe, timeout); string encrypted = FormsAuthentication.Encrypt(ticket); var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted); cookie.Expires = DateTime.Now.AddMinutes(timeout); cookie.HttpOnly = true; Response.Cookies.Add(cookie); if (v.Role == 1) { return(RedirectToAction("Welcome")); //welcome customer } else if (v.Role == 2) { return(RedirectToAction("WelcomeAdmin")); } // return Redirect(ReturnUrl); } else { Message = "invalid credidential provided"; } } else { Message = "invalid credidential provided"; } } ViewBag.Message = Message; return(View()); }
public ActionResult category(Category cat) { try { #region save to database using (CITIZENPULSEEntities3 dc = new CITIZENPULSEEntities3()) { if (ModelState.IsValid) { dc.Categories.Add(cat); dc.SaveChanges(); // return RedirectToAction("Index"); TempData["category"] = cat; return(RedirectToAction("displayCat")); } } ViewBag.customerId = new SelectList(db.Customers, "customerId", "customerId"); return(View(cat)); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } }
public ActionResult Sresponse(sur_response respo) { try { #region save to database using (CITIZENPULSEEntities3 dc = new CITIZENPULSEEntities3()) { if (ModelState.IsValid) { dc.sur_response.Add(respo); dc.SaveChanges(); // return RedirectToAction("Index"); } } ViewBag.SurveyId = new SelectList(db.Surveys, "SurveyId", "SurveyId"); return(View(respo)); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } }
public ActionResult Registration([Bind(Exclude = "IsActive")] User user) { bool Status = false; string Message = ""; //model validation if (ModelState.IsValid) { #region var isExist = IsEmailExist(user.email); if (isExist) { ModelState.AddModelError("EmailExist", "email alredy exist"); return(View(user)); } #endregion #region passwaord hash user.password = Crypto.hash(user.password); user.ConfirmPassword = Crypto.hash(user.ConfirmPassword); #endregion user.IsActive = true; try { #region save to database using (CITIZENPULSEEntities3 dc = new CITIZENPULSEEntities3()) { dc.Users.Add(user); dc.SaveChanges(); } TempData["Registraion"] = user; return(RedirectToAction("Regiation")); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } #endregion } else { Message = "invalid request"; } return(View(user)); }