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