public ActionResult ListofCompliance() { ViewBag.Message = TempData["Message"]; ListofComplianceViewModel model = new ListofComplianceViewModel(); ComplianceXrefService.ComplianceXrefServiceClient client = new ComplianceXrefService.ComplianceXrefServiceClient(); //string xmlcompliance = client.GetComplaince(0); //DataSet dscompliance = new DataSet(); //dscompliance.ReadXml(new StringReader (xmlcompliance)); //DataView dv = new DataView(dscompliance.Tables[0]); //dv.RowFilter = "level=1"; string xmldata = client.GetActs(0); DataSet ds = new DataSet(); ds.ReadXml(new StringReader(xmldata)); if (ds.Tables.Count > 0) { model.Actslist = bindCompliancelist(ds.Tables[0], model.Actslist); //xmldata = client.GetSections(0); //ds = new DataSet(); //ds.ReadXml(new StringReader(xmldata)); //if (ds.Tables.Count > 0) //{ // model.Sectionlist = bindCompliancelist(ds.Tables[0], model.Sectionlist); xmldata = client.GetRules(0); ds = new DataSet(); ds.ReadXml(new StringReader(xmldata)); if (ds.Tables.Count > 0) { foreach (System.Data.DataRow row in ds.Tables[0].Rows) { model.Rulelist.Add(new ComplianceXref { Compliance_Xref_ID = Convert.ToInt32(row["Compliance_Xref_ID"]), Compliance_Parent_ID = Convert.ToInt32(row["Compliance_Parent_ID"]), Compliance_Title = Convert.ToString(row["Compliance_Title"]), Comp_Category = Convert.ToString(row["Comp_Category"]), Comp_Description = Convert.ToString(row["Comp_Description"]), compl_def_consequence = Convert.ToString(row["compl_def_consequence"]), Comp_Order = Convert.ToInt32(row["Comp_Order"]), Country_ID = Convert.ToInt32(row["Country_ID"]), City_ID = Convert.ToInt32(row["City_ID"]), Effective_End_Date = Convert.ToDateTime(row["Effective_Start_Date"]), Effective_Start_Date = Convert.ToDateTime(row["Effective_End_Date"]), Form = Convert.ToString(row["Form"]), Is_Header = Convert.ToBoolean(Convert.ToInt32(row["Is_Header"])), level = Convert.ToInt32(row["level"]), State_ID = Convert.ToInt32(row["State_ID"]), User_ID = Convert.ToInt32(row["User_ID"]), Is_Active = Convert.ToBoolean(Convert.ToInt32(row["Is_Active"])), Is_Best_Practice = Convert.ToBoolean(Convert.ToInt32(row["Is_Best_Practice"])), Risk_Category = Convert.ToString(row["Risk_Category"]), Last_Updated_Date = Convert.ToDateTime(row["Last_Updated_Date"]), Recurrence = Convert.ToString(row["Recurrence"]), Risk_Description = Convert.ToString(row["Risk_Description"]), Type = Convert.ToString(row["Type"]), Version = Convert.ToInt32(row["Version"]) }); } } //} } return(View("_ListofCompliance", model)); }
public ActionResult ListofCompliance() { ViewBag.Message = TempData["Message"]; ListofComplianceViewModel model = new ListofComplianceViewModel(); int flag = 0; OrgService.OrganizationServiceClient organizationService = new OrgService.OrganizationServiceClient(); string strXMLCountries = organizationService.GetCountryList(); DataSet dsCountries = new DataSet(); dsCountries.ReadXml(new StringReader(strXMLCountries)); model.CountryList = new List <SelectListItem>(); if (dsCountries.Tables.Count > 0) { model.countryid = Convert.ToInt32(dsCountries.Tables[0].Rows[0]["Country_ID"]); foreach (System.Data.DataRow row in dsCountries.Tables[0].Rows) { model.CountryList.Add(new SelectListItem() { Text = row["Country_Name"].ToString(), Value = row["Country_ID"].ToString() }); } } string strXMLIndustryType = organizationService.GetIndustryType(); DataSet dsIndustryType = new DataSet(); dsIndustryType.ReadXml(new StringReader(strXMLIndustryType)); model.IndustryTypeList = new List <SelectListItem>(); model.IndustryTypeList.Add(new SelectListItem { Text = "-- Select Industry Type --", Value = "0" }); if (dsIndustryType.Tables.Count > 0) { foreach (System.Data.DataRow row in dsIndustryType.Tables[0].Rows) { model.IndustryTypeList.Add(new SelectListItem() { Text = row["Industry_Name"].ToString(), Value = row["Industry_Type_ID"].ToString() }); } } model.ComplianceTypeList = new List <SelectListItem>(); model.ComplianceTypeList.Add(new SelectListItem { Text = "-- Select ComplianceType List --", Value = "0" }); var countryid = Request.QueryString["countryid"]; if (countryid != null) { model.countryid = Convert.ToInt32(countryid); } else { model.countryid = 1; } var audit = Request.QueryString["compliancetypeid"]; if (audit != null) { model.compliancetypeid = Convert.ToInt32(audit); } else { model.compliancetypeid = 0; } ComplianceXrefService.ComplianceXrefServiceClient client = new ComplianceXrefService.ComplianceXrefServiceClient(); string xmldata = client.GetcomplianceonType(model.compliancetypeid, model.countryid, 0, 0, flag); DataSet ds = new DataSet(); ds.ReadXml(new StringReader(xmldata)); DataView dv = new DataView(ds.Tables[0]); dv.RowFilter = "level=1"; dv.Sort = "Last_Updated_Date desc"; DataTable dt = dv.ToTable(); dv = new DataView(ds.Tables[0]); dv.RowFilter = "level=2"; DataTable dtrules = dv.ToTable(); if (dt.Rows.Count > 0) { model.Actslist = bindCompliancelist(dt); if (dtrules.Rows.Count > 0) { model.Rulelist = bindCompliancelist(dtrules); } } return(View("_ListofCompliance", model)); }