//GET : Insert Update Command Upload Mapping
public ActionResult CreateCommandMapping(string Parameters)
{
CommandUploadMappingEntity objCommandUploadMappingEntity = new CommandUploadMappingEntity();
string ImportType = "data import";
if (!string.IsNullOrEmpty(Parameters))
{
Parameters = StringCipher.Decrypt(Parameters.Replace(Utility.Utility.urlseparator, "+"), General.passPhrase);
int id = Convert.ToInt32(Parameters);
if (id > 0)
{
bool IsTag = false;
bool IsInLanguage = false;
ColumnMappingFacade tac = new ColumnMappingFacade(this.CurrentClient.ApplicationDBConnectionString);
objCommandUploadMappingEntity = tac.GetCommandMappingById(id);
// Check if file contains tag field or not
if (Array.Exists(objCommandUploadMappingEntity.OriginalColumns.Split(','), element => element.ToLower() == "tags") || Array.Exists(objCommandUploadMappingEntity.OriginalColumns.Split(','), element => element.ToLower() == "tag"))
{
IsTag = true;
}
// Check if file contains language field or not
if (Array.Exists(objCommandUploadMappingEntity.OriginalColumns.Split(','), element => element.ToLower() == "language") ||
Array.Exists(objCommandUploadMappingEntity.OriginalColumns.Split(','), element => element.ToLower() == "language values") ||
Array.Exists(objCommandUploadMappingEntity.OriginalColumns.Split(','), element => element.ToLower() == "languagevalues") ||
Array.Exists(objCommandUploadMappingEntity.OriginalColumns.Split(','), element => element.ToLower() == "language code") ||
Array.Exists(objCommandUploadMappingEntity.OriginalColumns.Split(','), element => element.ToLower() == "languagecode"))
{
IsInLanguage = true;
}
List <SelectListItem> lstAllFilter = new List <SelectListItem>();
List <string> LstOriginalcolumnName = new List <string>();
LstOriginalcolumnName.AddRange(objCommandUploadMappingEntity.OriginalColumns.Split(','));
int i = 0;
foreach (var item in LstOriginalcolumnName)
{
lstAllFilter.Add(new SelectListItem {
Value = (i).ToString(), Text = Convert.ToString(item)
});
i++;
}
ViewBag.IsContainsTags = IsTag;
SessionHelper.CommandMapping_IsInLanguage = IsInLanguage;
ViewBag.ExternalColumn = lstAllFilter;
ViewBag.ColumnMapping = objCommandUploadMappingEntity.ColumnMapping;
ImportType = objCommandUploadMappingEntity.ImportType;
objCommandUploadMappingEntity.FileFormatCommandLine = objCommandUploadMappingEntity.FileFormat;
}
}
//get column Name
List <string> columnName = GetcolumnName(ImportType, this.CurrentClient.ApplicationDBConnectionString);
ViewBag.ImportMode = ImportType;
ViewBag.ColumnList = columnName;
return(PartialView("_createCommandMapping", objCommandUploadMappingEntity));
}
public ActionResult InsertUpdate(CommandUploadMappingEntity obj)
{
if (ModelState.IsValid)
{
ColumnMappingFacade fac = new ColumnMappingFacade(this.CurrentClient.ApplicationDBConnectionString);
obj.UserId = Helper.oUser.UserId;
obj.Tags = string.IsNullOrEmpty(obj.Tags) ? "" : obj.Tags == "0" ? "" : obj.Tags;
obj.Formatvalue = obj.FileFormat == "Delimiter" ? obj.Formatvalue : "";
obj.FileFormat = obj.FileFormatCommandLine;
string msg = fac.InsertUpdateCommandUploadMapping(obj);
string ImportType = obj == null ? "data import" : string.IsNullOrEmpty(obj.ImportType) ? "data import" : obj.ImportType.ToLower();
if (string.IsNullOrEmpty(msg))
{
if (obj.Id > 0)
{
ViewBag.Message = CommonMessagesLang.msgCommanUpdateMessage;
ImportType = obj.ImportType;
List <SelectListItem> lstAllFilter = new List <SelectListItem>();
List <string> LstOriginalcolumnName = new List <string>();
LstOriginalcolumnName.AddRange(obj.OriginalColumns.Split(','));
int i = 0;
foreach (var item in LstOriginalcolumnName)
{
lstAllFilter.Add(new SelectListItem {
Value = (i).ToString(), Text = Convert.ToString(item)
});
i++;
}
ViewBag.ExternalColumn = lstAllFilter;
ViewBag.ColumnMapping = obj.ColumnMapping;
}
else
{
ViewBag.Message = CommonMessagesLang.msgCommanInsertMessage;
obj = new CommandUploadMappingEntity();
}
}
else
{
ViewBag.Message = msg;
}
List <string> columnName = GetcolumnName(ImportType, this.CurrentClient.ApplicationDBConnectionString);
ViewBag.ColumnList = columnName;
ViewBag.ImportMode = ImportType;
}
else
{
ViewBag.Message = DandBSettingLang.msgInvadilState;
}
return(PartialView("_createCommandMapping", obj));
}
public ActionResult DeleteCommandDownload(string Parameters)
{
// 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);
}
ColumnMappingFacade fac = new ColumnMappingFacade(this.CurrentClient.ApplicationDBConnectionString);
fac.DeleteCommandDownloadMapping(Convert.ToInt32(Parameters));
return(Json(CommonMessagesLang.msgCommanDeleteMessage));
}
//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));
}
public ActionResult IndexCommandDownload()
{
ColumnMappingFacade tac = new ColumnMappingFacade(this.CurrentClient.ApplicationDBConnectionString);
List <CommandDownloadMappingEntity> model = new List <CommandDownloadMappingEntity>();
//Get Command Download Mapping List
model = tac.GetCommandDownloadMapping();
// MP-1046 Create Individual URL redirection for all Tabs to make better format for URL
if (Request.Headers["X-PJAX"] == "true")
{
return(PartialView("_indexCommandDownload", model));
}
else
{
ViewBag.SelectedTab = "Data Governance";
ViewBag.SelectedMainTab = "Integration Gateway";
ViewBag.SelectedIndividualTab = "Download Configuration";
return(View("~/Views/Portal/Index.cshtml", model));
}
}
