public ActionResult AddUpdateThirdPartyOrbCredential(ThirdPartyAPICredentialsEntity model) { ThirdPartyAPICredentialsFacade fac = new ThirdPartyAPICredentialsFacade(this.CurrentClient.ApplicationDBConnectionString); try { model.ThirdPartyProvider = ThirdPartyProvider.ORB.ToString(); string Message = fac.InsertUpdateThirdPartyAPICredentials(model, Helper.oUser.UserId); if (string.IsNullOrEmpty(Message)) { //fac.RefreshThirdPartyAPICredentials(ThirdPartyProvider.ORB.ToString()); if (model.CredentialId > 0) { return(Json(new { result = true, Message = CommonMessagesLang.msgCommanUpdateMessage }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { result = true, Message = CommonMessagesLang.msgCommanInsertMessage }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { result = false, Message = CommonMessagesLang.msgCommanErrorMessage }, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json(new { result = false, Message = CommonMessagesLang.msgCommanErrorMessage }, JsonRequestBehavior.AllowGet)); } }
internal ThirdPartyAPICredentialsEntity GetMinConfidenceSettingsById(int MinCCId) { ThirdPartyAPICredentialsEntity results = new ThirdPartyAPICredentialsEntity(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "dnb.GetMinConfidenceSettingsById"; sproc.StoredProceduresParameter.Add(GetParam("@Id", MinCCId.ToString(), SQLServerDatatype.IntDataType)); DataTable dt; dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, ""); if (dt != null && dt.Rows.Count > 0) { ThirdPartyAPICredentialsAdapter adta = new ThirdPartyAPICredentialsAdapter(); foreach (DataRow rw in dt.Rows) { results = adta.AdaptItem(rw); } } } catch (Exception) { throw; } return(results); }
public ActionResult AddUpdateThirdPartyOrbCredential(string Parameters) { int CredentialId = 0; ThirdPartyAPICredentialsEntity model = new ThirdPartyAPICredentialsEntity(); ThirdPartyAPICredentialsFacade fac = new ThirdPartyAPICredentialsFacade(this.CurrentClient.ApplicationDBConnectionString); if (!string.IsNullOrEmpty(Parameters)) { Parameters = StringCipher.Decrypt(Parameters.Replace(Utility.Utility.urlseparator, "+"), General.passPhrase); CredentialId = Convert.ToInt32(Parameters); if (CredentialId > 0) { model = fac.GetThirdPartyAPICredentialsById(CredentialId); } } return(View("~/Views/OI/OISetting/AddUpdateThirdPartyOrbCredential.cshtml", model)); }
internal ThirdPartyAPICredentialsEntity GetThirdPartyAPICredentialsById(int CredentialId) { ThirdPartyAPICredentialsEntity results = new ThirdPartyAPICredentialsEntity(); try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "cfg.GetThirdPartyAPICredentialsById"; sproc.StoredProceduresParameter.Add(GetParam("@CredentialId", CredentialId.ToString(), SQLServerDatatype.VarcharDataType)); DataTable dt = new DataTable(); dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "", DBIntent.Read.ToString()); if (dt != null && dt.Rows.Count > 0) { results = new ThirdPartyAPICredentialsAdapter().AdaptItem(dt.Rows[0]); } } catch (Exception) { throw; } return(results); }
public ActionResult AddUpdateThirdPartyDandBCredential(ThirdPartyAPICredentialsEntity model) { ModelState.Remove("Tag"); try { if (ModelState.IsValid) { ThirdPartyAPICredentialsFacade fac = new ThirdPartyAPICredentialsFacade(this.CurrentClient.ApplicationDBConnectionString); model.ThirdPartyProvider = ThirdPartyProvider.DNB.ToString(); string Message = fac.InsertUpdateThirdPartyAPICredentials(model, Helper.oUser.UserId); if (string.IsNullOrEmpty(Message)) { fac.RefreshThirdPartyAPICredentials(ThirdPartyProvider.DNB.ToString()); CommonMethod.GetThirdPartyAPICredentials(this.CurrentClient.ApplicationDBConnectionString); if (model.CredentialId > 0) { return(Json(new { result = true, Message = CommonMessagesLang.msgCommanUpdateMessage }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { result = true, Message = CommonMessagesLang.msgCommanInsertMessage }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { result = false, Message = CommonMessagesLang.msgCommanErrorMessage }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { result = false, Message = CommonMessagesLang.msgInvadilState }, JsonRequestBehavior.AllowGet)); } } catch (Exception) { return(Json(new { result = false, Message = CommonMessagesLang.msgCommanErrorMessage }, JsonRequestBehavior.AllowGet)); } }
internal string InsertUpdateThirdPartyAPICredentials(ThirdPartyAPICredentialsEntity obj, int UserId) { string Message = string.Empty; try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "cfg.InsertUpdateThirdPartyAPICredentials"; sproc.StoredProceduresParameter.Add(GetParam("@CredentialId", obj.CredentialId.ToString(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@ThirdPartyProvider", obj.ThirdPartyProvider, SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@CredentialName", obj.CredentialName, SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@APICredential", obj.APICredential, SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@APIPassword", obj.APIPassword, SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@APIType", obj.APIType, SQLServerDatatype.VarcharDataType)); sproc.StoredProceduresParameter.Add(GetParam("@UserId", Convert.ToString(UserId), SQLServerDatatype.IntDataType)); sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc); return(Message); } catch (Exception ex) { return(Message = ex.Message); } }
public string InsertUpdateThirdPartyAPICredentials(ThirdPartyAPICredentialsEntity obj, int UserId) { return(rep.InsertUpdateThirdPartyAPICredentials(obj, UserId)); }