public ActionResult New(TSS_Section sec)
{
Response res = new Response();
TSS_SectionBL sb = new TSS_SectionBL();
try
{
res.Status = "success";
if (sec.SectionId > 0)
{
sec.CreatedOn = DateTime.MinValue;
res.Value = sb.Manage("Update", sec);
res.Message = "Update successfully";
}
else
{
sec.CreatedBy = ViewBag.UserId;
sec.CreatedOn = DateTime.Now;
res.Value = sb.Manage("Insert", sec);
res.Message = "Save successfully";
}
}
catch (Exception ex)
{
res.Status = "danger";
res.Message = ex.Message;
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public void Tree()
{
var sur = new TSS_SectionBL().SurveyBySiteSurveyId(70418);
TSS_SurveyDocumentBL sb = new TSS_SurveyDocumentBL();
var result = sb.ToList("SURVEY_BY_WO", 728833.ToString(), true);
// new TSS_SurveyDocumentBL().GetSections("SURVEY_SECTIONS_BY_SITESURVEYID", 70418.ToString(), true);
}
public ActionResult List(string Value)
{
TSS_SectionBL sb = new TSS_SectionBL();
var rec = (Value != "0")? sb.ToList("By_SurveyId", Value):null;
var rec1 = (Value != "0")? sb.ToListWithoutTree("By_SurveyId", Value):null;
var result = new { list1 = rec, list2 = rec1 };
//return PartialView("~/Areas/Survey/Views/Section/_List.cshtml", rec);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public TSS_SurveyDocument SiteSurvey(Int64 SiteSurveyId)
{
try
{
TSS_SectionBL s = new TSS_SectionBL();
var sur = s.SurvayBySite(SiteSurveyId);
return(sur);
}
catch (Exception)
{
throw;
}
}
public List <TSS_Section> SurveySections(Int64 Id)
{
try
{
TSS_SectionBL sb = new TSS_SectionBL();
var sec = sb.ToList("By_SurveyId", Id.ToString()).ToList();
return(GetTreeView(sec));
}
catch (Exception)
{
throw;
}
}
public Response GetPdfBytes(Int64 Id)
{
try
{
var sur = new TSS_SectionBL().SurveyBySiteId(Id);
var response = new Response();
response.Value = new PdfController().PDFViewBytes(sur, "~/Areas/Survey/Views/Document/SurveyReport.cshtml");
return(response);
}
catch (Exception)
{
throw;
}
}
private List <TSS_Section> GetTreeView(List <TSS_Section> sec)
{
TSS_SectionBL sb = new TSS_SectionBL();
foreach (var s in sec)
{
if (s.PSectionId > 0)
{
var sec2 = sb.ToList("By_SectionId", s.PSectionId.ToString()).ToList();
if (sec2 != null)
{
s.Sections.AddRange(sec2);
GetTreeView(sec2);
}
}
}
return(sec);
}
public ActionResult Delete(Int64 Id)
{
Response res = new Response();
try
{
TSS_SectionBL sb = new TSS_SectionBL();
TSS_Section sec = new TSS_Section();
sec.SectionId = Id;
sb.Manage("Delete", sec);
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));
}
public ActionResult Tree(string filter, string value)
{
TSS_SectionBL sb = new TSS_SectionBL();
var list = sb.ToList(filter, value);
//var Parent = Sections.Where(m => m.PSectionId == 0).ToList();
List <TSS_Section> treeList = new List <TSS_Section>();
//foreach (var item in Sections)
//{
// GetTreeView(item, Sections);
//}
//return Json(Parent, JsonRequestBehavior.AllowGet);
if (list.Count > 0)
{
treeList = BuildTree(list);
}
return(new JsonResult {
Data = new { treeList = treeList }, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public void SurveyReportResultData()
{
TSS_SectionBL s = new TSS_SectionBL();
var sur = s.SurveyBySiteId(70398);
}
