internal CommandDownloadMappingEntity GetCommandDownloadMappingById(int Id)
{
CommandDownloadMappingEntity results = new CommandDownloadMappingEntity();
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.GetCommandDownloadMappingById";
sproc.StoredProceduresParameter.Add(GetParam("@Id", Id.ToString(), SQLServerDatatype.IntDataType));
DataTable dt;
dt = sql.ExecuteDataTable(CommandType.StoredProcedure, sproc, "");
if (dt != null && dt.Rows.Count > 0)
{
CommandDownloadMappingAdapter ta = new CommandDownloadMappingAdapter();
foreach (DataRow rw in dt.Rows)
{
results = ta.AdaptItem(rw, dt);
}
}
}
catch (Exception)
{
throw;
}
return(results);
}
//GET : Insert Update Command Download Mapping
public ActionResult InsertUpdateCommandDownload(string Parameters)
{
CommandDownloadMappingEntity obj = new CommandDownloadMappingEntity();
obj.IsAppendDateTime = true;
// Get Query string in Encrypted mode and decrypt Query string and set Parameters
if (!string.IsNullOrEmpty(Parameters))
{
Parameters = StringCipher.Decrypt(Parameters.Replace(Utility.Utility.urlseparator, "+"), General.passPhrase);
int id = Convert.ToInt32(Parameters);
if (id > 0)
{
ColumnMappingFacade tac = new ColumnMappingFacade(this.CurrentClient.ApplicationDBConnectionString);
obj = tac.GetCommandDownloadMappingById(id);
}
}
return(PartialView("_insertUpdateCommandDownload", obj));
}
public ActionResult InsertUpdateCommandDownload(CommandDownloadMappingEntity obj)
{
if (ModelState.IsValid)
{
if (string.IsNullOrEmpty(obj.ProviderType))
{
if (Helper.LicenseEnabledDNB && !Helper.LicenseEnabledOrb)
{
obj.ProviderType = "DandB";
}
else if (!Helper.LicenseEnabledDNB && Helper.LicenseEnabledOrb)
{
obj.ProviderType = "Orb";
}
}
ColumnMappingFacade fac = new ColumnMappingFacade(this.CurrentClient.ApplicationDBConnectionString);
obj.Formatvalue = obj.DownloadFormat == "Delimiter" ? obj.Formatvalue : "";
obj.UserId = 0;
string msg = fac.InsertUpdateCommandDownloadMapping(obj);
// set message for insert & update
if (string.IsNullOrEmpty(msg))
{
if (obj.Id > 0)
{
ViewBag.Message = CommonMessagesLang.msgCommanUpdateMessage;
}
else
{
ViewBag.Message = CommonMessagesLang.msgCommanInsertMessage;
}
}
else
{
ViewBag.Message = msg;
}
}
else
{
ViewBag.Message = DandBSettingLang.msgInvadilState;
}
return(View("_insertUpdateCommandDownload", obj));
}
internal string InsertUpdateCommandDownloadMapping(CommandDownloadMappingEntity objCommandDownloadMapping)
{
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "dnb.InsertUpdateCommandDownloadMapping";
sproc.StoredProceduresParameter.Add(GetParam("@Id", objCommandDownloadMapping.Id.ToString(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ConfigurationName", objCommandDownloadMapping.ConfigurationName.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Tag", string.IsNullOrEmpty(objCommandDownloadMapping.Tag) ? "" : objCommandDownloadMapping.Tag.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@LOBTag", string.IsNullOrEmpty(objCommandDownloadMapping.LOBTag) ? "" : objCommandDownloadMapping.LOBTag.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@DownloadMatchOutput", objCommandDownloadMapping.DownloadMatchOutput.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@DownloadEnrichmentOutput", objCommandDownloadMapping.DownloadEnrichmentOutput.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@DownloadMonitoringUpdates", objCommandDownloadMapping.DownloadMonitoringUpdates.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@DownloadActiveDataQueue", objCommandDownloadMapping.DownloadActiveDataQueue.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@DownloadTransferDUNS", objCommandDownloadMapping.DownloadTransferDUNS.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@DownloadFormat", string.IsNullOrEmpty(objCommandDownloadMapping.DownloadFormat) ? "" : objCommandDownloadMapping.DownloadFormat.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@FormatValue", string.IsNullOrEmpty(objCommandDownloadMapping.Formatvalue) ? "" : objCommandDownloadMapping.Formatvalue.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@MarkAsExported", objCommandDownloadMapping.MarkAsExported.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsDefault", objCommandDownloadMapping.IsDefault.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@APILayer", string.IsNullOrEmpty(objCommandDownloadMapping.APILayer) ? "" : objCommandDownloadMapping.APILayer.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsAppendDateTime", objCommandDownloadMapping.IsAppendDateTime.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@IsFilePrefix", objCommandDownloadMapping.IsFilePrefix.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@DateTimeFileFormat", string.IsNullOrEmpty(objCommandDownloadMapping.DateTimeFileFormat) ? "" : objCommandDownloadMapping.DateTimeFileFormat.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@FilePrefix", string.IsNullOrEmpty(objCommandDownloadMapping.FilePrefix) ? "" : objCommandDownloadMapping.FilePrefix.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ProviderType", string.IsNullOrEmpty(objCommandDownloadMapping.ProviderType) ? "" : objCommandDownloadMapping.ProviderType.ToString(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@DownloadCompanyTree", objCommandDownloadMapping.DownloadCompanyTree.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@DownloadLCMQueue", objCommandDownloadMapping.DownloadLCMQueue.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@DownloadNoMatchQueue", objCommandDownloadMapping.DownloadNoMatchQueue.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@ApplyTextQualifierToAll", objCommandDownloadMapping.ApplyTextQualifierToAll.ToString(), SQLServerDatatype.BitDataType));
sproc.StoredProceduresParameter.Add(GetParam("@UserId", Convert.ToString(objCommandDownloadMapping.UserId), SQLServerDatatype.IntDataType));
sql.ExecuteNoReturn(CommandType.StoredProcedure, sproc);
return("");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public string InsertUpdateCommandDownloadMapping(CommandDownloadMappingEntity objCommandDownloadMapping)
{
return rep.InsertUpdateCommandDownloadMapping(objCommandDownloadMapping);
}
