public ActionResult Edit(SurveyTable surveytable, FormCollection formcollection) { if (ModelState.IsValid) { //db.SaveChanges(); if (surveytable.IsApproved) { return(RedirectToAction("Edit", new { id = surveytable.SurveyTableID })); } if (DateTime.Now > surveytable.TimeStamp.AddDays(1)) { return(RedirectToAction("Edit", new { id = surveytable.SurveyTableID, customerr = "Üzgünüz, bu anketin geçerlilik süresi dolmuştur." })); } try { string hashconfirm = formcollection["HashkeyConfirm"]; var mysvtable_ = db.SurveyTables.AsNoTracking().Where(i => i.SurveyTableID == surveytable.SurveyTableID).SingleOrDefault(); if (mysvtable_.HashKey.Equals(hashconfirm)) { var mysvtemplate_ = db.SurveyTemplates.Where(i => i.SurveyTemplateID == surveytable.SurveyTemplateID).Include(p => p.SurveyRecords).SingleOrDefault(); foreach (SurveyRecord mysurvrecord in mysvtemplate_.SurveyRecords.ToList()) { if (mysurvrecord.SurveyRecordTypeID == 1) { mysurvrecord.Score = int.Parse(formcollection[mysurvrecord.SurveyRecordID.ToString() + "_Score"]); } else if (mysurvrecord.SurveyRecordTypeID == 2) { mysurvrecord.ApprovalStatus = bool.Parse(formcollection[mysurvrecord.SurveyRecordID.ToString() + "_ApprovalStatus"].Split(',')[0]); } mysurvrecord.Note = formcollection[mysurvrecord.SurveyRecordID.ToString() + "_Note"]; } db.SaveChanges(); db.Entry(surveytable).State = EntityState.Modified; surveytable.HashKey = hashconfirm; surveytable.IsApproved = true; surveytable.mTimeStamp = DateTime.Now; db.SaveChanges(); } else { return(RedirectToAction("Edit", new { id = surveytable.SurveyTableID, customerr = "Şifre Uyumsuz. Her anket için farklı şifre üretilmektedir, lütfen elinizdeki şifrenin doğruluğunu kontrol edin." })); } } catch (Exception exx) { return(RedirectToAction("Edit", new { id = surveytable.SurveyTableID, customerr = "Üzgünüz bir hata oldu.(Detaylar :" + exx.Message + ")" })); } return(RedirectToAction("Edit", new { id = surveytable.SurveyTableID })); } ViewBag.SurveyTemplateID = new SelectList(db.SurveyTemplates, "SurveyTemplateID", "Description", surveytable.SurveyTemplateID); ViewBag.RequestIssueID = new SelectList(db.RequestIssues, "RequestIssueID", "DetailedDescription", surveytable.RequestIssueID); return(View(surveytable)); }
public ActionResult AddSurvey(AddSurveyViewModel addSurveyView) { using (var context = new surveyEntities()) { SurveyTable surveyTable = new SurveyTable(); surveyTable.Survey_Type = addSurveyView.Survey_Type; context.SurveyTables.Add(surveyTable); context.SaveChanges(); } return(RedirectToAction("AddSurvey")); }
private void SaveSurveyButton_Click(object sender, EventArgs e) { DbConnector db = DbConnector.GetInstance(); for (int i = 0; i < SurveyTable.RowCount; i++) { survs[i].Name = SurveyTable.GetControlFromPosition(0, i).Text; survs[i].Cost = int.Parse(SurveyTable.GetControlFromPosition(1, i).Text); db.UpdateType(survs[i], "survey"); } }
private SurveyDto ConvertSurveyTableToDto(SurveyTable survey) { return(new SurveyDto { IdSurvey = survey.IdSurvey, IdUser = survey.IdUser, Question = survey.Question, Yes = survey.Yes, No = survey.No, Avoid = survey.Avoid, TypeMember = survey.TypeMember, EndTime = survey.EndTime, StartTime = survey.StartTime }); }
public void LoadEntriesSurveys() { SurveyTable.Controls.Clear(); survs = DbConnector.GetInstance().GetSurveyTypes(); SurveyTable.RowCount = survs.Count; SurveyTable.Update(); for (int i = 0; i < survs.Count; i++) { TextBox lb = new TextBox(); lb.Font = new Font("Calibri", 12); lb.Text = survs[i].Name; lb.Show(); TextBox lb1 = new TextBox(); lb1.Font = new Font("Calibri", 12); lb1.Text = survs[i].Cost.ToString(); lb1.Show(); DeleteButton b2 = new DeleteButton(survs[i].id, "surveytype"); b2.Click += b2_Click; this.SurveyTable.Controls.Add(lb, 0, i); this.SurveyTable.Controls.Add(lb1, 1, i); this.SurveyTable.Controls.Add(b2, 2, i); } }
public ActionResult Edit(int id, string customerr) { SurveyTable surveytable = db.SurveyTables.Find(id); ViewBag.SurveyTemplateID = new SelectList(db.SurveyTemplates, "SurveyTemplateID", "Description", surveytable.SurveyTemplateID); ViewBag.RequestIssueID = new SelectList(db.RequestIssues, "RequestIssueID", "DetailedDescription", surveytable.RequestIssueID); ViewBag.TheseSurveyRecords = surveytable.SurveyTemplate.SurveyRecords.ToList(); if (!(string.IsNullOrEmpty(customerr))) { ViewBag.CustomErr = customerr; } if (surveytable.IsApproved) { ViewBag.CustomErr = "Bu Anket İş Talep sahibi tarafından doldurularak tamamlanmıştır. İlginize Teşekkürler.."; } return(View(surveytable)); }