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));
}
