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