public JsonResult getCompliance(string countryid, string industrytypeid)
{
if (countryid == "")
{
countryid = Convert.ToString(0);
}
List <SelectListItem> cities = new List <SelectListItem>();
int CID = Convert.ToInt32(countryid);
if (industrytypeid == "")
{
industrytypeid = Convert.ToString(0);
}
int IndustryID = Convert.ToInt32(industrytypeid);
OrgService.OrganizationServiceClient organizationservice = new OrgService.OrganizationServiceClient();
string strXMLCompliances = organizationservice.GetComplianceType(CID, IndustryID);
DataSet dsCompliances = new DataSet();
dsCompliances.ReadXml(new StringReader(strXMLCompliances));
if (dsCompliances.Tables.Count > 0)
{
foreach (System.Data.DataRow row in dsCompliances.Tables[0].Rows)
{
cities.Add(new SelectListItem()
{
Text = row["Compliance_Type_Name"].ToString(), Value = row["Compliance_Type_ID"].ToString()
});
}
}
return(Json(cities, JsonRequestBehavior.AllowGet));
}
public ActionResult GetComplianceToBindGrid(string countryid, string industrytypeid)
{
List <ComplianceIndustryViewModel> objCompList = new List <ComplianceIndustryViewModel>();
if (countryid == "")
{
countryid = Convert.ToString(0);
}
int CID = Convert.ToInt32(countryid);
if (industrytypeid == "")
{
industrytypeid = Convert.ToString(0);
}
int IndustryID = Convert.ToInt32(industrytypeid);
OrgService.OrganizationServiceClient organizationservice = new OrgService.OrganizationServiceClient();
string strXMLCompliances = organizationservice.GetComplianceType(CID, IndustryID);
DataSet dsCompliances = new DataSet();
dsCompliances.ReadXml(new StringReader(strXMLCompliances));
if (dsCompliances.Tables.Count > 0)
{
//ComplianceIndustryViewModel objComp1 = new ComplianceIndustryViewModel();
//objComp1.CountryName = Convert.ToString(dsCompliances.Tables[0].Rows[0]["Country_Name"]);
//objComp1.IndustryName = dsCompliances.Tables[0].Rows[0]["Industry_Name"].ToString();
//objCompList.Add(objComp1);
for (int i = 0; i < dsCompliances.Tables[0].Rows.Count; i++)
{
ComplianceIndustryViewModel objComp = new ComplianceIndustryViewModel();
objComp.CountryName = Convert.ToString(dsCompliances.Tables[0].Rows[i]["Country_Name"]);
objComp.IndustryName = dsCompliances.Tables[0].Rows[i]["Industry_Name"].ToString();
objComp.ComplianceType = new ComplianceType();
objComp.ComplianceType.ComplianceTypeName = dsCompliances.Tables[0].Rows[i]["Compliance_Type_Name"].ToString();
objComp.ComplianceType.ComplianceTypeID = Convert.ToInt32(dsCompliances.Tables[0].Rows[i]["Compliance_Type_ID"]);
objCompList.Add(objComp);
}
}
return(Json(objCompList, JsonRequestBehavior.AllowGet));
}
public JsonResult getCompanyDetailsfroVendor(int compid, string industrytypeid)
{
int industryTypeID = 0;
if (industrytypeid != "")
{
industryTypeID = Convert.ToInt32(industrytypeid);
}
List <SelectListItem> compliance = new List <SelectListItem>();
VendorViewModel vendorVM = new VendorViewModel();
vendorVM.location = new BranchLocation();
OrgService.OrganizationServiceClient organizationservice = new OrgService.OrganizationServiceClient();
string strXMLCompanyDetails = organizationservice.getDefaultCompanyDetails(compid);
DataSet dsCompanyDetails = new DataSet();
dsCompanyDetails.ReadXml(new StringReader(strXMLCompanyDetails));
if (dsCompanyDetails.Tables.Count > 0)
{
vendorVM.location.Country_Id = Convert.ToInt32(dsCompanyDetails.Tables[0].Rows[0]["Country_ID"]);
vendorVM.location.State_Id = Convert.ToInt32(dsCompanyDetails.Tables[0].Rows[0]["State_ID"]);
vendorVM.location.City_Id = Convert.ToInt32(dsCompanyDetails.Tables[0].Rows[0]["City_ID"]);
vendorVM.location.Postal_Code = Convert.ToString(dsCompanyDetails.Tables[0].Rows[0]["Postal_Code"]);
string strCompliances = organizationservice.GetComplianceType(industryTypeID, vendorVM.location.Country_Id);
DataSet dsCompliances = new DataSet();
dsCompliances.ReadXml(new StringReader(strCompliances));
if (dsCompliances.Tables.Count > 0)
{
foreach (System.Data.DataRow row in dsCompliances.Tables[0].Rows)
{
compliance.Add(new SelectListItem()
{
Text = row["Compliance_Type_Name"].ToString(), Value = row["Compliance_Type_ID"].ToString()
});
}
}
}
return(Json(compliance, JsonRequestBehavior.AllowGet));
}
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));
}
