public ActionResult IndexDataImportHandling(OISettingEntity model)
{
if (!string.IsNullOrEmpty(model.ORB_DATA_IMPORT_DUPLICATE_RESOLUTION))
{
OISettingFacade fac = new OISettingFacade(this.CurrentClient.ApplicationDBConnectionString);
fac.UpdateOrbDataImportHandling(model, "OrbDataImportHandling");
return(Json(new { result = true, message = DandBSettingLang.msgSettingUpdate }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = true, message = DandBSettingLang.msgInvadilState }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult IndexDataImportHandling()
{
CleanseMatchSettingsModel model = new CleanseMatchSettingsModel();
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
model.Settings = fac.GetCleanseMatchSettings();
CommonMethod.GetSettingIDs(model);
OISettingEntity Orbmodel = new OISettingEntity();
Orbmodel.ORB_DATA_IMPORT_DUPLICATE_RESOLUTION_TAGS = model.Settings[model.ORB_DATA_IMPORT_DUPLICATE_RESOLUTION_TAGS].SettingValue;
Orbmodel.ORB_DATA_IMPORT_DUPLICATE_RESOLUTION = model.Settings[model.ORB_DATA_IMPORT_DUPLICATE_RESOLUTION].SettingValue;
return(PartialView("~/Views/OI/OISetting/IndexDataImportHandling.cshtml", Orbmodel));
}
public ActionResult OIBackgroundProcessSettings(OISettingEntity model)
{
if (!string.IsNullOrEmpty(model.ORB_BATCH_SIZE) && !string.IsNullOrEmpty(model.ORB_BATCH_WAITTIME_SECS) && !string.IsNullOrEmpty(model.ORB_MAX_PARALLEL_THREADS))
{
OISettingFacade fac = new OISettingFacade(this.CurrentClient.ApplicationDBConnectionString);
fac.UpdateOrbBackgroundSetting(model, "OrbBackgroundSetting");
Helper.IsEnableCorporateTreeEnrichment = model.ORB_ENABLE_CORPORATE_TREE_ENRICHMENT;
return(Json(new { result = true, message = DandBSettingLang.msgSettingUpdate }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = true, message = DandBSettingLang.msgInvadilState }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult OIBackgroundProcessSettings()
{
CleanseMatchSettingsModel model = new CleanseMatchSettingsModel();
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
model.Settings = fac.GetCleanseMatchSettings();
CommonMethod.GetSettingIDs(model);
OISettingEntity Orbmodel = new OISettingEntity();
Orbmodel.ORB_BATCH_SIZE = model.Settings[model.ORB_BATCH_SIZE].SettingValue;
Orbmodel.ORB_BATCH_WAITTIME_SECS = model.Settings[model.ORB_BATCH_WAITTIME_SECS].SettingValue;
Orbmodel.ORB_MAX_PARALLEL_THREADS = model.Settings[model.ORB_MAX_PARALLEL_THREADS].SettingValue;
Orbmodel.PAUSE_ORB_BATCHMATCH_ETL = Convert.ToBoolean(model.Settings[model.PAUSE_ORB_BATCHMATCH_ETL].SettingValue);
Orbmodel.ORB_ENABLE_CORPORATE_TREE_ENRICHMENT = Convert.ToBoolean(model.Settings[model.ORB_ENABLE_CORPORATE_TREE_ENRICHMENT].SettingValue);
return(PartialView("~/Views/OI/OISetting/OIBackgroundProcessSettings.cshtml", Orbmodel));
}
internal void UpdateOrbDataImportHandling(OISettingEntity orbEntity, string Section)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.OrbProcessSettingsUpdate";
sproc.StoredProceduresParameter.Add(GetParam("@Section", Section, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ORB_DATA_IMPORT_DUPLICATE_RESOLUTION", Convert.ToString(orbEntity.ORB_DATA_IMPORT_DUPLICATE_RESOLUTION), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ORB_DATA_IMPORT_DUPLICATE_RESOLUTION_TAGS", Convert.ToString(orbEntity.ORB_DATA_IMPORT_DUPLICATE_RESOLUTION_TAGS), SQLServerDatatype.VarcharDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
}
catch (Exception)
{
throw;
}
}
internal void UpdateOrbCredentials(OISettingEntity orbEntity, string Section)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.OrbProcessSettingsUpdate";
sproc.StoredProceduresParameter.Add(GetParam("@Section", Section, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@OrbAPIKey", orbEntity.ORB_API_KEY.ToString(), SQLServerDatatype.VarcharDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
}
catch (Exception)
{
throw;
}
}
public ActionResult IndexOILicense()
{
List <ThirdPartyAPICredentialsEntity> lstThirdPartyAPICredentials = new List <ThirdPartyAPICredentialsEntity>();
ThirdPartyAPICredentialsFacade fac = new ThirdPartyAPICredentialsFacade(this.CurrentClient.ApplicationDBConnectionString);
lstThirdPartyAPICredentials = fac.GetThirdPartyAPICredentials(ThirdPartyProvider.ORB.ToString());
OISettingEntity Orbmodel = new OISettingEntity();
if (lstThirdPartyAPICredentials != null && lstThirdPartyAPICredentials.Any())
{
Orbmodel.ORB_API_KEY = lstThirdPartyAPICredentials.FirstOrDefault().APICredential;
}
// MP-1046 Create Individual URL redirection for all Tabs to make better format for URL
ViewBag.SelectedTab = "OI Auto Acceptance";
return(PartialView("~/Views/OI/OISetting/IndexOILicense.cshtml", Orbmodel));
}
internal void UpdateOrbBackgroundSetting(OISettingEntity orbEntity, string Section)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "oi.OrbProcessSettingsUpdate";
sproc.StoredProceduresParameter.Add(GetParam("@Section", Section, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ORB_BATCH_SIZE", orbEntity.ORB_BATCH_SIZE.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ORB_BATCH_WAITTIME_SECS", orbEntity.ORB_BATCH_WAITTIME_SECS.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ORB_MAX_PARALLEL_THREADS", orbEntity.ORB_MAX_PARALLEL_THREADS.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@PAUSE_ORB_BATCHMATCH_ETL", orbEntity.PAUSE_ORB_BATCHMATCH_ETL.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ORB_ENABLE_CORPORATE_TREE_ENRICHMENT", orbEntity.ORB_ENABLE_CORPORATE_TREE_ENRICHMENT.ToString(), SQLServerDatatype.VarcharDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
}
catch (Exception)
{
throw;
}
}
public ActionResult IndexOILicense(OISettingEntity model)
{
if (!string.IsNullOrEmpty(model.ORB_API_KEY))
{
//Update API License in Main Portal DB
OISettingFacade fac = new OISettingFacade(this.CurrentClient.ApplicationDBConnectionString);
fac.UpdateOrbCredentials(model, "OrbCredentialsSetting");
//OI - License management for OI API. (MP-590)
//Update API License in ClientMasert DB
fac = new OISettingFacade(StringCipher.Decrypt(Helper.GetMasterConnctionstring(), General.passPhrase));
//Get SubDomain
string[] hostParts = new System.Uri(Request.Url.AbsoluteUri).Host.Split('.');
string SubDomain = hostParts[0];
fac.UpdateOIAPILicenseForClients(SubDomain, model.ORB_API_KEY); // MP-846 Admin database cleanup and code cleanup.-CLIENT
return(Json(new { result = true, message = DandBSettingLang.msgSettingUpdate }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = true, message = DandBSettingLang.msgInvadilState }, JsonRequestBehavior.AllowGet));
}
}
public void UpdateOrbDataImportHandling(OISettingEntity orbEntity, string Section)
{
rep.UpdateOrbDataImportHandling(orbEntity, Section);
}
public void UpdateOrbBackgroundSetting(OISettingEntity orbEntity, string Section)
{
rep.UpdateOrbBackgroundSetting(orbEntity, Section);
}
public void UpdateOrbCredentials(OISettingEntity orbEntity, string Section)
{
rep.UpdateOrbCredentials(orbEntity, Section);
}
