public string CreateQuestion()
{
if (!string.IsNullOrEmpty(Request["UserName"]) && !string.IsNullOrEmpty(Request["questionBody"]))
{
QandAContext qc = new QandAContext();
string userName = Request["UserName"];
string userContact = Request["UserContact"];
string questionClass = Request["QuestionClass"];
string questionSubject = Request["questionSubject"];
string questionBody = Request["questionBody"];
User u;
int uCount = qc.Users.Where(us => us.Name == userName).Count();
if (uCount == 0)
{
u = new User();
u.Name = userName;
u.Contact = userContact;
qc.Users.Add(u);
qc.SaveChanges();
}
else
{
u = qc.Users.Where(us => us.Name == userName).First();
u.Contact = userContact;
}
Qusetion qu = new Qusetion();
qu.QuestionClass = qc.QuestionClasss.Find(Guid.Parse(questionClass));
qu.Subject = questionSubject;
qu.Body = questionBody;
qu.SubmitUser = u;
qu.SubmitTime = DateTime.Now;
qu.State = qc.States.Where(s => s.Name == "待解决").First();
qc.Qusetions.Add(qu);
qc.SaveChanges();
return("QuestionOK");
}
return("False");
}
public string AnswerQuestion()
{
if (!string.IsNullOrEmpty(Request["UserName"]) && !string.IsNullOrEmpty(Request["AnswerBody"]))
{
QandAContext qc = new QandAContext();
string userName = Request["UserName"];
string userContact = Request["UserContact"];
string questionID = Request["QuestionID"];
string answerBody = Request["AnswerBody"];
User u;
int uCount = qc.Users.Where(us => us.Name == userName).Count();
if (uCount == 0)
{
u = new User();
u.Name = userName;
u.Contact = userContact;
qc.Users.Add(u);
qc.SaveChanges();
}
else
{
u = qc.Users.Where(us => us.Name == userName).First();
u.Contact = userContact;
}
Qusetion qu = qc.Qusetions.Find(Guid.Parse(questionID));
Answer an = new Answer();
an.Body = answerBody;
an.SubmitUser = u;
an.SubmitTime = DateTime.Now;
an.Qusetion = qu;
qc.Answers.Add(an);
qc.SaveChanges();
return("AnswerOK");
}
return("False");
}
public AccountController(QandAContext aContext)
{
_dbContext = aContext;
}
//
// GET: /QandA/
public ActionResult Index()
{
Dictionary <string, object> dataDic = new Dictionary <string, object>();
QandAContext qc = new QandAContext();
if (qc.QuestionClasss.Count() == 0)
{
QuestionClass c1 = new QuestionClass();
c1.ClassName = "费用信息维护";
c1.IndexNo = 1;
QuestionClass c2 = new QuestionClass();
c2.ClassName = "协议相关问题";
c2.IndexNo = 2;
QuestionClass c3 = new QuestionClass();
c3.ClassName = "操作流程指引";
c3.IndexNo = 3;
QuestionClass c4 = new QuestionClass();
c4.ClassName = "流程改进完善";
c4.IndexNo = 4;
QuestionClass c5 = new QuestionClass();
c5.ClassName = "需求完善建议";
c5.IndexNo = 5;
QuestionClass c6 = new QuestionClass();
c6.ClassName = "其他问题建议";
c6.IndexNo = 6;
qc.QuestionClasss.Add(c1);
qc.QuestionClasss.Add(c2);
qc.QuestionClasss.Add(c3);
qc.QuestionClasss.Add(c4);
qc.QuestionClasss.Add(c5);
qc.QuestionClasss.Add(c6);
qc.SaveChanges();
}
if (qc.States.Count() == 0)
{
State c1 = new State();
c1.Name = "待解决";
qc.States.Add(c1);
State c2 = new State();
c2.Name = "已解决";
qc.States.Add(c2);
State c3 = new State();
c3.Name = "待确认";
qc.States.Add(c3);
State c4 = new State();
c4.Name = "已关闭";
qc.States.Add(c4);
State c5 = new State();
c5.Name = "加急";
qc.States.Add(c5);
qc.SaveChanges();
}
dataDic.Add("TabList", qc.QuestionClasss.OrderBy(t => t.IndexNo).ToList());
string tabID = Request["TabID"];
dataDic.Add("QuestionTable", null);
if (string.IsNullOrEmpty(tabID))
{
tabID = qc.QuestionClasss.FirstOrDefault().ID.ToString();
}
ViewBag.TabID = tabID;
Guid tid = Guid.Parse(tabID);
if (qc.Qusetions.Where(q => q.QuestionClass.ID == tid).Count() != 0)
{
var tabs = qc.Qusetions.Include(q => q.Answers).Include(q => q.SubmitUser).Include(q => q.State).Where(q => q.QuestionClass.ID == tid).ToList();
foreach (var qu in tabs)
{
foreach (var an in qu.Answers)
{
an.SupportUsers.ToList();
an.SubmitUser = qc.Answers.Where(a => a.ID == an.ID).Select(a => a.SubmitUser).First();
}
}
dataDic["QuestionTable"] = tabs;
}
return(View(dataDic));
}
public HomeController(QandAContext aContext)
{
_dbContext = aContext;
}
