Untitled

foreach (DataRow ad in advertisingExcel.Rows)
{
    // Assuming these are the correct column names in your SharePoint list
    string databaseColumnName = ad["DatabaseColumn"].ToString();
    string sharepointColumnName = ad["SharePointColumn"].ToString();

    if (advertisingDT.Columns.Contains(databaseColumnName))
    {
        foreach (DataRow dr in advertisingDT.Rows)
        {
            Console.WriteLine($"Checking values for Database Column: {databaseColumnName}, SharePoint Column: {sharepointColumnName}");

            // Check if the column is "OrganizationName"
            if (databaseColumnName == "OrganizationName")
            {
                object orgValue = dr[databaseColumnName];

                Console.WriteLine($"Original Value (Before check): {orgValue}");

                // Check if its value is null or empty
                if (orgValue == null || string.IsNullOrEmpty(orgValue.ToString().Trim()))
                {
                    // Concatenate "OrganixationFirstName" and "OrganizationLastName" to create the final value
                    string finalValue = $"{dr["OrganixationFirstName"]}{dr["OrganizationLastName"]}";

                    Console.WriteLine($"Original Value (After check): {orgValue}, Final Value: {finalValue}");

                    ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation();
                    ListItem newItem = targetList.AddItem(itemCreateInfo);

                    newItem[sharepointColumnName] = finalValue;
                    newItem.Update();
                }
                else
                {
                    Console.WriteLine($"Value not null or empty: {orgValue}");

                    // If the value is not null or empty, use the original value
                    ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation();
                    ListItem newItem = targetList.AddItem(itemCreateInfo);

                    newItem[sharepointColumnName] = orgValue;
                    newItem.Update();
                }
            }
            else
            {
                // If the column is not "OrganizationName", use the original value
                Console.WriteLine($"Value (Not OrganizationName): {dr[databaseColumnName]}");

                ListItemCreationInformation itemCreateInfo = new ListItemCreationInformation();
                ListItem newItem = targetList.AddItem(itemCreateInfo);

                newItem[sharepointColumnName] = dr[databaseColumnName];
                newItem.Update();
            }
        }
    }
    else
    {
        Console.WriteLine($"Column {databaseColumnName} not found in DataTable.");
    }
}