// GET: BadInputData
#region "Load Bad Input Data"
public ActionResult Index(int?page, int?sortby, int?sortorder, int?pagevalue, string sort = null)
{
// Clear WorkQueue for Data
StewUserActivityCloseWindow();
if (Request.IsAjaxRequest())
{
// Set User name in session.
CompanyFacade fac = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName);
#region Set pagination Code
int pageNumber = (page ?? 1);
if (!string.IsNullOrEmpty(SessionHelper.CleanMatchPageNo) && pagevalue == null)
{
pagevalue = Convert.ToInt32(SessionHelper.CleanMatchPageNo);
}
if (pagevalue == null || Convert.ToInt32(pagevalue) == 0)
{
SettingFacade sfac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
pagevalue = Convert.ToInt32(sfac.GetDefaultPageSize(Helper.oUser.UserId, "BadInputData"));
pagevalue = pagevalue == 0 ? 10 : pagevalue;
}
BadInputDataModel model = new BadInputDataModel();
if (!(sortby.HasValue && sortby.Value > 0))
{
sortby = 1;
}
if (!(sortorder.HasValue && sortorder.Value > 0))
{
sortorder = 1;
}
int totalCount = 0;
int pageno = pagevalue.HasValue ? pagevalue.Value : 10;
pageno = pageno < 5 ? 5 : pageno;
// Set page no , sortorder , sortby and Page size to session
ViewBag.SortBy = sortby;
ViewBag.SortOrder = sortorder;
ViewBag.Page = pageNumber;
ViewBag.pageno = pageno;
Tuple <List <CompanyEntity>, string> tuplecompany = fac.GetBIDCompany(Helper.oUser.UserId, pageNumber, pageno, out totalCount);
model.Companies = tuplecompany.Item1;
SessionHelper.CleanQueueMessage = tuplecompany.Item2;
SessionHelper.CleanMatchPage = Convert.ToString(pageNumber);
SessionHelper.CleanMatchPageNo = Convert.ToString(pageno);
SessionHelper.CleanTotalCount = Convert.ToString(totalCount);
SessionHelper.CleanMatchedCompany = JsonConvert.SerializeObject(model.Companies);
#endregion
IPagedList <CompanyEntity> pagedCompany = new StaticPagedList <CompanyEntity>(model.Companies.ToList(), pageNumber, pageno, totalCount);// Set model of Company entity to pass this model to view.
return(PartialView("_Index", pagedCompany));
}
else
{
SessionHelper.BadInputData_IsFirstTimeFilter = true;
}
return(View());
}
public MonitoringRegistrationDetailResponse GetMonitoringRegistrationDetailResponseFromDB(string MonitoringRegistrationName)
{
MonitoringRegistrationDetailResponse monitoringRegistrationDetailResponse = new MonitoringRegistrationDetailResponse();
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
DataTable dt = fac.GetDPMRegistrationByName(MonitoringRegistrationName);
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
monitoringRegistrationDetailResponse.messages = new Messages();
monitoringRegistrationDetailResponse.messages.registration = new Registration();
monitoringRegistrationDetailResponse.messages.registration.reference = Convert.ToString(dt.Rows[0]["MonitoringRegistrationName"]);
monitoringRegistrationDetailResponse.messages.registration.productId = Convert.ToString(dt.Rows[0]["productId"]);
monitoringRegistrationDetailResponse.messages.registration.versionId = Convert.ToString(dt.Rows[0]["versionId"]);
monitoringRegistrationDetailResponse.messages.registration.email = Convert.ToString(dt.Rows[0]["email"]);
monitoringRegistrationDetailResponse.messages.registration.fileTransferProfile = Convert.ToString(dt.Rows[0]["fileTransferProfile"]);
monitoringRegistrationDetailResponse.messages.registration.description = Convert.ToString(dt.Rows[0]["description"]);
monitoringRegistrationDetailResponse.messages.registration.deliveryTrigger = Convert.ToString(dt.Rows[0]["deliveryTrigger"]);
monitoringRegistrationDetailResponse.messages.registration.deliveryFrequency = Convert.ToString(dt.Rows[0]["deliveryFrequency"]);
monitoringRegistrationDetailResponse.messages.registration.seedData = Convert.ToBoolean(dt.Rows[0]["seedData"]);
monitoringRegistrationDetailResponse.messages.registration.blockIds = Convert.ToString(dt.Rows[0]["blockIds"]);
monitoringRegistrationDetailResponse.messages.dunsCount = dt.Rows[0]["dunsCount"] != DBNull.Value ? Convert.ToInt32(dt.Rows[0]["dunsCount"]) : 0;
monitoringRegistrationDetailResponse.messages.registration.Tags = Convert.ToString(dt.Rows[0]["Tags"]);
monitoringRegistrationDetailResponse.messages.registration.CredentialId = dt.Rows[0]["CredentialId"] != DBNull.Value ? Convert.ToInt32(dt.Rows[0]["CredentialId"]) : 0;
monitoringRegistrationDetailResponse.messages.registration.CredentialName = dt.Rows[0]["CredentialName"] != DBNull.Value ? Convert.ToString(dt.Rows[0]["CredentialName"]) : string.Empty;
monitoringRegistrationDetailResponse.messages.registration.AuthToken = dt.Rows[0]["AuthToken"] != DBNull.Value ? Convert.ToString(dt.Rows[0]["AuthToken"]) : string.Empty;
}
return(monitoringRegistrationDetailResponse);
}
public List <MatchCodeEntity> LoadMatchGradesEntities(string ddlMatchGrade, string ConnectionString)
{
SettingFacade fac = new SettingFacade(ConnectionString);
switch (ddlMatchGrade)
{
case "Company":
return(fac.GetMatchMDPCodes("Company"));
case "StreetName":
return(fac.GetMatchMDPCodes("StreetName"));
case "StreetNo":
return(fac.GetMatchMDPCodes("StreetNo"));
case "City":
return(fac.GetMatchMDPCodes("City"));
case "State":
return(fac.GetMatchMDPCodes("State"));;
case "MailingAddress":
return(fac.GetMatchMDPCodes("MailingAddress"));
case "Phone":
return(fac.GetMatchMDPCodes("Phone"));
default:
return(fac.GetMatchMDPCodes(""));
}
}
public JsonResult BackgroundProcessSettings(BackgroundProcessSettingsViewModal model)
{
try
{
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
CleanseMatchSettingsModel oldmodel = new CleanseMatchSettingsModel();
oldmodel.Settings = fac.GetCleanseMatchSettings();
CommonMethod.GetSettingIDs(oldmodel);
if (CommonMethod.IsDigitsOnly(model.MAX_PARALLEL_THREAD) && CommonMethod.IsDigitsOnly(model.BATCH_SIZE) && CommonMethod.IsDigitsOnly(model.WAIT_TIME_BETWEEN_BATCHES_SECS))
{
oldmodel.Settings[oldmodel.MAX_PARALLEL_THREAD].SettingValue = model.MAX_PARALLEL_THREAD;
oldmodel.Settings[oldmodel.BATCH_SIZE].SettingValue = model.BATCH_SIZE;
oldmodel.Settings[oldmodel.WAIT_TIME_BETWEEN_BATCHES_SECS].SettingValue = model.WAIT_TIME_BETWEEN_BATCHES_SECS;
//update Cleanse Match Settings
fac.UpdateCleanseMatchSettings(oldmodel.Settings);
return(Json(new { result = true, Message = DandBSettingLang.msgSettingUpdate }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = false, Message = DandBSettingLang.msgInvadilState }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json(new { result = false, Message = CommonMessagesLang.msgSomethingWrong }, JsonRequestBehavior.AllowGet));
}
}
Task <T> IUserStore <T, string> .FindByIdAsync(string userId)
{
if (string.IsNullOrWhiteSpace(userId))
{
throw new ArgumentNullException("userId");
}
if (string.IsNullOrEmpty(_connectionString))
{
_connectionString = GetClientConnectionString();
}
SettingFacade fac = new SettingFacade(_connectionString);
int parsedUserId;
if (!int.TryParse(userId, out parsedUserId))
{
throw new ArgumentOutOfRangeException("userId", string.Format("'{0}' is not a valid GUID.", new { userId }));
}
return(Task.Factory.StartNew(() =>
{
UsersEntity oUser = fac.GetUserDetailsById(Convert.ToInt32(userId));
if (oUser == null)
{
return null;
}
else
{
return (T)(new ApplicationUser(oUser));
}
}));
}
public JsonResult GlobalMatchAutoAcceptanceSettings(CleanseMatchSettingsModel model)
{
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
CleanseMatchSettingsModel oldmodel = new CleanseMatchSettingsModel();
oldmodel.Settings = fac.GetCleanseMatchSettings();
GetSettingIDs(oldmodel);
//set Properties of Global Match Auto-Acceptance Settings
oldmodel.Settings[oldmodel.AUTO_CORRECTION_THRESHOLD].SettingValue = model.AUTO_CORRECTION_THRESHOLD.ToString();
oldmodel.Settings[oldmodel.APPLY_MATCH_GRADE_TO_LCM].SettingValue = model.boolApplyMatchGradeLCM.ToString();
oldmodel.Settings[oldmodel.MATCH_GRADE_NAME_THRESHOLD].SettingValue = model.boolBusinessName.ToString();
oldmodel.Settings[oldmodel.MATCH_GRADE_CITY_THRESHOLD].SettingValue = model.boolCity.ToString();
oldmodel.Settings[oldmodel.MATCH_GRADE_STATE_THRESHOLD].SettingValue = model.boolState.ToString();
oldmodel.Settings[oldmodel.MATCH_GRADE_STREET_NO_THRESHOLD].SettingValue = model.boolStreet.ToString();
oldmodel.Settings[oldmodel.MATCH_GRADE_STREET_NAME_THRESHOLD].SettingValue = model.boolStreetName.ToString();
oldmodel.Settings[oldmodel.MATCH_GRADE_TELEPHONE_THRESHOLD].SettingValue = model.boolTelephone.ToString();
oldmodel.Settings[oldmodel.MATCH_GRADE_ZIPCODE_THRESHOLD].SettingValue = model.boolZipCode.ToString();
//update Global Match Auto-Acceptance Settings
fac.UpdateCleanseMatchSettings(oldmodel.Settings);
model.Settings = fac.GetCleanseMatchSettings();
GetSettingIDs(model);
SetMatchGradeContent(model);
Clear(model);
return(Json(MessageCollection.SettingUpdate));
}
public ActionResult CachedDataSettings()
{
CleanseMatchSettingsModel model = new CleanseMatchSettingsModel();
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
// Fill all dropdown and value for setting value.
model.Settings = fac.GetCleanseMatchSettings();
CommonMethod.GetSettingIDs(model);
// GET API call for getting the udated value of MissingDataProvider field
Clients api = new Clients();
string ClientCode = model.Settings[model.DATA_STUB_CLIENT_CODE].SettingValue;
string missingdataprovider = api.GetClientCode(ClientCode);
if (missingdataprovider.Contains("False"))
{
missingdataprovider = "false";
}
else if (missingdataprovider.Contains("True"))
{
missingdataprovider = "true";
}
model.USE_DATA_STUB_VALUE = string.IsNullOrEmpty(model.Settings[model.USE_DATA_STUB].SettingValue) ? false : Convert.ToBoolean(model.Settings[model.USE_DATA_STUB].SettingValue);
model.USE_DATA_STUB_FOR_ENRICHMENT_VALUE = string.IsNullOrEmpty(model.Settings[model.USE_DATA_STUB_FOR_ENRICHMENT].SettingValue) ? false : Convert.ToBoolean(model.Settings[model.USE_DATA_STUB_FOR_ENRICHMENT].SettingValue);
if (missingdataprovider == "true" || missingdataprovider == "false")
{
model.MISSING_DATA_FROM_PROVIDER = Convert.ToBoolean(missingdataprovider);
}
SetMatchGradeContent(model);
Clear(model);
return(PartialView(model));
}
public List <CountryGroupEntity> LoadCountryGroupEntity(string ConnectionString)
{
// Load Country Group Entity
SettingFacade fac = new SettingFacade(ConnectionString);
return(fac.GetCountryGroup());
}
public List <MatchGradeEntity> LoadMatchGrades(string ConnectionString)
{
// Load Match Entity
SettingFacade fac = new SettingFacade(ConnectionString);
return(fac.GetMatchGrades());
}
public ActionResult GetDnBAPIList(string Parameters)
{
int credId = 0;
string apiType = string.Empty;
if (Parameters != null)
{
Parameters = StringCipher.Decrypt(Parameters.Replace(Utility.Utility.urlseparator, "+"), General.passPhrase);
apiType = Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 0, 1);
credId = Convert.ToInt32(Utility.Utility.SplitParameters(Parameters, Utility.Utility.Colonseparator, 1, 1));
}
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
List <ThirdPartyAPICredentialsEntity> lst = new List <ThirdPartyAPICredentialsEntity>();
List <DnbAPIEntity> lstAPI = new List <DnbAPIEntity>();
if (credId == 0)
{
lst = CommonDropdown.GetCredentials(this.CurrentClient.ApplicationDBConnectionString, ThirdPartyProvider.DNB.ToString(), apiType);
}
else
{
lstAPI = fac.GetDnBAPIList(apiType, credId);
}
if (lst.Count > 1)
{
lst.RemoveAt(0);
lstAPI = fac.GetDnBAPIList(apiType, lst[0].CredentialId);
}
var result = new { data = lstAPI, data2 = lst };
return(new JsonResult {
Data = result
});
}
public ListingItemViewModel(ListingFacade listingFacade, SettingFacade settingFacade)
{
_listingFacade = listingFacade;
_settingFacade = settingFacade;
Localities = new ObservableCollection <string>();
}
public ActionResult InsertUpdateDataEnrichment(DnBAPIGroupEntity model, string btnDnBApiGrp, string Tags)
{
Tags = Tags.TrimStart(',').TrimEnd(',');
model.Tags = Tags == "0" ? null : Tags;
// Save for DnbAbi Data.
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
model.lstDnbAPIs = fac.GetDnBAPIList(model.APIType);
List <string> lstAPIIDS = model.DnbAPIIds != null?model.DnbAPIIds.Split(',').ToList() : new List <string>();
if (model.IsValidSave)
{
if (!IsAPIGroupExists(model))
{
fac.InsertOrUpdateDnBAPIDetail(model);
ViewBag.APIMessage = model.APIGroupId == 0 ? CommonMessagesLang.msgCommanInsertMessage : CommonMessagesLang.msgCommanUpdateMessage;
return(Json(new { result = true, message = model.APIGroupId == 0 ? CommonMessagesLang.msgCommanInsertMessage : CommonMessagesLang.msgCommanUpdateMessage }, JsonRequestBehavior.AllowGet));
}
else
{
ViewBag.APIMessage = DandBSettingLang.msgGroupNameExist;
return(Json(new { result = false, message = DandBSettingLang.msgGroupNameExist }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { result = false, message = DandBSettingLang.msgInvadilState }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult DeleteAcceptance(string CriteriaGroupId, int CommentId)
{
// Delete Acceptance
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
fac.DeleteAcceptance(CriteriaGroupId, Helper.oUser.UserId, CommentId);
return(Json(MessageCollection.CommanDeleteMessage));
}
// Get Country with Country name and Code
public static List <CountryGroupEntity> GetCountry(string ConnectionString)
{
SettingFacade fac = new SettingFacade(ConnectionString);
List <CountryGroupEntity> CountryGroupEntity = new List <CountryGroupEntity>();
CountryGroupEntity = fac.GetCountryGroup();
return(CountryGroupEntity);
}
public PdfGenerationSettingsViewModel(SettingFacade settingFacade)
{
_settingFacade = settingFacade;
_pdfSetting = new DefaultListingPdfReportSetting();
_pdfSetting.OnSettingPropertyChanged += (arg) => {
OnSettingsPropertyChanged?.Invoke(this, arg);
};
}
public DataTable GetDPMDunsRegistrationByRegistrationName(string RegistrationName)
{
DataTable dt = new DataTable();
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
dt = fac.GetDPMDunsRegistrationByRegistrationName(RegistrationName);
return(dt);
}
public JsonResult DnBDirectLicense(CleanseMatchSettingsModel model, string btnSubmit = null)
{
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
CleanseMatchSettingsModel oldmodel = new CleanseMatchSettingsModel();
oldmodel.Settings = fac.GetCleanseMatchSettings();
GetSettingIDs(oldmodel);
try
{
model.Settings[oldmodel.DNB_PASSWORD].SettingValue = SBISCCMWeb.Utility.Utility.GetDecryptedString(model.Settings[model.DNB_PASSWORD].SettingValue);
}
catch
{
model.Settings[oldmodel.DNB_PASSWORD].SettingValue = model.Settings[oldmodel.DNB_PASSWORD].SettingValue;
}
oldmodel.Settings[oldmodel.DNB_USERNAME].SettingValue = model.Settings[oldmodel.DNB_USERNAME].SettingValue;
oldmodel.Settings[oldmodel.DNB_PASSWORD].SettingValue = model.Settings[oldmodel.DNB_PASSWORD].SettingValue;
oldmodel.Settings[oldmodel.API_LAYER].SettingValue = ApiLayerType.Direct20.ToString();
//check DnB Credentials is validate or not.
string Message = fac.ValidateDnBLogin(oldmodel.Settings[oldmodel.DNB_USERNAME].SettingValue, oldmodel.Settings[oldmodel.DNB_PASSWORD].SettingValue);
if (Message.ToLower() == MessageCollection.ValidCredential)
{
RestfulHttpClient <AuthResponse, string> authClient = new RestfulHttpClient <AuthResponse, string>(Helper.AuthURL, string.Empty, oldmodel.Settings[oldmodel.DNB_USERNAME].SettingValue, oldmodel.Settings[oldmodel.DNB_PASSWORD].SettingValue, Helper.JsonMediaType);
var responseData = authClient.GetAuthResponse();
if (responseData != null)
{
if (responseData.TransactionResult.ResultID != "CM000")
{
Helper.ApiToken = null;
}
else
{
Helper.ApiToken = responseData.AuthenticationDetail.Token;
}
}
else
{
Helper.ApiToken = null;
}
//update DnBDirectLicense Credentials
fac.UpdateCleanseMatchSettings(oldmodel.Settings);
fac.UpdateCleanseMatchSettingsAPIFamily(ApiLayerType.Direct20.ToString());
Message = MessageCollection.SettingUpdate;
}
model.Settings = fac.GetCleanseMatchSettings();
GetSettingIDs(model);
SetMatchGradeContent(model);
Clear(model);
TempData["ApiLayer"] = ApiLayerType.Direct20.ToString();
Helper.APILAYER = ApiLayerType.Direct20.ToString();
string Data = Message;
return(Json(Data));
}
public ActionResult CleanseMatchDataMatch()
{
DataTable dt = new DataTable();
if (TempData["Data"] != null)
{
dt = (TempData["Data"] as DataTable).Copy();
}
bool IsTag = false;
//Get Import File Column Name to fill in dropdown
List <SelectListItem> lstAllFilter = new List <SelectListItem>();
if (dt.Rows.Count > 0)
{
lstAllFilter.Add(new SelectListItem {
Value = "0", Text = "-Select-"
});
int i = 0;
foreach (DataColumn c in dt.Columns)
{
lstAllFilter.Add(new SelectListItem {
Value = (i + 1).ToString(), Text = Convert.ToString(c.ColumnName)
});
i++;
if (c.ColumnName.ToLower() == "tags" || c.ColumnName.ToLower() == "tag")
{
IsTag = true;
}
}
}
// Get InpCompany Data Column Names
SettingFacade sfac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
DataTable dtSecondaryAutoAcceptanceCriteria = new DataTable();
//Get Secondary Auto-Acceptance Criteria Columns Name
dtSecondaryAutoAcceptanceCriteria = sfac.GetSecondaryAutoAcceptanceCriteriaColumnsName();
List <string> columnName = new List <string>();
if (dtSecondaryAutoAcceptanceCriteria.Rows.Count > 0)
{
for (int k = 0; k < dtSecondaryAutoAcceptanceCriteria.Rows.Count; k++) //loop through the columns.
{
if (Convert.ToString(dtSecondaryAutoAcceptanceCriteria.Rows[k][0]) != "ImportRowId" && Convert.ToString(dtSecondaryAutoAcceptanceCriteria.Rows[k][0]) != "ImportProcessId" && Convert.ToString(dtSecondaryAutoAcceptanceCriteria.Rows[k][0]) != "CountryGroupId")
{
columnName.Add(Convert.ToString(dtSecondaryAutoAcceptanceCriteria.Rows[k][0]));
}
}
}
ViewBag.ColumnList = columnName;
ViewBag.ExternalColumn = lstAllFilter;
ViewBag.IsContainsTags = IsTag;
TempData["IsTag"] = IsTag;
IPagedList <dynamic> pagedProducts = new StaticPagedList <dynamic>(dt.AsDynamicEnumerable(), 1, 100000, 0);
TempData.Keep();
return(View(pagedProducts));
}
public ActionResult GetAutoAcceptanceCriteriaDetailByGroupId(int CriteriaGroupId)
{
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
List <AutoAcceptanceCriteriaDetail> lstAutoAcceptanceCriteriaDetail = new List <AutoAcceptanceCriteriaDetail>();
lstAutoAcceptanceCriteriaDetail = fac.GetAutoAcceptanceCriteriaDetailByGroupId(CriteriaGroupId);
return(PartialView("_AutoAcceptanceDetailView", lstAutoAcceptanceCriteriaDetail));
//return View("_AutoAcceptanceDetailView", lstAutoAcceptanceCriteriaDetail);
}
public ActionResult UpdateMonitoringRegistration(MonitoringRegistrationDetailResponse model)
{
model.messages.registration.Tags = model.messages.registration.Tags == "0" ? "" : model.messages.registration.Tags;
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
fac.DPMUpdateRegistration(model.messages.registration.reference, model.messages.registration.Tags);
ViewBag.MonitoringRegistrationMessage = CommonMessagesLang.msgCommanUpdateMessage;
return(Json(new { result = true, message = CommonMessagesLang.msgCommanUpdateMessage }, JsonRequestBehavior.AllowGet));
}
public SettingsViewModel(
IWindowManager windowManager,
SettingFacade settingFacade,
IIODialogService filePathDialogService
)
{
_windowManager = windowManager;
_settingFacade = settingFacade;
_filePathDialogService = filePathDialogService;
}
public CopyListingViewModel(
SettingFacade settingFacade,
ListingFacade listingFacade,
IListingFactory listingFactory
)
{
_settingFacade = settingFacade;
_listingFacade = listingFacade;
_listingFactory = listingFactory;
}
public JsonResult RunAutoAcceptanceRule()
{
//set Run Auto Acceptance Rule
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
fac.RunAutoAcceptanceRule();
return(new JsonResult {
Data = MessageCollection.RunRules
});
}
public JsonResult GetSecondaryAutoAcceptanceCriteriaGroupCount()
{
//set Run Auto Acceptance Rule
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
int count = Convert.ToInt32(fac.GetSecondaryAutoAcceptanceCriteriaGroupCount());
return(new JsonResult {
Data = count
});
}
public void LoadAdditionalAcceptanceDeatils(CleanseMatchSettingsModel model)
{
//Load AutoAcceptance Criteria.
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
model.AutoAcceptanceCriteria = fac.GetAutoAcceptanceDetails();
ObservableCollection <AutoAdditionalAcceptanceCriteriaEntity> myCollection = new ObservableCollection <AutoAdditionalAcceptanceCriteriaEntity>(model.AutoAcceptanceCriteria);
model.objAutoSetting = new AutoAdditionalAcceptanceCriteriaEntity();
}
// Update Cleans Match setting
public ActionResult UpdateCleanseMatchSettings(CleanseMatchSettingsModel model)
{
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
fac.UpdateCleanseMatchSettings(model.Settings);// Update Clean Bach Setting Value
string message = MessageCollection.SettingUpdate;
return(new JsonResult {
Data = message, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ListingPdfGenerationViewModel(
SettingFacade settingFacade,
IIODialogService filePathDialogService,
IListingsReportFactory listingsReportFactory,
IListingReportGenerator listingReportGenerator
)
{
_settingFacade = settingFacade;
_filePathDialogService = filePathDialogService;
_listingsReportFactory = listingsReportFactory;
_listingReportGenerator = listingReportGenerator;
}
//Get Auto-Acceptance Match Grade and fill dropdown list
public static List <string> GetAutoAcceptanceMatchGrade(string ConnectionString)
{
SettingFacade fac = new SettingFacade(ConnectionString);
DataTable dt = fac.GetAutoAcceptanceMatchGrade();
List <string> lstMatchGrade = new List <string>();
foreach (DataRow d in dt.Rows)
{
lstMatchGrade.Add(Convert.ToString(d["MatchGrade"]));
}
return(lstMatchGrade);
}
public JsonResult MixModeAPICredentials(FormCollection model)
{
try
{
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
CleanseMatchSettingsModel oldmodel = new CleanseMatchSettingsModel();
oldmodel.Settings = fac.GetCleanseMatchSettings();
GetSettingIDs(oldmodel);
string APIFamily = model["APIFamily"];
//DnB Direct License username & password
string DnBDirectLicenseuserName = model["Settings[" + oldmodel.DNB_USERNAME + "].SettingValue"];
string DnBDirectLicensePassword = model["Settings[" + oldmodel.DNB_PASSWORD + "].SettingValue"];
try
{
DnBDirectLicensePassword = SBISCCMWeb.Utility.Utility.GetDecryptedString(DnBDirectLicensePassword);
}
catch
{
DnBDirectLicensePassword = DnBDirectLicensePassword.ToString();
}
// Direct+ API Credentials username & password
string DirectPlusAPIuserName = model["Settings[" + oldmodel.DNB_PLUS_KEY + "].SettingValue"];
string DirectPlusAPIPassword = model["Settings[" + oldmodel.DNB_PLUS_SECRET + "].SettingValue"];
try
{
DirectPlusAPIPassword = SBISCCMWeb.Utility.Utility.GetDecryptedString(DirectPlusAPIPassword);
}
catch
{
DirectPlusAPIPassword = DirectPlusAPIPassword.ToString();
}
oldmodel.Settings[oldmodel.DNB_PLUS_KEY].SettingValue = DirectPlusAPIuserName;
oldmodel.Settings[oldmodel.DNB_PLUS_SECRET].SettingValue = DirectPlusAPIPassword;
oldmodel.Settings[oldmodel.DNB_USERNAME].SettingValue = DnBDirectLicenseuserName;
oldmodel.Settings[oldmodel.DNB_PASSWORD].SettingValue = DnBDirectLicensePassword;
oldmodel.Settings[oldmodel.API_LAYER].SettingValue = ApiLayerType.MixMode.ToString();
//update MixModeAPI Credentials
fac.UpdateCleanseMatchSettings(oldmodel.Settings);
fac.UpdateCleanseMatchSettingsAPIFamily(APIFamily);
TempData["ApiLayer"] = ApiLayerType.MixMode.ToString();
CompanyFacade fcd = new CompanyFacade(this.CurrentClient.ApplicationDBConnectionString, Helper.UserName);
APIFamily = fcd.GetAPILayer("Match and Cleanse");
Helper.APILAYER = ApiLayerType.MixMode.ToString();
var Result = new { Message = MessageCollection.SettingUpdate, APIFamily = APIFamily };
return(Json(Result));
}
catch (Exception)
{
return(Json(MessageCollection.SettingNotUpdate));
}
}
public ActionResult BackgroundProcessSettings()
{
CleanseMatchSettingsModel model = new CleanseMatchSettingsModel();
SettingFacade fac = new SettingFacade(this.CurrentClient.ApplicationDBConnectionString);
// Fill all dropdown and value for setting value.
model.Settings = fac.GetCleanseMatchSettings();
GetSettingIDs(model);
SetMatchGradeContent(model);
Clear(model);
return(PartialView(model));
}
