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));
}
