public JsonResult getdefaultindustrytype(int compid)
{
List <SelectListItem> cities = new List <SelectListItem>();
VendorViewModel model = new VendorViewModel();
model.companydetails = new CompanyDetails();
//int CID = Convert.ToInt32(compid);
OrgService.OrganizationServiceClient organizationservice = new OrgService.OrganizationServiceClient();
string strXMLIndustry = organizationservice.GetIndustryType();
DataSet dsIndustry = new DataSet();
dsIndustry.ReadXml(new StringReader(strXMLIndustry));
if (dsIndustry.Tables.Count > 0)
{
// model.companydetails.Industry_Type_ID=Convert.ToInt32(dsIndustry.Tables[0].Rows[0]["Industry_Type_ID"]);
//cities.Add(new SelectListItem() { Text = dsIndustry.Tables[0].Rows[0]["Industry_Name"].ToString(), Value = dsIndustry.Tables[0].Rows[0]["Industry_Type_ID"].ToString() });
foreach (System.Data.DataRow row in dsIndustry.Tables[0].Rows)
{
cities.Add(new SelectListItem()
{
Text = row["Industry_Name"].ToString(), Value = row["Industry_Type_ID"].ToString()
});
}
}
return(Json(cities, JsonRequestBehavior.AllowGet));
}
public ActionResult IndustryTypeMapwithCompliance()
{
ComplianceIndustryViewModel model = new ComplianceIndustryViewModel();
OrgService.OrganizationServiceClient organizationService = new OrgService.OrganizationServiceClient();
model.IndustryType = new Compliance.DataObject.IndustryType();
model.ComplianceType = new Compliance.DataObject.ComplianceType();
string strXMLCountries = organizationService.GetCountryList();
DataSet dsCountries = new DataSet();
dsCountries.ReadXml(new StringReader(strXMLCountries));
model.CountryList = new List<SelectListItem>();
model.CountryList.Add(new SelectListItem { Text = "-- Select Country --", Value = "" });
if (dsCountries.Tables.Count > 0)
{
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 = "-- Industry Type --", Value = "" });
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() });
}
}
//string strXMLComplianceTypes = organizationService.getAllComplianceTypes();
//DataSet dsComplianceTypes = new DataSet();
//dsComplianceTypes.ReadXml(new StringReader(strXMLIndustryType));
//model.ComplianceTypeList = new List<SelectListItem>();
//model.ComplianceTypeList.Add(new SelectListItem { Text = "-- Industry Type --", Value = "" });
//if (dsComplianceTypes.Tables.Count > 0)
//{
// foreach (System.Data.DataRow row in dsComplianceTypes.Tables[0].Rows)
// {
// model.ComplianceTypeList.Add(new SelectListItem() { Text = row["Compliance_Type_Name"].ToString(), Value = row["Compliance_Type_ID"].ToString() });
// }
//}
return View("_MapComplianceTypes", model);
}
public ActionResult ComplianceActMapping()
{
complianceActmappingViewModel model = new complianceActmappingViewModel();
OrgService.OrganizationServiceClient organizationService = new OrgService.OrganizationServiceClient();
string strXMLCountries = organizationService.GetCountryList();
DataSet dsCountries = new DataSet();
dsCountries.ReadXml(new StringReader(strXMLCountries));
model.Country = new List <SelectListItem>();
// model.Country.Add(new SelectListItem { Text = "-- Select Country --", Value = "" });
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.Country.Add(new SelectListItem()
{
Text = row["Country_Name"].ToString(), Value = row["Country_ID"].ToString()
});
}
}
//ComplianceXrefService.ComplianceXrefServiceClient client = new ComplianceXrefService.ComplianceXrefServiceClient();
//string xmldata = client.GetComplainceType(0);
//DataSet ds = new DataSet();
//ds.ReadXml(new StringReader(xmldata));
model.ComplianceType = new List <SelectListItem>();
//if (ds.Tables.Count > 0)
//{
// model.compliancetypeid = Convert.ToInt32(ds.Tables[0].Rows[0]["Compliance_Type_ID"]);
// foreach (System.Data.DataRow row in ds.Tables[0].Rows)
// {
// model.ComplianceType.Add(new SelectListItem { Text = Convert.ToString(row["Compliance_Type_Name"]), Value = Convert.ToString(row["Compliance_Type_ID"]) });
// }
//}
string strXMLIndustryType = organizationService.GetIndustryType();
DataSet dsIndustryType = new DataSet();
dsIndustryType.ReadXml(new StringReader(strXMLIndustryType));
model.IndustryType = new List <SelectListItem>();
// model.IndustryType.Add(new SelectListItem { Text = "-- Industry Type --", Value = "" });
if (dsIndustryType.Tables.Count > 0)
{
model.industryid = Convert.ToInt32(dsIndustryType.Tables[0].Rows[0]["Industry_Type_ID"]);
foreach (System.Data.DataRow row in dsIndustryType.Tables[0].Rows)
{
model.IndustryType.Add(new SelectListItem()
{
Text = row["Industry_Name"].ToString(), Value = row["Industry_Type_ID"].ToString()
});
}
}
string strXMLCompliances = organizationService.GetComplianceType(model.countryid, model.industryid);
DataSet dsCompliances = new DataSet();
dsCompliances.ReadXml(new StringReader(strXMLCompliances));
if (dsCompliances.Tables.Count > 0)
{
model.compliancetypeid = Convert.ToInt32(dsCompliances.Tables[0].Rows[0]["Compliance_Type_ID"]);
Session["compliancetypeid"] = Convert.ToInt32(dsCompliances.Tables[0].Rows[0]["Compliance_Type_ID"]);
foreach (System.Data.DataRow row in dsCompliances.Tables[0].Rows)
{
model.ComplianceType.Add(new SelectListItem()
{
Text = row["Compliance_Type_Name"].ToString(), Value = row["Compliance_Type_ID"].ToString()
});
}
}
return(View("_complianceActMap", 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));
}