private List <ZionWeb.DAL.Entities.LandingToCoreMapDetails> AddMapDetails(MapDetailsJsonModel json)//Previousely MapDetailsJson { List <ZionWeb.DAL.Entities.LandingToCoreMapDetails> mapDetails = new List <ZionWeb.DAL.Entities.LandingToCoreMapDetails>(); json.MappingArray.ForEach(m => { if (m.Source.LandingDetailId != 0) { ZionWeb.DAL.Entities.LandingToCoreMapDetails mapRow = new ZionWeb.DAL.Entities.LandingToCoreMapDetails { InterfaceId = json.InterfaceId, DatasetId = json.DataSetId, CreatedBy = json.CreatedBy, CreatedDate = DateTime.Now, LandingDetailId = m.Source.LandingDetailId, CoreDetailId = m.Target.CoreDetailId, Status = true, IsParentFlag = json.IsParentFlag }; mapDetails.Add(mapRow); } } ); return(mapDetails); }
public ActionResult Save([FromBody] MapDetailsJsonModel mapJson) { string message = _ingestionManager.SaveMappingDetails(mapJson); if (message.Length > 0) { return(Json(new { status = "Failure", message = "Mandatory columns in core table " + message + " are not mapped" })); } else { return(Json(new { status = "Success", message = "Mapping temporarily saved" })); } }
public string SaveMappingDetails(MapDetailsJsonModel mapJson) { List <ZionWeb.DAL.Entities.LandingToCoreTempDetails> mapDetails = new List <ZionWeb.DAL.Entities.LandingToCoreTempDetails>(); mapJson.MappingArray.ForEach(m => { if (m.Source.LandingDetailId != 0) { ZionWeb.DAL.Entities.LandingToCoreTempDetails mapRow = new ZionWeb.DAL.Entities.LandingToCoreTempDetails { InterfaceId = mapJson.InterfaceId, DatasetId = mapJson.DataSetId, CreatedBy = mapJson.CreatedBy, CreatedDate = DateTime.Now, LandingDetailId = m.Source.LandingDetailId, CoreDetailId = m.Target.CoreDetailId, Status = true, IsParentFlag = mapJson.IsParentFlag }; mapDetails.Add(mapRow); } } ); string mandatoryColumns = _ingestionDAL.MandatoryColumnsOnSave(mapDetails, mapJson.CoreTableName); //Todo: Test if (string.IsNullOrEmpty(mandatoryColumns)) { _ingestionDAL.SaveMappingDetails(mapDetails, mapJson.DataSetId, mapJson.CoreTableName); return(mandatoryColumns); } else { return(mandatoryColumns); } }