public ActionResult IsActive(TSS_Question q)
{
Response res = new Response();
TSS_QuestionBL qb = new TSS_QuestionBL();
dbDataTable dbtd = new dbDataTable();
try
{
DataTable dt = dbtd.List();
foreach (var item in q.Responses)
{
if (item.ResponseText != null)
{
myDataTable.AddRow(dt, "Value1", q.QuestionId, "Value2", item.ResponseText, "Value3", item.ResponseValue, "Value4", item.SortOrder, "Value5", item.IsPassed,
"Value6", item.MinValue, "Value7", item.MaxValue, "Value8", item.IsGps, "Value9", true);
}
}
q.CreatedOn = DateTime.Now;
q.CreatedBy = ViewBag.UserId;
if (q.QuestionId > 0)
{
res.Value = qb.Manage("UpdateStatus", q, dt);
}
res.Status = "success";
res.Message = "Save successfully";
}
catch (Exception ex)
{
res.Status = "danger";
res.Message = ex.Message;
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public List <TSS_Question> SectionQuestions(Int64 Id)
{
try
{
TSS_QuestionBL qb = new TSS_QuestionBL();
TSS_ResponseBL rb = new TSS_ResponseBL();
TSS_QuestionLogicBL qlb = new TSS_QuestionLogicBL();
var que =
new TSS_QuestionBL().GetQuestionsWithOptions("GET_Questions_BY_SECTIONID_API", 0, Id.ToString()).OrderBy(s => s.SortOrder).ToList();
//var que = qb.ToList("GET_QUESTION_BY_SECTION", Id.ToString());
//foreach (var q in que)
//{
// //q.Responses = rb.ToList("GET_BY_QUESTIONID", q.QuestionId.ToString());
// q.Responses = rb.ToList("GET_RESPONSE_BY_SITEQUESTION", q.QuestionId.ToString());
//}
foreach (var q in que)
{
q.QuestionLogics = qlb.ToList("GET_BY_QUESTIONID", q.QuestionId.ToString());
}
return(que);
}
catch (Exception)
{
throw;
}
}
public JsonResult ToList(string Filter, string Value)
{
TSS_QuestionBL qb = new TSS_QuestionBL();
var rec = qb.ToList(Filter, Value);
return(Json(rec, JsonRequestBehavior.AllowGet));
}
public ActionResult Single(Int64 Id)
{
TSS_QuestionBL qb = new TSS_QuestionBL();
TSS_Question q = qb.ToSingle("GET_BY_QUESTIONID", Id.ToString());
if (q != null)
{
TSS_ResponseBL rb = new TSS_ResponseBL();
q.Responses = rb.ToList("GET_BY_QUESTIONID", Id.ToString());
}
return(Json(q, JsonRequestBehavior.AllowGet));
}
public void GetSectionQuestions()
{
TSS_QuestionBL qb = new TSS_QuestionBL();
TSS_ResponseBL rb = new TSS_ResponseBL();
TSS_QuestionLogicBL qlb = new TSS_QuestionLogicBL();
var que =
new TSS_QuestionBL().GetQuestionsWithOptions("GET_Questions_BY_SECTIONID_API", 0, 70293.ToString());
//var que = qb.ToList("GET_QUESTION_BY_SECTION", Id.ToString());
//foreach (var q in que)
//{
// //q.Responses = rb.ToList("GET_BY_QUESTIONID", q.QuestionId.ToString());
// q.Responses = rb.ToList("GET_RESPONSE_BY_SITEQUESTION", q.QuestionId.ToString());
//}
foreach (var q in que)
{
q.QuestionLogics = qlb.ToList("GET_BY_QUESTIONID", q.QuestionId.ToString());
}
}
public ActionResult Delete(Int64 Id)
{
Response res = new Response();
try
{
TSS_QuestionBL qb = new TSS_QuestionBL();
TSS_Question q = new TSS_Question();
q.QuestionId = Id;
qb.Manage("Delete", q, null);
res.Status = "success";
res.Message = "Delete successfully";
}
catch (Exception ex)
{
res.Status = "danger";
res.Message = ex.Message;
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public ActionResult WithQuestions(string Value)
{
List <TSS_Section> Sections = new List <TSS_Section>();
TSS_SectionBL sb = new TSS_SectionBL();
string[] val = Value.Split(',');
foreach (var item in val)
{
TSS_Section sec = (item != "0") ? sb.ToSingle("By_SectionId", item) : null;
if (sec != null)
{
TSS_QuestionBL qb = new TSS_QuestionBL();
sec.QuestionList = qb.ToList("GET_BY_SECTIONID", sec.SectionId.ToString());
Sections.Add(sec);
}
}
return(Json(Sections, JsonRequestBehavior.AllowGet));
}
