public ActionResult CreateActs() { ComplianceViewModel model = new ComplianceViewModel(); model.Countrylist = new List <SelectListItem>(); model.Countrylist.Add(new SelectListItem() { Text = "--Select Country--", Value = "0" }); OrgService.OrganizationServiceClient organizationservice = new OrgService.OrganizationServiceClient(); string strXMLCountries = organizationservice.GetCountryList(); DataSet dsCountries = new DataSet(); dsCountries.ReadXml(new StringReader(strXMLCountries)); 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() }); } } model.Statelist = new List <SelectListItem>(); model.Statelist.Add(new SelectListItem() { Text = "--Select State--", Value = "0" }); model.Citylist = new List <SelectListItem>(); model.Citylist.Add(new SelectListItem() { Text = "--Select City--", Value = "0" }); model.ActType = new List <SelectListItem>(); model.ActType.Add(new SelectListItem { Text = "--Select Act Type--", Value = "0" }); model.ActType.Add(new SelectListItem { Text = "Union Level", Value = "1" }); model.ActType.Add(new SelectListItem { Text = "State Level", Value = "2" }); model.ActType.Add(new SelectListItem { Text = "City Level", Value = "3" }); model.Compliance = new ComplianceXref(); model.Compliance.Compliance_Xref_ID = 0; Session["Actmodel"] = model; return(PartialView("_AddActs", model)); }
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 UpdateAct(int id) { ComplianceViewModel model = new ComplianceViewModel(); model.Countrylist = new List <SelectListItem>(); model.Countrylist.Add(new SelectListItem() { Text = "--Select Country--", Value = "0" }); OrgService.OrganizationServiceClient organizationservice = new OrgService.OrganizationServiceClient(); string strXMLCountries = organizationservice.GetCountryList(); DataSet dsCountries = new DataSet(); dsCountries.ReadXml(new StringReader(strXMLCountries)); 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() }); } } model.Statelist = new List <SelectListItem>(); model.Statelist.Add(new SelectListItem() { Text = "--Select State--", Value = "0" }); model.Citylist = new List <SelectListItem>(); model.Citylist.Add(new SelectListItem() { Text = "--Select City--", Value = "0" }); model.ActType = new List <SelectListItem>(); model.ActType.Add(new SelectListItem { Text = "--Select Act Type--", Value = "0" }); model.ActType.Add(new SelectListItem { Text = "Union Level", Value = "1" }); model.ActType.Add(new SelectListItem { Text = "State Level", Value = "2" }); //model.ActType.Add(new SelectListItem { Text = "City Level", Value = "3" }); ComplianceXrefService.ComplianceXrefServiceClient client = new ComplianceXrefService.ComplianceXrefServiceClient(); model.ComplianceType = new List <SelectListItem>(); string xmldata = client.GetComplainceType(); DataSet ds = new DataSet(); ds.ReadXml(new StringReader(xmldata)); model.ComplianceType.Add(new SelectListItem { Text = "-- Select Compliance --", Value = "0" }); if (ds.Tables.Count > 0) { 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"]) }); } } model.Compliance = new ComplianceXref(); xmldata = client.GetActs(id); ds = new DataSet(); ds.ReadXml(new StringReader(xmldata)); model.Compliance.Compliance_Xref_ID = id; model.Compliance.Compliance_Type_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["Compliance_Type_ID"]); model.Compliance.Compliance_Parent_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["Compliance_Parent_ID"]); model.Compliance.Compliance_Title = Convert.ToString(ds.Tables[0].Rows[0]["Compliance_Title"]); model.Compliance.compl_def_consequence = Convert.ToString(ds.Tables[0].Rows[0]["compl_def_consequence"]); model.Compliance.City_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["City_ID"]); model.Compliance.Comp_Description = Convert.ToString(ds.Tables[0].Rows[0]["Comp_Description"]); model.Compliance.Effective_End_Date = Convert.ToDateTime(ds.Tables[0].Rows[0]["Effective_End_Date"]); model.Compliance.Effective_Start_Date = Convert.ToDateTime(ds.Tables[0].Rows[0]["Effective_Start_Date"]); model.Compliance.State_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["State_ID"]); model.Compliance.Country_ID = Convert.ToInt32(ds.Tables[0].Rows[0]["Country_ID"]); if (model.Compliance.State_ID == 0) { model.ActTypeID = 1; } else { model.ActTypeID = 2; } return(PartialView("~/Views/ComplianceManagement/UpdateAct.cshtml", 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)); }